Re: CA TRANSFER OF CSV,BAI OR XLS FILES (& KEYVIEW)

Angie,

If you are on V4R2 or later you can use the CPYFRMIMPF command. If you
are looking for a commercial product that can read .csv files directly
into an AS/400 database file you might want to look at our CrossData/400
product. It handles numeric field conversions and has a library scan
facility to automatically process received files. More info at:
http://www.patownsend.com

Ptrick

Wawrzaszek wrote:
> 
> HELP!!!!!
> Our bank gave us a new software program called KEYVIEW.  We pick up our file
> from them with our check reconcilliation.  The software gives us the ability
> to export the data out to either .csv or .bai format.  I have typed a file
> with .xls extension to create an excel file also and it allows this.
> 
> Now for the problem, when I transfer any of these files up to the AS400 the
> fields are not in the same positon.  I transfer it up to a 300 char line
> file.  Because the fields are not fixed length on the pc file they are just
> separated by a comma on the 400 file.  I really do not want to get into
> having to read the 400 file char by char to determine the beginning and
> ending positon of each field.  If I put the file into excel first, it looks
> great on excel, each field is separate.  If I save it as .xls and do a
> transfer it transfer 1 record and it is encrypted!  The file really has
> about 900 records.  Is there something I can do, or does anyone else use
> keyview and how did they handle this?
> 
> Thank you in advance, Angie
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

-- 
IBM AS/400 communications, FTP automation, and network security
software and consulting services.

http://www.patownsend.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---