Development

Intergrating Google Maps v.3 into Microsoft Dynamics CRM 4.0

In this post I will describe how to integrate Google Maps v.3 with Microsoft Dynamics CRM 4.0 using IFrame customization.

1. I created simple html page with following code (I called this page MapIntegration.html):

 

2. Copy this page into ISV subdirectory of your Microsoft CRM website:

3. Open customization form of entity you want to integrate Google Maps in, create new tab, new section and new iframe:

4. Insert following script to OnLoad event handler:

 

5. Save form, publish entity, check the result:

36 Comments on “Intergrating Google Maps v.3 into Microsoft Dynamics CRM 4.0

  1. Hi,
    Thanks for this post i wanted to do this for a while but couldnt find a sample out there that worked for me. this did – so thank you.
    It does how evernot show the location correctly. when i open the map tab, i get the following error – Geocode was not successful for the following reason: INVALID_REQUEST also the maps centres on a lake in south east australia even though the contacts are in the UK.
    What am i doing wrong

  2. Hi.

    Could you paste url you use for investigation? To get it modify code

    crmForm.all.tab4Tab.onclick = function()
    {
    var url = "";
    if (crmForm.all.address1_country.DataValue != null)
    url = crmForm.all.address1_country.DataValue;
    if (crmForm.all.address1_city.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_city.DataValue;
    if (crmForm.all.address1_name.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_name.DataValue;
    if (crmForm.all.address1_line1.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line1.DataValue;
    if (crmForm.all.address1_line2.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line2.DataValue;
    if (crmForm.all.address1_line3.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line3.DataValue;
    if (url != "")
    {
    url = "/ISV/gmap/mapintegration.html?address=" + url;
    crmForm.all.IFRAME_map.src = url;
    }
    }

    to code

    crmForm.all.tab4Tab.onclick = function()
    {
    var url = "";
    if (crmForm.all.address1_country.DataValue != null)
    url = crmForm.all.address1_country.DataValue;
    if (crmForm.all.address1_city.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_city.DataValue;
    if (crmForm.all.address1_name.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_name.DataValue;
    if (crmForm.all.address1_line1.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line1.DataValue;
    if (crmForm.all.address1_line2.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line2.DataValue;
    if (crmForm.all.address1_line3.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line3.DataValue;
    if (url != "")
    {
    alert(url);
    url = "/ISV/gmap/mapintegration.html?address=" + url;
    crmForm.all.IFRAME_map.src = url;
    }
    }

    Once you clicked at the tab you will get widow with URL which is opening, click CTRL+C, paste it somewhere and copy the link and publish here. I will try to help you.

  3. thanks for the quick reply,after i changed the code i get Eror : – Navigation to the webpage was canceled (URL: res://ieframe.dll/navcancl.htm) IF i leave the iframe address as about:blank (as per your 2nd screenshot).
    If i change the iframe url to where i placed the file – http://server/ISV/location.html i get this error – Geocode was not successful for the following reason: ZERO_RESULTS
    does that make any sense?

  4. Hi,
    I used your above code with the alert message to get the url.I am receiving the below url
    /ISV/gmap/mapintegration.html?address=India,Chennai,Ambatur,AmbaturEstate
    This what i am receiving as alert message
    But the Map is not loading in the iframe

  5. hi andriy, sorry for late reply i was enjoying a long overdue holiday.
    i do not understand what you mean by "show me the url which passed to iframe source"
    do you mean the 'URL' field under the 'Name' section in the 'General' tab of the 'IFAME Properties' ?
    If so – then the URL is http://crm/ISV/location.html
    Sorry for all the questions, but i do not understand what you mean.

  6. sorry for delay in answering..
    i had to concentrate on other matters, back i am back in to it now.
    i removed all the customization for this and started afresh – with similar results.
    so i added the alert and what i get now is a window opening titled 'message from webpage'
    and inside "uk, Belfast, 10 Royal Ave" (which is the address of the contact)

    There is no /ISV/location.html?adress

  7. hi,
    thanks for the great post!
    when i run the script withput crm, everything works fine, but when i try to run it with CRM i got error. i always get the error "Geocode was not successful for the following reason: ZERO_RESULTS". when i add the alert(url) to the code, nothing happend 🙁
    it seems that CRM can't fetch the adress…
    thanks for your help!

    @zaxxon: did u solve your problem? what was the prob, i think i have the same…

    @zaxxon: how did u solve

  8. i used this code:

    crmForm.all.tab5Tab.onclick = function()
    {
    var url = "";
    if (crmForm.all.address1_country.DataValue != null)
    url = crmForm.all.address1_country.DataValue;
    if (crmForm.all.address1_city.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_city.DataValue;
    if (crmForm.all.address1_name.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_name.DataValue;
    if (crmForm.all.address1_line1.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line1.DataValue;
    if (crmForm.all.address1_line2.DataValue != null)
    if (url != "")
    {
    alert(url);
    url = "/ISV/gmap/mapintegration.html?address=" + url;
    crmForm.all.IFRAME_map.src = url;
    }
    }

  9. Hi. It seems that you forgot to add one line. Try to use following code:

    crmForm.all.tab5Tab.onclick = function()
    {
    var url = "";
    if (crmForm.all.address1_country.DataValue != null)
    url = crmForm.all.address1_country.DataValue;
    if (crmForm.all.address1_city.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_city.DataValue;
    if (crmForm.all.address1_name.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_name.DataValue;
    if (crmForm.all.address1_line1.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line1.DataValue;
    if (crmForm.all.address1_line2.DataValue != null)
    url += (url == "" ? "" : ", ") + crmForm.all.address1_line2.DataValue; // You Forgot this line

    if (url != "")
    {
    alert(url);
    url = "/ISV/gmap/mapintegration.html?address=" + url;
    crmForm.all.IFRAME_map.src = url;
    }
    }

  10. Hi,
    Btw you've hidden the contact name, but the title of the window displays the contact name, thought you would like to hide this as well 🙂
    Keep the good work btw and thanks for the material

  11. Hi,
    I'm trying to implement your solution, I do have everything working ok but the IFRAME doesn't load the map, even if I manually set an url for the google maps page, the map doesn't get loaded in the Iframe.
    I always get two requests in IIS with an 200OK and 401. so strange. have you seen this before?

    2011-02-02 14:49:38 10.0.0.1 GET /ISV/gmap/GoogleMap.html address=ENGLAND,%20london,%20Leeds%20Houses 80 – 10.13.48.28 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+Trident/4.0;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729) 401 2 5 252
    2011-02-02 14:49:38 10.0.0.1 GET /ISV/gmap/GoogleMap.html address=ENGLAND,%20london,%20Leeds%20Houses 80 GLOBALNuno.Costa 10.13.48.28 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+Trident/4.0;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729) 200 0 0 208

  12. Hi Andriy,

    Yes that was the main issue, can I ask you how do you print the maps ?
    I'm thinking possibly using a report to render the map will be a possible solution ?

  13. Thank you for suggestion. It works, but anyway approach provided in the article – works too and it was used by me in several deployments and with other developers and customizers as far as I know.

  14. Hello,
    This would not work for this case.
    You will have to pass somehow 2 addresses to IFrame and use Geolocation webservice to get latitude an longitude of address and then show points on map. I have an idea to publish solution for CRM 2011 and Google maps but I can't tell you when I will have time for it.

Leave a Reply

Your email address will not be published. Required fields are marked *