It seems 80% or so of people that sign up are not showing up on our exported form. They have email confirmations though so I know they signed up.
PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.
Not getting all of the entries when exporting form as a .csv file
-
Can you view the entries when viewing entries? How many entries? You may be encountering a PHP timeout issue caused by not enough memory or your script timeout setting PHP setting is low and this is causing the export not to finish.
Posted 13 years ago on Wednesday August 18, 2010 | Permalink -
Is your site running any kind of caching plugin? Like W3 Total Cache or any database caching plugin or server caching plugin of any kind? The only instance where we have seen entries being missed is when database caching was implemented. Database caching, if not setup properly, can prevent Gravity Forms from writing live data to the database.
Posted 13 years ago on Thursday August 19, 2010 | Permalink -
You need to set the W3 Total Cache plugin so it doesn't cache Gravity Forms related tables.
By default W3 Total Cache shouldn't cache Gravity Forms related tables. This is in the latest version (0.9.1.1). If you go to the following page:
- Database Cache under the Performance nav item that W3 Total Cache adds
- On this page make sure "wp_rg_" exists under the "Ignored query stems"If it does, then it should be ignoring Gravity Forms requests and not return cached results.
HOWEVER "wp_rg_" is a table name and if your WordPress database table prefix is NOT the default "wp" then this won't work. You need to find out what the table prefix is for your WordPress site and change "wp" to the proper prefix.
For example if your WordPress database is using the prefix bakbek for all of it's tables (ex. bakbek_posts, etc.) then you would need to change that to "bakbek_rg_" and then save the change.
If that doesn't work you may need to contact the W3 Total Cache plugin developer to try and work out the issue.
Posted 13 years ago on Monday August 23, 2010 | Permalink -
Hey...I've got something slightly similar happening with a registration form I created. The database shows that there are 68 entries for this form but when its exported, only 58 come through. The back end of Gravity Forms shows "All (68) | Unread (68) | Starred (0)", on the left, but on the right side the pagination shows "Displaying 1- 20 of 58". What do you think could be going on here? Any help would be greatly appreciated.
Also, my client mentioned that 2 registrants also inquired about their registration and the record could not be found. I've verified that these folks got confirmation emails, but were not stored in the DB. This part is a little concerning.
I do have W3 Total Cache installed and (per the instructions above) verified that "wp_rg_" exists under "Ignored query stems".
The only thing I can think is that I made some changes to this form early on in the "live" registration process and potentially this caused some hiccuping.
Can you provide any clues? Thanks in advance....Ross
Posted 13 years ago on Monday September 13, 2010 | Permalink -
I would suggest testing with W3 Total Cache database caching turned completely off and see if the issue persists. It could be an issue with W3 Total Cache not always ignoring Gravity Forms queries.
Posted 13 years ago on Tuesday September 14, 2010 | Permalink -
Okay...DB caching is disabled. Any idea why the mismatched numbers in the WP back-end "entries" view of this form? Only 58 of the 68 will download. thx in advance.
Posted 13 years ago on Wednesday September 15, 2010 | Permalink -
@rpetersnmt If database caching was interfering with the entries being written it would be because entries were overwriting other entries but still incrementing the count. The count is stored separately so it doesn't have to query all the entries just to get the count.
Posted 13 years ago on Wednesday September 15, 2010 | Permalink
