[Plugin: Basic Google Maps Placemarks] Export to Excel

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?

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

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?

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