Export docs and attachments

HCL Domino Domino Forum
1

I am looking for a tool to export docs and attachments on these documents into an XML format. I know that Domino has the ability to do this, but I am not familiar with Lotuscript enough to be comfortable with the tools provided. Any suggestions on 3rd party tools, or a simple way to do this would be welcomed. TIA

2

Subject: Lotus Notes / Domino Export Utility

We have an Export utility for Lotus Notes which enables you to export Lotus Notes/Domino data from any database /view / document in the following formats:* CSV (comma)

  • PDF

  • HTML

  • Fixed Width

  • Tab Delimited

  • MS-Access

  • MS-Excel

  • MS-Word

  • XML

It fully supports exports from Notes clients and web browsers.

Some of the standard features includes:

  • Export whole documents, selected fields in documents or selected columns in views.

  • Exports can be scheduled.

  • Attachments and OLE objects can be exported.

  • Supply your own customised LotusScript to be executed before/after the export.

  • Notes R6.x clients can run exporting as background threaded agent.

  • Full documentation

  • And more…

Please click the following link for more information. You can download a trial version and even try it out online:

Single user license costs less than an hour of your time.

Regards,

Alex

3

Subject: It could not be much easier than this in an agent that runs on selected documents…

Sub Initialize
Dim ws As New NotesUIWorkspace
Dim session As New NotesSession
Dim db As NotesDatabase
Dim dc As NotesDocumentCollection
Dim doc As NotesDocument
Dim exporter As NotesDXLExporter
Dim stream As NotesStream
Set db = session.CurrentDatabase
Set dc = db.UnprocessedDocuments

filename$ = ws.SaveFileDialog(False,“File name”,"DXL Files|*.dxl, “c:\dxl”, “”)
If Isempty(filename) Then Exit Sub
Set stream = session.CreateStream If Not stream.Open(filename$) Then
Messagebox "Cannot open " & filename$, “Error”
Exit Sub
End If
Call stream.Truncate

Set exporter = session.CreateDXLExporter
Call exporter.SetInput(dc)
exporter.ConvertNotesBitmapsToGIF = True
Call exporter.SetOutput(stream)
Call exporter.Process
End Sub

4

Subject: RE: It could not be much easier than this in an agent that runs on selected documents…

I am getting an error with this script. here it is. Initialize: 12: Unexpected: c; Expected: Operator; ,;

Am I missing something?

5

Subject: Sorry, forgot a quote…

filename$ = ws.SaveFileDialog(False,“File name”,“DXL Files|*.dxl”, “c:\dxl”, “”)

6

Subject: RE: Sorry, forgot a quote…

Thanks for your help! I told you I didn’t know much Lotuscript! :slight_smile:

7

Subject: No problem. The Designer Help has some great examples of how to use the Notes classes.

8

Subject: RE: It could not be much easier than this in an agent that runs on selected documents…

Add an end quote to the following line, and give thanks to Bill. But not necessarily in that order.

filename$ = ws.SaveFileDialog(False,“File name”,“DXL Files|*.dxl”, “c:\dxl”, “”)