Preparing CSV file

File types

Important

CSV files must be comma delimited and comply to the UTF-8 standard.

../_images/mapper_csv_default_data_raw.jpg
../_images/mapper_csv_default_data_sheet.jpg

Sample CSV Data

Data types

SMS Mapper is able to distinguish data types per column. Value and text types supported are:

  • String (text)

  • Integer (-2, -1, 0, 1, 2, 3)

  • Float (0.314, -50.8045, 5.5)

Important

Do not mix data types per column (field). Mixing data types will result in values being interpreted as a string (text). Values will not read correctly, or the importer will result in an error. See figures below for correct use of data types.

Required fields

At a minimum your CSV file should contain an index field, name field, and a value field.

Index

The index field should match the name field as per the default sample above. SMS Mapper uses the index and name column internally to link data to the correct country objects.

Name field

  • The name field is needed to map data and also to name country objects in the scene.

  • The values in each record must be unique.

Value field

  • The value field is needed to set various parameters on the country objects.

  • The values in each record does not have to be unique.

  • Value types supported are float or integer.