Sections in the Article
This article describes how to import values into a CVL that has data type String (one language only).
Once you have set up the CVL, you need to fill it with values. One option is to do this manually, one row at a time. If there are many values, it may be more convenient to import them from Excel.
To Create the Excel File
- Create an Excel file with the following columns: Key, ParentKey, SortOrder, Deactivated, Value.
- 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.
- 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.
- Enter a number in the cell for the column SortOrder. This number determines the sort order for the values when the CVL is used in the Web Portal.
- Should the value be hidden initially?
- If no, enter false in the cell for the Deactivated column.
- If yes, enter true in the cell for the Deactivated column.
- Enter the CVL value in the cell for the column Value. Continue until all needed values have been added.
- Your Excel file may now look something like this:
- If the CVL has a Parent CVL list, the Excel file may now look something like this:
To Import Values to a CVL
- In Control Center, go to Model > CVL.
- Find the CVL.
- Double-click on the row of the CVL you want to import values to.
- Click the button Import CVL Values.
- Select the Excel file that has the values you need.
- In the dialog that opens, click Open.
The dialog closes and the import starts. If the import was successful, you will receive a confirmation message.
Troubleshooting the Imported Values
If some values couldn't be imported, you will get an error message notifying you. If this is the case, here is how you can troubleshoot the values to see why it wasn't imported:
- Check that all values in the ParentKey column match a value in the ParentCVL.
- Check that the Key column doesn't contain space (for example, write UnitedKingdom rather than United Kingdom).
- Check that the Key column doesn't contain language-specific characters (for example ê, ë, ñ, å, ä, æ, ö, ø).