I want to import multiple csv-files into the same table.
I want to know which imported rows were part of the same import-batch.
In the Debug-view I only see the INSERT (preceded by DEFAULT if modeled), but see no extra information about the batch or imported file.
How can I do this?
Best answer by Mark Jongeling
View original
+23
Hi Roy,
You could include the filename in the row data of your csv-file and map it to the designated filename column in your application. Would that suffice?
Hi Mark,
Unfortunately not, since the csv-file is generated externally and can contain a lot of rows. For smaller csv-files and ones that we generate ourselves this would be an option.
We already must make one change, as the last row contains a character that the default Thinkwise import can't handle:
Any ideas around that would also be helpful.
+23
I'm afraid this is currently not possible through the GUI import functionality. Feel free to create an idea for this.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
