dcsimmons
2007-10-10T02:54:00Z
I am using Vista 64, Office 2007 with Genius Connect, using a MySQL (5.0) database. I am interested in knowing a way to update the MySQL database, making changes only to the items that are in the particular Outlook Folder. Through the SQL UPDATE command, I want to SET changes in a particular field of the records of the table without making changes to all of the records.

What I want to specifically do is this:

I have 4 folders allowing me a quickview of the status of orders; Confirmed, Shipped, Delivered, Folllowed Up. When an order is placed on the Web server, it is automatically brougnt in through Genius Connect to the "Confirmed" Folder in Outlook. That all works fine. After an order is shipped, the orders are taken from the "confirmed" folder and moved into the "shipped" folder by a macro. Since the items that are now in the "Shipped Folder" were not brought in from the Database, there is no history for them to Synchronize to.

I want to tell GeniusConnect to take these orders that are in the "Shpped" folder and update only these matching orders in the MySQL database to a status of "shipped".

Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2007-11-15T16:43:00Z
When you move Outlook items between folders, Outlook deletes the item from org. Folder and inserts a new item to target folder.
GeniusConnect receives delete message and insert message from Outlook, by default, (if you have Auto.Save and auto.delete options ON), GeniusConnect will try to delete a record and insert a record.

But you want only status update, to solve this problem, You have to overrule the default GeniusConnect behavior to keep the primary key when Outlook item has been moved to a new folder.

You have to set registry param IgnorePrimaryKeyOnInsert to zero.

See also help topic:Advanced registry settings


Ignore Primary Key on Insert
Outlook inserts a new Item during Copy/Paste (or Move to Folder) operations, all values from original item are copied to the new item.

GeniusConnect removes primary key info from the new item by default. (To avoid linking multiple Outlook items to the same database record)

You can overrule this behavior by setting IgnorePrimaryKeyOnInsert value to 0 (zero)

Path: HKEY HKEY_CURRENT_USER\Software\Genius@Work\GeniusConnect\Folders\<Folder ID>
Key: IgnorePrimaryKeyOnInsert
Type: REG_DWORD
Value:1(decimal) or 0 (1=default)

Please note:
Changing this parameter can cause duplicate items in Outlook!