× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



We have used Scott Klement's XLPARSER4 service program and xlparse.jar code
(http://www.systeminetwork.com/artarchive/index.cfm?fuseaction=viewarticle&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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.