CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Plotting Addresses on Google Map in Reports

Bijay Soren-Oracle
Bijay Soren-Oracle Posts: 659 Silver Trophy
edited Sep 15, 2013 9:48PM in CRM On Demand - Reports and Dashboards (MOSC) 4 comments

Comments

  • User572846-OC
    User572846-OC Posts: 29 Green Ribbon

    Hi Bijay,

    Thakas for this super document.I wanted to know can we skip the 1st pasrt where we place a button and get the Geocodes.

    Instead can we not directly in the report pass the address and get the plotting in the map.

    I have Lakhs of Customers.It would not be possible to go to every Customer -->Go to Edit mode> Update the Geocodes...(Can this proces be automated)

    Regards,

    Sankalp

  • Bijay Soren-Oracle
    Bijay Soren-Oracle Posts: 659 Silver Trophy

    Hi Bijay,

    Thakas for this super document.I wanted to know can we skip the 1st pasrt where we place a button and get the Geocodes.

    Instead can we not directly in the report pass the address and get the plotting in the map.

    I have Lakhs of Customers.It would not be possible to go to every Customer -->Go to Edit mode> Update the Geocodes...(Can this proces be automated)

    Regards,

    Sankalp

    Hi Sankalp,

    You can directly pass the address and get the Geocoding(Latitude and Longitude) value and plot them on the map. However, there is a limit on how many Geocoding(Latitude and Longitude) requests you can send per second set by Google. You have to delay the geocoding request by implementing some logic in you code and hence, this will take longer time to display the address mapping on the google map. For this reason, I have saved the Geocoding(Latitude and Longitude) values before hand.

    More info about other Google map api limitation can be found on https://developers.google.com/maps/documentation/business/articles/usage_limits

    Regards,

    Bijay

  • User572846-OC
    User572846-OC Posts: 29 Green Ribbon

    Hi Sankalp,

    You can directly pass the address and get the Geocoding(Latitude and Longitude) value and plot them on the map. However, there is a limit on how many Geocoding(Latitude and Longitude) requests you can send per second set by Google. You have to delay the geocoding request by implementing some logic in you code and hence, this will take longer time to display the address mapping on the google map. For this reason, I have saved the Geocoding(Latitude and Longitude) values before hand.

    More info about other Google map api limitation can be found on https://developers.google.com/maps/documentation/business/articles/usage_limits

    Regards,

    Bijay

    Hello Bijay,

    Actually I was thinking something else..Like in webapplet we simply pass the address and we get that on the map.There we dont pass any Geocodes

    can that approach be impelemted here? I was wondering cannot we simply pass the address.We don't want Google returns the geocodes, we just want that Google plots that address on map instead of converting the address to Geocodes.

    I hope you get my point.

    TO repharese" If we can send multiple Geocodes to get the plotting on Map, can we not send multiple address to get the plotting on map"

  • MKH-OC
    MKH-OC Posts: 427 Silver Badge

    Hi Sankalp,

    You can directly pass the address and get the Geocoding(Latitude and Longitude) value and plot them on the map. However, there is a limit on how many Geocoding(Latitude and Longitude) requests you can send per second set by Google. You have to delay the geocoding request by implementing some logic in you code and hence, this will take longer time to display the address mapping on the google map. For this reason, I have saved the Geocoding(Latitude and Longitude) values before hand.

    More info about other Google map api limitation can be found on https://developers.google.com/maps/documentation/business/articles/usage_limits

    Regards,

    Bijay

    Hi Bijay!

    On the lines of what User572846-OC was asking...I am trying to accomplish this by creating an Applet and using an Account Report and need help with the code for passing the addresses on the filtered report to plot on the Narrative Google Map.  Do you have any code for this (rather than using the lattitude and Longitude)?

    Any help is greatly appreciated.

    Mary

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center