[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Get CSV file
in case no one has mentioned it, this is handy as well:
Replace null values . . . . . RPLNULLVAL *FLDDFT
it prevents failures due to no value between the commas.
"Stoicescu, Adriana" <astoicescu@xxxxxxxxxx> wrote:
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
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"
> To:
> 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
-------------------------------------------------------------------
----
_________________________________________________________________
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
[1]Try it now.
References
1. http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------