RE: MS Excel ====>> iSeries.

It is easier to do in java than in RPG/JAVA. 
Just use java FTP to get the file as an inputstream and process the it
using JXL (java XL) each row become a record and each column a field to
your database. Use com.ibm.as400.access.FTP for your FTP and
jxl.Workbook ,jxl.Sheet, jxl.Cell, jxl.CellType, jxl.labelCell to
process your spreadsheet. The above methods should give you a good
start.

Good Luck

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jake M
Sent: Wednesday, April 26, 2006 8:26 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: MS Excel ====>> iSeries.

This approach sounds good but I am still learning RPG. I do not have any
problem with coding in Java. So,  does it involve  very complex coding?
Does
anybody have a code snippet which involves checking of data types of
columns
in Excel against the DDS of the physical file to which the data is being
uploaded to?

Aaron:
I have just now started looking into the datafile utility. That sounds
nice
too. I will keep you posted as to how that goes...:).

I appreciate all the suggestions/input.

cheers,

Jake.

On 4/25/06, Reid, Deon <DReid@xxxxxxxxxxxxxxxxxx> wrote:
>
> You could use JCIFS or Java FTP to pick up the .xls file from the
> network share. Check the column type of the spreadsheet with the file
> layout of the AS400 and if there is any problem with a match (the dds
is
> expecting a date field and the spreadsheet is character), then create
an
> exception report.
> All this can be done with RPG mixing it with java.
> We do the same thing, some of our EDI clients send us their file in
XLS.
>
>
>
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of albartell
> Sent: Tuesday, April 25, 2006 1:07 PM
> To: 'Java Programming on and around the iSeries / AS400'
> Subject: RE: MS Excel ====>> iSeries.
>
> >Would you please elaborate on this for me?
> It was essentially giving them the ability to mass maintain a set of
> document attributes (i.e. a document being a Word or Excel document)
vs.
> going through my web ui which requires much more clicks.
>
>
>
> Here's what I would do in your case.
>
> Write a Java web application (I use Tapestry) that resides on the
> iSeries
> (or another machine, it doesn't matter) that will allow the user to
> upload a
> csv file. Using http://datafile.sourceforge.net/ parse through each
csv
> record and validate each field. At that point you can determine if one
> value
> is incorrect it causes the entire upload to be rejected or not. Once
all
> of
> the data is validated just do a JDBC SQL insert into the DB2 table of
> choice
> on your iSeries.
>
> Doing it this way ensures you have good data in your files AND it is a
> familiar interfaces for the end user (Browser).
>
> HTH,
> Aaron Bartell
>
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Jake M
> Sent: Tuesday, April 25, 2006 11:55 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: Re: MS Excel ====>> iSeries.
>
> Aaron,
>
> Would you please elaborate on this for me?
> >I used it to allow "mass configuration" from an excel csv file to
make
> >it easier (more timely) for an admin to maintain the software I
wrote.
>
>
> I have the same approach in place and the user perhaps could upload
the
> file
> directly to IFS instead of the NT box. So, if the user could upload a
> correctly formatted spreadsheet to IFS through a web interface and
then
> issue a command on the iSeries...that would be great!! heck, I could
> even
> make a .jsp file which could trigger off the iSeries command by
clicking
> on
> the link...So, the main thing here would be how would I ensure that
the
> user
> is uploading the correctly formatted data in the spreadsheet. I could
> make
> the user issue a command from iSeries(command to run a java app) and
it
> will
> comeback unsuccessful with a message in qshell mode and then the user
> will
> know that something is wrong. What do you think about that?
>
> I appreciate all your help,
>
> cheers,
>
> Jake.
>
>
> >
> >
> > HTH,
> > Aaron Bartell
> >
> >
> --
> This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L)
> mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To
> subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at
http://archive.midrange.com/java400-l.
>
> --
> This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>
>
>
>
------------------------------------------------------------------------
------
> The information transmitted by the following E-Mail is intended only
for
> the addressee and may contain confidential and/or privileged material.
Any
> interception, review, retransmission, dissemination, or other use, or
taking
> any action upon this information by persons or entities other than the
> intended recipient is prohibited by law and may subject them to
criminal or
> civil liability. If you received this communication in error, please
contact
> us immediately at 954-660-7400 and delete the communication from any
> computer or network system.
>
>
========================================================================
======
>
>
> --
> This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>