Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

GOOGLE API GEO location loader

avkeep01
Valued Contributor

GOOGLE API GEO location loader

Hi All,

I created a QVF which loads GEOlocations from the Google API.

On the "Data Load Editor" just change the source for the table "Addresses" on the sheet "setup"

on the sheet "Setting" adjust the following variables:

SET vMapsQVD = [lib://GeoLocation/GeoLocation.qvd];

SET vMapsLanguage = EN;

SET vNumberOfLookups = 100; // MAX 2.500

!

Tags (1)
Attachments
Comments
nestmartv
New Contributor II

Hi, I´m interested in you QVF. I´m trying run the QVF but I don´t know what is my error running the script. Could you help me giving me information about what i need to change in the QVF?

Please.

avkeep01
Valued Contributor

Hi Nestor,

A few things, the inline table needs to be filled with your data. And you probably need to change the library location. What is de error messages?

nestmartv
New Contributor II

Well the information that i need to charge is an Excel file, but only to prove it I wrote one direction more inthe LOAD IN LINE direction INLINE.jpg

The first error was a problem with the Rest connector, update the conexion was the solution Mtke1.jpg

But now my problem is with this error:

mtke2.jpg

Thank you for help me!

avkeep01
Valued Contributor

Hi Nestor,

Is it possible that all addresses are already in the GeoLocation.QVD? If so then there would be a row in the script log showing:

TRACE -- No new addresses --;

(In that case the script should end. Right now the Exict Script is missing on the "Check QVD" Sheet. )

Version history
Revision #:
1 of 1
Last update:
‎11-22-2017 10:00 AM
Updated by: