VizMap Dictionary

VizMap: the dictionary parameter Block  get it now


This parameter block is handled by cDataSet classes and provides a mapping of fields that are required on a Google Map or its visualizations and where to find them in Excel WorkBook.

For this example we are going to use the Concerts/Venues example. The complete workbook (googlemapping.xlsm) can be downloaded and the example Parameter WorkSheet is called VenuesParameters.

Dictionary Parameter Block

The block for the example application we are using can be found in the VenuesParameters WorkSheet and looks like this and is terminated by a blank line.


The items in Red are required for Mapping purposes and the Matching Columns must exist in your input data. The others are a list of every data item you are going to refer to when setting up your visualizations and info Windows.

The jSon representation of this is generated automatically as part of the VizMap application generation, and is part of the framework section. The above generates the following jSon fragment. The data types are figured out automatically by analyzing the data contents.

"dictionary":{
         "Latitude":"number",
         "Longtitude":"number",
         "SpotID":"number",
         "Title":"string",
         "Content":"string",
         "Code":"string",
         "Country":"string",
         "Venue":"string",
         "State":"string",
         "City":"string",
         "Address":"string",
         "Shows":"number",
         "ID":"number",
         "Average Price":"number",
         "Price":"number",
         "Date":"date",
         "Artist":"string",
         "Artist Photo":"string",
         "Venue Photo":"string"
      },

The next step is to assign these dictionary items to specific tabs within each Spot's Map Marker InfoWindow

Notes

  1. Latititude and Longtitude are returned from the geoCoding process which can be built in to the vizMap application generation process.
  2. SpotID is a unique ID for each marker and should be some kind of master ID that you generate. It refers to a single place - in this case a concert venue. This example uses the Venue ID as the SpotID
  3. The Dictionary names are case sensitive which is the norm for javaScript based applications. The column names are not, which is the norm for cDataSet columns in Excel. This means that as you refer to these Dictionary names elsewhere, you will need to be careful that the case matches. 
Comments