Notices 20th March 2019

Update 3.9.5.2 has been issued today (20th March) which resolves the following issues:

1) An error message appearing on launch saying it cannot load the login screen

2) The SIMS Extract failing at the point of login

3) Key stage 5 grades not importing

If you still receive any of these errors, please ensure you have updated to 3.9.5.2 prior to contacting us.


 Numbers are formatted as text in the exported file

Solution

This is a known behavior and it's due to the numbers in 4Matrix being stored as a string. This is because we would generally hide or remove pupils from calculations when filters are applied in order to prevent them from registering as a 0 value.

The workaround in MS Excel is to copy the exported sheet and paste into a new sheet or workbook using the Paste Special 'As Values' option. This will then allow you to select the numeric cells and use the small exclamation mark (which appears in the top left cell of the selection) and choose to 'Convert to Number'.

 
Was this article helpful? yes / no
 

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