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):


Genius properties:




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.

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

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.

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/ 

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

please send us a Remote session request, we will check your config remotely (techsupport at geniusconnect.com)

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?

Hello,

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