Hi.
I'm currently checking out GeniusConnect to see if has the features that we need. Our setup is that we will have multiple staff members syncing Outlook contacts with a MySQL database. After data from Outlook has been synced to a 'holding' table in the database it will then be examined by our software which will copy and update changes to another table which is used as the backend for a web-based application. This should enable individual field changes in Outlook and the web application to be synced in both directions. I've tested out most of the process and it all seems like it will work, however, I have a couple of questions.

As we will have multiple staff members syncing Outlook to the holding table is it possible to record the Windows User that has stored the record into the table? I see that the Windows User is available for filtering records when syncing, is it also possible to have it put into a field in the database when contacts are stored? For course it make no sense to try and load the value from the database.

Also, do you have any recommendations for which Outlook contact field
would be best to store a value from the database that should never be edited by a user in Outlook? I plan on storing a contact version number (or modified time) in Outlook which is a record of when the contact was loaded from the database. This means that when a contact is stored back into the databse our software can use the version number/modified time when processing the holding table.

Thanks for your time.
Cheers
Toro

Hi,

the Windows User is available only for filtering, but you can create a SQL statement like 'select CURRENT_USER()',
and use this statement for a mandatory field in GeniusConnect. GeniusConnect will run the statement before insert
and use the result of the statement in the Insert statement.

But the best way to solve this, are database triggers. It is always better to cover this on the server then on the client.


"Also, do you have any recommendations for which Outlook contact field
would be best to store a value from the database that should never be edited by a user in Outlook?"
You can use one of the 4 UserFields on ContactItem, but user still can edit it!