Re: Upload a CSV with multiple record types

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

So you are getting rid of you mapper so that you can manually map a
different file? Interesting choice. Maybe you can tell them to just send
fixed format records with the record name as the first 10 characters. Then
if should be simple to handle in RPG.

Or, as long as they are telling you the record format as the first field of
the CSV, you could fairly easily split them up into individual files with
API's.

On Thu, Oct 26, 2017 at 1:00 PM, Bob Cagle <bcagle@xxxxxxxxxxx> wrote:

> (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