Page 1 of 1

File Watcher plugin. Import CSV with header row

PostPosted: Wed Feb 11, 2015 10:12 am
by DannyC
Hi,

The provided plugin in Jiwa 7 works for importing a sales order CSV which does not have a header row. Can you provide an example of the File Watcher plugin which allows for a CSV file to have a header row?

Regards

Danny

Re: File Watcher plugin. Import CSV with header row  Topic is solved

PostPosted: Wed Feb 11, 2015 10:16 am
by Scott.Pearce
If the CSV file has a header row, just add the line:

Code: Select all
csvParser.ReadFields


to just above the "Do While Not csvParser.EndOfData" line. This has the effect of "skipping" the first row.

Re: File Watcher plugin. Import CSV with header row

PostPosted: Wed Feb 11, 2015 10:45 am
by DannyC
Too good.

Thanks so much - particularly for the fast response as i needed that solution right away!

Cheers

Danny