Test csv for before import with dataport

Kisu

Hey, what is the best way to check the csv file that it is possible to import in and it has correct number of colums and the data of the columns are in right column?

Kisu

Hmm I could probably solve this if I could count the csv file first row length before it's imported, since it will stay same.

kriki

1) Open it with Excel to do a first control
2) You can import it in a test-environment
3) You can import it in a temporary table. In this table you must make the fields long enough so there are no errors in importing the data. You neither do any validation. Once the file is imported, you can have some procedure to validate the data (e.g. see if an item exists and is not blocked). Once everything is OK, you can really import the data from this temptable into the real tables of NAV.