Need help? Check out our Support site, then


Bug inserting google maps with google spreasheet input as kml .

  1. 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
    <br /> <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><br /><small><a href="http://maps.google.com/maps?f=q&source=embed&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">Agrandir le plan</a></small><br />

    The code transformed by wordpress.com in the post
    <br /> [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]<br />

    The resulting code when checking source
    <br /> <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><br /><small><a rel='noreferrer' href='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&source=embed'>View Larger Map</a></small></p><br />

    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=2

    It 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 alaventure.wordpress.com.

  2. Are you modifying the code in google spreadsheet? I guess I'm not understanding why you are messing with it in a spreadsheet.

  3. 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 links

    http://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.

  4. Talk to staff. Google maps embed just fine here. I have no idea what google spreadsheet does to them that wordpress does not like, but I doubt it is a wordpress bug.

    http://en.support.wordpress.com/contact/

  5. Support confirm the problem with "advanced" map.
    For now, no way to have a map with points, lines, ... as allowed with kml

  6. Good to know, and thanks for posting back here with what they said.

Topic Closed

This topic has been closed to new replies.

About this Topic