XML data transfer from 1 instance table to another instance table

[scottangehr]

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

[Deepak Kumar5]

Another way you can try - First import to the same table records with XMl from one to another instance. Then copy the records value from one table to another table on same instance.

[scottangehr · Accepted solution]

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

<OLD> = <NEW>

<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!