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.
It is important to note that if two sections are not related as parent and child, their ID fields are entirely independent of each other. ID references are meaningful only within the context of explicitly linked parent and child tables.
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.
If a document with data has been created in XML Authority and you wish to export this data to a new Excel import template, click the Export button on the Excel ribbon.
Creating an Excel Import Template from a Non-Root Element
If you navigate to a table other than the root element and click the Export button on the Excel ribbon, XML Authority will open a form allowing you to create an Excel import template either from the root or based on that specific element. By clicking “Create From Here” option, an Excel import template will be generated using the currently location, including all tables and forms it contains.
Importing Data into a Specific Table or Form
Similarly, if you choose to import from an Excel import template, you can navigate to any table or form other than the root element, click the Import button, and select the “Import From Here” option. The data will then be imported into the currently opened table or form, along with all the tables it contains.
Automatic Alignment of Schema Masks
If a document in XML Authority contains masks that differ from those in the Excel import template you are importing from, you will be prompted to update the schema masks to match those in the template.
