Dataport imports only 1 record

Business Central/NAV Developers Forum
1

Hi I have to import a bunch of records from a TAB-seperated file (generated via ‘save as’ in Excel). However, the dataport only imports the first line of the file. There’s no error message, it just cycles through the lines of the importfile without importing. I think it has to do with the recordseparator. At the moment it is , but maybe this is not correct for an excel-txtfile ? Thanks Best regards Josh

2

Hi Josh, do you fill the primary key fields of that table? Best Regards feri

3

Yes, AutoIncrement of the field was set to Yes.

4

Thanks Feri for putting me on the right track. I sorted the filling of the primary key out (by code this time, not via autoincremen) and it works. Thanks. Josh

5

you are welcome [;)] Best Regards feri