Re: Upload a CSV with multiple record types

[Henrik Rützou <hr@xxxxxxxxxxxx>]

What I do is to convert it to XML like

Input: (the delimiter can be set to any char)
01|"FILE DESWCRIPTION"|20140717|"HOSPF001"|""|""|""|""|

10|123456789|123456789|111223333|"LAST NAME"|"FIRST NAME"|"MIDDLE
NAME"|"SUFFIX"|"ALIAS LST NAME"|"NICKNAME"|

Output:
<row rrn="1">
 <column1>01</column1>
 <column2>FILE DESWCRIPTION</column2>
 <column3>20140717</column3>
 <column4>HOSPF001</column4>
 <column5 />
 <column6 />
 <column7 />
 <column8 />
</row>
<row rrn="2">
 <column1>10</column1>
 <column2>123456789</column2>
 <column3>123456789</column3>
 <column4>111223333</column4>
 <column5>LAST NAME</column5>
 <column6>FIRST NAME</column6>
 <column7>MIDDLE NAME</column7>
 <column8>SUFFIX</column8>
 <column9>ALIAS LST NAME</column9>
 <column10>NICKNAME</column10>
</row>





On Thu, Oct 26, 2017 at 6:08 PM, 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