Updating Unique Identifier (aka ID) Data Manually
Users can update individual unique identifiers one at a time directly in the System Administration interface. For example:
- Navigate to Courses & Sections.
- Click into a specific Course Detail page.
-
Select Edit Details.
This will open a flyout where you can modify the section_ID.
Updating Unique Identifier Data in Bulk
When a larger number of updates are required, System Administrators can submit a request through our Help Center. Be sure to attach a spreadsheet with a column of the ‘current IDs’ and a column with the ‘update-to-IDs.’ See example below.
Example data above show the current and updated ids, which will need to be provided to Watermark Support
For information on how to submit a Support request, please see the article linked Contacting Watermark's Client Support.
Reviewing Current Data
Obtain and review current data by exporting it from a Data Page in System Administration.
Data Types and Unique Identifiers
The table below shows which data files support updates via CSV and which field serves as the unique identifier:
| Data Type | CSV File Name | Unique Identifier |
|---|---|---|
| Organizations | organizations.csv | organization_code |
| Programs | programs.csv | program_code |
| People | person.csv | person_id |
| Terms | terms.csv | term_id |
| Courses | courses.csv | course_catalog_code |
| Sections | sections.csv | section_id |
| Enrollments | enrollments.csv | (None) |
| Person Attributes | basicpersonattributes.csv | (None) |
| Student Term Attributes | studenttermattributes.csv | (None) |
| Program Curriculum | programcurriculum.csv | (None) |
| Cohort Enrollments | cohortenrollments.csv | (None) |
| Roles | roles.csv | (None) |