Hello, loved your plugin very much, set everything i need it a day, but i stuck with an export of posts. For me it’s very important, because i make database of patients.
When i export posts from wordpress admin panel, i get this in XML http://yadi.sk/d/nWodspjzSaxEN
So, i don’t have a single line for a single post, but ~20 lines. As more, i don’t have a signle column for single field (for exaple date of birth).
Export data from phpmyadmin is impossible, because data lies in different tables. As more, it looks very strange, it doesn’t rely to a single post, but has different ids… http://yadi.sk/d/dezon2HbSazeJ
May be you can suggest any other possibility to export them, or point me on my mistake somewhere. I will approtiate any help! On screenshots it russian language.
Well i solved this problem partly.
You can export posts with Phimind Excel Export plugin (it’s very easy out there). But it can’t export data arrays. And i reached maximum of posts quantity (it’s about of 40-50 fields).
Other way of export is SQL SELECT. Here is my query.
SELECT DISTINCT
post_title
,(SELECT meta_value FROM kr_postmeta WHERE kr_postmeta.meta_key = 'birth_day' AND kr_postmeta.post_id = kr_posts.ID) as "birth_day"
,(SELECT meta_value FROM kr_postmeta WHERE kr_postmeta.meta_key = 'birth_month' AND kr_postmeta.post_id = kr_posts.ID) as "birth_month"
,(SELECT meta_value FROM kr_postmeta WHERE kr_postmeta.meta_key = 'birth_year' AND kr_postmeta.post_id = kr_posts.ID) as "birth_year"
FROM kr_posts
WHERE post_type = 'post'
GROUP BY post_title
ORDER BY post_title DESC