show a place with google maps

[agh_grove]

Hi,

in a list are two fields: Longitude and latitude. tey are different regarding an other field e.g. orderno.

I want to show this place with google maps. How can i do this ?

rgds,

Andreas

 

[troester]

You can't directly. Fabrik googlemap viz needs records with a googlemap element.

A googlemap element needs the coordinates in format (lat,lon):zoom (e.g. (47.3969647, 8.618638499999975):8 ).

So you must add a googlemap element to your list. If you need additionally fields with lat and lon you have to add a form php plugin converting lat/lon to googlemap format (or vice versa) on form save.

 

[IamJim]

Hello Troester

let's picture this please? But what if I already have a csv/db with US Zip codes Lats & Longs?

 

[IamJim]

/*BUMP*/

 

[rob]

you would need to write a MySQL query to convert those lats and longs into the format that the google map element uses.
Say your db table is call countries and has field lat, long and you have a final field called 'map' which is the google map element. Run this query from phpmyadmin or similar:

update countries set map = CONCAT('(', `lat`, ', ', `long`, '):8')