Export data from ZOO
8 years 4 months ago #4188
by Markus
Export data from ZOO was created by Markus
Hello
In ZOO from Yootheme, there are many fields stored in the table #_zoo_item in row "elements" as JSON.
like:
is there an easy way to export this Code in a proper CSV Columne style? So each of this "Values" are one column.
I saw a preset export profile named "Zoo items export", but this profile gives only a raw text export of the field "elements"
Unfortunately, I have no great experience in SQL Querys and things like that
thanks for help
Markus
In ZOO from Yootheme, there are many fields stored in the table #_zoo_item in row "elements" as JSON.
like:
Warning: Spoiler!
"96b4799a-ce29-4f8e-acfb-7b40efea2ee6": {
"0": {
"value": "street"
}
},
"ea0666d7-51e3-4e52-8617-25e3ad61f8b8": {
"0": {
"value": "phone xxxx"
}
},
"205d442b-a962-473b-a651-ee0ce8a3b5a3": {
"0": {
"value": "some other text field"
}
},
"0": {
"value": "street"
}
},
"ea0666d7-51e3-4e52-8617-25e3ad61f8b8": {
"0": {
"value": "phone xxxx"
}
},
"205d442b-a962-473b-a651-ee0ce8a3b5a3": {
"0": {
"value": "some other text field"
}
},
is there an easy way to export this Code in a proper CSV Columne style? So each of this "Values" are one column.
I saw a preset export profile named "Zoo items export", but this profile gives only a raw text export of the field "elements"
Unfortunately, I have no great experience in SQL Querys and things like that

thanks for help
Markus
Please Log in to join the conversation.
8 years 4 months ago #4189
by Daniel
Thanks
Daniel
Replied by Daniel on topic Export data from ZOO
Hello,
You can apply PHP functions on that column with vData @vdPhp feature. However these values won't come up in different columns. But we can customize the tool to make it work as per your requirements. Please contact our Sales team via Contact us -> Request a Quote form, We'll look into it.
You can apply PHP functions on that column with vData @vdPhp feature. However these values won't come up in different columns. But we can customize the tool to make it work as per your requirements. Please contact our Sales team via Contact us -> Request a Quote form, We'll look into it.
Thanks
Daniel
Please Log in to join the conversation.