PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/22/2021 2:07 PM by  Ragu Raghavan
Sample CSV flow for IPA
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Jay
Application specialist Sr
Private
Basic Member
(11 points)
Basic Member
Posts:5


Send Message:

--
12/22/2021 2: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
    Private
    Private
    Veteran Member
    (1282 points)
    Veteran Member
    Posts:446


    Send Message:

    --
    12/22/2021 2: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
    Private
    Private
    Veteran Member
    (1282 points)
    Veteran Member
    Posts:446


    Send Message:

    --
    12/22/2021 2:16 PM
    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.