lbertrand
2007-03-01T19:57:00Z
We have a MS Access table (Events) that we want to link to a number of Outlook users' calendars. Each user only needs to see his own events in the Events table. What is the best way to do this? Do we create a filter based on the {OUTLOOK_USER} variable? I can add whatever field is necessary to the Events table in order for this to map correctly.

Also, we have a primary key in the Events table, is this enough to ensure that the events and Outlook Calendar records are properly linked? I have specified this as a Mandatory Key of type Primary in the setup menus.

We are using the demo version and have successfully loaded events from our table to one user's outlook calendar thus far.

Thank you for your help.
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2007-03-02T12:41:00Z
Hello,
yes, you can create a filter with the {OUTLOOK_USER} param.

The primary key is enough to properly link the record. If you will write back to the DB; you need also a SQL statement to generate new key value; if you sync only one direction , DB to Outlook, you can ignore the SQL statement for prim.key generation
lbertrand
2007-03-02T22:03:00Z
Thank you for your help. This brings up another question. We want to sync from DB to Outlook but then we want to be able to change the data in Outlook and update it back to DB. So, I guess that's not a true sync. We will never insert a record from Outlook to DB - only update existing records in DB. Can this be done?
Administrator
2007-03-03T14:08:00Z
Yes,

You can use the Auto.Save option (Business license and higher), this will save changes made in Outlook immediately to DB.
You can also use your own Update/Insert statements/stored procedures, see SQL Commands tab in Folder Options.
lbertrand
2007-03-06T16:58:00Z
Assuming I cannot use the Auto.Save option ... If I specfiy Update and Delete SQL statements, does this mean that if I have no Insert statements, no inserts will ever be done? Is there any field that I can evaluate to tell whether the Outlook record was added from the database?

Thank you for your help.
Administrator
2007-03-06T17:29:00Z
Hello,

If you do not specify a custom Insert SQL Statement GeniusConnect will generate a default Insert statement.

If an Outlook Item was Added from the database, GeniusConnect will execute an Update statement or your Custom SQL Statement for Update. (GeniusConnect stores the primary key info in custom MAPI fields OCMPRIMNAMES,OCMPRIMVALUES)

In current version, we do not have an options to ignore inserts, You can try to create a dummy custom insert statement without real DB insert.
Administrator
2007-06-14T17:23:00Z
Feature implemented in version 4.0.0.0:
-"Only update and do not insert Database Items"
If checked, GeniusConnect will ignore Outlook items not added from database