cordial
2013-02-28T12:39:00Z
Hello,

we have a business program with our customer contacts. We would like to have the contacts from the program into the outlook contacts. So we try to import...

Business Program (Tryversion):
UserPostedImage

Genius properties:
UserPostedImage
UserPostedImage
UserPostedImage

Genius can connect the database, but no items will import to outlook. where is the problem. We use the Testversion of Genius. Can anyone help me? I would like to import Name, Adresse and Telephonenumbers.
Administrator
2013-02-28T13:14:00Z
it looks like GeniusConnect is not getting any result from DB, can you try to go to:
-Assing Table dialg
-click Flter Rows
-enter 1=1
-click "Test Query"

you should see some data, if not check your ODBC driver and ODBC datasource settings

http://www.geniusconnect.com/articles/Contact/6/6/ 


Also:
- don't use Names as primary key, use real primary key like "Kunden nummer"
- You don't have to use "File As" Outlook field, Outlook generates automatically "File As" from First/Last Name
cordial
2013-03-01T10:51:00Z
Testquery:

select * from "dbo"."Kundenportal_Kontakt" where 1=1

"No data found!"

I have try with database user "sa" - Same result

ODBC Driver:

Original Windows XP Sp3 driver. I have no other new SQL driver installed - SQL Server / Version 2000.85.1132.00

I have run a testconnection with the ODBC driver and it is successful.

EDIT: I have contact the program company to say me, which table is the correct database table to get the right information.
Administrator
2013-03-01T11:29:00Z
Hello,

SQL Server driver version 2000.85.1132.00 is old.

if you are using SQL Server 2008 , your driver SQL Server Native driver should start with 2009.1XXX , if you are using normal SQL Server driver, ver should start with 6.XXX.

What is your Outlook version? Check also if you have correct Unicode/Non-Unicode GeniusConnect version.

You can use our Outlook version detection tool
to use correct GeniusConnect version:
http://www.geniusconnect...les/GeniusConnect/2/3/4/ 
cordial
2013-03-01T12:17:00Z
Hello,

Microsoft Outlook® 2007 Version:12.0.6423.1000 (32-bit)

Geniusconnectverion installed:

GeniusConnect-32-Unicode5-0-1-1R2

SQL Native client:

I have installed the following client and try again: SQL Server Native Client 10.0 / Version 2009.100.1600.01

Result: Same problems...
Administrator
2013-03-01T12:45:00Z
please send us a Remote session request, we will check your config remotely (techsupport at geniusconnect.com)
cordial
2013-03-05T15:17:00Z
Hello,

Now it works fine WITH data, hehe :)

We delete in the software some dataformation, but in outlook the data is not delete. Its still there. Where can i set it?
Administrator
2013-03-05T15:32:00Z
Hello,

these options are in Assign Table->Options (Delete Outlook item when database record deleted...).
You need Business license to use this feature!