Important reading for JIRA administrators before upgrading to Tempo Timesheets 8.2.0
- In this version the worklog attribute type that is called Script is removed. When you upgrade to this version, all attributes of this type are removed and are not recoverable.
- The installation of Tempo Timesheets takes longer than usual because of data migration so you might want to upgrade outside of office hours.
- We cannot guarantee that you will not lose data if you first upgrade to Timesheets 8.2.x and later downgrade to an earlier version.
Data migration
Numeric work attribute
A new numeric value column is added to the WA_VALUE table.
Numeric work attribute is migrated from a string type column to the new numeric type column.
New Static List work attribute
Any dynamic dropdowns that were used to create work attributes with static lists are migrated to a new attribute type called "Static list".
The table below shows changes to the database.
Table | Data | Notes |
|---|---|---|
AO_013613_WA_VALUE | Work attribute values of type numeric | New column NUMERIC_VALUE added. Numeric values previously stored in VALUE column migrated to new column. |
| AO_013613_WA_SL_VALUE | List options for static list work attributes | Example Dynamic dropdown value url from Tempo Timesheets 8.1
After migrate in Tempo Timesheets 8.2 options are migrated to the new Static list work attribute type.
|
Periods and Period configuration
Periods are being migrated from the JIRA properties database to new Active Objects tables.
Table | Data |
|---|---|
| AO_86ED1B_PERIOD | Period keys and statuses (open/closed for Team members or Users with Approve Timesheet permission). |
| AO_86ED1B_PERIOD_CONFIG | Configuration of start day and month for periods. |
How does this affect my JIRA?
This should not affect you unless you downgrade to a previous version after migration tasks are run. Downgrading will result in data loss if you upgrade again later since the migration will not run again.
Feature removal
This release of Tempo Timesheets removes the work attributes of type Script. That means all attributes of this type are removed and are not recoverable after the upgrade.
Before the upgrade, check whether you are using the script type or not (click Administration cogwheel > Add-ons > TEMPO Work attributes). If you are not using scripts, then removal of this worklog attribute type does not affect your Tempo Timesheets setup.
Removal of this worklog attribute type does not affect dynamic drop-down lists that get information from a REST service.
How does this affect my JIRA?
Functionality introduced on your JIRA by injecting Scripts will stop working as it will be removed. With the Script attribute, it was possible to inject JavaScript code into Tempo Timesheets for use with the Log Work form. With the JavaScript code, you could link fields on the form with one another or add new functionality. This feature presented some security concerns as the system could accept JavaScript code that could, intentionally or not, corrupt data and open your company's JIRA environment to other risks.
What do I do?
If you are using the Script attribute type, find an alternative way of injecting scripts, before the upgrade. Atlassian Marketplace offers resource plugins for injecting JavaScript code into JIRA. Our Atlassian Expert Partners also have vast knowledge about JIRA and can provide consulting services.