- 15 Nov 2023
- 1 minute read
- Print
- DarkLight
- PDF
Cleaning up School-Scoped Data
- Updated 15 Nov 2023
- 1 minute read
- Print
- DarkLight
- PDF
There are times where you'll want to clean up school-scoped data, this can happen by:
Using a query to export current school data
Use Excel to clean the data up
Using Upload Dataset to reimport the school data
Export School-Scoped Data
Run a new query using:
Type - Configurable Joins
Category - Related
Base - School, This will return one school record per row
Add at least the following exports:
Person - "Reference ID" - A unique person-scoped identifier. You may also export any other unique person-scoped identifier.
School - "GUID" - A unique school-scoped identifier. This is the GUID, or ID, of the school record.
Filter on the desired records.
Run and export the query.
Clean the Data using Excel
Open the file from #1
Clean the data in Excel
Save the file
Reimport the Data
Using Upload Dataset, reimport the file from step #2. This import should be Unsafe. You should at least be mapping:
"Ref": "Record" → "Slate ID Matching Only"
"School GUID": "Schools" → "School: GUID Matching Only"
The data you are looking to set/clean up
Verify the data stored as expected