Salvadori, Andrea
2006-12-13T12:32:00Z
Hello,
can i map Outlook combo ID to database ID? Is possible to do it by forcing field conversion for field that has Outlook Type = DB Type?
Thanks
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2006-12-13T12:38:00Z
What do you mean with "Outlook combo ID"?
Salvadori, Andrea
2006-12-13T13:45:00Z
For example the Categories field in a Outlook Activity.
Administrator
2006-12-13T14:00:00Z
Outlook returns category as string using ; as separator

So if you select category Personal and Status

Outlook returns: Personal; Status
Salvadori, Andrea
2006-12-13T14:29:00Z
But can i force the value "Personal" to be written in the database as the value "x" and viceversa with the Conversion function?
Thanks
Administrator
2006-12-13T14:40:00Z
No, You have to use custom SQL Commands (stored procedure) and remap it in the stored procedure.

Please note: User can create any category he want's, so static mapping like Personal = 1 will never work,
If User Adds a new Category "MyJohnCategory" what do you want to write to DB?