Solved

Opening a 6.5 nsf file in 8.5

Posted on 2010-11-15
8
958 Views
Last Modified: 2013-12-18
Hi Lotus Notes Expert,

I am wondering if it is possible to copy a *.nsf file that was created in 6.5, copy it onto a different machine and open it up in 8.5.

Come to think of it, I really don't care all that much whether it opens up in 8.5 or not, but I do like to grab the data and dump it into Access or Excel.

So far what I have tried is to copy the *.nsf file created in 6.5, created an ODBC Data Source with a Lotus NotesSQL Driver and pointed it to the nsf file.  When I try to connect to it via MS access I get the following error message: "[lotus][odbc_lotus_notes]cannot open specified database".

thank you

thank you
0
Comment
Question by:yechan
  • 2
  • 2
  • 2
  • +1
8 Comments
 
LVL 4

Expert Comment

by:MtnChick
ID: 34140124
I regularly use databases created in 4.5 in my current version of Notes (8.5) so I don't see any reason why that would be an issue.  The real question would be...does your ID have access to open it?  You can't open a Notes database through MS access or straight through Notes without the correct ACL permissions.
0
 
LVL 1

Author Comment

by:yechan
ID: 34140180
Gotcha.  That is great to read that opening 6.5 nsf files in Lotus 8.5 is not an issue.  I do not have an ID to open it.  Will talk to the administrator tomorrow.  Perhaps she can help me out.  

Since this my first day working with Lotus, please excuse this newbie question.  The Lotus Domino, is that a Server where all the *.nsf files are being stored?

Many thanks
0
 
LVL 4

Accepted Solution

by:
MtnChick earned 250 total points
ID: 34140206
Yes, Domino is the server platform.  Although nsf fles can be created locally as well.   At a minimun, the server or author will have access to file.  The admin should be able to give you permissions to open.  
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 34141653
I usually grab Access or Excel data and dump it in a Notes database... ;-) Read up on Notes, you'll be astonished how much it can do!

http://www-10.lotus.com/ldd/dominowiki.nsf/
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 3

Expert Comment

by:ironclads
ID: 34159323
FYI, with few exeptions, the only time your .nsf changes is when you use an element not native to the release your db was created on.  So, if I were to create an XPage, my nsf (db) becomes an Notes 8 db instead of a 6.5 db, since xpages didn't exist with 6.5.

As for the NotesSQL stuff, here's some links that might provide information I surely can't give you. (Not my thing, sorry):
http://www.builderau.com.au/architect/database/soa/Create-an-ODBC-connection-to-a-Lotus-Notes-database/0,339024547,320282240,00.htm
http://www.databasejournal.com/features/mssql/article.php/3462011/Connect-to-Lotus-Domino-using-SQL-Server-Linked-Server.htm

Good Luck.

-TIM

0
 
LVL 1

Author Comment

by:yechan
ID: 34163302
Hi all,

sorry for responding so late.  Things here takes a while to push through let alone all the paperwork i had to fill out just to get a login.  

I think I will try IronClads solution as a last resort because I am afraid to muck around with the server (i.e. installing NotesSql) because it's a Windows 2000 box running Domino Server 6.5 and nobody here knows Domino Server in case it breaks down.  =(

Just to be sure.  If I create a database (i.e. nsf file) on the Domino Server 6.5 and copy that nsf file onto my local machine that has Lotus Notes 8.5 installed, I can open it?
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 34164451
Don't copy that directly from the server, as a file. Do it the Notes' way: make a replica of that database to your local Notes environment. It is in fact almost a file-system copy.

A Notes copy of a database creates a new database with all the data from the original database, but it is not a replica. The background replicator task copies documents between true replicas only, so that both sides will contain the same documents (unless specified otherwise).

And programming it in Notes? Not your cup of tea??
0
 
LVL 3

Assisted Solution

by:ironclads
ironclads earned 250 total points
ID: 34165379
You can copy and paste using the Windows Explorer if you wish, and it's ok to do this, but if Domino has a hook into this database, it won't let you.  You'd need to shutdown the Domino server to release the db hook.  Even if you copy and paste it, it will be a replica of the server's db, not a copy.  Sjef is right, typically it is best just to create a copy of the db.  You can do that from your 8.5 client.  Add the server db to your workspace or open the db, then do a "file...\application...\new copy" to make a local copy.  If instead you want it to be replicating with the domino server, just do a "file...application...\new replica" and make a replica to your local.  This way you can replicate changes to/from the domino server to your local replica.  Everyone has to agree, Lotus replication is a thing of beauty.  No one comes close to it's sophistication.

Good Luck.  Let us know if you still have questions.

-TIM
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now