Loading coordinates from Google maps

Anonymous — Thu, 11 Apr 2013 12:56:04 GMT

Hi guys,

I need your help!

I'm loading Coordinates directly from Google maps API with following code:

//loop each location to get geo info

let noRows = NoOfRows('Locations')-1;

for i=0 to $(noRows)

Data:

LOAD

'$(address)' as AddressString,

'$(loc_key)' as LocationKey,

'$(address)' as Address,

'$(i)' as LocationRow_tmp,

[Response/Placemark/Point/coordinates],

subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,

subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude,

[Response/Status/code] AS Statuscode

This worked for a long time but since March it doesn't anymore.

I got an API key and changed the "call" by adding the "sensor"-parameter. So the map works again.

But the load above does not get any data back from google.

For each record the statuscode is "610". That means the key I'm using is wrong or something?

G_GEO_BAD_KEY = 610 The given key is either invalid or does not match the domain for which it was given.

Can anyone give me some advice how to fix it?

Do I need an other key? which one?

Thanks!

MaciekP

topic Loading coordinates from Google maps in QlikView