× 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.


  1.  Home
  2. RPG400-L
  3. May 2014

RE: Parsing an XML-XLSX file using XML-INTO

Yay, another solution! Thanks Rory. (Actually its' good to know them all)

I looked at XML-SAX though, and I like what I see and it looks like that will be it. I was going with XML-INTO because I thought it would be more complicated to program than XML-INTO but it's actually simpler, I think (for me anyway).

If it's a paid solution, I know they're not going to buy it here or budget for it, because the recently hired new CIO is reviewing everything top to bottom and he's already hinted that though the "AS/400" (his word) is one durable, stable machine like no other, he's looking for the best thing for the company and so on and so on. Since nobody at the parent company knows anything about the IBM I family of machines, and his tone, you don't need any tea leaves...

I will report the future...

Alan


-----Original Message-----
From: RPG400-L... On Behalf Of Rory Hewitt
Sent: Wednesday, May 21, 2014 12:06 PM

Alan,
One final thought - if you're looking for an RPG-only solution, you could try out RPG-XML from KrengelTech (Aaron Bartell). It's a paid solution, though, and I don't know what you're willing to pay. Either way, you can use RPG-XML's DOM Parser module to process your XML file very easily, in pure RPG.
Rory


On Wed, May 21, 2014 at 7:50 AM, Alan Cassidy <ACassidy@xxxxxxxxxxxxxx<mailto:ACassidy@xxxxxxxxxxxxxx>>wrote:

Thanks Henry!
PowerExt looks useful.

Alan


Alan Cassidy
Senior Developer
Hospital Physician Partners
954-693-0000 ext. 3433 - Direct phone
786-380-9236 - Mobile phone
acassidy@xxxxxxxxxxxxxx<mailto:acassidy@xxxxxxxxxxxxxx>
www.hppartners.com<http://www.hppartners.com>




-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Henrik Rützou
Sent: Wednesday, May 21, 2014 10:00 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Parsing an XML-XLSX file using XML-INTO

Well here is a RPG/XML approach where I position myself on the
AsOfDate data element:

* Reading XML

/copy qsrc,pxapihdr General H-Spec's

* powerEXT API Connectors
/copy qsrc,pxapicgicn Basic HTTP connecter & Basic Services

* Declare Internal Variables
d dsp s 52a varying

/free
clearSrvPgm();
setContent('*none');

xmlFromStmf('xls.xml');
xmlReaderInz(xmladdr:xmlsize);
xmlReaderCase('L');

dow xmlReader = 0;

select;
// read only 'AsOfDate' data element in Row/Cell relation
when xmlGetNode = 'data' and xmlGetAttr = ''
and xmlGetXpath(1:2) = '/row/cell';
if xmlgetData = 'AsOfDate';
dsply 'now I''m positioned';
dsp = xmlGetData;
dsply dsp;
endif;
endsl;

enddo;


*inlr = *on;
/end-free



On Wed, May 21, 2014 at 3:52 PM, John Yeung
<gallium.arsenide@xxxxxxxxx
wrote:

On Wed, May 21, 2014 at 9:00 AM, Jon Paris
<jon.paris@xxxxxxxxxxxxxx<mailto:jon.paris@xxxxxxxxxxxxxx>>
wrote:
Unless I'm misremembering John, Alan reached this point of having
the users save off in XML format (his idea not mine) _after_
having tried the POI classes to access the data directly. I would
have recommended that approach (or PHP or ...) had he not already
gone down that route.

Having the users save in XML was definitely his idea. And I never
meant to imply that your *first choice* would be for the users to
save multiple XML worksheets. I just felt that if you had gotten to
the point where you were even *considering* asking the users to do
yet another step, then it was at least worth taking one more look
back at other alternatives.

He did start on the POI path before deciding on XML, but it's not
clear how far he got. What I mean is, I don't know if he got to a
point where *POI* couldn't do the job, or to a point where *he*
couldn't get POI to do the job.

I suspect that XML then became more attractive because (1)
conceptually, processing XML from scratch is simpler than processing
a "native" Excel file from scratch (even the .xlsx variety); and (2)
when you receive an XML file, you can *see*, with your own eyeballs,
what's in it. The end result is tantalizingly close. If you
receive an Excel file, you can't just open it in a text editor or
even a hex editor and go "ah, I see, you just have to pick out these
pieces and Bob's your uncle". No, with an Excel file, you really
need proper tooling.

Now, I did bring up some questions regarding POI (because I don't
have personal experience with it, and was trying to establish
whether it was indeed up to the task), but they never got answered.
They mainly had to do with formulas. I specifically mentioned that
the packages I
*am* personally aware of can retrieve values from formula cells
(provided that those formulas were evaluated by Excel, and that the
workbook was saved by Excel). No answer.

My fear was that Adam (and others on this list) didn't really
understand what I was talking about, and thus didn't give my
alternatives a fair shake. Even then, I was completely fine with
that. I only spoke up again when your exchange with Adam showed
that the XML approach isn't turning out to be as straightforward as hoped.
That's why I've attempted to revisit the direct Excel-reading path,
but this time with concrete examples.

John Y.
--
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<mailto: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<mailto:RPG400-L-request@xxxxxxxxxxxx> Before posting, please take
a moment to review the archives at http://archive.midrange.com/rpg400-l.




--
Regards,
Henrik Rützou

http://powerEXT.com <http://powerext.com/>
--
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<mailto: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<mailto:RPG400-L-request@xxxxxxxxxxxx> Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.



----------------------------------------------------------------------
---------- Confidentiality Notice: This email may contain confidential
information or information covered under the Privacy Act, 5 USC
552(a), and/or the Health Insurance Portability and Accountability Act
(PL 104-191) and its various implementing regulations and must be
protected in accordance with those provisions. It contains information
that is legally privileged, confidential or otherwise protected from
use or disclosure. This e-mail message, including any attachments, is
for the sole use of the intended recipient(s). Any unauthorized
review, use, disclosure or distribution is prohibited. You, the
recipient, are obligated to maintain it in a safe, secure and
confidential manner. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the
original message. 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<mailto: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<mailto:RPG400-L-request@xxxxxxxxxxxx> Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.




--
Rory Hewitt

http://www.linkedin.com/in/roryhewitt
--
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<mailto: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<mailto:RPG400-L-request@xxxxxxxxxxxx>
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.



--------------------------------------------------------------------------------
Confidentiality Notice: This email may contain confidential information or information covered under the Privacy Act, 5 USC 552(a), and/or the Health Insurance Portability and Accountability Act (PL 104-191) and its various implementing regulations and must be protected in accordance with those provisions. It contains information that is legally privileged, confidential or otherwise protected from use or disclosure. This e-mail message, including any attachments, is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Thank you.
--------------------------------------------------------------------------------



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.