implement google map

[thanhphongle]

Hello community,

i tried to implement google maps in qv with an instruction posted in qv forum. unfortunetly i coulnt managed it and do not really know where my fault is. could anyone help me out here please?

my script:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

LOAD [Lease No],

     Category,

     Manufacturer,

     Model,

     [Serial Number],

     [Selling price],

     [Location of installation],

FROM

[Testdatenbank 15.06.2015.xlsx]

(ooxml, embedded labels);

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

for i=0 to $(noRows)

    let a=peek('Category',$(i),'Sheet1');

       let b=peek('Manufacturer',$(i),'Sheet1');

       let c=peek(‘Model’,$(i),'Sheet1');

    let address=peek('[Location of installation]',$(i),'Sheet1'); 

Data:

    LOAD

    '$(a)' as Category,

    '$(b)' as Manufacturer,

    '$(c)' as Model,

    '$(address)' as Standort,

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

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

    FROM [http://maps.google.com/maps/geo?q=$(address)&output=xml&oe=utf8&sensor=false&key=XXYYZZ] (XmlSimple, Table is [kml]);

next

new tab (Google map)

// get a key here http://code.google.com/apis/maps/signup.html

gmap_key = 'xx';

max_zoom_level = 17; //maximum value 17

// Variables required for calculating map

// No need to change these

var_pi180=        '=pi()/180';

var_lat_offset=    '0';

var_mc2=        '=256*pow(2,$(var_zoom))';

var_mc1=        '=256*pow(2,($(var_zoom)-1))';

var_mid_lat=    '=min(latitude)+(1+var_lat_offset)*((max(latitude)-min(latitude))/2)';

var_mid_long=    '=min(longitude)+(max(longitude)-min(longitude))/2';

var_zoom=        '=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( longitude  *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( longitude  *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<map_size_y,_zoom_level,1),_zoom_level))';

var_maptype=    '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 1 ),maptype)';

map_size_x=        '400';

map_size_y=     '400';

SET HidePrefix='_' ;

// Field required for calcualting best zoom level

_zoom_level:

Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

maptype:

LOAD * INLINE [

    maptype

    roadmap

    mobile

    satellite

    terrain

    hybrid

];

[thanhphongle]

qvw is attached

[jpenuliar]

attached

[thanhphongle]

i think you attached the wrong file