The suppliers of the main school MIS have developed their software to hold the data required for the School Workforce Census and produce automatically an extract in the required XML format for submission to COLLECT. Other systems, e.g. non standard school MIS or HR/ payroll systems, may not be able to provide data in the correct format for submission to COLLECT for the School Workforce Census.
The Department has developed two comma-separated value (CSV) to XML conversion tools to facilitate this: one for the data required for school employed staff and the other for centrally employed staff. The zipped files included in the CSV to XML converter for school employed staff are as follows (similar files are included for centrally employed staff):
All of these files should be stored in the same folder. The files should not be renamed as the given filenames are required for the converter to run correctly. The CSV file can be stored in a different folder, in which case the full path will need to be entered when prompted. Care should be taken that these files are stored in secure folders on systems.
If you have difficulties using these tools, please ensure you have read the instructions carefully and followed them, and then please do not hesitate to contact the DSD Helpdesk for further help and advice.
Data and Statistics Division (DSD) Helpdesk
1st Floor Mowden Hall
Telephone: 01325 392626
zip, 1 Mb
zip, 1 Mb