Importing values into a CVL (Controlled Vocabulary List)

This article describes how to import values into a CVL for String (single language) and LocaleString (multiple languages) data types.

Once you have set up the CVL, you need to fill it with values. This can be done manually, one row at a time, but for larger numbers of values, it may be more convenient to import them from Excel.

Viewing defined languages

Navigate to Control Center > Model > Language to find the list of languages defined in your inriver system.

Creating the Excel file

1. Create an Excel file with the following columns:
   
   
   • For String:
     Key, ParentKey, SortOrder, Deactivated, and Value.
     
     
   • For LocaleString:
     Key, ParentKey, SortOrder, Deactivated, plus a column per language code
     (for example Key, ParentKey, SortOrder, Deactivated, en, sv, es, de).
     
     
2. Enter the key value in the cell for the Key column.
   The ID can contain letters and numbers and must be unique within the list.

    

   Make sure that the Key column does not contain language-specific characters (for example ê, ë, ñ, å, ä, æ, ö, ø).

   
   
   
3. Does the value have a parent value in another CVL?
   
   • If no, leave the cell for the ParentKey column blank.
   • If yes, enter the value for the parent in the ParentKey column.

      

     Make sure that all values in the ParentKey column match the values in the parent-CVL.

     
     
     
4. Enter a number in the cell for the SortOrder column. 
   This number determines the sort order of the values when the CVL is used in inriver.
   
   
5. Should the value be initially hidden?
   • If no, enter false in the cell for the Deactivated column.
   • If yes, enter true in the cell for the Deactivated column.
     
     
6. Enter the CVL value in the cell for the column Value. Continue until all needed values have been added.
   

   

   

   

   

   
   Save the sheet when you are done.

Importing values to a CVL

In Control Center > Model > CVL
do the following:

1. Click on the CVL you want to import values to.
   The CVL Values page opens.
   
   
2. Select Import CVL Values from the dropdown menu (...) on the right.
   A browsing window opens.
   
   
3. Locate and select the Excel file that you want to use for the value import on your computer.
   The import process starts.
   
   When the import is successful, you receive a confirmation message.

Exporting CVLs

In Control Center > Model > CVL > CVL Values you also have the option to export CVL values for a particular CVL by clicking on Export CVL Values.

Further readings

Excel import

Excel export

Publish application

Characters not accepted when importing data

Adding values to a CVL (one language)