CA TRANSFER OF CSV,BAI OR XLS FILES (& KEYVIEW) -Reply

[Archie Cameron <AGCAMER@xxxxxxxxxxxxxxxxxxxxxxx>]

Angie, I did this one time and it worked for me, might be worth a try. 
After I loaded this into excel I saved it as a csv file.  I determined the
length of the fields and created a file on the AS400 with corresponding
field length.  The only trick was that there is an index that gets passed up
with csv and you need to accommodate that also.  I  established the
index size in my case it was two feilds at the beginning of the file one 8
one 5. Then used CA file transfer.   Just in case you aren't familiar with
CA file xfer you will have to do a download first to get the FDF file, 3.1.3
will allow this to happen w/o any data,.  Then use that fdf for you
upload.  
Good luck
Archie

>>> Wawrzaszek <wawrzaszek@austeel.com> 03/05/99 10:32am >>>
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
+---

+---
| 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
+---