how to export data table to another instance?

georgechen · ‎04-19-2016

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,

Brian Dailey1 · ‎04-19-2016

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:

Go to System Update Sets>Local Update Sets
Click New
Name it, and click "Submit and Make Current"
From your table definition, click on each new custom table column to open its entry in the Dictionary
Change the Column label to something
Click Save
Change the Column label back to your original value
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.

View solution in original post

Brian Dailey1 · ‎04-20-2016

Anytime .

Mayu · ‎04-28-2021

Use the Export update set :1)Copy URL

2)xml file

Navigator-->update set-->update source -->Type URL & Password-->test connection-->ok

Hope it's helpful.

Thanks and Regards,

Mayuri Mandavkar