RE: Get CSV file

["Craig Jacobsen" <CJacobsen@xxxxxxxxxxxxx>]

Another thing you could do is parse the commas inside your program and
put them directly into your DB file.  Same thing on the way out (better
than CPYTOIMPF, no extra blank spaces).  This would also allow you to
validate the data and send an email to the user that all is ok or there
is an error with the data.  Another thing you could use is HSSF to
write/read the spread sheet as an .xls instead of a .csv.

HTH,

Craig

-----Original Message-----
From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
[mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Steve L.
Sent: Wednesday, January 09, 2008 1:35 PM
To: HTTPAPI and FTPAPI Projects
Subject: Re: Get CSV file

No, but you could use FTPAPI get the file and place it into a folder in
the IFS, then 
subsequently use CPYFRMIMPF to copy the file from the IFS to the
database file, and 
vice-versa.

- steve

----- Original Message ----- 
From: "Janet Lopian" <jlopian@xxxxxxxxxxxxx>
To: <ftpapi@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Wednesday, January 09, 2008 11:19 AM
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
>
-----------------------------------------------------------------------
> 

-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.  Unless expressly stated in this e-mail, nothing in this message or any attachment should be construed as a digital or electronic signature.
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------