XML data transfer from 1 instance table to another instance table

scottangehr · ‎10-01-2017

I've searched the community but didn't really find an answer to this question.

I need to export (XML) data from 1 instance table to another instance on a different table.

I read the doc article below that says this is possible, but I can't seem to find out how.

"Note: If the data does not import, navigate to System Definition > Tables & Columns and verify that the table from which the data was exported also exists in the instance importing the data. If the table does not exist in that instance, you can move it using an update set."

Import a single XML file containing one or more records

How do I move a large amount of records to an update set?

Thank you,
Scott

scottangehr · ‎10-03-2017

Hello all

Thank you for helping. I was able to edit up the XML file to get it to import to the newly created table in another instance. In my case, we merged 2 custom tables into 1. This may not be best practice, but it's what we had to do to get the records over. For future references, these are the fields that had to be updated in the XML to get the table to match up. Underlined are the table names. I simply did a replace in the XML.

**NOTE - I did not do a replace on just the table name because I didn't want to affect the field names, so I made sure to copy the full XML statement I wanted to replace.

EDITS IN XML FILE

<equip_request action="INSERT_OR_UPDATE"> = <u_asset_movement_request action="INSERT_OR_UPDATE">

<sys_class_name>equip_request</sys_class_name> = <sys_class_name>u_asset_movement_request</sys_class_name>

<table_name>equip_request</table_name> = <table_name>u_asset_movement_request</table_name>

</equip_request> = </u_asset_movement_request>

I also did a CSV export/import to capture any other data to connect to the newly created fields.

This may not have been the best solution, but it was a solution that worked for me.

Thank you!

View solution in original post

Pradeep Sharma · ‎10-01-2017

Hello Scott,

You may find the below threads helpful.

https://snprotips.com/blog/2016/9/7/force-include-any-record-into-an-update-set-in-servicenow

https://docs.servicenow.com/bundle/jakarta-application-development/page/build/applications/task/t_Ad...

scottangehr · ‎10-01-2017

That's a great tool to have handy, however - I don't see how I can select the table I need the task records to go to.

Deepak Kumar5 · ‎10-01-2017

Do you want to move table or records in that table?

I need to export (XML) data from 1 instance table to another instance on a different table.

Moving one table data to another table using xml is not possible as it contain the table name to be update.

If the table does not exist in that instance, you can move it using an update set.

Check the table creation date from Tables then go to Local update set,using it find all the entry for that table creation in Default update set , Change the update set name to your new updateset name.

scottangehr · ‎10-01-2017

I need to move all the records from 1 custom table (rma) to another (u_asset_movement_request) in another instance