Oh by the way, I looked around on the Internet for a product like that, and there's too much noise. My guess is search-engine optimization interference.. Did that before I set up the question here...
Thanks again
-----Original Message-----
From: PcTech [mailto:pctech-bounces@xxxxxxxxxxxx] On Behalf Of Alan Cassidy
Sent: Wednesday, May 07, 2014 5:04 PM
To: PC Technical Discussion for IBM i (AS/400 and iSeries) Users
Subject: Re: [PCTECH] Windows batch-file-friendly command to automatically convert Excel to XML
Thanks for the encouragement, Buck.
I am "continuing the momentum", such as it is, with some independent study on various things that are also on the PC, that will be one of them. Didn't get into those POI classes at all really before the brick wall hit.
I'm going to look at parsing the data from the XML version of the file from IFS. Looks like it'll work that way. Between tonight and the weekend I'll also look at using the XML-INTO op code. Haven't used it yet, looks good.
Alan
-----Original Message-----
From: PcTech [mailto:pctech-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro
On 5/6/2014 5:07 PM, Alan Cassidy wrote:
I recently posted to the Midrange and RPG list, about the tools available for reading from an Excel file using the Java classes from POI-HSSF or XSSF.
However, when I asked about contacting the sys-admin, which is a 3rd party vendor that handles those duties, and implementing this, there was blowback about it, mostly because apparently I would be the only one able to support it, and what if (blank) happens to you, or you leave, or something. I don't think the other RPG programmer here has much interest, really, or maybe it's something else.
...because as we all know, RPG source code can be very difficult for RPG programmers to maintain. Yep, there's something else going on.
There's not much to do then, because (1) the officially titled IT Director here is not technical, and will not have the position after a move to the parent HQ in days, and the new CIO there (the new boss of my boss to be) is reorganizing everything and he hinted in my get-to-know-you interview that the "AS/400" is a machine that you can set up and when you stabilize your applications on it it runs forever (and other high praise), but they're looking at what options they have for the future.
And the VP of Development was real glad I would gladly adapt to any other technology. (Another clear hint). And by the way, it's a dot-net shop.
(Sigh)
:)
So now I need either auto-conversion Windows command or they'll have to open, and save-as to a share directory on the IFS. Function probably going away in a few months anyway. No wonder they figure I might not last.
If you've done any work researching the POI classes you can keep the momentum going by using those classes - in Java, on the PC. There are a boatload of examples on the net.
Otherwise, there might be a third party product they'd be willing to pay for. Who knows?
--buck
--
This is the PC Technical Discussion for IBM i (AS/400 and iSeries) Users (PcTech) mailing list To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/pctech.
--------------------------------------------------------------------------------
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 PC Technical Discussion for IBM i (AS/400 and iSeries) Users (PcTech) mailing list To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/pctech.
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
midrange.com
