Selective import of XML

HCL Domino Domino Forum
1

Has anyone used the XML parsers and classes in Domino to do selective imports? By this I mean taking a large XML file and importing pieces of it into existing Notes documents, as opposed to creating new docs for each record.

I’ve read the few articles on LDD about the XML classes, but they only address exporting Domino data, and imports that create new records. I’ve also looked at the redbook, but it’s 5 years old and geared to R5.

A bit of background: we currently have a legacy data warehouse with an Oracle backend. We run LEI processes each night to pull data into our Notes apps. That Oracle system is being moved into SAP, with Tibco software being used to pull out XML files each night. We need to be able to get pieces of data out of those XML files and into existing Notes documents.

I’ve worked with XML/XSLt, but never in connection with Notes. I’d appreciate any resources anyone can provide - articles, books, etc.

2

Subject: Selective import of XML

If you have the XML file in the file system, you can write a Lotus Script agent to only read the desired tags to create Notes documents. There are many XML classes in Lotus Script that will allow you to do so.

3

Subject: RE: Selective import of XML

Thanks, James, but the operative word in your response is “create” - the problem is, we don’t want to create new documents. We want to update existing documents.