Local Code systems

Importing local code systems from Excel

To import a local code system from an Excel file go to File > Import > Snow Owl > Local Code Systems from Excel file, click Next. Please make sure that the Excel file is in standard format, which is the format produced when exporting an Excel file from a LCS.

Importing a Local Code System in Excel

Browse for the import file and select one of the following import options:

Click Finish to start the import. A warning will inform you if you are about to overwrite content: in this case you need to confirm the import. If the import fails due to a problem with the data in the Excel sheet, a validation log will display details. Note: During the import empty status cells default to Active, empty effective time to unpublished. Also, populated effective time defaults to unpublished during the import, as you need to version and publish it with the tool.

Merging imported components with existing database

After the import, you can review a summary of the imported content. A small blue plus decorator indicates that a component was added. The screenshot shows different local codes that were added as well as the local code system. When clicking on a component, the details are displayed in the bottom section (e.g. imported metadata of the local code system). The icons indicate the type of component (e.g. for metadata). The middle section contains details about the import (e.g. time, user name, date, file name). If you updated a local code system you could see different versions here, and click the versions to display the history in the buttom section.

Summary of imported content

Exporting local code systems to Excel

To export a local code system to an Excel file

Selecting LCS for export

Local code systems are exported in standard format (see screenshot). Different LCS are filed in separate worksheets, an index sheet is generated in the first tab of the spreadsheet to allow easy navigation between the tabs. Metadata are exported as additional rows under the mandatory properties. In case of multiple keywords, multiple rows with the same property but different values are exported.

Exported LCS in Excel