Welcome, Guest
Please Login or Register.    Lost Password?

Parsing CSV file
(1 viewing) (1) Guest
Convertigo Products
This is the place to ask questions, request for enhancements and more generally discuss about Convertigo products.
Go to bottomPage: 1
TOPIC: Parsing CSV file
#187
Parsing CSV file 6 Months, 3 Weeks ago Karma: 0
After extracting a CSV file via Convertigo, I need to parse this file in order to register its data in a database, but I cannot find documentation for this point.

Could you tell me where I can find this informations or else provide an explination about this problem ?

Thanks a lot in advance.

Orange
orange
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#188
Re:Parsing CSV file 6 Months, 3 Weeks ago Karma: 1
Hello,

This can be done using the sequencer. You can use the ReadCSV step to read the CSV file. then by Iterating on the ReadCSV's source with the Iterator step (www.convertigo.com/docs/ReferenceManual/Iterator.html) you will be able for each line of the CSV file to use the CallTransaction step (www.convertigo.com/docs/ReferenceManual/CallTransaction.html). Call a specific transaction in a SQL connector to insert data in a SQL database.

You can refer to the sequencer getting started manual for more info.

For example, How to set a SQL connector : www.convertigo.com/docs/CMS/5.2.0/af1027666.html#Xaf1027666

Hope This helps !
admin
Convertigo Team
Posts: 34
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2012/02/02 13:25 By elodiee.
The administrator has disabled public write access.
 
Go to topPage: 1
Moderators: elodiee