What is the template?
The template enables you to easily create your own map with predefined visualizations, indicators, and filters. You need to clone an existing template into your new project and load it with your own data.
What structure must data follow?
You need to upload your data in CSV file. We provide a template of CSV file that can be downloaded, filled with your data, and uploaded back. The CSV file has to be correctly formatted for a successful upload and further data visualization in the map.
There are several requirements for CSV file formate:
Number of columns, their order, and data types* must be the same as in the sample CSV file. In the future, it will possible to edit the dataset in your project.
The column name does not have to match the template. Column names are on the first line in CSV which is truncated during the load.
The blank cell in the CSV changes its value to NULL. If the column containing NULL values is used in a metric, then these values are displayed on the UI as N/A values. For example, a point with a NULL valie in a column is not displayed on the map and it appears in the block ranking with N/A value.
The value of a column that is listed as primaryKey cannot be empty (NULL) and must be unique.
* CleverMaps supports several data types: integer, bigint, decimal, string, boolean, date, latitude, longitude. For specific details about each data type refer to our Documentation. Below you can find the most important rules that you have to follow to load your own data into a map created from a template.:
You have to use the same data types as in template.
If the value in the cell of the column of the string type is a space, it does not change to NULL, but the assembly is a space. For other data types, space cannot be sent.
You can't enter a decimal point into a column described as an integer or bigint. For numbers with a decimal point, the decimal type is used. On the contrary, you can enter an integer in the decimal column.
The decimal point in the decimal type has to be written with a dot, not a comma.
For type date, we prefer the format YYYY-MM-DD, but it is also possible to send in the format MM / DD / YYYY, DD-MON-YY, or DD / MON / YYYY.