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.