OnDemand User Group
Support Forums => Report Indexing => Topic started by: niclee on September 13, 2017, 08:10:13 PM
-
Greetings fellow CMOD gurus,
We received a requirement to archive XML files, that consist of information of their customers, from a potential customer. However, we don't know where to start. Knowledge Center isn't exactly very helpful.
The theory that we understand is that these XML files would need to be converted to another XML file that follows CMOD's structure (odxmlidx.xsd). The converter is either XSLT or XQuery. Let's say we want to use XSLT, do we build it based on odxmlidx.xsd?
I understand that we can use Generic indexer with an additional index file. Assuming the customer isn't willing to generate the index file from their end, we would probably need to build an application that reads the XML contents to generate the index file. That would be the last option as we would like to explore what CMOD's XML indexer can do first.
Also, how do we load the XMLs automatically using XML indexer? Just move the transformed XML file into the data load directory? What is the extension/format of the input file? XML or ARD? Or rename the XML file to .OUT, and ARD is just the trigger?
Really really appreciate the help. Thank you in advance.
-
Bud Paton did a Demo of XML & CMOD a few years back, and the recording failed. Maybe we'll invite him to present again and make another attempt at recording it for the future.
-JD.
-
Bud Paton did a Demo of XML & CMOD a few years back, and the recording failed. Maybe we'll invite him to present again and make another attempt at recording it for the future.
-JD.
Looking forward for that video from the master. Meanwhile, do you have any advice/recommendations for my inquiries?
Thanks JD!
-
I haven't done any work with XML, so I leave it to others to comment on.
FYI, I spoke with Bud, and he's agreed to repeat the XML webinar early next year.
-JD.
-
niclee - not my strong suit but to see how to export and import via arsxml see my samples in
http://www.odusergroup.org/forums/index.php?topic=1551.0 (http://www.odusergroup.org/forums/index.php?topic=1551.0)
That will show you how to export and import data using arsxml.
I realize this isn't what you're looking for, but at least you'll be able to touch arsxml and verify it works.
Ed
-
I haven't done any work with XML, so I leave it to others to comment on.
FYI, I spoke with Bud, and he's agreed to repeat the XML webinar early next year.
-JD.
That's great!
However, we're expecting the deal to come in in the fourth quarter this year. The webinar might be a tad too late for us. :(
Anyway, thanks JD for the effort!
-
niclee - not my strong suit but to see how to export and import via arsxml see my samples in
http://www.odusergroup.org/forums/index.php?topic=1551.0 (http://www.odusergroup.org/forums/index.php?topic=1551.0)
That will show you how to export and import data using arsxml.
I realize this isn't what you're looking for, but at least you'll be able to touch arsxml and verify it works.
Ed
I've tried exporting administrative objects using XML. It's different from XML indexing.
Anyways, thanks Ed!