Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
Please let me know if anyone of you is aware of a quick way to upload around 3000 records in a data table.
Regards,
Hemant
Hi Hemant Rastogi,
Per my understanding; following steps can be used:
1. Import the csv file to the file repository.
2. The path of the csv file can be taken using GetFileInfo service.
3. Then, map the path from GetFileInfo service to LoadText service which will provide the csv content.
4. Identify the Primary key in your Data; if there is none add a Id field which will primary the Primary key. (In this case we will have to iterate through the table to add distinct value to the primary key field)
4. Create the DataShape which defines the structure of the data.
5. Use AddDataTableEntries service of the DataTable to add the records to the DataTable.
I hope it helps.