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

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 fully understand... If speed and simplicty is what your after (get it
working in the next hour), I would suggest scripts that,  ftp the data to
the as/400, followed by a run remote command to have cpytoimpf copy the csv
data into a physical file.  This works very well also...  But it requires a
manual step to export the data to a csv,  prior to the FTP.  (I have seen
this suggestion several time already, and it does work nicely)

With the java scenario I was trying to show a dynamic approach to the
creation of the as/400 table.

have a nice day... tim

p.s. And for what it's worth, my Java skills are pretty weak.  And I have
not written the program to do what I suggested, the need my company had was
to produce .xls files from our as/400, so my program went the other way.  My
java program would do a sql statement back to the as/400 using a JDBC call,
and then it created the columns, and then any formating (font size, column
width, rotation) and then I would start populating the data from the result
set.  And then the 400 would e-mail the .xls to the end-users.



> -----Original Message-----
> From: Chuck Lewis [SMTP:clewis@iquest.net]
> Sent: Thursday, July 25, 2002 11:13 AM
> To:   midrange-l@midrange.com
> Subject:      RE: Best Way to get Excel data to AS/400
>
> GREAT idea from the sounds of it Tim - If I had a CLUE as to how to do the
> Java part :-) Even have a Java CD but have not gotten around to finding
> the
> time to seriously devote to learning it... "One man shop" and "you know
> whats to the walls" lately. Thanks !
>
> Chuck
>
> -----Original Message-----
> From: midrange-l-admin@midrange.com
> [mailto:midrange-l-admin@midrange.com]On Behalf Of Hatzenbeler, Tim
> Sent: Thursday, July 25, 2002 10:29 AM
> To: 'midrange-l@midrange.com'
> Subject: RE: Best Way to get Excel data to AS/400
>
>
> 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 ]
> Painless is a subjective word...  For me it means, a way to get a job done
> with the least amount of support calls later :-)  But one suggestion would
> be to use java, and one of the EXCEL classes out their (accutate [$$$], or
> POI [free])  these classes will allow you to read/write native xls files,
> and then you can read the column definitions (ie: text or numeric) and
> then
> after you have read all the column types, you can create a table via sql
> on
> the as/400 to match these data types, and then you iterate through the
> spread sheet and populate the table on the as/400.  This could all be
> triggered after the FTP to the as/400, and use the run remote command (top
> launch the java program) after your PUT command...
>
> Just another idea...
>
> > -----Original Message-----
> > From:       Chuck Lewis [SMTP: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
> >
> > _______________________________________________
> > 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.
> This e-mail message, including any attachments, is for the sole use of the
> intended recipient(s) and may contain confidential or privileged
> information.  Any unauthorized review; use, disclosure or distribution is
> prohibited.  If you are not the intended recipient, please contact the
> sender by reply e-mail and destroy the message.
> _______________________________________________
> 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.
>
>
>
> _______________________________________________
> 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.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.