'Record was not matched' - how to fix mismatching student ID numbers
This is a common reason why you might be unable to publish data and import to Connect Interactive / report. Connect Data uses Student ID numbers to link your Cohort and Grades, so if the IDs do not match, the software will be unable to create your Gradepoint.
The following article provides step by step instructions on how to add leading zeros to your Student IDs in Excel.
- Open your data in Excel.
- The new system does not allow you to import any information that is incorrect, so if the leading zeros are missing and the student IDs do not match, you will have to edit the data at source rather than exporting it from Connect Data into Excel.
- Add the leading zeros into an empty column, this column must be formatted as Text.
- Double click in the bottom right corner of the cell, then select ' Copy Cells' if it fills in as a series.
- In the next column, you need to add these zeros onto the front of the student ID. Do this by using the formula '=(leading zero cell) & (student ID cell)'. In the example below this is =K1&A1
- Double click in the bottom right hand corner of this cell to apply the formula to all cells in the selected columns.
- Copy this column of data, then 'Paste Values' into the student ID column.
- Delete the extra columns - the 00 and formula column.
- Go back into Connect Data and start the import wizard.
- Follow the steps appropriately with the new student IDs.
- If you paste data in then please untick 'Does this data contain headers' if your data does not have headings. This is available on the column mapping screen.
Related Articles
Importing Student Data
To set up a new year group in Connect, you can export your MIS data to excel and upload it into the Connect Data Management area. Please note the process for importing Student Data is the same for KS4 and KS5, the only difference being the Prior ...Grade Errors
This article will show you some common grade errors that you may come up against when importing grades data into Alps. Invalid Subject Mapping This error can occur when you have chosen the incorrect subject in the subject mapping step that doesn't ...Importing your Exam Results
Exam Results imports are reserved for the End of Year examination grades that your students receive on Results Day. Any other grades should be entered as a Monitoring Point. You will be able to import these Exam Results on or before results day ...Editing Student Data
If you need to edit your existing Student Data, you can do so by either editing individual students or uploading data in bulk. For example, you may wish to edit individual data if a student has left your college/school, or you could do a bulk upload ...Students not included in Key Indicator Calculations
Value added progress cannot be calculated for students without a prior achievement score. The Alps report will show you the individual students did not have a prior achievement score in the data file you submitted to Alps. Please check that these are ...