Page Comparison

...

1. Start by extracting the Jira issue Account information from your (old) Server instance. You should only export the issues that have a Tempo Account value set to limit the number as much as possible. Export the Jira issues into a csv file. The only fields you need is the Jira issue key and the Tempo Account field value.

   Image RemovedImage Added

2. Import the extracted csv file into a spreadsheet that you are going to work with for the updating purpose. Your spreadsheet should look similar to the one below.

   Image RemovedImage Added

   Since the export attaches the Tempo Account key in brackets we will need to get rid of that as we do the mapping later only against the Tempo Account name. Add an extra column and populate it the the Tempo Account name only by using a formula like:

   Code Block
   =left(C2,find("(",C2)-2)

3. Now you will need to extract all Tempo Accounts from your Cloud instance since we need the new identifier of the migrated Tempo Accounts. Therefore you will need to leverage the Tempo REST APIs. You can retrieve all Tempo Accounts with the following curl command:

   Code Block
   curl --request GET 'https://api.tempo.io/core/3/accounts' -H 'Authorization: Bearer {TempoAPIToken}'

   From the response extract the values in the “results” section and save the content to a file. Find an json converter tool of your convenience (like https://www.convertcsv.com/) to convert the json content to a file format that can be used in your spreadsheet (e.g. csv).

4. Insert the csv file into your spreadsheet (into a new sheet) and after that you should have something similar to the file below.

   Image RemovedImage Added

   The only data we need is the “name” and the “id” column. As we are working with the “lookup” function later it is better to switch the columns so that the “name” comes first and then the “id” column.

   In the previous sheet with the Jira issue we inserted a “lookup” function into column “E” to get the new identification of the Tempo Account to update the Jira issue.1

   Code Block
   =VLOOKUP(D2,Accounts_Cloud!A:B,2,false)

   Your spreadsheet should look like:

   Image RemovedImage Added

5. The final information we need is the Tempo Account Jira custom field ID. This information can be retrieved by calling the Jira REST API:

   Code Block
   curl --request GET 'https://{JiraCloudUrl}/rest/api/3/field' --user '{AtlassianUser}:{AtlassianAPIToken}'

   This will include information about the Tempo Account custom field. Look for the key "io.tempo.jira__account".

   Code Block
   "id": "customfield_10201", "key": "io.tempo.jira__account", "name": "Account",

6. Now we have all the information we need and we can start to populate our spreadsheet with the update commands that we will run later in batch. In column “F” of our spreadsheet insert the formula:

   Code Block
   ="curl --request PUT 'https:///{JiraCloudUrl}/rest/api/3/issue/"&A2&"' --header 'Content-Type: application/json' --user '{AtlassianUser}:{AtlassianAPIToken}' --data-raw '{""fields"": {""customfield_10201"": "&E2&"}}'"

   Of course you replace the formula with your matching values for the Jira Cloud url, the Atlassian token and the Jira customfield ID retrieved from the response above.

   You can copy the content of the column “F” and paste it into a new text file that you will need to save as an executable shell script (e.g. “UpdateJiraAccounts.sh”).

   Image RemovedImage Added

   You simply run the batch update commands from the command line by executing the text file you have populated:

   Code Block
   sh UpdateJiraAccounts.sh

   Watch out for any warning errors that you might get during the output.