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

Discussions relating to plugin development, and the Jiwa API.

File Watcher plugin. Import CSV with header row

Postby DannyC » Wed Feb 11, 2015 10:12 am

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
User avatar
DannyC
Senpai
Senpai
 
Posts: 635
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 29

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

Postby Scott.Pearce » Wed Feb 11, 2015 10:16 am

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.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: File Watcher plugin. Import CSV with header row

Postby DannyC » Wed Feb 11, 2015 10:45 am

Too good.

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

Cheers

Danny
User avatar
DannyC
Senpai
Senpai
 
Posts: 635
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 29


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron