Giter Club home page Giter Club logo

nsf2sql's Introduction

NSF2SQL

Convert Lotus notes (.nsf) to SQL

This application finds Lotus Notes applications on a Domino server or local computer and exports the documents to a SQL file or directly to a MySQL server.

The tables are forms with each document as a row.

It stores fields with multiple values as separate tables linked with a foreign key.

Tutorial

Download

1. Download the latest release.

Open

2. Open NSF2SQL.exe.

Search

3. Click [Search Server] to search for an application on a Domino Server or [Search Computer] to browse your computer for a .nsf file.

4. Enter the server information if searching a server or just the password if opening a local file.

Select

5. Select the database to export and click [Export Documents].

Parse

6. Wait until the program is done parsing the documents.

Export

7.Once all documents are parsed it will ask if you want to export to a server. Click [Yes] to have the sql imported directly to a MySQL server or click [No] to have the SQL dumped to a file so you can import it a different way.

8. If you chose to have the program import it directly to a MySQL server it will ask for your server information. Database is the name you want for the new database

9. If you chose to dump the SQL to a file it will be saved to a file called "export.sql" on your desktop and it will be opened after the program creates it.

nsf2sql's People

Contributors

andreamorello93 avatar dependabot[bot] avatar kevingy avatar lesh-andrew avatar uzitech avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

nsf2sql's Issues

duplicate column name

After entering the MySQL database and password information, when the transfer process starts, a "Duplicate Column name Sil" warning is displayed. How can I resolve this issue?

Executing the app

Downloaded and executed the app to get the error below
image
Any support will be greatly appreciated

the apps ask password for opening file

when i try to open nsf file it ask for password? what password should I use?
do i need copy my id file to app's directory?

and what syntax for server connection?
name of the phisical-server?
domain.. ok, but password again.. without username?

Are attachments handled

I'm going to try this when my IT dept have renewed my Domino certificate. Quick question... One of our Lotus Notes R5 databases I want to migrate has PDF attachments with each record. Does your tool handle the attachments and dump them to a folder which can be references by the outputted tables? Cheers.

32 bit

Is there a 32 bit version?

Could not find or load assembly Microsoft.WindowsAPICodePack.Shell

I'm getting this error after clicking Search Server:

image

I've attempted to download the Microsoft.WindowsAPICodePack.Shell.dll from Nuget. I've placed it in the directory with the application, but it didn't seem to help. I also installed nuget.exe and installed it using Nuget. Neither worked. Do you have any suggestions?

run from commandline

I would like to automate export every day. Is it possible to run from commandline and define server/file from parameters ?

"Object reference not set to an instance of the object" error

Hello,
I am trying to open a Notes 9.x .nsf database with this tool. After entering the Notes password I get a popup with the text "Object reference not set to an instance of the object", and cannot proceed further with the target database. What can I do to better diagnose this issue? Thanks!

Export to T-SQL

Hello and thank you for this tool.
I have been using it for about 2 months now. I am doing what I need to do with the MySQL output files, but still - is it possible / do you plan on integrating export to MSSQL (T-SQL)?

"Unable to translate Unicode character" Exception

Screenshot 2021-01-12 at 15 55 26

Hi, I got this exception after I chose to convert my document into an SQL file. It began to format the data, but then it shows me this exception. The SQL file was created but is incomplete, cut in the middle of the creation of a row.

I haven't had this exception with other NSF documents, so I think it could be coming from my data, but I was wondering if you've encountered this problem before and if you have any idea about it.

Notes error: Could not open ID file

Hi!

I'd love to test your tool, but in our environment we have different notes.ini locations, multiple user ID files, etc. in combination with a shared install. Somehow this prevents a successful authentication. I also don't quite understand why your server authentication dialog does not contain a user field - I have multiple users for different purposes an only some are useable for a DB export.

What can I do to make it work :-)?

Regards,
Holger

app server

how to connect another location application server

Grateful for a new release

Thanks for this awesome project.
Could you please publish a new release?
Tried many days to build a .exe file,but failed.

How are answer documents handled?

Hi!

While testing your app (only exporting to file atm), which is great in general ๐Ÿ‘, I noticed that it does not export DocumentIDs. As answer documents rely on them to connect to the main document, I wonder how you are handling this. Are the connections lost or do your reconnect them via newly generated primary keys?

Regards,
Holger

mssql connection error

image

see attached screen, may you provide as well which db versions (ms sql & my sql ) should be used and if possible how to make proper setup for connections and db itself how to properly run export to db ? many thanks

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.