SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Aug 2009
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool Using MySQL - Import from Lotus Notes

    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, although 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.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    if you can get the data into excel, you're on your way

    export it from there into a csv file, then use mysql's LOAD DATA INFILE command
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast
    Join Date
    Jun 2009
    Posts
    98
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    if you can get the data into excel, you're on your way

    export it from there into a csv file, then use mysql's LOAD DATA INFILE command
    Agreed with what r937 said. You can also use a MySQL browser such as SQLyog which has a import from CSV function. LOAD DATA INFILE would be faster and a permanent solution esp if you are looking create a script for later.

  4. #4
    SitePoint Member
    Join Date
    Aug 2009
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool

    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.

  5. #5
    SitePoint Member
    Join Date
    Aug 2009
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb

    just a quick update with outcome... the best option to get linked into lotus notes is using pyodbc - see http://code.google.com/p/pyodbc . this will allow you to run like SQL queries and to obtain data in table format from lotus notes. hope this help others.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •