4Matrix 4Matrix Support Knowledgebase
Importing Data
Suggested knowledgebase articles:

Knowledgebase Importing Data

Articles in this category

Level 6 shows as error in Key to Success/GIAP import

You may need to update 4Matrix if Level 6’s are flagged as an error in the Key to Success import. Update 3.7.0.0 (January 2017) will handle Level 6 test scores. The DfE have confirmed that the actual ...

795
(16)
Arbor guide for importing exam results on download day

While the Arbor extract in 4Matrix allows you to pull exam results directly into 4Matrix, Arbor will not allow you to import directly via the extract until the results embargo has expired, enabling th...

198
(1)
Gender column not recognised

Right click the Gender column header and select Refresh.

676
(15)
Importing Key Stage 2 Data for use with Key Stage 4 Progress Measures

We strongly recommend importing KS2 using information from Get Information About Pupils (GIAP) where possible. You can download your KS2 Prior Attainment data from the GIAP site and import it into 4Ma...

1,833
(2)
Can I import Mastery statements?

This is not possible to do at the moment, but it is something that we plan to look into for the Cloud version

464
(14)
Can I import more than 1 set of Key Stage 2 results for a pupil?

It is not possible to import more than one set of Key Stage 2 results into a single pupil record via Edit Markbook, except for the fact that you can add a custom KS2 result and/or a NC Test Level, Fin...

530
(21)
Can I use your CDA tools to import and manage KS2 pupils?

4Matrix is designed to support key stages 3, 4 and 5. Although some of our CDA tools may appear to be compatible with any year group, the fundamental processes for importing and managing data, along w...

539
(12)
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...

520
(14)
Error when trying to paste Key to Success / GIAP 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. 

434
(13)
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 ...

796
(13)
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...

919
(13)
How do I deal with unmatched pupils in the 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 matching record in 4Matrix. Select the pupil, right click an...

485
(12)
In what order should I import data into 4Matrix?

Ultimately, it doesn't matter which year group you import first or whether it's an MIS Extract or or results/grade data via a spreadsheet. SIMS, Bromcom or Arbor users can create a complete series wit...

1,465
(19)
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...

475
(12)
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 ...

742
(14)
SIMS not matching pupils correctly

This might affects schools with hosted SIMS as they have to use the reports from www.4matrix.com/simsreports If there is no MIS ID then the creation of the marksheet generates one automatically, hence...

548
(13)
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...

461
(12)
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...

426
(13)
What is a series?

A series is a snapshot of performance - for example a "Y11 Autumn 1" series may refer to teacher assessments that were taken before Autumn half term. It is important to note that each series can only ...

543
(12)
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.

837
(16)
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...

451
(13)
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...

1,242
(15)
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 ...

1,219
(10)
Error: 4Matrix already contains entries for some subjects / Multiple Entries

If the Arbor, Bromcom or SIMS 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.

533
(3)
Importing KS4 APS for KS5 Progress Measures (Y13 2021/2022 and Older Cohorts)

Information correct as at 27th February 2023

888
(1)
Can I import Year 14 into 4Matrix?

Information correct as at 21/09/2020 Year 14 students can be accounted for in two different ways in 4Matrix, d

279
(1)
Arbor MIS Extract Tool Now Available! (05/03/2021)

We are pleased to confirm that an Arbor Data Extract Tool is now available to 4Matrix schools as part of 4Matrix Desktop update 3.9.8.0 (issued 5th March 2021)  

2,290
(2)
Cloud School MIS Extract Now Available! (13/05/2021)

We are pleased to confirm that a Cloud School Data Extract Tool is now available to 4Matrix schools as part of 4Matrix Desktop update 3.9.8.1 (released 14th May 2021) Please note this tool is in BETA ...

1,283
(0)
4Matrix GIAP Import Update – Special Consideration

4Matrix Desktop update 3.9.8.5 (February 2023) adds support for Special Consideration methodology in the GIAP import routine when using the KS2.CSV download file.  We recommend re-importing your GIAP ...

464
(0)
Importing KS4 APS for KS5 Progress Measures (Y12 and Y13 2022/23)

As this cohort have nationally published GCSE result it is possible to import them using a GIAP extract. Log into DfE Secure Access, and select GIAP site at https://get-information-pupils.service.gov...

30
(0)