Export data from ZOO
- Daniel
-
- Offline
- Administrator
-
26 Apr 2017 15:20 #4189
Thanks
Daniel
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.
Thanks
Daniel
Please Log in or Create an account to join the conversation.
- Markus
-
Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
26 Apr 2017 15:04 #4188
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
Hello
In ZOO from Yootheme, there are many fields stored in the table #_zoo_item in row "elements" as JSON.
like:
Warning: Spoiler!
[ Click to expand ]
[ Click to hide ]
"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 or Create an account to join the conversation.