Load External Files {SACADR-12} 

This option will upload Standards from NZQA.

Before the upload program can be run the following must be set-up and in place:
  1. Enter the School ID of own institution on {GOPS-21} with External Body NZQ and External Type SID.
  2. Query on {SMNT-12}, Code = A1 and update Alpha/Date field to  NZQA.
  3. The directory for the upload files must have been entered in the Directories for FTP Transfers {BATCH-7} against function "NZQAR - Path and File for NZQA Results Upload" for System "STUD"

1.    NQF Standards:  file Standard.txt:  

This file is supplied by NZQA to School software providers and contains a full list of current standards on the National Qualifications Framework (NQF) and the current Scholarship standards.  This file is sent to software providers at the beginning of each year with several upates also being sent during the year.  

File conventions:  The file is a variable length ASCII text file terminated by carriage return and line feed, with fields deilmited by "*'.  The files are named 'standard.txt', 'context.txt' and 'accredsnnnn.txt'.

First Record:  The first record has a special format to record the date generated at NZQA.


Standardfiledate = YYYYMMDD where "YYYYMMDD" is the date created.

2.    Context Codes:  file Context.txt:

This file will be sent to software providers in conjunction with the standards file and will also be available to schools as a downloadable file from March 2006.

File conventions:  This file is a fixed width standard ASCII text file with each row terminating with  a carriage return and line feed.
Unless stated otherwise, numberic fields are right-justified with leading spaces, alpha fields are left-justified with trailing spaces and the date field format is dd/mm/ccyy with leading zeros.  

3.  School Accreditations:  file accredsnnnn.txt:

This file is supplied by NZQA to the requesting school and contains a list of the standards in which the school is currenlty accredited to assess.  This file is available as a dynamically generated downloadable file from the school's secure website or on request to NZQA.

File conventions:  This file is a fixed width standard ASCII text file with each row terminating with a carriage return and line feed.  Unless stated otherwise, numeric fields are rights-justified with leading spaces, alpha fields are left-justified with trailing spaces and the date fiel format is dd/mm/ccyy with leading zeros.  The file is named "accredsnnnn.txt", where nnnn is the MoE Provider Number of the school (e.g. accreds0075).

 
User Selection Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments
NQF standards file name A200 Insert the name of the file e.g. standard.txt
Context Code File A200 Insert the name of the file e.g. context.txt
School Accreditations File Name A200 Insert the name of the file e.g. accredsnnnn.txt
(T)rial or (U)pdate mode A1 Run the file in (T)rial or (U)pdate mode?
 

Sort Order Per Comments
  None.  


System Select  
  No special system selection.


Example
:  Layout of the "standard.txt" file

Example of ...



Example
:  Output of the "standard.txt" file

Example of ...



Example:  Layout of the "context.txt" file.

Example of ...



Example:  Output of the "context.txt" file.

Example of ...


Example:   Layout of the "accredsnnnn.txt" file.

Example of ...



Example:   Output of the "accredsnnnn.txt" file.

Example of ...


Processing
Rules
 
  No special processing rules.



List of fields in xml/xsl object (delete if not applicable):



See Also:



History of Changes

Date System Version By Whom Job Description
19-Jan-2010 v02.0.0.0 Magda van der Westhuizen
T161190 New manual.
25-Feb-2010 v02.0.0.1 Bea Swart T160923 Add External Conversion Codes and SOD T163811
25-Oct-2010 v02.0.0.2 Frans Pelser f170024 Directory for FTP Transfers