How Can We Help?

Search for answers or browse our knowledge base.

Deployment | Administration | Support

< All Topics
Print

Bulk Update from CSV

Bulk update by ids enables migrating from other synchronization systems by setting source and target ids mapping in a CSV file, this will register the entity pair mapping in SyncNow.

Usually bulk update from CSV also is synchronizing entities from both sides and refreshing their data. This process can take a lot of time, SyncNow has an option only to register entity pairs. When this option is checked entities information is saved and they are mapped. Entities will be updated only in next synchronization if they will be changed.

The CSV File Structure

Bulk Sync by IDs execution is based on a CSV file.
For successful Bulk Sync by IDs CSV file should

  • Contains 4 columns with headers:
    • SystemAEntityUniqueIdentifier
    • SystemBEntityUniqueIdentifier
    • SystemAEntityType
    • SystemBEntityType
  • 1 row should contains entities with types accordingly to the entities mapping of the process.
  • Contains less than 10,000 rows
  • To be UTF-8 encoded (without BOM)
  • have as column delimited one of the following symbols ,, ;, \t, |
  • have every entity pair in new line

Bulk Sync Example

  1. Navigate to the Processes page (Figure 2, 3)
  2. Press the Bulk Synchronization button
  3. Confirm that understood that Bulk Synchronization will update many entities in target system and a revert back is impossible
  4. Upload CSV from the file system, for example
SystemBEntityUniqueIdentifier;SystemBEntityType;SystemAEntityUniqueIdentifier;SystemAEntityType
CLS-3930;Story;543618;User Story
CLS-3937;Task;533807;Task
CLS-3917;Bug;548892;Bug
CLS-3918;Bug;544192;Bug
CLS-3916;Story;533810;User Story
CLS-3939;Task;128807;Task
  1. To only register the Sync Pair without refreshing source and target entities from the work systems check the “Only Refresh Synchronization Metadata” checkbox
  2. In the top of the page you can see the progress
  3. Import progress can be viewed In the top of the window
  1. Press the the View Synchronization Status button to monitor the status (Figure 4, 5).
    Button will appear after the sync run will start.
Figure 2. Navigate the Bulk Synchronization page.

Figure 3. Start bulk synchronization by IDs.

Bulk synchronization status will be similar to the one on Figure 4, 5.

Figure 4. Bulk synchronization: mapping entities.
Figure 5. Bulk synchronization: successfully synchronized 4 entities from one system
and 4 entities from another system.

Details about a sync run execution of entities from both systems you can review in the Log and on the Status Entities page (Figure 6).

Canceling Import Process

Import can be cancelled at any time. In order to cancel an import process click the cancel red button in the progress area at the top of the Bulk Synchronization section, synchronization will be gradually be stopped and canceled.

s4.jpg
Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Previous Migration | Bulk Update From Date
Table of Contents