RE: CA TRANSFER OF CSV../CPYFRMPCD

You stored your spreadsheet on the AS/400 as a spreadsheet. It did not
magically become AS/400 database information. Try saving the spreadsheet
as a .PRN file which is a simpler structure than a .XLS.
As far as the CPYFRMPCD command, you probably had the wrong folder name
somewhere down the line. Go back and check you AS/400 drive mapping and
make sure QDLS is part of the folder structure you used. QDLS is where
objects exist on the AS/400 that commands like CPYFRMPCD, WRKFLR,
WRKDOC... can reference.

Ken Slaugh
Senior Programmer/System Analyst
AS/400 Professional Network Administrator/MSE
Specialist - Client Access/400
Chouinard & Myhre, Inc.

> -----Original Message-----
> From: wawrzaszek@austeel.com [SMTP:wawrzaszek@austeel.com]
> Sent: Tuesday, March 09, 1999 7:28 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      RE: CA TRANSFER OF CSV../CPYFRMPCD 
> 
> I am not a PC person so I don't know if I did what you said.  I
> created an
> excel spreadsheet of the file and put it on our mapped network drive.
> I
> tried to send it using CPYFRMPCD put it tells me it cannot find
> document
> key.xls (the name of my spreadsheet).  Was I suppose to do something
> else?
> You talk about using macros, and letting excel create the AS400 file
> so I'm
> assuming I am missing alot since all I did was put the info into a
> spreadsheet.
>  
> Please help!  Thanks
> 
> >Let Excel create the AS/400 file for you via the shared folders, then
> >use the CPYFRMPCD command to copy the data into any native physical
> file
> >you want. The macro capabilities of Excel are all you need to write
> to a
> >mapped network drive on the AS/400. If you want even more macro
> to/from
> >AS/400 support, check out our ActiveX AS/400 objects at
> >http://www.cm-inc.com/AS400ole/
> >
> >Ken Slaugh
> >Senior Programmer/System Analyst
> >AS/400 Professional Network Administrator/MSE
> >Specialist - Client Access/400
> >Chouinard & Myhre, Inc.
> >
> >> >>> 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
> >> +---
> >+---
> >| 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
> +---
+---
| 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
+---