mscrm-addons.com - Blog

IMPORTANT INFORMATION

This blog is deprecated since July 2020.The articles below are no longer maintained and might contain outdated information. 
You can find the most acutal and relevenat information in our Knowledge Base at support.mscrm-addons.com

News.mscrm-addons.com Blog

rss

Hello and welcome to our blog! What can we do for you? Are you looking for further technical information or step-by-step instructions to our products? Or would you like to read the latest news on mscrm-addons? Please feel free to browse our blog for detailed information and to share our posts!


How to configure map – charts

Dashboard for MS CRM 4.0 provides several maps (World-map, Europe, U.S., Germany, Netherlands,…) in order to e.g. display customer-distributions.
This blog contains basic information on how to configure maps. This is explained with a Step-by-Step-Setup of a Customers in the U.S.A-chart.

  1. Main-Chart settings: The following settings need to be configured within the Dashboard-Chart-configuration:

    Figure 1: Main chart settings

    1. Chart Series: Select Map to load the available maps into the chart-type configuration
    2. Chart Type: All available maps are listed. Choose the country/area you want to use
    3. Label(X): Select the CRM-attribute that contains country-specific data (e.g. Country-code, Contry-name,.. see below)

      Example US-Map: We choose Chart-Type: [Shapefiles/Usa_st] 
                                and Lablel(x) : [Adress1: State/Province]

  2. Map-definition: Within the Dashboard for MS CRM 4.0 - [Installation-directory]\ClientBin\Shapefiles we can find a *.dbf-File for each available map.

    Each of this files contains several info like name, code, population... about the areas within the maps, marked by an UNIQUE-Columnname (AREA,STATE_NAME,…)
    E.g usa_st.dbf:
    dbf_file
    Figure 2: usa_st.dbf

  3. Data-mapping: But how to link this data with CRM? Like all dashboard-charts, map charts are based on the results of an Advanced Find. This advanced find needs to deliver an attribute that fits to one of our UNIQE-columns within the *.dbf-file.

    In most cases this will prospectively be Address1: Country or Adress1: State/Province

    Example US-map: Adress1: State/Province delivers the names of the US-state Winsconsin, Washington:


    Figure 3: names of Winsconsin, Washington

    So in this example, the Label(x)-Value (Adress1: State/Province) needs to be linked to the STATE_NAME-column in the *.dbf-file.

    Therefore we have to switch to the Values-tab on the Dashboard-chart record:

    Figure 4: Dashboard chart record (value-tab)

    The mapping is defined in the StyleValue-column:
    |reader.DataMapping-Name=STATE_NAME; ToolTip=STATE_NAME|
    • reader-DataMapping: Specifies the mapped column
    • ToolTip: It is possible to choose any of the columns from the *.dbf-file to appear in the tooltip of the country
  4. Result: Now, we get following result:

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.




Comments are closed.