locked
Maps & Longitude/Latitude Coordinates RRS feed

  • Question

  • We have some 50,000+ records in our database. Some of them have longitude/latitude coordinates and some don't. I need a solution that:

    1) Adds longitude/latitude coordinates for all leads that don't already have it
    2) Add longitude/latitude coordinates for newly created leads/accounts/contacts

    I am find doing 1) for the 50,000+ records manually, meaning export the list, have the missing longitude/latitude filled in by some software, and then re-importing the records. 2) needs to happen automatically in the background.

    What solutions are available for both tasks? Is there an easy integration with Microsoft MapPoints? If not what other options are there?

    Wednesday, March 12, 2014 6:33 PM

All replies

  • Hi hfaun,

    Develop a one time console application, that fetches all the Leads record that do not have latitude/longitude values, and use your application (web service or flat file) to fetch the longitude and latitude values for the leads and update them in CRM.

    For future where you need the latitude and longitude values to be auto-populated in CRM, you could write a plugin on post update of Lead to determine the latitude/longitude values and update the Lead record.

    Also, for integrating Dynamics CRM with Microsoft MapPoints you could have a look here:

    http://blogs.msdn.com/b/crm/archive/2007/06/14/microsoft-dynamics-crm-and-mappoint-integration-a-picture-is-worth-a-thousand-words.aspx


    Admin QuikView Solution for CRM 2013


    • Edited by Anupam Bishui Wednesday, March 12, 2014 7:14 PM
    • Proposed as answer by Anupam Bishui Friday, March 14, 2014 9:29 AM
    • Unproposed as answer by Anupam Bishui Friday, March 14, 2014 7:18 PM
    Wednesday, March 12, 2014 7:11 PM
  • Thanks for the reply. I was actually looking for recommendations for some software. It is my understanding MapPoint web services you mentioned have been discontinued. Bing Web Services seem to be way too expensive. Actually, I contacted MS about it but did not get a response so I looked at info that was available online.

    I looked into various other options and figured that the MapPoint software, which offers a COM interface, is the best way to go. Unfortunately, I am facing some issues with that integration (not trusted, resolved with not putting the plugin into a sandbox) and 32-bit vs 64-bit.

    Friday, March 14, 2014 5:56 PM
  • Create a Geocoding UDF in SQL. Here is a blog post on how to do this: http://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/ This will allow you to easily geocode your data in SQL using queries. You could setup a trigger for when new rows are added to geocode them automatically.

    It should be noted that the MapPoint CD product is not allowed to be used on a server to populate a database like the other suggests mention.


    http://rbrundritt.wordpress.com


    Wednesday, March 19, 2014 2:34 PM
  • As you mentioned, the licensing for the 'big' providers gets prohibitive (Bing, Google, Yahoo, etc). One of the articles linked in this thread is about writing a SQL UDF that calls Bing Location services - which still doesn't solve the licensing issue, but it also has a link IN that article on how to roll your own UDF based on downloaded data.

    http://sqlbits.com/%28S%28fueva455qrdns245thsoiovo%29%29/Sessions/Event8/Who_needs_Google_Maps_Build-your-own_Mapping_Geocoding_and_Routing_service

    If that's a bit more than you want to take on, we have had some success using Melissa Data web services to provide both address correction and geocoding. The last time I dealt with them you could license X number of 'hits' for a reasonable price, and your 50,000 records would not be a huge burden. The services were also relatively easy to work with.

    Wednesday, March 19, 2014 3:24 PM