Clever requires a unique ID for every record we process, and each data type contains at least one unique record ID field value: 'School_id', 'Teacher_id', 'Section_id', or 'Student_id'. If two or more records share an ID value, Clever can only process the first record with that ID. The following error will be surfaced: invalid 'section_id (school_id, teacher_id, student_id)' due to error 'not unique'
These unique IDs are used to make connections between data types and therefore need to be unique and consistent across all 5 files. For example, a school record in your ‘schools.csv’ file with 'School_id' “12345” should be identified as “12345” for each student attending that school in the ‘students.csv’ file.
How to fix this error:
- Visit the Sync Report in your Dashboard for detailed information about data that Clever was unable to process.
- Click "Download Invalid Rows" to download a list of records affected by this error.
- Correct these errors in your uploads by determining a truly unique identifier for all records, or filter the data before you upload to Clever.
What about teachers at multiple school sites?
To avoid receiving this duplicate ID error, teachers at multiple school sites should still only be listed once in the teachers.csv file with one school_id as their primary school. However, they can then be associated with sections from multiple schools in the sections.csv file.