REF import file templates
Below are template REF import files in XML, Microsoft Access and Microsoft Excel formats. All files were last updated as indicated.
The XML and Microsoft Access files are templates for institutions to complete when importing records to all the relevant REF data forms along with user records and user permission records.
Example Import file for submissions data (updated October 2012) (xml)
Download the Example submission import file (Oct 2012) as XML (27 KB)
Example Import file for system users (updated December 2012)
Download the Example user import file (Dec 2012) as XML (1 KB)
Template Import file (updated September 2013) (xsd)
Download the 4.Template Import file- September 2013 (xsd) as XML (30 KB)
Template Import file (updated September 2013) (accdb)
Download the Ref2014Template.accdb as zip (57 KB)
Template Import file (updated September 2013) (mdb)
Download the Ref2014Template.mdb as zip (29 KB)
Template Import file 2000 (updated September 2013) (mdb)
The below file provides details of the structure of the XML file produced by validation and import when the user selects the validation report as an XML file (added October 2012)
Template validation file (xsd)
The Microsoft Excel files are templates for institutions to use in the importing of records to REF forms REF1a, REF1b, REF1c, REF2, REF4a, REF4b, REF4c, along with user records and user permission records.
Template Import file 1997 – 2003 (updated January 2013) (xls)
Download the 8.Excel Template 2003 as MS Excel Spreadsheet (31 KB)
Template Import file 2007 (updated January 2013) (xlsx)
Download the 9.Excel Template 2007 as MS Excel Spreadsheet (19 KB)
All templates (updated September 2013) (zipped)
