[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Get CSV file
Scott Klement published a series of articles on working with IFS files.
In System iNews (January 2005), he provided a service program for
reading/parsing CSV files into PFs.
It works very well. Here is a link to the article.
http://www.systeminetwork.com/artarchive/19626/RPG_and_the_IFS__Text_Fil
es_in_the_World.html
The code can be found under January 2005 through the code link.
You might need a log-on for SystemiNetwork.com to get this article and
code.
________________________________
Scott A. Schollenberger
Director, R&D
Harris School Solutions
Phone: (610) 239-9988 ext. 305
Fax: (610) 239-9995
Email: sschollenberger@xxxxxxxxxxxxxxxxxx
2011 Renaissance Blvd., Suite 100
King of Prussia, PA 19406
This message and any attachments are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee you may not copy, forward,
disclose or use any part of the message or its attachments and if you
have received this message in error, please notify the sender
immediately by return e-mail and delete it from your system. The sender
does not accept liability for any errors or omissions in the context of
this message that arise as a result of Internet transmission. Any
opinions contained in this message are those of the author and are not
given or endorsed by the Harris company or office through which this
message is sent unless otherwise clearly indicated in this message and
the authority of the author to so bind the Harris entity referred to is
duly verified.
-----Original Message-----
From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
[mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
magne@xxxxxxxxx
Sent: Wednesday, January 09, 2008 2:33 PM
To: HTTPAPI and FTPAPI Projects
Subject: Re: Get CSV file
Hi,
you could use ftpapi to get the file and then use the System i
CPYFRMIMPF command to place the csv data into a PF.
Magne
>-----Original Message-----
>From: Janet Lopian [mailto:jlopian@xxxxxxxxxxxxx]
>Sent: Wednesday, January 9, 2008 06:19 PM
>To: ftpapi@xxxxxxxxxxxxxxxxxxxxxx
>Subject: Get CSV file
>
>Hi All,
>
>
>
>FTPAPI is GREAT! I do have a question about the get command. I need to
>get a CSV file from a server and place it into an iSeries physical
file.
>The user will perform some maintenance duties on the file and then put
>it back to the server. The get works well when I am using a flat file.
>It does not work when the file contains more than one field. I think
>that I know the answer to this but I promised my boss that I would ask:
>can the get command place a CSV file into a physical file with multiple
>fields, in other words removing the commas and parsing the data into
>the fields? The opposite would be needed with the put command.
>
>
>
>Thanks so much for your time!
>
>
>
>Jan
>
>
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------