ProcessFlow to parse csv file

 3 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
slavo
Basic Member Send Private Message
Posts: 8
Basic Member
I am relatively inexperienced as a PF designer, I need to parse an input csv file, parse the fields out and write them to a SQL server table.  This should be very easy but I cannot figure out the Data Iterator node at all.  If someone has a simple flow they can shar, I would be very grateful.  CFan email me an example if possible to: slavom@hotmail.com



M Graham
Veteran Member Send Private Message
Posts: 32
Veteran Member
I use 2 DataIterator nodes to parse the fields in an input csv file and will email you an example. 
1. The 1st Data Interator node parameters:
    Input Method:  File
    Input File:  (enter your file name and directory)
    Parse by: Line
2. The 2nd Data Interator node is nested inside the 1st Data Iterator node:
     Input Method:  Data
     Input Data: 
     Parse by:  Delimiter String
     Delimiter String:  , (enter a comma symbol if the fields in your csv file are separated by a comma).
M Graham
Veteran Member Send Private Message
Posts: 32
Veteran Member
2nd try - This post didn't display my text for the "Input Data" parameter because I enclosed the text between symbols for "greater than" and "less than.  Here are the parameters again:
2. The 2nd Data Interator node is nested inside the 1st Data Iterator node:
     Input Method:  Data
     Input Data:  !FileIn_outputData  - be sure to enclose this text between 'greater than' and 'less than' symbols.<!--leIn_outputDa-->
     Parse by:  Delimiter String
     Delimiter String:  , (enter a comma symbol if the fields in your csv file are separated by a comma).
Kevin Cubillas
Basic Member Send Private Message
Posts: 9
Basic Member
The Memorial Patient Refund flow does this. Just have Diana R. email it to your.