Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Sample CSV flow for IPA

 2 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Jay
Basic Member
Posts: 5
Basic Member
12/22/2021 7:07 PM
    Hi I am new to Lawson! I wrote couple interfaces using COBOL, now I am learning IPA and would like to some assistance how I should read a .CSV file and pars/contact (data manipulation) to create a output file that will feed into database. Any help greatly appreciated.
    Thanks
    Jay
    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    12/22/2021 7:07 PM
      Something like this?
      1. FileAccess to read the csv file
      2. DataIterator to read each line of the file
      3. Assign Node with Javascript to split each record by commas and massage the data as needed
      4. FileAccess to write the formatted data
      5. SysCommand to call 'importb' to load the data
      Ragu Raghavan
      Veteran Member
      Posts: 476
      Veteran Member
      12/22/2021 7:16 PM
        Here is one doc for IP designer version 10.
        Do a google search on Infor IPA, you may be pleasantly surprised.
        Attachments