how to export data table to another instance?

[georgechen]

Hello everyone,

I am having a table exporting question this time, hoping to get your advice.       I am working on two instances with the same table, one is a latter version which has a few more custom fields, while the other only has less.       I have tried to export the table with the newer table into an xml, and then imported to the one.   The steps I tried are listed below

1) On the source table -> Tables -> Table -> Time Worked -> Export -> XML (This Record)

2) On the target instance -> Retrieved Update Sets -> Scroll down to 'Import Update Set from XML' -> Select the xml file and then 'Upload'

Once uploaded the extra columns are still not showing in the target instance.     I also wonder if the columns need to be exported separately, but hoping if anyone could help.

Any advice is appreciated.

Thanks,

[Vikas-Malhotra]

Hi George,

You can try the direct webservice for the same. In this you can directly map the columns between the two instances.

You can refer this link for the same.

Service-now.com Tutorial : SOAP Message Intro - YouTube  

Hope it's helpful.

Thanks and Regards,

Vikas Malhotra

[tony_barratt]

Hi George,

If you want to move data via xml export/import from one instance to another, the relevant columns must exist, in the target table, prior to carrying the import into the target table.

Best Regards

Tony

[Brian Dailey1 · Accepted solution]

Hi George,

So, first things first.   You need to move the new custom components of your table from one instance to the other before trying to import any data.   An easy way to do this is the following:

1. Go to System Update Sets>Local Update Sets
2. Click New
3. Name it, and click "Submit and Make Current"
4. From your table definition, click on each new custom table column to open its entry in the Dictionary
5. Change the Column label to something
6. Click Save
7. Change the Column label back to your original value
8. Click Save again

Your update set should capture both the dictionary record and the label record for each new field.   Once you're done, change the state on your new update set to "Complete", save it, and then choose to Export it to XML.   Go to your other instance, select System Update Sets>Loaded Update Sets, and use the link to import the update set you've just saved to XML.   Preview and commit it.

Your instance will now be ready to accept the imported data.   GIve this a try.

Thanks,

-Brian

Note:
In step (5), it's important that you edit the column label and not some other field on the dictionary entry.   Because you need to change the label to capture it as well as the dictionary entry.

[georgechen]

Hi Brian

Thanks for your useful and detailed response, it worked perfectly via the update set xml export and import.

Your assistance is very much appreciated.