Importing a dictionary from a CSV file

eye 0thumbs up 0thumbs down 0clock 10 December 2023

You can create a Simple Dictionary based on a list you have in a CSV file.

Procedure:

  1. Prepare a suitable file with the dictionary values. It should contain only one column, without a header. The dictionary values should be listed in consecutive rows. Save the file in CSV format.
  2. Go to: Administration Panel > Dictionaries.
  3. Click “Import Dictionary” and then select “from CSV file”.
  4. A new window will open, where you should: assign a name to the dictionary, select the data type, and choose the file by indicating its location on your disk.

The data type should be selected according to the values contained in the dictionary. Using “integer” or “decimal” will not allow you to enter non-numeric values, such as letters or special characters. However, it will enable correct ascending sorting and the use of graduated symbology.
The most universal type is “text”, which allows you to enter letters, numbers, and special characters. However, it will limit the ability to perform the number-specific operations described above.

  1. Click “Load”. The newly generated dictionary will appear in the list of dictionaries. To open it, click the three dots and select “Edit”.
  2. Finally, you need to assign the dictionary to the appropriate layer attribute. To do this, go to Data Sources and then open Attribute Management for the selected layer.

Was the article helpful?

Next article

Calendar heatmap