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

[Bob Crothers <bob@xxxxxxxxxxxxxx>]

Angie,

Create a native file on your AS/400 to receive the info.  This file 
should have individual fields that are always at least as long as what 
you bank sends you.  Eg: Make the description 50 char, amounts 15.2, 
etc.

Now download this file to create the FDF.  Make sure you set your 
target file to be CSV.

Now create an upload using the FDF.  Now when you do the upload via 
Client Access, it will put the fields from the CSV into the fields in 
your transfer file (created above).  now you can use RPG or whatever 
to actually do something with the data.

Note: You must us Client Access...NOT FTP.

Bob
-----Original Message-----
From:   Wawrzaszek [SMTP:wawrzaszek@austeel.com]
Sent:   Friday, March 05, 1999 11:32 AM
To:     MIDRANGE-L@midrange.com
Subject:        CA TRANSFER OF CSV,BAI OR XLS FILES (& KEYVIEW)

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