Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 133
	Members: 0
	Total: 133

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

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

New Poster

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: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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