Re: Upload a CSV with multiple record types

[Mohammad Tanveer <surgum@xxxxxxxxx>]

Did you try something like this?  I think it should work and keep your
programs simple.

Step 1:
CPYFRMIMPF from IFS file to "A" file on iSeries

Step 2:
CPYF FROMFILE(A) TOFILE(B) INCCHAR(*FLD 1 *EQ '01')
CPYF FROMFILE(A) TOFILE(C) INCCHAR(*FLD 1 *EQ '02')
CPYF FROMFILE(A) TOFILE(D) INCCHAR(*FLD 1 *EQ '01')

Regards

On Thu, Oct 26, 2017 at 11:08 AM, Bob Cagle <bcagle@xxxxxxxxxxx> wrote:

> 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 RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-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