How to Download Current Posts for Structure?

Hmm. that sounds like a good feature to have. I’ve considered including template files, but this would make analysis for importing a lot easier.

The following sql query will give you the data you need to build the spreadsheet, but with the taxonomies and postmeta, it would take a bit more doing to get them all on one row by just using a sql query.

column names for postmeta is the meta_key
column names for taxonomies is csv_tax_(taxonomy name) – precede values for heirarchical taxonomies with a comma

select
p.id,
post_title as csv_post_title,
post_content as csv_post_post,
post_type as csv_post_type,
post_excerpt as csv_post_excerpt,
post_date as csv_post_date,
post_name as csv_post_slug,
post_parent as csv_post_parent,
u.user_login as csv_post_author,
tt.taxonomy,
t.name, t.slug,
pm.meta_key, pm.meta_value
from wp_posts p
join wp_users u on p.post_author = u.id
join wp_term_relationships tr on tr.object_id = p.id
join wp_term_taxonomy tt on tr.term_taxonomy_id = tt.term_taxonomy_id
join wp_terms t on t.term_id = tt.term_id
join wp_postmeta pm on p.id = pm.post_id