Prev
Next
Forums Integration / Customization IPA/ProcessFlow

ProcessFlow to parse csv file

 3 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
slavo
Basic Member
Posts: 8
Basic Member
3/8/2013 4:27 PM
    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
    Posts: 32
    Veteran Member
    3/8/2013 4:55 PM
      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
      Posts: 32
      Veteran Member
      3/8/2013 5:01 PM
        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
        Posts: 9
        Basic Member
        3/8/2013 9:12 PM
          The Memorial Patient Refund flow does this. Just have Diana R. email it to your.