Author Topic: Cannot import contacts to LMCE from Outlook  (Read 2611 times)

bulek

  • Administrator
  • wants to work for LinuxMCE
  • *****
  • Posts: 909
  • Living with LMCE
    • View Profile
Cannot import contacts to LMCE from Outlook
« on: November 08, 2008, 11:54:32 am »
Hi,

I did this once some time ago and it worked for me (added description on wiki):

http://wiki.linuxmce.org/index.php/OutlookSync

Since I've sucessfully added few local weather and news xml services to my 7970 phones, I'd also like to get Directory working with Thom's additions.

But I need to import contacts from Outlook to LMCE and it didn't worked for me. I've tried two ways :
1. (as I described in wiki page) - have run it, Outlook asked me to give permissions, but then mysql2outlook crashed with "unhandled exception" and text attached below :

2. I've tried to download sync utility from local core but link doesn't work. Then have searched the disk and found all those files in /usr/pluto/installers. But there is no .msi file, only ImportContacts.zip. I've extracted it and tried that utility too with few possible variations of URL specification, but none works... It says that 0 contacts were imported or updated... In the log I can find that it reads contacts from outlook sucessfully, but then it says :
Code: [Select]
Finish read from Outlook
Database connect catch
Couldn't connect to Contact table
Couldn't log a contact without any name
Database executeSql catch
Contact already exist:Name XXXX
and for each contact it says that it already exists....


Has anyone sucessfully import contacts from Outlook recently ? Anyone else looking for this feature to be functional ?
Any hint, which method is more current and deserves further investigation ?

Thanks in advance,

regards,

Bulek.


 






Quote
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.OverflowException: Arithmetic operation resulted in an overflow.
   at mysql2outlook.frmOutLookUpdate.PrintPhone(Int16& Buff, String& PhoneType, String& Phone)
   at mysql2outlook.frmOutLookUpdate.PutData2MySql()
   at mysql2outlook.frmOutLookUpdate.Command1_Click(Object eventSender, EventArgs eventArgs)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
mysql2outlook
    Assembly Version: 1.0.2459.12732
    Win32 Version: 1.0.2459.12732
    CodeBase: file:///C:/Program%20Files/SCB/mysql2outlooksetup/mysql2outlook.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
Interop.Scripting
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files/SCB/mysql2outlooksetup/Interop.Scripting.DLL
----------------------------------------
Interop.MSXML2
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.0.0
    CodeBase: file:///C:/Program%20Files/SCB/mysql2outlooksetup/Interop.MSXML2.DLL
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 7.0.5000.0
    Win32 Version: 7.10.6001.4
    CodeBase: file:///c:/windows/assembly/gac/microsoft.visualbasic/7.0.5000.0__b03f5f7f11d50a3a/microsoft.visualbasic.dll
----------------------------------------
System.Drawing
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
AxInterop.MSWinsockLib
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files/SCB/mysql2outlooksetup/AxInterop.MSWinsockLib.DLL
----------------------------------------
Interop.MSWinsockLib
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files/SCB/mysql2outlooksetup/Interop.MSWinsockLib.DLL
----------------------------------------
Microsoft.VisualBasic.Compatibility
    Assembly Version: 7.0.5000.0
    Win32 Version: 7.10.3077
    CodeBase: file:///C:/Program%20Files/SCB/mysql2outlooksetup/Microsoft.VisualBasic.Compatibility.DLL
----------------------------------------
CustomMarshalers
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.573
    CodeBase: file:///c:/windows/assembly/gac/custommarshalers/1.0.5000.0__b03f5f7f11d50a3a/custommarshalers.dll
----------------------------------------

************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.


« Last Edit: November 14, 2008, 03:05:57 pm by bulek »
Thanks in advance,

regards,

Bulek.

bulek

  • Administrator
  • wants to work for LinuxMCE
  • *****
  • Posts: 909
  • Living with LMCE
    • View Profile
Re: Cannot import contacts to LMCE from Outlook
« Reply #1 on: November 14, 2008, 03:07:22 pm »
Hi,

I have found no further info on this one. Really noone tried to import contacts into LMCE or with some knowledge about those two approaches ?

Thanks in advance,

regards,

Bulek.
Thanks in advance,

regards,

Bulek.

sp00nhead

  • Veteran
  • ***
  • Posts: 69
    • View Profile
Re: Cannot import contacts to LMCE from Outlook
« Reply #2 on: November 14, 2008, 04:15:33 pm »
I'll have a go this weekend and see what happens. Which version of outlook you using?

bulek

  • Administrator
  • wants to work for LinuxMCE
  • *****
  • Posts: 909
  • Living with LMCE
    • View Profile
Re: Cannot import contacts to LMCE from Outlook
« Reply #3 on: November 14, 2008, 06:03:07 pm »
I'll have a go this weekend and see what happens. Which version of outlook you using?

2003 SP2. As described, found two ways and no info which one is more recent... But I guess that we're not so far from working solution...

Thanks in advance,

regards,

Bulek.
Thanks in advance,

regards,

Bulek.