Re: Upload a CSV with multiple record types

Even if all the lines are not identical, as long as they can be mapped to a record layout you could use a modified version of my Open Access CSV reader and process the file that way. It would require that you treat it as a display file (silly as that may sound) in order to handle the multiple formats. Probably just as easy to just code directly to the C-level IFS APIs.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Oct 26, 2017, at 1:15 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

If all lines in the CSV file are not identical then utilities like
CPYFRMIMPF are out.
If you have disk space, time and processor to waste then you could use
CPYFRMSTMF to convert it to a flat file in Db2 and then process that.
Otherwise I would stick to using IFS APIs (such as those documented by
Scott Klement). You will find that these:
- Perform better than utilities such as CPYFRMIMPF
- Give you more granularity of control in processing exceptions. For
example, a 16 character item number comes in but your ERP package only
allows 15 characters then you can handle that exception.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Bob Cagle <bcagle@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 10/26/2017 01:01 PM
Subject: Upload a CSV with multiple record types
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



(cross posted from the RPG list - not necessarily restricted to RPG)



We have a new third party EDI provider that is replacing our on-premise
mapping software. They will be sending us data in CSV files with multiple
record types per line, as in each line directly correlates to a specific
file on our system.



We use JDE and they are sending the data elements to match the fields in
the upload files for sales orders (the F47 files for inbound 850s for
those in the know).



And ideas or suggestions on how to parse this CSV?



I'm thinking that I'll need to read the CSV off the IFS and load each file
field individually, but I'd rather not have to do that. Looking for a
quicker more efficient method as we're talking about 500 total fields!



Thanks



Bob Cagle

IT Manager

Lynk

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD