 Copy and Paste Data into CMaps Analytics
Pasting tab delimited data directly from Excel is supported in CMaps Designer, as an approach to quickly prototype and test layers.
Data Formatting Logic and Security
CMaps Analytics Designer provides a mechanism to test and preview simple data sets directly inside of Designer by copying / pasting from Excel.
WHEN SHOULD YOU COPY & PASTE DATA
You should copy / paste data into CMaps Designer to quickly prototype maps, test features, or deliver a map where the data does not change.
WHERE DOES THE DATA GO?
Copying and pasting data into CMaps Designer will keep the data in your browser and embed it inside the .CMaps template file.
DATA SECURITY
CMaps Analytics will NOT transmit data that you copy and paste into CMaps Designer. Instead this data is loaded onto your map locally, within the browser.
WHERE TO UPLOAD DATA?
If you want to load data into CMaps Analytics from a cloud data store, we recommend using CartoDB for cloud storage, or for more robust data models and dashboards Antivia DecisionPoint (supports CMaps Templates).
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.
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