Sample CSV flow for IPA

Sort:
You are not authorized to post a reply.
Author
Messages
Jay
Basic Member
Posts: 5
Basic Member
    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: 468
    Veteran Member
      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: 468
      Veteran Member
        Here is one doc for IP designer version 10.
        Do a google search on Infor IPA, you may be pleasantly surprised.
        Attachments
        You are not authorized to post a reply.