Nübling, Tommi
2007-09-01T19:53:00Z
Hi, I have a problem with the sync. I use a MySql database with a datetime column. I use this field with the LastModification Fild in Outlook 2003. I have the newest Version of Genius Connect private edition.

Should I use a sql statement for the DATETIME field? Which one, because the sync is not working. The DATETIME fileds will not be updated.

Thanks for help.
Nice software. Tommi
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2007-09-02T12:25:00Z
The column in database is not updated? Is the column mapped to an Outlook column?
Try to use the SQL Trace (GeniusConnect setup->Advanced Admin options) and investigate the trace file.
Nübling, Tommi
2007-09-03T11:10:00Z
Hi,

it's a DATETIME column and mapped to LastModification time. But perhaps this column needs a sql statement? For the id I use: "select MAX(id)+1 from adressen". So its' possible to store a new item from Outlook in the database. But the items not will be updated, only from database to outlook but not in the other direction.

Thanks for help.
Tommi
Administrator
2007-09-03T11:38:00Z
If the column is mapped, you do not need a SQL Statement, it will get Outlook value from mapped column (LastModification ) and
store it to DB.

If you change the item in Outlook (this will change LastModificationTime value) and the hit Store Item, whate update statement will be generated? (SQL Trace file)

Nübling, Tommi
2007-09-04T12:57:00Z
Hi,

I have no Trace File. I searched in the directory specified in the help file. When I now update a address with "Store Item" it will be deleted. Is there no manual for use with mysql. Like a configuration help tutorial?

Greets Tommi
Administrator
2007-09-04T13:02:00Z
What will be deleted? Trace File, The database record or Address data?
Are you using custom SQL Commands? Without using wrong SQL Command, GeniusConnect will never delete an record during "Store Item".

There is an mySQL Example database and mapping template:
See help topic: mySQL
For config steps, (same for all examples), you can use help topic : Microsoft SQL Server