Rollbase selectQuery and Google maps callstack

Okay well I figured out why this happens, the geocoder.geocode function is called asynchronously so the loop finishes before the method executes.

Now I might need help to think of a workaround :)

Hi  alexanderg,

Any particular reasons to use the client side API to query the data? If not you can create a formula field that returns the needed values so that the value is generated via server side and then you can just use the formula field token to render the values and put it in the geocode function.

Another approach that I would suggest is to use a better Google map plugin. Gmap.js is a very good Google map plugin which simplifies the code needed to generate a map.

Let me know if you have anymore questions.

Thanks,

Gian

Answers from this StackOverFlow question might help you... stackoverflow.com/.../multiple-markers-google-map-api-v3-from-array-of-addresses-and-avoid-over-query

Try using server-side API in EVAL[ ] block instead of client-side API. That would be much simpler - you don't need callback.

Hello,

We have done the exact same implementation in our Rollbase apps and encountered the same problems.

What we ended up doing (which is one possible solution) is we created a Rollbase "HTTP GET" trigger in our object that calls Google Maps Geocoder, retrieves the result, and saves latitude and longitude into two Rollbase Text Fields that we created. (A faster way to do this, would be to use a Object Script type of trigger and the rbv_api.sendHttpGet function)

Then in our client-side JavaScript, we use rbf_selectQuery to retrive latitudes and longitudes, instead of the adresses, and create Google Maps markers, before putting them onto the map.

Don't hesitate to contact me should you want some more info or code samples.

Cheers,

Romain.

Hi guys, thanks for your help.

I'm currently creating formula fields for the latitude and longitude but I don't know where to include the google maps API in my application server side? The formula that I entered doesn't recognize the "google" keyword of course so that tells me that the API isn't included

bump

So I've been trying out the rbv_api.sendHttpGet method also to no avail, getting some very in-concise errors that I dont understand

Hi Alexander,

You can include the scripts in the formula field by creating a hosted file.  Go to Settings -> Application Settings -> Hosted Files.

After creating a hosted file, include the hosted file token in the formula field you created.

Thanks,

Gian

Hi Gian, can I actually load the google maps API as a hosted file?

The error I'm getting with the "rbv_api.sendHttpGet" method is:

Error  http://maps.googleapis.com/maps/api/geocode/json?address=28+3rd+Street+Menlopark+Pretoria+ZA&key={API-KEY} (line #11) in formula:
var rbv_api = new Packages.com.rb.core.services.api.ServerSideAPI(1, 5790);

function getLat()
{
  var city = ", " + "Pretoria";
  var country = ", " + "ZA";
  var address = "28 3rd Street Menlopark" + " " + "Pretoria" + " " + "ZA";
  address = address.replace(/ /g,"+");

This is the original formula that I've entered:

function getLat()
{
  var city = ", " + "{!city#value}";
  var country = ", " + "{!country#code}";
  var address = "{!streetAddr1#value}" + " " + "{!city#value}" + " " + "{!country#code}";
  address = address.replace(/ /g,"+");
 
  var result = rbv_api.sendHttpGet("http://maps.googleapis.com/maps/api/geocode/json?address="+address+"&key=AIzaSyCQBMnqH-q8etEl3CDOQHQaosd1LSXz_GM");

  return result.results[0].geometry.location.lat;
}

getLat();

Hi,

Your request ends up calling:

maps.googleapis.com/.../json

Which doesn't work (because it requires SSL and your key seems wrong).

If you call this instead:

maps.googleapis.com/.../json

It seems to work fine.

Then, I think you also need to call the "rbv_api.stringToJson" function.

The following works:

function getLat()

{

 var result = rbv_api.stringToJson(rbv_api.sendHttpGet("maps.googleapis.com/.../json));

 return result.results[0].geometry.location.lat;

}

getLat();

Hi Romain

Would you mind posting the those full URLS?

It seems the forums have shorted them somehow

Romain I've run through the combinations on that url and I keep getting the same error as previous?

I copy pasted the urls you posted(at least what comes up when I click on them in my browser), I used the other method and put a "+" in between as well.

Also, if it means anything, I manually removed my api key from the url I posed here but I use the correct one on my side

Hello,

This works fine in my Rollbase trigger(hopefully the adress isn't shortened):

var result = rbv_api.stringToJson(rbv_api.sendHttpGet("maps.googleapis.com/.../json));

rbv_api.println(result.results[0].geometry.location.lat);

Have you added the "rbv_api.stringToJson" call?

Cheers,

Romain.

Hey guys

Thanks for all your help.

After much investigation and reacting on my own hunch I decided to test if it was our proxy server denying these requests and indeed it was.

The error in Rollbase had no indication to this and neither did the Catalina logs(at least for how far my Tomcat knowledge reaches).

I suspect it has something to do with the combination of Rollbase and Tomcat or either one alone because the geocoder requests do work through Javascript ran on the browser's side.

Again thanks for all your help