Import Sequence Number attribute in Dataverse

Import Sequence Number is an internal field (whole number), that acts as a unique identifier of the data import or data migration that created this record that ensures data consistency and traceability during data import/migration.

Here when we imported around 50 contact records from myFile0.csv, without specifying any value or mapping import sequence number, the system generated an import sequence number and associated it with all the 50 records created using the import.

Next, we imported 3 more records, and this time we manually specified the value for the import sequence number.

We could see the record created with the value we had specified.

Next, we again removed the import sequence number and imported it.

We can see the record created with an auto-generated sequence number i.e. 3

On manually created records from the application, we can see the value being null for it.

As we can see, the primary function of the import sequence number is to track which records were created during a specific import. It allows us to identify records created through import vs manually entered. It can also be used for troubleshooting if there are certain records not created during the import process. When migrating data from another system we can include a corresponding import sequence number in our source data. This can help establish a one-to-one link between the source record and the newly created record inside Dataverse, allowing better handling of failed rows.

Check out – Dynamics CRM Data Migration Tip Using the Import Sequence Number Field

Hope it helps..