It is recommended that you always include the following fields in mapping so that Outlook contact items could be more correctly filled in: FullName, FileAs and Subject. It is important during downloading when new items are created within the Outlook. If you do not include these fields, the created contact items will not look good in Outlook.
To prevent uploading of these fields back to database (several fields cannot be uploaded into one database column at the same time), please use CanRead=false as described in the sample below:
<mapping>
<PropertyName>FullName</PropertyName>
<ColumnName>full_name</ColumnName>
</mapping>
<mapping>
<PropertyName>FileAs</PropertyName>
<CanRead>false</CanRead>
<ColumnName>full_name</ColumnName>
<Description>The best value is the same as FullName</Description>
</mapping>
<mapping>
<PropertyName>Subject</PropertyName>
<CanRead>false</CanRead>
<ColumnName>full_name</ColumnName>
<Description>The best value is the same as FullName</Description>
</mapping>
If your database table contains separate columns for first, last and, possibly, middle names, you can create a view in the database and concatenate them into one field.
Sync2DB Developer Team
