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

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.