Export to excel from multiple databases (bulk export)

HCL Domino Domino Forum
1

Hi,

I have to export data from 300+ lotus notes databases to excel. Is there any way or tool which can export data from all db’s to different excel sheets? I am not looking to export from each database. Looking for some automated way to export from all lotus notes databases.

Thanks for your help

Rao

2

Subject: Export to excel from multiple databases (bulk export)

You could write an agent to do this, assuming you run it under an ID that has access to all those databases.

Loop through each DB using NotesDBDirectory.GetNextDatabase.

Then Loop through each document using NotesDatabase.AllDocuments.

There are plenty of posts here about writing to files, including Excel files to help with the details.