Apache OpenOffice (AOO) Bugzilla – Issue 17099
Lotus Notes, NSF Files as Database Source?
Last modified: 2014-03-20 14:14:50 UTC
Is it possible to engineering the software to read Lotus Notes NSF files and include it as database source (e.g. for mail merge)?
SBA: Reassigned to Bettina from the User Experience team for consideration.
This is possible on Windows with OpenOffice's ODBC feature and "Lotus NotesSQL", ugly URL: http://www.lotus.com/products/rnext.nsf/873769A79D9C5B2285256A0800720B96/F8BA31E9F7BDEC3A85256C4700667625?OpenDocument I've tried it and it works fine. Here are some details on Lotus NotesSQL: """ NotesSQL is an ODBC (Open Database Connectivity) driver for Notes and Domino. It allows ODBC-enabled data reporting tools, database tools, and application development tools to read, report, and update information that is stored in Domino databases (.nsf files). With NotesSQL, end users and application developers can integrate Domino data with their applications using tools such as Crystal Decisions Crystal Reports, Microsoft Visual Basic, Access, Brio and Lotus Approach. Even Internet application development tools that support ODBC can access Domino data. IT professionals can enable their existing ODBC-enabled applications to access data stored in a Domino database. A Domino database is not relational, but with NotesSQL a Domino database looks like a relational data source to an OBDC-enabled tool. This allows relational database management systems (RDBMS) such as Oracle or DB2 to issue SQL (Structured Query Language) statements to Domino. """
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently 'Unconfirmed' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
Confirmed with AOO410m14(Build:9760) - Rev. 1573601 2014-03-03 17:47:48 (Mo, 03 Mrz 2014) win 7