AMREIN ENGINEERING Agenda/X | Sharepoint | Solutions | Partners | Support | Search | About us | Home  
  AE Google Map Chart Sharepoint Web Part Deutsch English  


Sharepoint Web Parts  

Digital Clock Web Part  

Stock Chart Web Part  

Stock Quotes Web Part  

Dilbert Web Part  

Quote of the Day Web Part  

"Spotlight On.." Web Part  

"Tip of the Day" Web Part  

Lightbox Web Part  

Weather Web Part  

Slideshow Web Part  

Currency Rates Web Part  

Media Player Web Part  

YouTube Player Web Part  

Map Chart Web Part  

Google Chart Web Part  

Bullet Graph Web Part  

RSS Feed Ticker Web Part  

SQL Viewer Web Part  

Google Map Web Part  

Quick Poll Web Part  

Quick Survey Web Part  

Audio Player Web Part  

Google GeoMapper Web Part  

SQL Chart Web Part  

Exchange Calendar Web Part  

Podcast Web Part  

Filter Web Part  

Image Rotator Web Part  

Navigator Web Part  

KPI Web Part  

Page Hits Web Part  

Picture Menu Web Part  

Timer Web Part  

Van Gogh Web Part  

SQL Bullet Graph Web Part  

User Spotlight Web Part  

List View Web Part  

Staff Directory Web Part  

Birthday Reminder Web Part  

News Carousel Web Part  

Team Members Web Part  

Christmas Web Part  

Classifieds Web Part  

Google Earth Web Part  

Timeline Web Part  

Banner Rotator Web Part  

AZ Index Web Part  

Blog Roll Up Web Part  

Discussion Roll Up Web Part  

Document Roll Up Web Part  

News Roll Up Web Part  

Task Roll Up Web Part  

Calendar Roll Up Web Part  

Quick Form Web Part  

Twitter Web Part  

Upcoming Events Web Part  

Welcome Web Part  

Color Calendar Web Part  

Image Carousel Web Part  

Metro Grid Web Part  

Goal Thermometer Web Part  

Swipe Gallery Web Part  

List Rotator Web Part  

List Search Web Part  

Flash Rotator Web Part  

Accordion & Tabs List Bundle  

Accordion List Web Part  

Tabs List Web Part  

Microblog/Chat Web Part  

Toast Notifications  

Vacation Planner Web Part  

Multilevel Tile Web Part  

Inspired Tiles Web Part  

Facebook Timeline Web Part  

Zip Creator  

Web Part Support  

Web Part Bundle  

Microsoft Sharepoint Web Parts

Google Map Chart Sharepoint Web Part



Map Chart Web Part
The Google Map Chart Web Part allows to chart data contained in the specified Sharepoint List as a geographical map. The map is created using Google's public Chart API (see official Google Documentation)

The Web Part can be used with Windows Sharepoint Services V3, MOSS 2007, Sharepoint 2010,  Sharepoint 2013 and Sharepoint 2016. 
 

The following parameters can be configured:
  • Sharepoint List containing the data to be visualized
  • Geographical map area:
    • USA
    • South America
    • Europe
    • Asia
    • Middle East
    • Africa
    • World
  • Map dimensions
  • Web Part and Map background colors
  • Map Chart Color Palette
  • Chart Legend
Google Map Chart Web Part
Product Price
Google Map Chart Web Part
30 day Evaluation Version
Free download..
Google Map Chart Web Part
Office365/Sharepoint Online Sandbox Version (Evaluation Version)
Free download..
Google Map Chart Web Part Licensed Version
per Server License
Includes 1 year technical support plus free upgrades.
USD 75.00
Web Part Installation Instructions download..


