Share via

Update School Data Sync Anchor IDs before creating users


If you want to use SDS (Classic) to create new users from the V2.1 CSV file format, and you’ve previously run SDS using the OneRoster API, PowerSchool Rest API, or V1 formats, you must first run a PowerShell script to update the already created users' anchor ID to the new format.


SDS supports various sync methods including CSV file formats and API-based syncs. SDS can create users from the source data. If it’s your first time running SDS and you want to create users, you can pick any sync method available and create your users. If you have already created users in SDS, each user has an anchor ID extension attribute. The anchor ID is used to identify previously synced and created users to make sure SDS doesn’t create duplicate accounts. By stamping the anchor ID, you can create a new sync profile with the "create users" option. SDS will only attempt to create the users that SDS hasn’t previously synced.


The anchor ID format changed with the recent V2.1 schema enhancement. Instead of using the format of student (SIS ID) and teacher (SIS ID), SDS creates users with user (SIS ID).

If you’ve previously run SDS to create users with another sync profile type and attempt to create users with the new V2.1 CSV format, SDS won't find the previously synced users. The result is errors or duplicate user accounts.


To mitigate the issue, you must run a PowerShell script to update the anchor IDs for all previously synced users to user (SIS ID).

SDS will then find and match all previously synced users and only create new users that haven't been synced before.