WordPress.org

Ready to get started?Download WordPress

Forums

Basic Google Maps Placemarks
[resolved] Export to Excel (11 posts)

  1. firesitedesign
    Member
    Posted 1 year ago #

    Our site under development is here:

    http://www.carolinasfirepage.com/gis

    We have a need to capture our placemark data as a cvs or excel file. I know that we can Export from WordPress as an xml file. Is there a known converter after you have an xml file?

    I have also checked into the database in mysql through myphpadmin.

    It looks like wp_postmeta contains the data we are looking for, but it's not easily accessed.

    Any tricks for getting our existing placemarks into a simple xls or cvs file?

    Thanks in advance.

    http://wordpress.org/extend/plugins/basic-google-maps-placemarks/

  2. Ian Dunn
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. firesitedesign
    Member
    Posted 1 year ago #

    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?

  4. firesitedesign
    Member
    Posted 1 year ago #

    I figured this much out:

    bgmp-latitude
    bgmp-longitude

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

  5. Ian Dunn
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  6. firesitedesign
    Member
    Posted 1 year ago #

    It does support export of taxonomies.

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

  7. firesitedesign
    Member
    Posted 1 year ago #

    Correct to above post, use underscore, not the dash

    so

    bgmp_latitude
    bgmp_longitude

  8. Ian Dunn
    Member
    Plugin Author

    Posted 1 year ago #

    The taxonomy slug is bgmp-category

  9. firesitedesign
    Member
    Posted 1 year ago #

    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?

  10. Ian Dunn
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  11. maximusbrown
    Member
    Posted 1 year ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic