ICT Services 4 Education

 

Tab Files - MIS Data Export for Creation of Accounts

For full details on the tab file process of provisioning nsix accounts via our Identity Management system, please see the following page: 'Creating Google Accounts for Students and Staff'.

To perform a manual export of data from your MIS (management information system) for our Identity Management system, please pick the fields in your MIS reporting tool that best correspond to the below. You may need to manipulate this data in Excel to get the columns in the exact order including blank columns.

The extracts then need to be exported as Tab delimited files with the names detailed below. The naming convention is very important so please double check this before sending via AVCO Anycomms. If the file names are wrong the files can not be processed and you will not get your email accounts. Also, please check that you have saved the files in Tab delimited format and not Excel (.xlsx) format. If you have the data in an Excel spreadsheet you will need to save the spreadsheet as 'Text (Tab delimited)' file type. The file generated will be .txt file type which you can then rename to .tab. Please see the following page for instructions on how to send the files to us via Anycomms Plus  'Uploading nsix account tab files via Anycomms Plus' .

 

Filename Action
XXXX_Pupils.tab Returns Key Pupil Data (Name, DOB, UPN, Yeargroup etc)
XXXX_Staff.tab Returns Key Staff Data (Name, DOB, Teacher Number etc)

XXXX refers to your 4 digit short form DfE number.


Fields

Pupils

Field Name Example Notes
DfE 1072 School 4 digit DfE number
Forename John  
Legal Surname Bloggs  
Blank Column 1   Leave blank
Blank Column 2   Leave blank
Blank Column 3   Leave blank
Blank Column 4   Leave blank
Blank Column 5   Leave blank
Blank Column 6   Leave blank
DOB 11/02/2001 Date of Birth, other valid formats acceptable
UPN R926804433867 Unique pupil number.
Year 5 National curriculum year group.
Blank Column 6   Leave blank
Blank Column 7   Leave blank
Enrolment status C Dual Registration Status, one of
Code Description
G Guest user (exams)
C Single Registration
M Dual Registration,Main School
S Dual Registration, Subsidiary School

Staff

Field Name Example Notes
DfE 1072 School 4 digit DfE number
Forename Joe  
Legal Surname Bloggs  
Blank Column 1   Leave blank
Blank Column 2   Leave blank
Blank Column 3   Leave blank
Blank Column 4   Leave blank
Blank Column 5   Leave blank
Blank Column 6   Leave blank
DOB 18/07/1968 Date of Birth, other valid formats acceptable
DfE Teacher Number 56/98463  
Title Dr  
Teacher Code JFB Teacher Code, to link with sets and registration groups.

 

Close