WordPress.org

Support

Support » Plugins and Hacks » Basic Google Maps Placemarks » [Resolved] [Plugin: Basic Google Maps Placemarks] Export to Excel

[Resolved] [Plugin: Basic Google Maps Placemarks] Export to Excel

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Ian Dunn

    @iandunn

    The placemarks are a custom post type, so they’re no different than regular WordPress posts, pages, etc. If you can find a plugin that converts post data to a CSV then that should work.

    One problem is that the database form is normalized, though, so you might need a way to combine the wp_posts and wp_postmeta tables, depending on what you want.

    Found what appears to be a useful plugin, Supra CSV, that will extract to an .xls file.

    I’m trying to export the post_title and post_content.

    One option asks for “meta keys provide a comma separated value”

    I would like to export the coordinates. What’s the meta name for that?

    I figured this much out:

    bgmp-latitude
    bgmp-longitude

    Any tips on extracting the bgmp categories, so I can easily sort the list?

    Plugin Author Ian Dunn

    @iandunn

    Categories are stored in the wp_terms, wp_terms_taxonomy and wp_terms_relationships tables, just not like categories and tags for regular Posts. So, the plugin will have to support taxonomies for it to work.

    It does support export of taxonomies.

    What string should I enter for the taxonomies for the bgmp categories?

    Correct to above post, use underscore, not the dash

    so

    bgmp_latitude
    bgmp_longitude

    Plugin Author Ian Dunn

    @iandunn

    The taxonomy slug is bgmp-category

    Excellent!

    Got it to work.

    Just one last question:

    Some placemarks are assigned to multiple bgmp categories, is there a way to determine which category the “bgmp-category” taxonomy will produce?

    Plugin Author Ian Dunn

    @iandunn

    That’s probably determined by the CSV plugin’s implementation. It could choose to export all of them in a single field, or create multiple rows, or only pick one.

    Would you be open to establishing an ODBC connection for Excel to communicate to your mySQL database? The excel template could include parameters like date, user, etc. Then all you have to do is click “refresh data” and the data will be retrieved from mySQL into Excel. Which version of Excel do you use? Do you have admin permissions on your computer? Would this be something useful for WordPress users like yourself?

    Best,

    maximusbrown

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘[Resolved] [Plugin: Basic Google Maps Placemarks] Export to Excel’ is closed to new replies.
Skip to toolbar