...
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
Please follow steps below to export data.
...
Export
...
data
...
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
using JCMA tool
Partially migrate app data
While migrating Jira using migration assistant, choose Upraise app as well to migrate.
Once you are done with migration, you will see migration status as INCOMPLETE and progress as “App data partially migrated”
...
Locate export data file
The data will be exported to zip file. 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
...
...
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";
//Query to find out Users using Upraise
select "ID","KEY","DISPLAY_NAME" from "AO_EB0AB3_UP_USERS" where "STATUS" !=2 |
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
This option is still in beta. While migrating Jira using migration assistant, choose Upraise app as well to migrate. No manual intervention is required all upraise data will be migrated automatically.