Code Lists

Colectica is able to import multiple code lists from an Excel (*.xlsx) file.

1. Navigate to a ResourcePackage to which you would like to add the new code lists.

2. Click the Import Code Lists button on the ribbon.

3. Select an Excel file that contains your code lists.

4. The code lists will be added to the ResourcePackage.

Excel File Format

The Excel file should be in the following format:

• Each sheet contains one code list

• The first row of each sheet is a header row. The following headers can be used.

  • Value: the code’s value.

  • Label: the code’s category label.

  • Description: the code’s category description.

Labels and descriptions can, optionally, be imported in one or more languages. To specify the language of a label, use a column header like Label[en] for English, or Label[fr] for French. To specify the language of a description, use a column header like Description[en] for English, or Description[fr] for French.

If no language is specified in the column header, the the active language will be used.