If you want to be real simple and don't have to import often you can
import the XML into Microsoft Excel and then export it as a CSV, then
CPYFRMIMPF into the PF or use the Excel database connection to import to
your table. OpenOffice also has nice tools for this.
You could also do a simple XSLT to transform the XML into CSV provided
you have java or some other such animal with JAXP support.
You may find that some SQL clients will open the XML directly and let
you save the table into your PF.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rick baird
Sent: Tuesday, September 16, 2008 2:57 PM
To: Midrange Systems Technical Discussion
Subject: XML to PF
I was looking for a simple XML to PF conversion, along the lines of
CPYFRMIMPF or some such on V5R3.
I looked through the archives and found where RPG has some extensions
for XML parsing in V5R4 - no luck there.
I also saw some references to Scott Klement's xml parser, and I'd love
to dive into that, but at this point, third party roll your own stuff is
out of the question for this tiny project. The politics involved in
getting it installed and getting myself up to speed on it aren't worth
the effort.
The XML file in question is very simple, will have the same number of
columns as the target PF, even the same column names.
I'm getting the feeling I'm out of luck, but I thought I'd check once
more just to make sure.
No need to reply unless you have something other than what i've already
mentioned.
Thanks!
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
