Bug inserting google maps with google spreasheet input as kml .
-
Hello,
I’m trying to insert a google maps in my blog. I checked
http://en.support.wordpress.com/google-maps/But my map is a generated dynamically from google spreadsheet as txt. It is after used as a direct kml input in googlemaps and wordpress.com doesn’t manage to display the content of the map.
Code from google
<iframe width="600" height="450" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.com/maps?f=q&source=s_q&hl=fr&geocode=&q=https:%2F%2Fspreadsheets.google.com%2Fpub%3Fkey%3D0Aiz7oO7ZYCxQdDNuM3RMdS1BbEd3VHVpeVk1cUxjT2c%26hl%3Den%26single%3Dtrue%26gid%3D3%26range%3DA12%26output%3Dtxt&ie=UTF8&ll=-0.624052,159.570698&spn=0.004828,0.006427&z=17&output=embed&z=2"></iframe>
<small>Agrandir le plan</small>
The code transformed by wordpress.com in the post
[googlemaps http://maps.google.com/maps?f=q&source=s_q&hl=fr&geocode=&q=https:%2F%2Fspreadsheets.google.com%2Fpub%3Fkey%3D0Aiz7oO7ZYCxQdDNuM3RMdS1BbEd3VHVpeVk1cUxjT2c%26hl%3Den%26single%3Dtrue%26gid%3D3%26range%3DA12%26output%3Dtxt&ie=UTF8&ll=-0.624052,159.570698&spn=0.004828,0.006427&z=17&output=embed&z=2&w=600&h=450]
The resulting code when checking source
<p><iframe width="600" height="450" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.com/maps?f=q&source=s_q&hl=fr&geocode=&q=https://spreadsheets.google.com/pub?key=0Aiz7oO7ZYCxQdDNuM3RMdS1BbEd3VHVpeVk1cUxjT2c&hl=en&single=true&gid=3&range=A12&output=txt&ie=UTF8&ll=-0.624052,159.570698&spn=0.004828,0.006427&z=2&output=embed"></iframe>
<small>View Larger Map</small></p>
The direct link to consult the working map
http://maps.google.com/maps?q=https:%2F%2Fspreadsheets.google.com%2Fpub%3Fkey%3D0Aiz7oO7ZYCxQdDNuM3RMdS1BbEd3VHVpeVk1cUxjT2c%26hl%3Den%26single%3Dtrue%26gid%3D3%26range%3DA12%26output%3Dtxt&sll=37.0625,-95.677068&sspn=45.063105,75.9375&ie=UTF8&ll=-0.624057,159.5707&spn=90,-45.560574&output=embed&z=2It seemed wordpress.com doesn’t manage well the multiple arguments in calling google maps, so it try to display an incorrect kml url reference.
any ideas how to solve this ?
Thanks a lot
The blog I need help with is: (visible only to logged in users)
-
Are you modifying the code in google spreadsheet? I guess I’m not understanding why you are messing with it in a spreadsheet.
-
Modifying which code in google spreadsheet. It generates valid kml code which can be read in google earth and by google maps. That’s only a wordpress problem.
It’s a bug discussion not why I do this. But I explain:
doing this allow simply to list location and dynamically geocode them and generate corresponding map with some legend like following linkshttp://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsmapwizard/makecustommap.htm
http://www.zadling.com/2010/03/create-a-google-map-from-a-spreadsheet/
(which seems to mention the same bug that I have)
http://googlemapsapi.blogspot.com/2007/03/creating-dynamic-client-side-maps.html
http://www.digitalgeography.co.uk/archives/2006/08/online-spreadsheets-and-kml-the-possibilities-are-endless/A single change in spreadsheet will update the map without any code.
-
Support confirm the problem with “advanced” map.
For now, no way to have a map with points, lines, … as allowed with kml -
- The topic ‘Bug inserting google maps with google spreasheet input as kml .’ is closed to new replies.
WordPress.com Forums 