Convert NSF database to CSV format

coronoahcoro
coronoahcoro used Ask the Experts™
on
We would like to extract some data off of our Notes database to a CSV format so we can export it into SQL database. Our Notes databases do not have rich text fields, can we write an agent to do this? If we can can you please give a starting point how we could do that. We would like to test what can SQL databases do compared to our Notes databases. Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
    Hi there coronoahcoro,,,

Firstly, Did you try the following ,,, Click File ==> Export , then export the data you are looking for ...

Secondly, I have made some search and found the following ..
http://www.giveawayoftheday.com/nsf+to+csv/
http://wiki.cns.iu.edu/display/CISHELL/NSF+csv+format+(.nsf)
http://www.giveawayoftheday.com/converter+nsf+to+csv/
I recommend you to test them on a local testing database .

Finally, you may also  be looking for one of these
http://www.fileguru.com/apps/convert_nsf_to_sql
http://www.topshareware.com/.nsf-to-sql/downloads/1.htm
http://www.lotus-notes-export.com/lotus-notes-to-sql.asp
Again I recommend you to test them on a local testing database .

Best Wishes


Author

Commented:
The nsf that I'm talking about here is Notes Storage Format from Lotus Notes
Top Expert 2007
Commented:
What you should do is create a view with the fields/columns you want to export, and then just do a file - export and choose csv as the format

I hope this helps !

Commented:
all valid answers and also you can copy all the rows, right click and copy as table and then go and paste it anwywhere and save as csv

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial