CFDB saves its data in the table wp_cf7dbplugin_submits. You would have to import that table data into your new site.
Hi Michael,
I was looking at the table you just mentioned and i find Something like this in submit_time column:
1445051264.8993
1445052761.7050
What format is this?
How do I convert to a dd/mm/yyyy format?
As always, thank you very mucho for your assistance!!!
It is Unix time (seconds since 1970)
Thank you very much Michael.
Since we can customize our fields, every row is related to that “field”
Do you have any suggest to query this info as a single row?
I’m trying using PIVOT option, but it’s not workin’
Thanks in advance!!!
There is an option in the CFDB Options page to display the query on the admin page where you view the data. It will show the pivot query it uses on that page.
Thank you Michael,
I’ve checked the option you just mentioned, and it was working fine for a while, but now, it doesn’t shows the query.
It is related with the fact that we’ve updated to Version 2.10.25????
Tanks you very much!!!
Nothing should have changed with that in the latest version. It works for me.
