Login
Register
4Matrix 4Matrix Support Knowledgebase
4Matrix Desktop: Importing Data
Suggested knowledgebase articles:

Summer Holidays Support Hours

From Monday 20th July to Wednesday 2nd September, our support services (tickets, live chat and telephone) will be available from 9am to 3pm.

We will provide extended support hours during results days as follows:

  • Wednesday 12th August (GCE Results): 8:00am to 5:00pm
  • Thursday 13th August (GCE Results): 8:00am to 5:00pm
  • Wednesday 19th August (GCSE Results): 8:00am to 5:00pm
  • Thursday 20th August (GCSE Results): 8:00am to 5:00pm

 

Knowledgebase 4Matrix Desktop: Importing Data

Articles in this category

Gender column not recognised

Right click the Gender column header and select Refresh.

1,148
(20)

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...

6,364
(4)

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

929
(16)

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...

1,021
(22)

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...

916
(14)

Error when trying to paste 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. 

864
(14)

Fine Grade formats

4Matrix now supports multiple fine grade formats and it is possible to use a mixture of these in the same series. As well as the standard 1, 2, and 3 to indicate high, mid and low grades (i.e C1, C2, ...

1,542
(14)

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 in Help>Support Tools>QAN Chec...

1,650
(14)

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...

966
(13)

In what order should I import data into 4Matrix?

Ultimately, it doesn't matter which year group you import first or whether it's actual results via an MIS Extract, assessment data via a spreadsheet, or GIAP data. SIMS, Bromcom and Arbor users can cr...

2,611
(20)

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 (Step 5), there is a tick box -...

861
(13)

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 ...

1,285
(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, henc

996
(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...

1,059
(13)

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...

825
(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 ...

1,263
(14)

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,812
(16)

Bromcom Extract Login Error / Error at Date Selection Step

If you see an error message when using the Bromcom Extract tool after supplying your log in details or at the point of selecting an Effective Date for the extract, the most likely causes of the error ...

2,930
(13)

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.

1,504
(4)

Can I import Year 14 into 4Matrix?

Year 14 students can be accounted for in two different ways in 4Matrix, depending on the requirements of the school; 1. Using a separate Y14 year group/series

718
(2)

Arbor MIS Data Extract Wizard

We are pleased to confirm that an Arbor Data Extract Tool is available to 4Matrix schools.   If your school uses A

4,849
(4)

4Matrix GIAP Import Update – Special Consideration

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

2,134
(0)

Importing KS4 APS for KS5 Progress Measures (Year 13 and 12 - Academic year 2025/26)

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...

2,256
(9)

Wonde MIS Extract Tool Now Available! (11/04/2023)

We are pleased to confirm that 4Matrix Desktop will extract data from all major MIS via Wonde, as part of update 3.9.8.6 (issued 1st March 2023)  

1,016
(0)

Importing Assessment Data into 4Matrix Desktop

4Matrix provides analysis of assessment data, predictions, targets, exam results and more. All assessment data must be imported using spreadsheets. Exam results can be imported via an MIS extract, det...

1,104
(0)