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
Hi TrishaM, thank you for respond.
I build a base of children for russian medical institutions. It was planned so worker from institution can add child to database and add services that child got there. So theese are checkboxes for services https://yadi.sk/d/_6SEkMP3V3cQC.
I tell it because key function for me is repeater field, not sure if GF of Formidable have it. Also i bought this plugin and set up whole website for it, so i don’t rly want to give up so easily.
Close to the problem. In database it is saved serialized, like this https://yadi.sk/d/V4OiXtalV3d4o . I export posts and meta to Excel using SQL SELECT and i get this serialized data there too…
And I can’t even say what i expect to see as a solution, all of them seem to be impracticable. It might be:
1) Changing way of writing multiple data in ACF, so i get not serialized data.
2) Enhance export to get unserialized data.
3) Unserialize data in CSV file.
Thank you for help.
Hi, could you please explain how u managed this problem, how should i use this code?
I have a big form full of checkbox fields and after export in excel i get not separated with comma data, but something like this
a:4{i:0;s:6:”value_1″;i:1;s:10:”value_2″;i:2;s:10:”value_3″;i:3;s:10:”value_4″;}
I’d appreciate your help very much!
I know why he needs it to be unserialized. In database it looks like https://yadi.sk/d/8NCF4IaeV2i9c . And when i export it to Excel i get https://yadi.sk/d/2VKnO00DV2jho insted of data separated by commas.
I search for any posiibility to make it right now. I’d appriciate any help!
