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, eg 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 2 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. Each of these zipped files includes a user guide which explains how to use the converter.

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 data collections helpdesk for further help and advice.