As Atlassian has stepped up its Cloud game, lot of teams are moving from Jira Server/DC variants to Cloud. To support this transition, UpRaise apps let you take your existing UpRaise data from Server/DC and move it to Cloud. This can be done via JCMA tool provided by Atlassian or via manual steps. Reach out to us on our service desk so that we can offer our guidance for UpRaise apps migration.
You need to export the upraise data to a file and share exported file with us. We will import it manually. There are 2 ways to export data
Option 1: Export and map data manually
Following steps need to be run while migrating from on-prem to cloud manually.
Exporting UpRaise data from on-prem
As far as export of current data is concerned, please upgrade your on-prem UpRaise app to the latest version & then follow these steps:
Hit the URL based on which app you are using
Employee Success - <jira-server-domain>/rest/upraisesuccess/latest/upraise-migration/export-data
Employee Garrison - <jira-server-domain>/rest/upraise/latest/upraise-migration/export-data
People - <jira-server-domain>/rest/upraisepeople/latest/upraise-migration/export-data
Exported data will be available at location <jira-app-data-dir>/upraise/export/xxxx-xxx-xx-xxxxx.zip
Jira data mapping
In addition to the UpRaise export data coming out of above endpoint, we need mapping between Jira entities from on-prem to cloud. Details laid out below (old refers to datapoint from Server/DC, new refers to datapoint from Cloud)
User
old - userKey, new - accountId
Project
old - projectId, new - projectId
Issue
old - issueKey, new issueKey
old - issueId, new issueId
User groups
old - groupName, new - groupName
Custom fields (if used in OKR configurations to calculate progress)
old - customFieldId, new - customFieldId
We need the data in json format as below (if issueKeys remain same then that can be ignored)
{
"users": {
"username1": "accountid1",
"username2": "accountid2",
},
"issueIds": {
"10001": "10100",
"10002": "10200"
},
"issueKeys": {
"UP-100": "UP-1000",
"UP-200": "UP-2000"
},
"projectIds": {
"10200": "20200",
"10300": "20300"
},
"groups": {
"developers": "new-developers",
"product-owners": "new-product-owners"
},
"customFields": {
"customfield_10006": "customfield_10006"
"customfield_10007": "customfield_10007"
}
}
Finding our UpRaise - Jira links
You need to run below queries on your Jira database (on-prem instance) to find out UpRaise - Jira links. Please share this information with us on the migration support ticket you created on our support portal. Do note that the syntax could change based on your database.
| Code Block | ||
|---|---|---|
| ||
//Query to find out which Jira issues are linked to feedback. Here RESOURCE_ID is a Jira issue key. SELECT DISTINCT "RESOURCE_ID" FROM "AO_EB0AB3_UP_FB" WHERE "RESOURCE_TYPE"='ISSUE'; //Query to find out which Jira issues are linked to the feedback requests. Here RESOURCE_ID is a Jira issue key. SELECT DISTINCT "RESOURCE_ID" FROM "AO_EB0AB3_UP_FB_REQUESTS" WHERE "RESOURCE_TYPE"='ISSUE'; //Query to find out which Jira issues are linked to the issue as a key result. Here TITLE is a Jira issue key & ISSUE_ID //is a Jira issue id. SELECT DISTINCT "TITLE", "ISSUE_ID" FROM "AO_EB0AB3_UP_OBJ_KEY_RESULTS" WHERE "OKR_TYPE"=2; `//Query to find out which JQL is linked to JQL as a key result. Here ISSUE_DETAILS is a JQL. SELECT DISTINCT "ISSUE_DETAILS" FROM "AO_EB0AB3_UP_OBJ_KEY_RESULTS" WHERE "OKR_TYPE"=3; //Query to find out which Jira issues are linked to issue as a key result action. Here TITLE is a Jira issue key & //ISSUE_ID is a Jira issue id. SELECT DISTINCT "TITLE", "ISSUE_ID" FROM "AO_EB0AB3_UP_OBJ_KR_ACTIONS" WHERE "ACTION_TYPE"=0; //Query to find out which JQL is linked to JQL as a key result action. Here ISSUE_DETAILS is a JQL. SELECT DISTINCT "ISSUE_DETAILS" FROM "AO_EB0AB3_UP_OBJ_KR_ACTIONS" WHERE "ACTION_TYPE"=1; //Query to find out which Jira fields are linked to auto update metric key result configuration. Here FIELD is a Jira //field name. SELECT DISTINCT "FIELD" FROM "AO_EB0AB3_UP_OBJ_KR_PRG_CNF" WHERE "AGGR_FUNCTION" IN (2,3); //Query to find out which JQL is linked to auto-update metric key result configuration. Here JQL is a JQL. SELECT DISTINCT "JQL" FROM "AO_EB0AB3_UP_OBJ_KR_PRG_CNF"; //Query to find out which Jira projects are associated with the project restrictions issue panel. SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='issue_panel_enabled_exceptions'; //Query to find out which Jira projects are associated with the project restrictions feedback panel. SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='cf_enabled_exceptions'; //Query to find out which Jira projects are associated with project restrictions OKR panel. SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='okr_enabled_exceptions'; //Query to find out which Jira groups are associated with Jira group-based access setting. SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='GROUP_ACCESS_EXCEPTIONS'; //Query to find out which Jira groups are associated with UpRaise team. //Here JIRA_GROUPS are stored in an encrypted format. SELECT DISTINCT "JIRA_GROUPS" FROM "AO_EB0AB3_UP_TEAMS"; |
Sharing the data with us
You will need to upload the exported zip file and the json to a Dropbox link we share with you. Post that we will import this data on the cloud instance (please share this url with us on the ticket) where you can verify it.
Option 2: Export data using JCMA tool
While migrating Jira using migration assistant, choose Upraise app as well to migrate. Please note, this will not migrate upraise app data to cloud, it will export data automatically with proper mapping in json file in zip and you do not need to create this json file manually as mentioned in Option 1.
Once migration status becomes Complete, exported upraise data can be found at “<jira-app-data-dir>/upraise/export/xxxx-xxx-xx-xxxxx.zip”
You will need to upload the exported zip file to a Dropbox link we share with you. Post that we will import this data on the cloud instance (please share this url with us on the ticket) where you can verify it.
...