Wiki

Clone wiki

servertimesheet / Migration guide

If you'd like to migrate old (prior 2.3.9) gadgets to to new, it's possible to do it manually.

Analyze DB, find 'portletconfiguration' and 'gadgetuserpreference' tables.

In old Jira portletconfiguration.GADGET_XML you should see values:

- rest/gadgets/1.0/g/jira-timesheet-plugin:timesheet-gadget/gadget.xml (old)
- rest/gadgets/1.0/g/jira-timesheet-plugin:group-timesheet-gadget/group-timesheet-gadget.xml (group)

In new Jira portletconfiguration.GADGET_XML you should see value:

- rest/gadgets/1.0/g/jira-timesheet-plugin:timesheet-gadget/timesheet-gadget.xml (new)

In gadgetuserpreference DB table see USERPREFKEY values for the particular gadgets:

- num_weeks
- reporting_day
- user
- group
- isConfigured
- projectOrFilter

You can perform these steps for migration:

  1. Rename portletconfiguration.GADGET_XML to rest/gadgets/1.0/g/jira-timesheet-plugin:timesheet-gadget/timesheet-gadget.xml for old and group gadgets
  2. In gadgetuserpreference DB table:
  3. For old gadget:
    • leave 'reporting_day' field as it is
    • leave 'num_weeks' field as it is
    • leave 'user' field as it is
    • create sumSubTasks field with value: 'false'
    • create isConfigured field with value: 'true'
    • create projectOrFilter field with value: ''
    • create showIssues field with value: 'true'
    • create 'group' field with value: ''
    • create 'projectRole' with value: '<some ID from projectrole DB table>'
  4. For group gadget:
    • leave 'reporting_day' field as it is
    • leave 'num_weeks' field as it is
    • leave 'group' field as it is
    • leave 'isConfigured ' field as it is
    • leave 'projectOrFilter ' field as it is
    • create sumSubTasks field with value: 'false'
    • create showIssues field with value: 'true'
    • create 'user' field with value: ''
    • create 'projectRole' with value: '<some ID from projectrole DB table>'

Note, there is no need to create missing preferences, gadgets should work out defaults, end user later may adjust missing settings.

Updated