LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
LinkBack Search this Thread
Old 09-11-2009, 04:41 AM   #1
threaderslash
Member
 
Registered: Dec 2008
Location: HongKong
Distribution: Fedora/Centos/RedHat
Posts: 115

Rep: Reputation: 15
Cool Client Server - Migrate DB from Lotus to MySQL


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.
 
Old 09-11-2009, 05:52 AM   #2
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
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).
 
Old 09-17-2009, 10:52 PM   #3
threaderslash
Member
 
Registered: Dec 2008
Location: HongKong
Distribution: Fedora/Centos/RedHat
Posts: 115

Original Poster
Rep: Reputation: 15
Cool Python - win32com - Lotus direct manipulation

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.
 
Old 09-18-2009, 03:21 AM   #4
ngiamol
Member
 
Registered: Apr 2009
Location: Athens - Hellas (greece)
Distribution: Centos
Posts: 36

Rep: Reputation: 16
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.
 
  


Reply

Tags
member


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to automatically migrate users from server to client? rsamurti Zenwalk 2 12-09-2008 09:35 AM
Does IBM Lotus Notes 8.5 mail Client work with MS Exchange 2003 Server? maiden2 Linux - Software 2 07-02-2008 03:13 PM
Migrate MySQL database to new server babal Linux - Server 4 11-21-2007 01:31 AM
Migrate MySQL database to new server babal LinuxQuestions.org Member Intro 1 11-17-2007 04:45 AM


All times are GMT -5. The time now is 07:56 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration