Re: Looking for Ideas For Processing CSV

[Alan Campin <alan0307d@xxxxxxxxx>]

Why don't you just process the file directly in RPG and update the file? I
have wrapper service programs but no access to a machine at the moment.
Search the archives for examples of using unix file api's. All kinds of
stuff out there.


On Mon, Feb 4, 2013 at 2:26 PM, Michael Schutte <mschutte369@xxxxxxxxx>wrote:

> I have a request to process a CSV file and import the data into a file.
>
> The first record will have column header with the name of the field that
> it's suppose to update.
>
> For example if in file   ITEM_MASTER there are fields ITEM and DESCRIPTION
>
>
> R ITEMMST
>    ITEM               20
>    DESCRIPTION        50
>
>
> The CSV would look like this.
>
> "ITEM","DESCRIPTION"
> "1234","ITEM NUMBER 1"
>
> The user would like to first see if there is an item that currently exists
> and then update when found or write a new record.
>
> So I got to thinking(bad idea), maybe I could somehow take the entire csv
> record and put them into an array, easily...  For example with a SQL
> procedure or function you could
>
>
>    SET fields = ARRAY["ITEM", "DESCRIPTION"];
>    SET data = ARRAY["1234","ITEM NUMBER 1"];
>
>
> Then I could loop through the array, do validation... when passed then
> update item master file.
>
> What do you think?  Is there a better method when the number of columns in
> the import file could differ?
>
> If you like this idea, I'm having trouble finding examples of using SQL
> Arrrays in RPGLE.
>
>
> P.S.  There will a ton a validation and put into a holding file prior to
> updating the ITEM master.
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.