RE: Best Way to get Excel data to AS/400

[Glenn Ericson <Glenn-Ericson@xxxxxxx>]

--
[ Picked text/plain from multipart/alternative ]
Chuck
the most painless way is fully  automated especially  if it is automated.
Talk to me  off line/privately.

         Glenn

At 01:59 PM 07/24/2002 -0700, Joel Fritz wrote:
>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>--
>[ Picked text/plain from multipart/alternative ]
>I'm torn between FTP and cpyfrmimpf after saving the Excel files in an IFS
>directory in your favorite text format.  FTP might be marginally easier to
>script. If there's a lot of files involved, the real annoyance will be
>keying in all the from and to names correctly and building the destination
>files if they're not there already.  I've never used the Synapse file
>transfer.  Is it great grandchild of ETU?
>
>Is there a way to eliminate the middle person and get text files directly
>from the Unix box?  That would be my fantasy first choice.  FTP into
>intermediate file in IFS or direct to database file.
>
> > -----Original Message-----
> > From: Chuck Lewis [mailto:clewis@iquest.net]
> > Sent: Wednesday, July 24, 2002 1:30 PM
> > To: Midrange-L
> > Subject: Best Way to get Excel data to AS/400
> > Importance: High
> >
> >
> > Hi Folks,
> >
> > We are needing to get data from an RS/6000 to the AS/400.
> > These folks can
> > download the files we need via a report writer into Excel and they are
> > emailing them to us.
> >
> > We can save this information to a CSV file, TXT file, etc.
> >
> > My question is what is the most "painless" way to get this data to our
> > AS/400 ?
> >
> > We are running the Synapse TCP/IP emulation product and it has
> > Upload/Download GUI programs aka CA. I've done this before
> > but it can be a
> > hassle with numbers, etc.
> >
> > And then there is also the FTP option which I would think
> > would be a good
> > option but I have never done much more than uploads of text
> > information with
> > that...
> >
> > So what's the consensus on best way to do this ? We are on V4R5.
> >
> > Thanks !
> >
> > Chuck
> >
>NOTICE:
>All e-mail sent to or from this e-mail address will be received or otherwise
>recorded by The Sharper Image corporate e-mail system and is subject to
>archival, monitoring, review by and/or disclosure to Sharper Image security
>and other management. This message is intended only for the use of the
>addressee and may contain information that is privileged and confidential.
>If you are not the intended recipient, dissemination of this communication
>is prohibited.
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
--