...
2. Select "Import Excel" to get to the following screen:
3. Here you can provide an Excel file which will be imported and converted into a Data Model. The name of the Data Model may be specified in the first field under "Model Name". If this is not provided, a name will be extracted from the filename of the Excel file.
An example Excel file is available here (a snapshot of a version of the LOINC dataset).
4. In addition to the Excel file you will also need to provide an Excel Config XML File or " i.e. a Headers Map" such such as this one. This "Headers Map" tells tells the Exchange which columns should become what sort of Catalogue Element.
For example, in LOINC the following columns are mapped to Catalogue Element Elements like this:
- CLASS-→ Data Class Name (the name of a Data Class),
- COMPONENT-→ Data Element Name (the name of a Data Element).
- LOINC_NUM -→ dataElementID (the id of a dataElement).
- SCALE_TYPE-→ Data Type Name.
- Many columns become metadata entries for each Data Element e.g. SYSTEM -→ Metadata
Generally it is assumed that a row of the spreadsheet represents one "Data Element", possibly with an associated "Data Type" and "metadata", and belonging to a "Data Class".
Please see the extended example below if you require further assistance.
5. Once an Excel file and Headers Map have been selected, click on import to generate a Data Model.
...