Home › Forums › General Issues › Export data / database issue › Reply To: Export data / database issue
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
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.