...
An update to the Synergetic NZQA Standards Import functionality to handle this change was released recently (Version 70.20.4 and later) and this has been found to have an issue.This issue is fixed by running the below SQL which needs to be run against NZ instances of Synergetic.
NZQA require that where a Standard does not have an Assessment Opportunity, that this is indicated by the value being a Null. Currently these are being set to 0 and this is causing errors to be reported.
This issue is fixed by running the below script against NZ instances of Synergetic.
Obtaining and applying the hotfix
We have created a SQL patch fix for v70 release of Synergetic.
1) Download the .sql file fix from the link below :
- sp_spiSubjectAssessmentNCEAStandards.sql
- Save to a location of your choosing, that you can access from your SQL Server
2) Open and run the .sql file fix against your Synergetic Database.
3) Once the SQL fix has completed run successfully, your system should be updated and ready to re-import the latest NZQA Standards file.
4) Re-import the latest NZQA Standards file via the NZQA tab of Students > Student Data Import/Export...
This must be done to fix the Assessment Opportunities data in your system.
5) The issue should now be resolved.
...