Forums

 
ForumForumPlug-in and Pla...Plug-in and Pla...Outlook Plug-inOutlook Plug-inWhatWhat's sp name of merge contact with splendidcrm
Previous Previous
 
Next
 Disabled
New Post
 8/12/2013 1:20 PM
 
 Modified By Fred  on 8/12/2013 1:21:10 PM

Hi Support,

we are using outlook 2010 to sync contacts with CRM. we found that it will overwrite the address with the associated account address. Can we know the stored procedure that representing this action? 


I believe the address fields in outlook should go to Primary address field of CRM, but currently it is not.


Thanks

New Post
 8/12/2013 8:09 PM
 
 Modified By Support  on 8/12/2013 8:09:50 PM

The plug-in does its work through the SOAP.asmx service. The mapping of Outlook fields to CRM fields can be seen in the Outlook Plug-in source code file Contacts.cs. Here is a small piece of the code that shows the mappings:

olContact.HomeTelephoneNumber = Sql.ToString(row["phone_home" ]);
olContact.MobileTelephoneNumber = Sql.ToString(row["phone_mobile" ]);
// 02/10/2006 Paul. Use BusinessTelephoneNumber instead of Primary.
olContact.BusinessTelephoneNumber = Sql.ToString(row["phone_work" ]);
olContact.OtherTelephoneNumber = Sql.ToString(row["phone_other" ]);
olContact.BusinessFaxNumber = Sql.ToString(row["phone_fax" ]);
olContact.Email1Address = Sql.ToString(row["email1" ]);
olContact.Email2Address = Sql.ToString(row["email2" ]);
olContact.AssistantName = Sql.ToString(row["assistant" ]);
olContact.AssistantTelephoneNumber = Sql.ToString(row["assistant_phone" ]);
olContact.BusinessAddressStreet = Sql.ToString(row["primary_address_street" ]);
olContact.BusinessAddressCity = Sql.ToString(row["primary_address_city" ]);
olContact.BusinessAddressPostalCode = Sql.ToString(row["primary_address_postalcode"]);
olContact.BusinessAddressState = Sql.ToString(row["primary_address_state" ]);
olContact.BusinessAddressCountry = Sql.ToString(row["primary_address_country" ]);
olContact.OtherAddressStreet = Sql.ToString(row["alt_address_street" ]);
olContact.OtherAddressCity = Sql.ToString(row["alt_address_city" ]);
olContact.OtherAddressPostalCode = Sql.ToString(row["alt_address_postalcode" ]);
olContact.OtherAddressState = Sql.ToString(row["alt_address_state" ]);
olContact.OtherAddressCountry = Sql.ToString(row["alt_address_country" ]);
olContact.Body = Sql.ToString(row["description" ]);

Your description of a Contact address updating an Account address does not seem correct. Contact changes in Outlook should only affect Contact changes in the CRM.

Previous Previous
 
Next
 Disabled
ForumForumPlug-in and Pla...Plug-in and Pla...Outlook Plug-inOutlook Plug-inWhatWhat's sp name of merge contact with splendidcrm