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

XXXX refers to your 4 digit short form DfE number.

Fields

Pupils

Staff