Very slow import

Hi, I am importing 25 MB file with fixed lengh fields (about 60000 records). The import takes about 5 hours. Did you have such problem?

Hi Val, Navision dataports have always been slow, though since ver 1.3 they get faster each version. In the case of fixed length fields (which are even slower in NAvision than a CSV), you are best off to write a codeunit to do it. Just create a new table, and use the Function to bring the data in one line (everything up to the {CF LF}) into one record. Then write code to strip the data from the records. If the lines are longer than 250 bytes, then you can create multiple fields, but the more fields, the slower the import. Once in Navision, processing 60,000 records is simple.

Other two easy ways are: 1) Cut the file into multiple smaller files and import them one after the other (the longer the file is the slower it will go on Navision dataports). 2) Create a database in Access whith that file (it takes about 4 minutes) and then import the data from Access with a report using ADO automation… it will go a lot faster and the speed will remain constant. Regards,

or since you are below the 64k row limit, just put it into excel, and use the code that’s already there.

Is it Native or SQL?

Import to temporary record. OnPostDataport transfer data to not temporary record


Originally posted by Agustin Carceller
Import to temporary record. OnPostDataport transfer data to not temporary record

I have never tried this, is it a lot faster? How much faster, do you have any numbers. If it is faster, this is great news. It seems odd though, since the main reason that Dataports are slow, is because of how the text file is read.

Temporary files don’t update keys, and are … We have BOM Explosion ( It use temporary files. We transfer information from Temporary table to other temporary table to print and transfer from 1 to other temporary 10.000 records can be 0.1 sg (Explosion with operations, e-config and 10 item levels) Best regards from BCN

Yes, I know that Temporary tables are faster in the case you cite here, but the question is related to DataPorting, does it make dataports faster?