Hi Everybody..

I need to migrate data from Lotus Notes (LN) to MySQL system.

I googled around, but didn't find much information about it.

The LN has an option to export data like Lotus 1-2-3, which allows you to open the data into excell, but nothing apparently to MySQL.

I also opened the MySQLMigration-ToolKit. In the import DataBase System, it doesn't appear LN as an option of supported systems.

I hope somebody has gone through this issue before, and was successful in fixing it?

We are trying to keep things using freeware and cross-platform, although sometimes providing final customer products that run on MS.

There is any tool available around, or should we go and code the routines to read the tables from Lotus to MySQL using a programming language like C?

Any hints are mostly appreciated.

Can you export to csv? If so, have a look at load data infile at the MySQL site. Unfortunately you will have to recreate the tables; but I assume that the same will be the case when exporting to lotus-1-2-3.

mysqlimport provides a commandline interface to the "load data infile" statement (see the MySQL manual).

Hi.. Thanks for some previous input.

After working on it, it seems that the best choice to directly manipulate Lotus is to use Python with win32COM - http://www.boddie.org.uk/python/COM.html . I installed ActivePython 2.6 compiler, which comes with integrated win32com.

However, when I try to run.. it gives me the error:

--x--x--

ActivePython 2.6.2.2 (ActiveState Software Inc.) based on
Python 2.6.2 (r262:71600, Apr 21 2009, 15:05:37) [MSC v.1500 32 bit (Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import win32com.client
>>> sess=win32com.client.Dispatch("Lotus.NotesSession")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "C:\dev\python\Py26\lib\site-packages\win32com\client\__init__.py", line 95, in Dispatch
dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
File "C:\dev\python\Py26\lib\site-packages\win32com\client\dynamic.py", line 98, in _GetGoodDispatchAndUserN
ame
return (_GetGoodDispatch(IDispatch, clsctx), userName)
File "C:\dev\python\Py26\lib\site-packages\win32com\client\dynamic.py", line 78, in _GetGoodDispatch
IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.IID_IDispatch)
pywintypes.com_error: (-2147221005, 'Invalid class string', None, None)

--x--x--

Any suggestions? Some help is mostly appreciated.

I will keep working to get it fixed, after I post the working solution here.

Before a year i had to convert an access db to mysql. I took and tested almost everything on net, but unfortunately, due to the local language, the convert was unsuccessful.

One day ive found the full convert of spectral core. I downloaded the trial version and tried the conversion.
It done within 2 mins for 1.5gb database and mostly error free.

I cant say that is best for you, but you have nothing to lose for trying it.