Installation Instructions:

  1. download and unpack the AEMapChartWebpart.zip file.
  2. download the Map Chart Web Part Installation Instructions (PDF file, see above) 
  3. either install the web part manually or deploy the feature to your server/farm as described in the instructions.
  4. Either adapt an existing Sharepoint List or create a new Sharepoint List to store the data to be mapped.
    Also optionally define a suitable List View for the List if you want to sort or filter the data in a specific way.
    The list should include a
    • column to hold the data values to be charted (see Value Field Name setting below). The column should be a numeric type (Number or Currency).
    • column to hold the US state or country names (see State/Country Field Name setting below).




  5. Configure the following Web Part properties in the Web Part Editor "Miscellaneous" pane section as needed:
    • Site Name: Enter the name of the site that contains the Sharepoint List containing the data to be charted.
      - leave this field empty if the List is in the current site (eg. the Web Part is placed in the same site)
      - Enter a "/" character if the List contained in the top site
      - Enter a path if the List is in a subsite of the current site (eg. in the form of "current site/subsite")
    • List Name: Enter the desired Sharepoint List containing the data to be charted.
    • View Name: Optionally enter the desired List View of the list specified above. A List View allows you to specify specific data filtering and sorting.
      Leave this field empty if you want to use the List default view.

      If you enter multiple List Views (separated by semicolons as eg.

      Westcoast;Eastcoast

      the user will be able to interactively choose one of the specified List Views:


    • State/Country Field Name: enter the Sharepoint list column name of the column that contains the US state (US Map) or country name (all other maps).
      • US States (US map): use the official 2 letter abbreviation as eg. CA for California (see United States of America state codes).
      • Countries (all other maps): use the ISO 3166-1-alpha-2 codes as eg. GB for United Kingdom (see ISO 3166 Countries and Regions list). The country code is optionally followed by a dash and a second identifier for regions or cities.
        Examples: GB (Great Britain), GB-LND (London), US-NJ (state of New Jersey in the United States)
    • Value Field Name: enter the Sharepoint list column name of the column that contains the numeric data to be charted.
      If you enter multiple List columns (separated by semicolons as eg.

      Sales 2010;Sales 2011;Sales 2012

      the user will be able to interactively choose one of the specified List columns:



    • Marker Field Name: optionally enter the Sharepoint list column name of the column that contains the value to be used as a chart marker for each country or region.
    • Group By: optionally enter the Sharepoint list column name of the column that contains the grouping value. All countries/regions sharing  the same "Group By" value will be assigned the same color and legend. If you would like to define one exact color for each group you must enter as much colors as groups and add ",ffffff" e.g. 3 groups with colors red, yellow, green: "ff0000,ffff00,00ff00,ffffff"
      You can optionally append the "/sum" (summed up Group totals) or the "/count" parameter (number of items per Group). This extra information will be displayed in the chart legend:


    • Map Geographical Area: if "USA" is chosen, the short state abbreviations can be used (eg. TX for Texas) as opposed to the ISO abbreviations (eg. US-TX).
      • USA
      • other
    • Map Width: enter the desired width of the Map Chart in pixels  (the maximun value is 600 pixels and the maximum chart size is 300,000 pixels).
    • Map Height: enter the desired height of the Map Chart in pixels  (the maximun value is 600 pixels and the maximum chart size is 300,000 pixels)
    • Map Zoom Area: optionally allows you to explicitly specify the Latitude/Longitude of the lower left and upper right corners of your map (separate the values by commas). The order of the number to enter is as as follows:

      Lat(Lower),Lon(Left),Lat(Upper),Lon(Right).

      You can also interactively look up Latitude/Longitude vales on the  Google Maps Lat/Lon Lookup page.

      Example: 38.5,17,51.3,62


    • Web Part Background Color: enter the RGB Hex value of the desired background color.
      The default value is FFFFFF (white).
      Specify colors with a 6-letter string of hexadecimal values in the format RRGGBB. For example:
      • FF0000 = red
      • 00FF00 = green
      • 0000FF = blue
      • 000000 = black
      • FFFFFF = white
    • Map Background Color: enter the RGB Hex value of the desired Map background color. The default value is F0F0F0 (light gray). This color is used for all countries or regions that have no assigned data values.
    • Map Chart Color Palette: enter two or more RRGGBB hexadecimal numbers (separated by a comma) to specify the extremes of a color gradient that is used to color all countries/regions having data assigned to them. To control the gradient further, specify more colors. The default setting specifies a green palette.
    • Chart Title: enter the optional Chart title to be displayed at the top.
    • Chart Caption: enter the optional Chart caption to be displayed at the bottom.
    • Show Map Chart Legend: this optional setting displays or hides the chart legend
    • Legend Value Units: Specifies the unit of the selected Sharepoint list column defining the data points. The unit setting is used to format the chart legend:
      • Currency
      • Number
      • Percentage
    • Extra Chart Parameters: allows to append optional extra custom Google Chart API parameters (see official Google Documentation)
      Example: &chts=FF0000,24&chdls=00FF00,12
      (sets the chart title to red with a 24pt font and the chart legend to green with a 12pt font)
    • License Key: enter your Product License Key (as supplied after purchase of the "Map Chart Web Part" license key). Leave this field empty if you are using the free 30 day evaluation version.

Please enter a comment below if you have problems with the installation, want to give feedback or have suggestions for improvements:

User Comments Post a Comment 

Anjaneya   
4/21/2009 07:47 
Its really very good. If you are able to show the state names in the map it looks very good.
Robin Majumdar  
4/24/2009 19:49 
Too bad the Google charting API doesn't support state/province level granularity outside the US.... :S
Vidette Pires  
6/18/2009 20:30 
When I enter multiple colors for 'Map Chart Color Palette' the legend does not reflect the multiple colors. What do we do to match up the legend? thanks in advance.
Juerg  
6/19/2009 10:43 
Vidette,
this should be handled automatically by the Google Chart API. Do the colors display OK for the states/countries ?
What exactly did you enter into the "Map Chart Color Palette" field ?
Tim Wood  
6/22/2009 20:47 
This is really nice. Only change I would make is allowing the legend to be formatted differently. 50 states worth of information make the web part look out of place.
Juerg  
6/23/2009 11:33 
Tim, I agree, we'll have a look at this. At least we now have adjusted the webpart such that the map is now vertically aligned at the top with respect to the legend.
Sohail  
7/2/2009 00:43 
I can see the color and number reflecting on legend but I can't see anything on the map? Do you know what could be the problem? I am using WSS
Nigel  
7/8/2009 08:49 
I have followed your installation instructions but get the following error; Unable to add selected web parts, Google Chart: Cannot import this Web part
Alessandro Pelagotti  
7/8/2009 12:02 
Hi all, its really good, but i've a problem, i've created a list with 4 items each with 2 columns (Value and state) (CA,TX, CO, AL) The Wss page display the legend with value and colour but in map every state is blank. Please help me :)
Alessandro Pelagotti  
7/8/2009 12:11 
Add-on my original post, I discovered that the connection passes 10 values while states are 6. This is the link
chart.apis.google.com/chart?chs=385x220&cht=t&chtm=usa&chco=F0F0F0,FFF0F0,00FF00
&chd=t:4,9,24,3,75,7,100,97,4,25,4&chld=CATXCOALLAPA&chf=bg,s,EAF7FE
-------- It's really strange
Juerg  
7/8/2009 13:59 
Nigel,
please check your web.config file if your Trust level is set to "WSS_Minimal". If yes, please modify the web.config file in the virtual directory root for your site and change the following tag

<TRUST originUrl="" level="WSS_Minimal" /> to

<TRUST originUrl="" level="WSS_Medium" />

The difference between Minimal and Medium is (among other things) the addition of SharePoint object-model access for users.
Juerg  
7/8/2009 17:55 
Sohail and Alessandro,
Yes, the comma separator seems to be the problem. The data values are passed to Google as a list of comma-separated values. We thus have applied a corresponding fix (to take care of all locales that do not use a “.” decimal point for floating point numbers) to correct this problem.
Please re-download the ZIP file, extract and replace the DLL. If you have deployed the DLL to the GAC, please also do an IIS reset.
Filippo  
8/28/2009 15:46 
I have the same issue as Nigel. WSS_Medium doesn't help. My message is: Unable to add selected web part(s). AE Google Map Chart: cannot import Google Map Chart Web Part. Thanks for you support
Juerg  
8/28/2009 16:08 
Filippo, were you able to add other web parts from us without problems?
Can you also check if you modified the correct web.config file at c:\inetpub\wwwroot\wss\virtualdirectories\80 ?
Filippo  
8/31/2009 17:56 
Hi Juerg,
this is bizarre: I am totally sure I have copied the dll in the Assemblies folder, but this afternoon I rechecked and it was not there. Now I have recopied it and am able to upload the Web Part.
So, thanks for your support and sorry for the unneeded troubles.
Thanks Filippo
PS: the Web Part is great!
Randall  
10/21/2009 21:51 
I am having the same trouble as Sohail and Alessandro -- the map is not filling out the states with the color that the legend has displayed.
Randall  
10/21/2009 22:02 
Never mind. I'm a moron. I didn't read the Google Documentation on how the states had to be named. THanks. Awesome webpart.
Rouel  
10/29/2009 18:35 
trying to install the google map webpart - errors. made the changes suggested above but no dice. I would love to use this as it as various client facing utilities. any suggestions? error is "not registered safe"
Juerg  
10/29/2009 18:55 
Rouel, you have to add the following line to the "<SAFECONTROLS>" section of your Web.Config file:

<SafeControl Assembly="MapChartWebpart, Version=1.0.0.0, Culture=neutral, PublicKeyToken=390c6862534d1b79" Namespace="MapChartWebpart" TypeName="*" Safe="True" />

Please make sure that this is on one single line (no line breaks). Please also make sure that you placed the line into the right web.config file, since you might have multiple Sharepoint applications installed on the same machine.
The default application typically is located at:

c:/Inetpub/wwwroot/wss/VirtualDirectories/80
Thomas Dravecz  
11/3/2009 18:07 
I receive the same error as the others above, "Cannot import this Web part". The control is marked as safe. I verified by removing it from the safecontrols. I then receive "...The type is not registered as safe." as expected. The trust level in the web.config is<trust level="wss_custom" originUrl="" />.
I assume that refers to the following, but since I didn't specifiy any custom settings, I have no idea why this is there... or what is in it.
<trustLevel name="WSS_Custom" policyFile="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\config\wss_custom_wss_minimaltrust_1092262d-5ae8-45cf-89c4-e2fd97524009.config" />
<trustLevel name="wss_custom" policyFile="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\config\wss_custom_wss_custom_wss_minimaltrust_1092262d-5ae8-45cf-89c4-e2fd97524009.config" />
Juerg  
11/4/2009 13:59 
Thomas,
rather than trying to edit you custom policy file, I recommend that you copy the DLL into c:\windows\assembly and delete it from your BIN directory. This will give it full trust.
Please use Windows Explorer to copy the DLL into the GAC (either directly at the server or via RDP, not via a network share)
antonio  
3/8/2010 20:23 
Can someone please post a example of their webconfig file to get this webpart working? I'm running into some issues. Would appreciate your assistance.
Juerg  
3/9/2010 15:31 
antonio, what exactly is the error message you get ?
Chuck  
6/5/2010 17:55 
Could not get this to install omn SP2010 Enterprise. Fails on apply or inserting into a page. Error is "cnnot import web part"
Radhika Karavadi  
6/14/2010 23:16 
The legend is being displayed, but not the map image. Please help.
Radhika  
6/14/2010 23:22 
I am not able to see the image because I am not connected to internet on my server. Nevermind :)
Can this chart be made interactive?  
6/15/2010 20:31 
CAN I CLICK ON SAY A COUNTRY AND FILTER another webpart based on the country clicked?
Juerg  
6/16/2010 16:28 
this is currently not possible. We'll hopefully find the time to release a new version later this year based on the Google Visualization API which will include this feature.
Rom  
12/9/2010 04:19 
No display on Map Chart...Whats is the problem with my installation and Settings..Thanks
Chuck Gann  
2/7/2011 16:50 
Good morning, Is it possible to show groupings? For example, if my company has divisions that are made up of multiple states, can I show the division's distinctly? Thanks.
Juerg  
2/17/2011 14:33 
Chuck,
we now have released the new version 2.0 of the „Map Chart” web part which now (besides other now features) also allows to group countries or states. The displayed settings on this page should actually describe your desired setup (grouping US states).
Lloyd Apter  
2/21/2011 20:58 
Hi Juerg, can the map be used as a home page, so that if people click on the countries/states they will be redirected to there country folder/site? thanks for the help.
Nicolás  
5/30/2011 23:21 
Can I use an Calculated field as Value Field Name and Marker Field Name?
Juerg  
5/31/2011 11:36 
Lloyd, this is currently not possible. We'll hopefully find the time to release a new version later this year based on the Google Visualization API which will allow us to include this feature.
Juerg  
5/31/2011 12:00 
Nicolas,
we have now added support for calculated fields (both for the „Value Field Name” and the “Marker Field Name” settings).
Please re-download the updated Zip file from our web site, extract and then replace the DLL, followed by an “iisreset” command if you placed the DLL in c:\windows\assembly.
Janina   
9/1/2011 20:22 
Hello, I copied your list that, followed each step and I cannot get it to look like the the map that you have as a example on your page, US Sales Q2 2010.
Nicolas  
10/18/2011 20:18 
Hi, I bought this component and it's great but now I have many flags in the map and i'd like to have to more parameters to set list columns wich contains the values to apply horizontal and vertical offset per eache flag.
Kylie  
11/16/2011 03:19 
My client has purchased the licensed version of this web part and it is really good. What we would love to do is use a term set to hold all of the country codes (I have created a term set based on the list here: http://en.wikipedia.org/wiki/ISO_3166-2) Using these codes for State/Country Field name kind of works - we get the map legend coming up, with the correct value options, however nothing is plotted on the map. This will most likely be because the value stored in the field is not simply the term label, it is the term label + the GUID for that term. It would be fantastic if you could get this to work using a taxonomy field. I can see a lot of people wanting to use it this way.
Juerg  
11/24/2011 19:12 
Janina,
can you send us a screen shot of
1. The Sharepoint List (data to be mapped)
2. The Web Part’s “Miscellaneous” configuration tool pane section
3. The resulting map
Juerg  
11/24/2011 19:17 
Nicolas,
you can shift individual flags as follows: Define an additional column named “Marker” (single line of text).
Enter the horizontal and vertical marker adjustment into this field where needed:
Allen Maloy  
12/1/2011 00:06 
Hello...when I use a text column for "Marker Field Name" i get no markers. if i use the "Value Field Name" column I get markers. I want a name to be used for the marker...is that possible?
Michael  
2/7/2012 11:53 
do the Google Map Chart Sharepoint Web Part work without internet access ?
Juerg  
2/7/2012 12:12 
Michael,
yes, the browser (but not the Sharepoint server) needs to be able to access the Google Chart web service via the internet.
Rob Pearmain  
6/22/2012 11:04 
Based on the current user, I perform a SQL query on a list of accounts and display the resulting postcodes.

I would love to display this as a map in SharePoint.

Would you ever add the option of running a SQL query instead of looking at a list, as this resultset would be dynamic based on the current user?
Thomas  
8/6/2012 17:05 
Rob,
good idea. May be we implement it for the next major version.
Qsnew  
9/5/2012 11:47 
Will this work with SharePoint Online?
Juerg  
9/5/2012 17:36 
Qsnew,
we have now added the “Download” button for the Office365/Sharepoint Online version of the Map Chart web part.
Steven  
3/1/2013 21:57 
Could this web part be used with defined areas within a city instead of states within a country? e.g. neighborhood boundaries.
Juerg  
3/5/2013 12:24 
Steven,
the Google Visualization API (as used by the web part) currently only supports map areas down to the metropolitan level (but not areas within metropolitan areas).
Jeff  
7/10/2014 02:29 
Is there any way to have the flag appear in a particular city?
Juerg  
7/10/2014 17:28 
Jeff,
the map is not able to display the cities (unless you place a marker containing the city name).
However, you can shift marker positions as follows:
Define an additional column named “Marker” (single line of text).
Enter the horizontal and vertical marker adjustment into this field where needed:

Keith  
10/28/2015 20:12 
The GroupBy section in the instructions is not making sense to me.

I have a Column "Region" which does group by just fine, but if I add the colours and /sum into the column field the part throws errors:
'Value' List column not found:Funding/Column 'Region,ff0000,ffff00,00ff00,aabbcc,ffffff' does not exist.
Grouping Error:Column 'Region,ff0000,ffff00,00ff00,aabbcc,ffffff' does not exist

Can you please clarify where I am supposed to putting the colour coding and /sum text?
Juerg  
11/3/2015 14:35 
Keith,
please enter the below into the "Group By" web part setting:

Region/sum

and the region color values into the "Map Chart Color Palette" setting as for example:

FF9999,008000
Keith  
11/6/2015 16:47 
Juerg,

Thanks for the reply. I got the demo of it working. Is there any way to make the regions or countries or flags clickable so I could drive to other pages for reporting?

So far the client likes what they saw, but they have asked for this click on the map to drive to other pages functionality.

Cheers!
Juerg  
11/6/2015 17:14 
Keith,
the Google Map Chart has no provision to click on individual map items, so you would need to create an HTML image map to make the chart areas clickable.

Technical Support Contact Information
If you find that you cannot resolve an issue using the above tools, our Technical Support staff will be ready to handle your technical support needs. You can reach our staff by phone or by email.

Phone: +41 (0)62 823 75 75 (9am - 6pm GMT+1)
Fax : +41 (0)62 823 75 74
Email: support@amrein.com
 
© 2017 AMREIN ENGINEERING AG


Support is fast and accurate. Very helpful. Very nice selection of components.

Mark Kraska, eHealth Global Technologies Inc.





Subscribe to Newsletter
If you want to be kept informed about our new or enhanced Sharepoint web parts, subscribe to our Sharepoint Web Part Newsletter:

You can also subscribe to our Web Part News RSS Feed:

RSS Feed

Follow us on Twitter:

Web Part NewsSharePoint News Carousel Web Part
5/1/2017
The new "News Carousel" Web Part allows to rotate SharePoint List items (typically used with a SharePoint "Announcements" list) manually and/or automatically. It displays an optional image, the title and the item body text. The web part can be used with SharePoint 2010, SharePoint 2013 and SharePoint 2016.

SharePoint List Rotator Web Part
5/1/2017
The new "List Rotator" Web Part allows to rotate SharePoint List items manually and/or automatically using a freely configurable layout template. The web part can be used on SharePoint 2010, SharePoint 2013 and SharePoint 2016.

SharePoint Facebook Timeline
6/1/2016
The free "Facebook Timeline" Web Part allows to embed the Timeline of the specified Facebook timeline. The users can like and share the posts without having to leave SharePoint.

The web part can be used on SharePoint 2010, SharePoint 2013, SharePoint 2016 and SharePoint Online/Office365.

SharePoint Toast Notifcations
6/1/2016
The Toast Notification SharePoint solution lets you centrally manage notifications and alerts targeted to all users or specific user groups.
It reads entries from the included SharePoint List and displays notifications targeted to either selected groups or all users during the specified time window as configured for each notification.
The solution can be used on SharePoint 2010, SharePoint 2013, SharePoint 2016 and SharePoint Online/Office365.