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

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.

Was this helpful?