We have a Lotus Notes collateral database system running on a Domino server v7.0.2 and are required to export all of the data, including data from all fields on all forms, into either an Access database or Excel.
In order to avoid having to create new views, which will be very time-consuming and labourious, I am trying to find a quicker/easier way of achieving this.
I have Googled this and have found some information on NotesSQL, but when downloading the toolkit, I cannot find an option for this Notes version. I am attempting to download the toolkit for v8, but do not know if this will work.
Can anyone please advise as soon as possible - I have a deadline of this Friday!!!
Thanks
Ruth
Subject: Exporting Data from a Domino Database
The notessql driver version needs to match the client version. So if you run Notes 8.5.3 client you shoudl be ok. The Notessql 8 with a 7.02 might even work but “not supported”
Subject: RE: Exporting Data from a Domino Database
Thank you both very much.
In the end, I was able to download notessql onto the Domino server and have been able to configure an ODBC connection to our Lotus Notes databases.
Thanks again
Ruth
Subject: Exporting Data from a Domino Database
I wrote a tool a few years ago, and made some changes to it earlier this year. It export the data as XML, but I should be able to modify it to generate CSV instead. You can find the current version here:
http://www.texasswede.com/websites/texasswede.nsf/Page/Notes%20XML%20Exporter
However, how do you want to handle things like line-breaks and images/attachments in Excel/Access?
I think XML might be a better choice, then you can do whatever you want with the data. My tool also detach any files attached to teh Notes documents, and extract GIF and JPG images embedded in rich text fields.
I will be out of town Friday, so if you have any questions, contact me before then. My contact info is on my website as well.