I don’t know if it is related but it seems like the data itself is causing some errors.
If I select the “data” directly from the db, and try to unserialize it, some rows return an error.
SELECT data FROM wp_6_vfb_pro_entries WHERE entries_id = 201
Yet I can select and view the same record in the VFB interface “…wp-admin/admin.php?page=vfb-entries&action=edit&entry=201“
Is the export function more strict than the edit/view function ?
Have you tried the latest update?
i have the same problem. It was fine until a updated to the latest update a few days ago now when i export data (any format)i only get the date and id etc. I dont get any of the date the customer left. Its driving me up the wall lol!!!!!!
I’m also having this issue. I’m trying to get the information people fill into the Form on a CSV or Excel file and simply cannot anymore..
Thanks!
I am also having this issue. Entries exported fine until latest update, now I only get date and IP, no names or emails. HELP!
Thanks!
Hey Matthew,
Is there any chance this will be fixed in a future update?
I really need to grab the info that is gathered from People who fill it out in an excel/CSV file.
Thanks again!
just updated the plugin with the most recent update “Version 2.2.1”
Its still the same, When i export the entries all i get is the following data.
“Entries ID” “Date Submitted” “IP Address” “Subject”
“Sender Name” “Sender Email” “Emailed To”
It doesn’t make a difference if i export the data to .txt or .csv or .xls
Any ideas Matthew???
Thank you
Some hosts that have mod_security installed can prevent certain things from working, especially AJAX (which VFB relies on to load the Entries fields during export).
Here’s a thread that explains how to either disable it completely or whitelist certain admin pages.
You can try to disable completely with the following inserted into your htaccess:
<IfModule mod_security.c>
SecFilterEngine Off
SecFilterScanPOST Off
</IfModule>
Note that this may not work if your host prevents mod_security from being disabled via htaccess. In any case, I’d contact your host and ask for your domain to be whitelisted or for assistance is narrowing down what exactly is causing the block.
From searching around, Hostgator seems to be a big offender with this thing. Not sure about other hosts yet, but feel free to add them here.
Hi Matthew,
I took the code posted above and contacted the support with my host SiteGround. They applied the code for me but there was no change.
When going to export>Entries the Fields section still reads:
Fields: No entries to pull field names from.
Do you have any other suggestions for pulling out the responses from people’s form entries?
and thank you! ( I hit enter and it sent the last message)
You should probably work with your host to narrow down the issue. Like I explained above, that code may not be enough to solve it.
Matthew, I turned back to the SiteGround Host Support Team.
This is what they had to say,
“I’ve carefully investigated the issue, but it seems to be a coding related one, rather than a server-side settings. The reason I believe so is because the data is actually sent by the server to the web page, but it is not processed at all.
What I did to investigate the issue was to enable my FireBug console (a plugin for Firefox, which tracks AJAX requests) and visit the export page. Upon selecting ‘Entries’ and then choosing a form from the drop down menu, the browser makes a request to the WordPress, with visual_form_builder_export_load_options as task variable (which is correct) and it receives the following as result:
Code:
<label for=”vfb-display-entries-val-0″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-0″ type=”checkbox” value=”Entries ID” checked=”checked”> Entries ID</label>
<label for=”vfb-display-entries-val-1″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-1″ type=”checkbox” value=”Date Submitted” checked=”checked”> Date Submitted</label>
<label for=”vfb-display-entries-val-2″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-2″ type=”checkbox” value=”IP Address” checked=”checked”> IP Address</label>
<label for=”vfb-display-entries-val-3″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-3″ type=”checkbox” value=”Subject” checked=”checked”> Subject</label>
<label for=”vfb-display-entries-val-4″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-4″ type=”checkbox” value=”Sender Name” checked=”checked”> Sender Name</label>
<label for=”vfb-display-entries-val-5″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-5″ type=”checkbox” value=”Sender Email” checked=”checked”> Sender Email</label>
<label for=”vfb-display-entries-val-6″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-6″ type=”checkbox” value=”Emailed To” checked=”checked”> Emailed To</label>
<label for=”vfb-display-entries-val-7″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-7″ type=”checkbox” value=”Who will win tonight?” > Who will win tonight?</label>
<label for=”vfb-display-entries-val-8″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-8″ type=”checkbox” value=”Your Name” > Your Name</label>
<label for=”vfb-display-entries-val-9″><input name=”entries_columns[]” class=”vfb-display-entries-vals” id=”vfb-display-entries-val-9″ type=”checkbox” value=”Email” > Email</label>
The above code seems to be the exact HTML required by the form but for some reason the JavaScript is not updating the appropriate area of the HTML element. Perhaps there is a missing handler for the success result of the AJAX query. I would recommend you to get in touch with the plugin developers and ask them for further information what might be causing this — it certainly is not the mod_Security installed on the server (because it does reply to the request).
Best Regards,
Val M.
Senior Supervisor,
Technical Support Team”
Is there anyway we can just get back the old way to export all the selections from the entries page? Can I downgrade versions and keep all of my forms and entries?
Thank you.
Good to know it’s not mod_security on your end.
The above code seems to be the exact HTML required by the form but for some reason the JavaScript is not updating the appropriate area of the HTML element. Perhaps there is a missing handler for the success result of the AJAX query.
This statement would lead you to believe that it doesn’t function at all, which isn’t true. I’m running it on several sites right now and it works fine. You can see if there’s a jQuery conflict with another plugin installed.
As an aside, I may have found a couple of things to improve on the accuracy of loading the fields and will address that when the plugin is updated.
