Lotus Domino script snippet Comprehensive Export to Excel/CSV

Lotus Domino script snippet Comprehensive Export to Excel/CSV

This code exports selected/all Notes documents to Excel or CSV.

The code can be run manually on selected documents, or scheduled on all documents in the database
EXPORT_StartScheduled, run by a scheduled agent, exports all documents to a CSV file
EXPORT_CallExportOnClient –> exports selected documents, client-based

The fields to be exported are defined in the EXCEL_MAPPING.
Constants to define in (Declarations):
EXCEL_MAPPING – define: Excel column header 1; Notes field Name 1; Type | Excel column header 2; Notes field Name 2; Type |… etc.
Type 2 = Integer
Type 3 = Long
Type 7 = Date
Type 8 = String

The view to select Notes documents is defined in constant VIEW_DATABASE_INFO