Does anybody know how to Export a document in a Lotus Notes Database using VB? I cannot seem to find an applicable method in the Object Browser. I would like to Export the document as a CSV.
Basically, I am trying to do the File > Export thing on VB.
Thank you.
Subject: Export as CSV not a notes option from a document
So the best thing to do is write your own exporter
I have set one up that calls exportDoc(doc as notesdocument, filepath as string, fieldlist as variant)
Then the sub exports the fields listed in the fieldlist array, in the order given, from the doc supplied to the csv file specified in the filepath string
It’s a trivial task to make sure that text fields have quotes around them, numbers & dates don’t, and that RTFs export their text values
Subject: Tak a look at this…
As Christopher already said, it is trivial to write a CSV exporter yourself.Often I don’t even bother to use existing code, I just write it from scratch when needed.
You can perhaps take a look at the CSV export code I posted at Export Notes view to Excel – with multi-value fields – TexasSwede and get inspiration from it…