RE: CA TRANSFER OF CSV../CPYFRMPCD -- MIDRANGE-L

        I'm kinda halfway there. I also saved an Excel file onto our 400 via
the Save as...., I saved it to what looks like on a PC as the "usr"
directory on the 400. Do this by doing:

File->Save as->Network Neighborhood->"AS400 name"->usr. 

However after saving this file on my 400, I was unable to find it using
WRKOBJ!
But, was able to find (and delete) this file using Client Access' Operations
Navigator.

Also did not understand the promptings on the CPYFRMPCD command. This looks
like it may be a very useful utility, will be doing some searches on some of
IBM's sites to learn more.




Dale Draper
Sega Enterprises, Inc. (USA)
Dale.Draper@seu.sega.com
650-632-7555


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