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

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 <[1]astoicescu@xxxxxxxxxx>
   wrote:

     You can get rid of extra blank spaces generated by CPYTOIMPF by
     using
     the parameter RMVBLANK.
     Adriana

   -----Original Message-----
   From: [2]ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx

   [mailto:[3]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: [4]ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
   [mailto:[5]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" <[6]jlopian@xxxxxxxxxxxxx>
   To: <[7]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:
   > [8]http://www.scottklement.com/mailman/listinfo/ftpapi
   >
   ----------------------------------------------------------------------
   -
   >
   ----------------------------------------------------------------------
   -
   This is the FTPAPI mailing list.  To unsubscribe, please go to:
   [9]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:
   [10]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:
   [11]http://www.scottklement.com/mailman/listinfo/ftpapi
   ----------------------------------------------------------------------
   -

   --
   Francis Lapeyre
   Solum potestis prohibere ignes silvarum.

References

   1. mailto:astoicescu@xxxxxxxxxx
   2. mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
   3. mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
   4. mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
   5. mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
   6. mailto:jlopian@xxxxxxxxxxxxx
   7. mailto:ftpapi@xxxxxxxxxxxxxxxxxxxxxx
   8. http://www.scottklement.com/mailman/listinfo/ftpapi
   9. http://www.scottklement.com/mailman/listinfo/ftpapi
  10. http://www.scottklement.com/mailman/listinfo/ftpapi
  11. 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
-----------------------------------------------------------------------