Atlassian Jira Integration for Agile Development

[Ravi16]

I am working on Atlassian Jira integration project .

Question is How to move the update sets from one to another environments

we have 33 projects . I have created each project(sn_jira_int_proj) and individual table(sn_int_common_table_map.do) and Field maps(sn_int_common_field_map) are captured in the update set.

what I observed is every environment Project table sys id's are different. So, do we need to create mappings manually table maps, Field maps and choice maps for each project without the update sets in each environment? its taking lot of time to create table mappings and Field mappings and choice for each project.

Is there any way without going through manual steps?

Thanks,

Ravi

[James Schwab]

Hi Ravi,

It sounds like your issue is that you have records in your table have different sys_ids between environments. This is because if they are not being moved across in the update set and they were created independently, the sys_id would be different. 

Let's say you have Instance A and Instance B. Instance A may have the versions of the records you want. Navigate to the list of records you want to export on the sn_jira_int_proj table. Filter, if needed, to show only the records you want to export.  Export > XML as normal.  It will export all of those records.  Go to Instance B, from any list view, select "Import XML" from the menu option.  

As a result, Instance B will have the same records with the same sys_ids then what you have on Instance A.

[SaiShekharP]

Hi Ravi,
In the update set, you need to include records from the Mapping Configuration table ("sn_int_common_map_config") as well.
All the table maps, field maps, choice maps, have a reference to this mapping config. 

Then, in the production instance, once you discover all the projects, for each project, select the correct Mapping Config record that you have imported from the update set.