Category: Importing Data

Articles in this Category

Level 6 shows as error in Key to Success import
You may need to update 4Matrix if Level 6’s are flagged as an error in the Key to Success import. Update (January 2017) will handle Level 6 test scores. The DfE have confirmed that the actual ...
Article rated 3.0/5.0
Gender column not recognised
Right click the Gender column header and select Refresh.
Article rated 3.0/5.0
Importing Key Stage 2 Data
We strongly recommend importing data from Key to Success where possible. You can download your KS2 Test Levels and Teacher Assessments from Key To Success (K2S) and import them into 4Matrix.
Article not rated yet
Error: Input Array - Import Error
Issue: An error occurs when attempting to import data via a spreadsheet into an existing series in which result
Article rated 5.0/5.0
Can I import Mastery statements?
This is not possible to do at the moment, but it is something that we plan to look into in 2019.
Article rated 3.0/5.0
Can I Import Key Stage 2 data/Scaled Scores? How do I use them?
It is possible to import Scaled Scores for the 2018/19 Y7, 8 and 9 using the Key to Success import routine (Admin > Spreadsheet > Key to Success) for these pupils. The only tool which c
Article rated 3.5/5.0
Can I import more than 1 set of Key Stage 2 results for a pupil?
It is not possible to import more than 1 set of Key Stage 2 results into a single pupil record - except for the fact that you can add a custom KS2 result alongside their Test Level, Fine Points and Te...
Article rated 2.3/5.0
Can I use your AWL tools to import and manage KS2 pupils?
4Matrix is designed to support key stages 3, 4 and 5. Although some of our AWL tools may appear to be compatible with any year group, the fundamental processes for importing and managing data, along w...
Article rated 3.0/5.0
Error: (Spreadsheet import) Could not load file or assembly C1.Win.C1FlexGrid2
This is because of a missing (or out of date) file in the 4Matrix directory on the client, C1.Win.C1FlexGrid2.dll A 4Matrix support agent will need to send a copy of this file to the user to add to th...
Article rated 3.3/5.0
Error: SIMS Extract unable to extract pupil details successfully
This may indicate that your SIMS Extract files (which reside with the 4Matrix installation) are corrupt. You should re-install 4Matrix on the affected client or ask us to send you the most recent SIMS...
Article rated 3.0/5.0
Error when trying to paste FFT Extract into 4Matrix
This may be for 2 reasons; Make sure that you have not edited the downloaded file in any way Check that it is the right extract - you need to use the op
Article rated 3.0/5.0
Error when trying to paste Key to Success extract into 4Matrix
Make sure that you have not edited the extract file in any way.  If your file is unedited please contact us for assistance. 
Article rated 2.8/5.0
Fine Grade formats
4Matrix now supports multiple fine grade formats and it is possible to use a mixture of these in the same series (except for KS3 NC Levels).  As well as the standard 1, 2, and 3 to indicate high, mid ...
Article rated 3.0/5.0
I can't find a qualification when mapping
There are over 8000 qualifications in the 4Matrix database, but in some cases, you might find that the one you're after is missing. The first thing to do is search by QAN - that's the unique 8 digit c...
Article rated 3.0/5.0
How do I deal with unmatched pupils in Step 5 of import?
There are generally 2 reasons as to why a pupil is unmatched; They are a new pupil to the school (and 4Matrix) and therefore they have no singeing record in the database. Select the pupil, right clic...
Article rated 3.0/5.0
In what order should I import data into 4Matrix?
Ultimately, it doesn't matter which year group you import first or whether it's contextual data or results/grade data. Users should be aware that 4Matrix can be unstable without any result/grade data ...
Article rated 2.5/5.0
Pupils incorrectly appear in more than 1 class for the same subject
If you find that pupils are incorrectly appearing in more than 1 class for the same subject, you will need to re-import your class data. In the final step of the import, there is a tick box - 'Overwri...
Article rated 3.0/5.0
SIMS Extract tool won't launch
After selecting the 'save to' location, there is another tick box that says ‘run from custom location’. Tick this, and then select another location in the field below (it can be the same as the ‘save ...
Article rated 3.0/5.0
SIMS not matching pupils correctly
This might affects schools with hosted SIMS as they have to use the reports from If there is no MIS ID then the creation of the marksheet generates one automatically, hence...
Article rated 3.0/5.0
Subject column header shows red warning triangle
This is usually displayed for 2 reasons; You already have a subject in your database with the same name but mapped to a different qualification You
Article rated 3.0/5.0
Unhandled Exception error after completing spreadsheet import
This is usually related to either the formatting in the original spreadsheet or a corrupt map file. In Excel, copy the sheet you're working with and paste the data into a new sheet using Paste > Va...
Article rated 3.0/5.0
Validate Data throws lots of errors
The most common reason for this is incorrect subject mappings, whether deliberate or accidental.  For example, you may be importing 9-1 grades for English Language, but you have accidentally chosen th...
Article rated 3.0/5.0
What is a series?
A series is a snapshot of performance - a Y11 Autumn 1 series may refer to teacher assessments that were taken before Autumn half term. Over the course of a year, 4Matrix can be used to analyse, diagn...
Article rated 3.0/5.0
Why has the 'import Key Stage 2 base data' option been removed from the SIMS extract?
Generally, this option would only import the English and Maths test levels. For Progress 8, this is not enough. Fine Points, Test Levels and Teacher Assessments are required. We recommend obtaining yo...
Article rated 3.2/5.0
I can only enter numeric grade 0 for some 9-1 subjects
If the subject is linked to a 9-1 generic 'QAN 0' subject, it is possible to import a numeric grade 0.  However, if the subject is linked to a specific QAN code, a numeric grade 0 is generally not acc...
Article rated 3.0/5.0
SIMS Extract Error: Could not load file or assembly 'AbstractProcesses.DLL'
This error can occur when clicking Run Extract after choosing a location to save a copy of the Extract to. This can mean that there is a problem with the SIMS.INI file and we recommend contacting us b...
Article rated 2.6/5.0
Importing KS4 APS starting points for Y12 and Y13
Key to Success Import Method The Admin > Spreadsheet > Key to Success import method can be used to import the following: 1) Key s
Article rated 3.1/5.0
Bromcom Extract error at Date Selection
If you get an error when using the Bromcom Extract tool, after supplying your log in details and reaching the date selection stage, this is most likely due to invalid permissions. > In Bromcom, go ...
Article rated 3.0/5.0
Error: 4Matrix already contains entries for some subjects / Multiple Entries
If the SIMS or Bromcom extract produces multiple results for the same subject, or if you’re adding results to a series containing early entries, you will see a prompt like the one shown below.
Article rated 3.7/5.0

Powered by Help Desk Software HESK, in partnership with SysAid Technologies