RE: Parsing multiple Excel workbooks

Sounds like you are saving some "left overs" that ordinarily would be
cleaned up by shutting down the program, as in setting on *INLR. The
program is saying, "I've already done this," and goes back to sleep...
?? 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott A
Schollenberger
Sent: Tuesday, September 26, 2006 12:46 PM
To: RPG programming on the AS400 / iSeries
Subject: Parsing multiple Excel workbooks

We have used Scott Klement's XLPARSER4 service program and xlparse.jar
code
(http://www.systeminetwork.com/artarchive/index.cfm?fuseaction=viewartic
le&CO_ContentID=17840&channel=art&PageView=Search)
for several years to load a spreadsheet of journal entries into a work
file for updating into our accounting package.

As originally designed,  we only handle one spreadsheet upload at a time
before the edit and update process had to be run to post the journal
entries into the accounting system.

I have been requested to modify the upload to allow entry of multiple
spreadsheet names to be uploaded at a single time.  We used a command to
enter the IFS file name so I modified the command to allow multiple
entries and changed the RPGLE program to processing the number of
entries from the CMD PARM and loop through the file names.

The first file gets uploaded fine, the name of the second file gets
prepared but when the xlparse_workbook subprocedure is called, nothing
seems to happen with the second file.

No error is returned (as far as I can tell) but none of the second
spreadsheet's entries are being written to the database upload file.

I'm hoping someone can point me in a direction to investigate.

Thanks, Scott
----------------------

Scott A. Schollenberger
Director, Research & Development
Harris Computer Systems
Schools division

2011 Renaissance Blvd., Suite 100
King of Prussia, PA  19406
Phone: 610-239-9988  Ext. 305
Fax: 610-239-9995
E-mail: saschollenberger@xxxxxxxxxxxx
              sschollenberger@xxxxxxxxxxxxxxxxxx
Web: www.tenexsys.com

IBM Certified Specialist - eServer i5 iSeries Technical Solutions
Implementer V5R3

CONFIDENTIALITY NOTICE:  This email message, including any attachments,
is for the sole use of the intended recipient(s) and contains
confidential and privileged information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.