What would be the best way to import a very large XML-file into a production, modifying it depending on certain conditions, and creating a new XML file?

Question

Question

Emil Odobasic · Nov 29, 2023

Hello everyone!
Sorry for the vague title! But I wonder what would be the best way to easily import a large XML-file into a production, modifying it by deleting elements and nodes depending on what values are in those nodes/elements and later creating whole new XML-file from that?

I have gone through this: Using Caché XML Tools | Caché & Ensemble 2018.1.4 – 2018.1.8 (intersystems.com)

But I get the sense that there are a lot of ways of approaching this, but I do not know what is the most effective for my certain needs.

I appreciate the help! Thanks beforehand! :)

Product version: IRIS 2023.2

Discussion (5)3

Log in or sign up to continue

Enrico Parisi · Nov 29, 2023

Hi Emil,
I can think of 3 possible approaches.

1) Use XPATH
2) Modify the XML Document as a DOM
3) Use XSLT transformations

All 3 can be used/implemented in IRIS.

Enrico

P.S.: I suggest using the latest version of the documentation

2 0

Jani Hurskainen · Dec 14, 2023

Sounds like a perfect case for XSLT that is a special purpose language for transforming XML documents. See Performing XSLT Transformations to get started with XSLT In IRIS.

2 0

score 0 · Answer 1 · 2023-11-29T10:32:53-05:00

Emil Odobasic · Nov 29, 2023

Hello Enrico!

I will try your suggenstions!

Thank you very much once again! :)

0 0

score 0 · Answer 2 · 2023-12-14T10:36:48-05:00

Emil Odobasic · Dec 14, 2023

Thanks alot for the help! :)

0 0

score 0 · Answer 3 · 2023-12-15T16:19:53-05:00

XSLT unless we are talking about a very large files to be processed very quickly in which case SAX parser might be worth a consideration.