Excel/CSV

Snowray supports importing Code Systems from various columned data sources, such as Excel, CSV, TSV or any TEXT file that contains structured data.

Once the format is selected (Excel or CSV) the system displays an import wizard and guides you through the process.

Excel import

Accessible via the XLS import menu item.

Code System XLS Import Wizard

The following fields can be specified when importing Excel files:

Field	Description
Title	The title of the Code System (mandatory)
ID	The identifier of the Code System. If you leave this field empty, the system will automatically generate an ID for your Code System
Location	The Bundle in which the resource will be imported
Sheet	The sheet of the import file from which content will be imported (mandatory)

The Location field allows users to specify where to import the resource within the active workspace. Clicking in the field reveals the potential locations in a dropdown. From the list, you can select the Bundle in which you would like to place your imported resource.

CSV import

Accessible via the CSV import menu item.

Code System CSV Import Wizard

The following fields can be specified when importing text (e.g. CSV, TSV) files:

Field	Description
Title	The title of the Code System (mandatory)
ID	The identifier of the Code System. If you leave this field empty, the system will automatically generate an ID for your Code System
Location	The Bundle in which the resource will be imported
Delimiter	The character that will be used to as column separator (mandatory)

Column mapping

Once the structured data source has been configured, Snowray offers a step in the wizard flow to configure how the system will map the columns to the Code System concept model.

Field	Description	Auto-recognized columns
Concept ID	The column from which data will be used to for concept IDs	id, code, concept, conceptId, referencedComponentId
Preferred Term	The column from which data will be used as the display/preferred term for the concepts	term, pt, description, label
Parent	The column from which data will be used to specify the parent concepts	parent, parentcolumn
Synonyms	The column(s) from which data will be used to generate synonyms	-
Ignore	The column(s) that will be ignored	-

Code System Column Mapping

Unmapped columns will be imported as Concept properties. To opt-out of this functionality for certain columns, specify them as ignored columns.

Column autorecognition supports case insensitive matching, meaning that a source file with an ID column will match id and will be assigned to the Concept ID mapping.

With the import file in place and content details specified, clicking will perform the import.

Once completed, the wizard will report success if it was able to process the file and import its contents