5.1 Excel Import Templates

Once you have completed your schema masking and the schema now matches your reporting requirements, you can generate an import template by selecting the "Create Template" button in the Excel ribbon:

You will then be prompted to save the import template, before an Excel file is created and automatically opened. 

The Excel tables utilise primary ID and foreign ID relationships. These IDs are used to define the relationships between records in different worksheets. The unique identifier you provide for your primary and foreign IDs can be anything as this information does not appear in the XML instance that will be submitted to the regulator.

There is a useful legend on the first worksheet of the Excel template to help guide you:

To link 2 sheets to each other a primary ID is inserted into the ID field:

The primary ID will then be used as a foreign ID in the sheet that connects data to it:

The records with a primary ID of Acc001-Acc005 are connected to the parent sheet (CRS OECD) by using the primary key (001) of the parent sheet as a foreign ID in the child sheet.

Once you have populated all the required fields in Excel you can import the information back into XML Authority by selecting the "Import" button in the same Excel ribbon:

You will be prompted to browse for the import template and once selected it will import the data into XML Authority.