Designer Data Import CSV

Load CSV File Data into CMaps Analytics

CSV files are supported as a direct data source containing Comma Separated Values.  CSV Data sources are loaded as a direct URL to a CSV file.

 

Capture

  • CMaps Analytics Designer will NOT upload your CSV file to CMaps Analytics cloud.
  • CSV URL files must be accessed via HTTPS inside of CMaps Designer.
  • CSV files must be loaded from a server that grants cross domain access (contact your server administrator for more details) Learn about CORS
  • CSV files can not be loaded from file shares or your desktop

Data Column Definitions and Ordering

Column ordering grants control to a designer to modify the default column data order based on your original data set. While it is generally recommended to load data into CMaps Designer using the default order, there could be scenarios where a map may need to accommodate data that is slightly different in ordering of columns. Simply drag and drop the columns to change the order.

Capture

Location

Any address value or comma separated latitude,longitude: Example: 43.43434,-33.54545

Label

The label is the name of each asset (point of interest or shape) displayed in the InfoWindow, chart, tile, and other views. It is the primary identifier visible to mobile users. Example: Dr Klauss

Value (measure)

A value is a numeric value associated with each point or region. This value is used for dynamic icon sizing, alerts, and chart visuals. Currently CMaps Designer supports 1 measure at a time. You can easily toggle between measures using the CMaps Designer API. Example: 45000

Color

If you want to define the color in your data rather than the property sheet you can use hexidecimal color codes to change the color of points or shapes: example: #FF0055

Category

Category is a placeholder for future functionality, including embedded pie charts, and other visualization options.

Drill ID

Drill ID represents the parent and child elements when you are drilling between multiple layers. The Drill ID establishes a simple hierarchy. When using more than 2 levels, any layer in between top and bottom must contain both the parent, and current drill levels with a “|” delimiter.

Examples are illustrated below:

Example 1 is 2 Layer Hierarchy

Layer 1

Label  |   Drill ID

West    West
East     East

Layer 2

Label  |   Drill ID

CA    West
NV     West
NY    East
FL     East

Example 2 is 3 Layer Hierarchy

Layer 1

Label  |   Drill ID

West    West
East     East

Layer 2

Label  |   Drill ID

CA    West|CA
NV     West|NV
NY    East|NY
FL     East|FL

Layer 3

Los Angeles    CA
San Diego       CA
Nevada           NV
Reno               NV