Historical Sync

Updated 2 months ago by Devinder Singh

Introduction

Byteline Data Sync efficiently synchronizes existing data in both apps so that you can keep valuable data. This process is accomplished by comparing records in both applications using a unique key. The unique key is a field specific to your records and shares the same value across both apps, even if it has different names. On the fields mapping screen, you simply need to review and modify the selection if necessary. For most integrations, this key is automatically selected. However, if the default selection does not accurately represent your data, it is recommended to be changed.

Changing Unique Keys

Unique keys can be changed from the "Map fields" (#3) screen of the data sync configuration. If you're not currently on this screen, Edit the sync and go to this screen.

The current selection is shown in green.

Note: Unique keys are only considered for the historical sync, i.e., the first time sync. Once a sync is active, unique keys are not checked.
Steps to change

1. Click on the selected key (in green) to unselect it.

Screenshot of: Click on the selected key (in green) to unselect it.

2. Confirm the change.

Screenshot of: Confirm the change.

3. Click on the key icon for the new field to make it unique.

Screenshot of: Click on the key icon for the new field to make it unique.

4. Confirm the change.

Screenshot of: Confirm the change.

How to trigger historical sync?

The historical sync is automatically performed when a sync is started. Once a sync is live, our ongoing sync process will keep your data in sync.

If you're planning to change the structure of your tables and want to perform historical sync afterward. You should follow the below steps:

  1. Stop the sync.
  2. Make modifications to your table(s) structure.
  3. Edit the sync for the new table structure.
  4. Make the sync live, which will perform the historical sync.

Troubleshooting

The record count doesn't match

You have completed the historical sync but subsequently discovered a discrepancy in the record counts between the tables of the two apps. This situation often arises when incorrect unique key(s) are selected. Occasionally, a field designated as a unique key may not be truly unique. To ensure accuracy, you can verify the validity of the unique key(s) by counting the distinct values across all rows. The resulting count should match the total number of rows.

Please note that you have the option to select multiple fields as unique. In such cases, Byteline considers the values of both fields as criteria for matching records (using an AND condition).


How did we do?