Export XML from View

Hi,

I would like to export a categorized view to XML, so I can use it to transform it to an XML structure using XSLT.

I know it can be done through an url using ReadViewEntries, my question is: can it also be done within a notes agent or action?

DXLExporter.setInput doesn’t seem to support NotesViewEntriesCollections…

Regards,

Wouter de Vaal

Subject: Export XML from View

Use the XML Toolkit available for free download from the downloads area of IBM/Lotus. This should give you all you need!

Also try:

http://www-10.lotus.com/ldd/today.nsf/lookup/LS_XML1

and

http://www-10.lotus.com/ldd/today.nsf/lookup/DXL_roadmap

HTH,

R

Subject: RE: Export XML from View

What makes you think that the Lotus XML Toolkit can export from a ViewEntryCollection? Its documentation seems to confirm what Wouter has already written.

Subject: RE: Export XML from View

Have you tried the following link - it’s got an agent which calls readviewentries:http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/18a8fd27e1a7c60d85256deb001266fb?OpenDocument

I don’t profess that it’s possible to get the data from a NotesView entry collection - but the original posting asks:

can it also be done within a notes agent or action?

Wel the answer is yes - the XML Toolkit can export data from a Notes View as XML…

HTH,

Ranjan

Subject: RE: Export XML from View

If I use the Lotus XML Toolkit to export a view, I only get design data from the view note. I do not get the view’s entries. What makes you think that the Lotus XML Toolkit can export the data that Wouter wants – the data that ReadViewEntries exports?

Subject: RE: Export XML from View

OK ok Rod - point taken - so the answer is clear use ‘readviewentries’ in the backend…

Subject: RE: Export XML from View

Ranjan,

Although the dtd (domino.dtd) included within the XML Toolkit does include entries for view elements, it does not provide the functionality to export views.

The best way forward would be to either utilise the ReadViewEntries url on the backend or to ‘roll your own’ viewExporter using the dtd entries as a starter point.

Regards

Wayne

Subject: Export XML from View

Perhaps the agent can get the data from the URL, or perhaps you can write your own code to process the NotesViewEntryCollection.