[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Get CSV file



You are right.

Adriana
 


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

I'm guessing that parameter (RMVBLANK) was added at V5R4, because I'm at
V5R3 aand it isn't there.

On Jan 9, 2008 2:10 PM, Stoicescu, Adriana <astoicescu@xxxxxxxxxx>
wrote:

> You can get rid of extra blank spaces generated by CPYTOIMPF by using
> the parameter RMVBLANK.
>
>
> Adriana
>
>
> -----Original Message-----
> From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Craig
> Jacobsen
> Sent: Wednesday, January 09, 2008 11:00 AM
> To: HTTPAPI and FTPAPI Projects
>  Subject: RE: Get CSV file
>
> 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
>
-----------------------------------------------------------------------
>
>
------------------------------------------------------------------------
-------------
> Email Confidentiality Notice and Disclaimer
>
> This email message contains information which may be confidential and
> or legally privileged. Unless you are the intended recipient (or have
> been authorised to receive on behalf of the intended recipient), you
> may not use, copy or disclose to anyone the message or any information
> contained in the message or from any attachments that were sent with
> this email. If you have received this email message in error, please
> advise the sender by email, and delete the message.
>
>
>
------------------------------------------------------------------------
-------------
>
-----------------------------------------------------------------------
> This is the FTPAPI mailing list.  To unsubscribe, please go to:
> http://www.scottklement.com/mailman/listinfo/ftpapi
>
-----------------------------------------------------------------------
>



-- 
Francis Lapeyre

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