RE: XLPARSER4 open source tool for RPG

Hi Bradley,

When I check the job log for the java error it says the following:

Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure XLPARSE_WO in program XLPARSE36/XLPARSER4
received Java exception "java.lang.NoClassDefFoundError:
com.iseriesnetwork.clubtech.xlparse.ParseSheet" when calling method
"parse201003" with signature "([B)V" in class
"com.iseriesnetwork.clubtech.xlparse.ParseSheet".
Recovery . . . : Contact the person responsible for program maintenance to
determine the cause of the problem.
Technical description . . . . . . . . : If the exception indicates that the
Java class was not found, ensure the class for the method is in the class
path. If the exception indicates that the Java method was not found, check
the method name and signature. If the signature is not correct, change the
RPG prototype for the method, or change the Java method, so that the return
type and parameter types match. You can determine the signatures for all the
methods in class XYZ using command QSH CMD('javap -s XYZ').

I'm not really sure what this means. Am I missing a java component of some kind?

Thank you,
Mike

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bradley Stone
Sent: Friday, August 31, 2018 3:40 PM
To: RPG programming on the IBM i / System i
Subject: Re: XLPARSER4 open source tool for RPG

Michael,

There should be more detailed information in the job log. Can you look for that? Especially the Java Exception error.

On Fri, Aug 31, 2018 at 2:18 PM Soucy, Michael <MSoucy@xxxxxxxxxxx> wrote:

I'm looking for some help with the Excel parsing tool written by Scott
Klement found here:

http://www.scottklement.com/poi/

I have downloaded and installed all the needed parts on my system.
When I attempt to run the sample program XLPDEMO it's giving me an
error. The error says:

Java exception received when calling Java method.
DSPLY Error occcured while parsing spreadsheet.

I'm not sure what it is I have done wrong. Does anyone have any
suggestions of how to debug my problem?

Michael Soucy
Sr. Programmer / Analyst
Community Health and Counseling Services
(207) 922-4837

****** CONFIDENTIALITY NOTICE ******

The documents accompanying this email contain confidential information
that may be legally privileged and protected by federal and state law.
This information is intended for use only by the entity or individual
to whom it is addressed. The authorized recipient is obligated to
maintain the information in a safe, secure, and confidential manner.
The authorized recipient is prohibited from using this information for
purposes other than intended, prohibited from disclosing this
information to any other party unless required to do so by law or
regulation, and is required to destroy the information after its stated need has been fulfilled.

If you are in possession of this protected health information, and are
not the intended recipient, you are hereby notified that any improper
disclosure, copying, or distribution of the contents of this
information is strictly prohibited. Please notify the owner of this
information immediately and arrange for its return or destruction. Thank You.
--
This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD