How to import Agile Stories from DEV instance into TEST or PROD?

[Alina-Maria_S]

Hello,

We are trying to move Agile stories from DEV instance into TEST using Export/Import XML functionality, but is not importing what is captured in Activities section, information like: State changes, Assigned to field changes - and for Work notes, is not importing properly the dates and who added that Work note, even though we ensured that all users have the same sys_id in both instances. 

Are there any specific steps that needs to be performed to have all the story information (including what is captured in Activities) imported from one instance into another? 

Thank you. 

[Community Alums]

Hi @Alina-Maria Pasca ,

You can use this UTILITY. Have a look and see:

https://developer.servicenow.com/connect.do#!/share/contents/9824957_add_to_update_set_utility?t=PRO...

OR

Export the data from each table manually to XMLs and imported them to the other instance.  We don't have data in all the tables, so you only export wherever there's data. For a complete list of tables installed with Agile 2.0, see https://docs.servicenow.com/bundle/rome-it-business-management/page/product/agile-development/refere...

Don't forget the data for agile group and group membership.

• sys_user_group (filter= type contains Agile Team)
• sys_user_grmember (filter = Group.type contains Agile Team)

The activities for the stories are included and I didn't have to do a separate export.  

If you use Project with Agile Development, you will also need to export data from Project tables such as:

• pm_project
• pm_project_task
• ... etc.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Alina-Maria_S]

Hi @Sandeep Dutta ,

We imported the Project to which this stories are related, the Agile groups, group members, group role, Epics, Themes, Sprints with XML, and when importing the stories, it imports properly data captured in story fields, but what is in Activities section: information about State changes of changes on Assigned to field - is not moved to the other instance, and Work notes appear to be added by other user in TEST instance, even though they were added by me in DEV instance (from where we exported the XML). 

[Community Alums]

As i mentioned above you will need to export all the tables where you have data, then you can find the activities.

[Alina-Maria_S]

As mentioned, we exported and imported all the table where there was data, but Activities section still not imported properly.