Import Data Table data multiple times

Question

I could not find any article or post that discussed this specifically so asking here. Should be an easy one. In the process of migrating apps to a new install of Thingworx, this should be a common concern. So, we have moved over our Entities but now need to move over the data from the data tables. I have 5 that I need to move over but currently, I am in a rehearsal/test mode.
According to CS393743  I should be able to select each, export the data and import to the new server. This fails to address anything about subsequent updates. Since I am in a test mode,  I want to validate things are working so I need the data but data is still being actively updated in production. During a Go live event, I will take the final extract and wish to re-import the data to this new instance. What will occur?
I can see three possible outcomes:

Import succeeds and all data exists in new instance (ideal)
Import fails as unique entries already exist (bad)
Data is duplicated or merged with previous import leading to duplication issues (very bad)

If anyone has been down this road, please reply with your experiences and best path forward.

avillanueva · Accepted Answer

I was able to find a sample data table from an abandoned project to use as a test. I exported it and imported it to my new server. From there, I returned to my source system, added a new entry and made a small change to a field in another. The ID or key of that entry did not change so that's a good thing. Repeated the process of export and and import. No duplication but I did see the updated entry and the new entry appear. Check and Check. Now, if I had made new entries in and mods in my target system, I would expect that there would be some merging of data. Same for deletions in the source. Goes without saying but this nails it. Thanks for the confidence @GuillaumeL .

GuillaumeL · Answer

Hello,

If I remember well, answer 3 !!

In my case I scripted the import by using following steps. So that at the end of this, we are in answer 1 !!

1- deleting all values

2- Importing values from a CSV file (which was previously exported in CSV)

Here is a piece of code : (name corresponds to the DataTable thing)

	Things[name].PurgeDataTableEntries();

	Things[name].AddOrUpdateDataTableEntries({
		values: csvContent
	});

Regards,

Guillaume

Index	Fruit	Count
1	Apple	13
2	Orange	10
3	Banana	8
4	Peach	20

Index	Fruit	Count
1	Apple	13
2	Orange	10
3	Banana	8
4	Peach	20
5	Apple	15
6	Orange	10
7	Banana	8
8	Peach	20
9	Mango	5

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded