Re: Get CSV file

["Francis Lapeyre" <flapeyre@xxxxxxxxx>]

   CPYFRMIMPF will do that, but make sure you change the default record
   delimiter (RCDDLM) parameter to *CRLF.



   CPYTOIMPF does the same thing in reverse, however, your .csv file will
   have embedded blanks in text fields. If that's a problem, then you can
   either use Scott's IFS tools to directly write to your .csv file, or
   use one of the many tools out there to transfer between native
   physical files and Excel/comma-delimited files. Again, with
   CPYTOIMPF, you need to change the RCDDLM parameter to *CRLF.



   Easiest way is to have your .csv file in an IFS folder on the iSeries;
   FTPAPI can transfer it fine from and to there.

   On Jan 9, 2008 11:19 AM, Janet Lopian <[1]jlopian@xxxxxxxxxxxxx>
   wrote:

       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:
     [2]http://www.scottklement.com/mailman/listinfo/ftpapi
     -------------------------------------------------------------------
     ----

   --
   Francis Lapeyre
   Solum potestis prohibere ignes silvarum.

References

   1. mailto:jlopian@xxxxxxxxxxxxx
   2. 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
-----------------------------------------------------------------------