Issue 17099 - Lotus Notes, NSF Files as Database Source?
Summary: Lotus Notes, NSF Files as Database Source?
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC
Hardware: PC Windows, all
: P5 (lowest) Minor with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-19 05:44 UTC by Unknown
Modified: 2014-03-20 14:14 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: 4.1.0-beta
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-07-19 05:44:03 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)?
Comment 1 stefan.baltzer 2003-09-08 17:29:52 UTC 
SBA: Reassigned to Bettina from the User Experience team for consideration.
Comment 2 dcca2302 2004-02-18 18:32:27 UTC 
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.
"""
Comment 3 ace_dent 2008-05-16 02:13:56 UTC 
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
Comment 4 bettina.haberer 2010-05-21 15:03:24 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".
Comment 5 Edwin Sharp 2014-03-20 14:14:50 UTC 
Confirmed with
AOO410m14(Build:9760)  -  Rev. 1573601
2014-03-03 17:47:48 (Mo, 03 Mrz 2014)
win 7