...
Next, open up your XML mapping file. A blank template XML file has been created here:
View file name TemplateMetadataXMLFile.xml
(Alternatively it can be generated from the Metadata XML Schema found on the importer pages:
)View file name Metadata XML Schema - headersMap.xsd It is now time to map the header row to each of the catalogue elements/properties. Simply enter the column header names into the correct sections. In this example file they have been labelled as
EnterColumnHeaderHere. Simply replace this text with the name of your column. For example :<dataClassID>EnterColumnHeaderHere</dataClassID>→<dataClassID>Data_Class</dataClassID>If you have used enumerations or multiple metadata definitions, remember to also specify the separator you have used. See above section: https://metadata.atlassian.net/wiki/spaces/MDX/pages/edit-v2/2549481480#Advanced%3A-Specifying-Multiple-Metadata-and-Enumeration-Definitions-in-a-Single-Cell
Remove any sections that are not present in your spreadsheet. For example, if you have no additional metadata associated with each data element, you can delete the following line.
| Code Block |
|---|
<metadata>EnterColumnHeaderHere</metadata> |
Ensure your excel spreadsheet columns follow the order of the XML file e.g. Data Class, Data Class Description Data Element, Data Element Description etc.
On the “ Import a new data model with Structural Metadata (Excel) ” page , upload your Excel and XML files and then click Submit.
...