Hans
2006-02-22T10:08:00Z
Hi,

We are currently testing your software for use in our own commercial PIM software package to sync appointments from-and-to Outlook.
Therefore we built one table "outlookagenda" in our database containing all appointments from our system. This table is maintained by database triggers to the "real" appointment tables in our database.

QUESTIONS:
1. is it possible to recognize wich records in our "outlookagenda" table are updated by GeniusConnect? For inserted records by GeniusConnect I can specify default values for mandatory fields. I really would like to have such a feature for updated records (my own triggers then can "reset" such a value after handling the records).

2. is it possible to use the current outlook username as a dynamic parameter for the retrieval filter? (our customers all use an exchange-server in combination with active directory, and I don't want all clients to login to the database with their own name, so I don't have the possibility to extract it from the database). Or can I just use the WINDOWS_USER variable then (is that allways the same as the outlook user)?

3. I've got a problem with the "Assign table" dialog: after some testing, it does not show all fields anymore for the agenda-folder (e.g. start, duration, organizer are missing). I've read in the forum that you use the 1st custom-form you can find for displaying the fields? But i'm not using custom-forms... I suspect that some "corrupted" appointments are somewhere in my outlook agenda (invisible). Do you have some hints/tips for me to resolve this?

Thanks

NOTE: I noted that you keep the logfile locked until Outlook is closed (I cannot open it). Maybe you can resolve that in a future version?

Hans
Administrator
2006-02-22T12:09:00Z
Hello,

1. is it possible to recognize wich records in our "outlookagenda" table are updated by GeniusConnect? For inserted records by GeniusConnect I can specify default values for mandatory fields. I really would like to have such a feature for updated records (my own triggers then can "reset" such a value after handling the records).

You can define a (Mandatory/Primary keys dialog) mandatory field with a select statement returning always a flag value
like select 'this is from outlook' or you can use the Timestamp value See help file topic "Timestamp"

2. is it possible to use the current outlook username as a dynamic parameter for the retrieval filter? (our customers all use an exchange-server in combination with active directory, and I don't want all clients to login to the database with their own name, so I don't have the possibility to extract it from the database). Or can I just use the WINDOWS_USER variable then (is that allways the same as the outlook user)?

You can use:
{DB_LOGIN_USER}
{DB_USER_NAME}
{WINDOWS_USER}

"is that allways the same as the outlook user?"

It depends on your setup, if you are using MS Exchange the User account often linkes to a NT User, so it may be possible.

Enterig a login name and password per user is not necessary if you are using NT Security to connect with the database!

3. I've got a problem with the "Assign table" dialog: after some testing, it does not show all fields anymore for the agenda-folder (e.g. start, duration, organizer are missing). I've read in the forum that you use the 1st custom-form you can find for displaying the fields? But i'm not using custom-forms... I suspect that some "corrupted" appointments are somewhere in my outlook agenda (invisible). Do you have some hints/tips for me to resolve this?

GeniusConnect uses the first item in the folder only for custom fields, but I'm not 100% sure, we will test this.
Hans
2006-02-22T14:45:00Z
ad 1: in the Mandatory/Primary keys dialog I can only specify values wich will be set by GeniusConnect for NEW records.
I need that functionality for UPDATED records as well... Other processes are updating my table as well and I would like to distinguish the GeniusConnect updates from those.

ad 2: is it difficult for you to implement this in a future version (passing the Outlook user account)?

ad 3: thanks

Hans
Administrator
2006-02-23T23:30:00Z
Hi,

please see 3.0.0.5 or later:
http://www.geniusconnect...es/GeniusConnect/2/3/53/ 

ad 1:
SQL Statements for Mandatory keys are now executed also for Updates

ad 2:
Outlook user dyn.param has been added (only for Outlook 2003 and higher)

ad 3:
You are correct, if the first item in the folder is corrupted, GeniusConnect will use it.
We have fixed this, now we are using also values from a new dummy item with default columns (depends on Folder type).

Please let me know if 3.0.0.5 helps.