Forums
IPA/ProcessFlow
Sample CSV flow for IPA
Author
Messages
Jay
Basic Member
Posts: 5
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: 469
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: 469
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
LPDUG_10.1.0.0_UW.pdf