I'm having issues syncronizing one table of my sets. I update the records, create new ones but the records show no updates and the records not appears in the CRM. see attached files.
Records Not Updating
- Last Post 13 June 2017
Most likely, you SQL Server database table doesn't have autogenerated primary key.
The main requirement for synchronizing database data is that the primary key columns of the database tables must be autogenerated.
A Synchronization package synchronizes data between a source and a target in both directions. When synchronization is performed for the first time, it does not check whether the records in sources are identical and simply copies data from one side to another and vice versa, and "maps" the original records to their copies in another source. During subsequent synchronizations, if a record is modified or deleted in one source, Skyvia modifies or deletes the data, mapped to this record in another source, and vice versa.
If a record synchronization fails when a synchronization is performed for the first time or after resetting LastSyncTime parameter, the changes, made to this record, won’t be detected and synchronized during the subsequent package runs. However, if you add a new record to one of the sources, the next package run will add it to another source.
We have studied your package. You use constant mapping with the value "true" for the SourceCRM field in the target to source mapping. You have also selected "Use this value as filter of target records" check box. This means, that when you add a new record or change an existing one in the SQL Server table and the SourceCRM is not equal to true, this record won't be synchronized. A tracking table will have a value for this record, but the package filter will filter out this row. For more information, please refer to https://skyvia.com/resources/docs/index.html?constant_mapping.htm
Please make sure that you set true for the SourceCRM column when you add a new value to the SQL Server table.