Support

Home Forums Event Espresso Premium All Registrations Download

All Registrations Download

Posted: December 21, 2015 at 10:10 pm


b2995

December 21, 2015 at 10:10 pm

I’m trying to download a specific category of 1900 records but the reporting just keeps repeating… “Wrote 912 rows to report CSV file…” and I’m on 70,000.

Am I doing something wrong? Does the report download ALL records or just the category I’m in?


Josh

  • Support Staff

December 22, 2015 at 8:36 am

Hi there,

It turns out the report downloads all records, the filters for categories and statuses only apply to the list table display in the WordPress admin.

In addition to the all attendees report, you can also download a report for one specific event at a time. So for example, if you are looking at the registrations for one event, or the checkins for one event, there’s a button at the bottom of the table that says Event Registrations CSV Report, which will generate a report of registrations for that one event.


b2995

December 29, 2015 at 3:09 pm

Hey Guys!

It still won’t let me download ALL, and when I download EVENT REG CSV, it’s only downloading the header row.


Lorenzo Orlando Caum

  • Support Staff

December 29, 2015 at 5:43 pm

Hi, that isn’t expected. Could you ensure that you are on the latest version of Event Espresso 4?

https://eventespresso.com/wiki/ee4-changelog/

If it still fails, then please try adding this in your .htaccess file and saving changes:

AddType application/ms-excel .csv

The htaccess file is usually in the WordPress root and can be found by logging into your site using an SFTP or FTP client like FileZilla or Cyberduck. The login information would be available from your web host.

If that still does not help, then their may be another plugin interfering. Try temporarily deactivating other plugins and then re-testing.

Do let us know if one of these steps works for you.


Lorenzo


b2995

December 29, 2015 at 8:22 pm

I’m in version 4.8.27.p. Which .htaccess folder do I use? The main account folder or account/site.com? Here’s what I tried in each…

account/.htaccess

# Use PHP5.4 as default
AddHandler application/x-httpd-php54 .php
AddType application/ms-excel .csv

account/site.com/.htacess:

# BEGIN W3TC Browser Cache
<IfModule mod_deflate.c>
    <IfModule mod_headers.c>
        Header append Vary User-Agent env=!dont-vary
    </IfModule>
        AddOutputFilterByType DEFLATE text/css text/x-component application/x-javascript application/javascript text/javascript text/x-js text/html text/richtext image/svg+xml text/plain text/xsd text/xsl text/xml image/x-icon application/json
        # DEFLATE by extension
        AddOutputFilter DEFLATE js css htm html xml
    </IfModule>
</IfModule>
# END W3TC Browser Cache
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress
AddType application/ms-excel .csv


b2995

December 29, 2015 at 8:23 pm

Neither worked…


b2995

December 29, 2015 at 8:35 pm

Found it! I previously downloaded the temp fix…Site Specific Plugin for EE Export functions. I disabled it and it’s working now.

Resolved! ๐Ÿ˜‰


Tony

  • Support Staff

December 30, 2015 at 3:55 am

Hi there,

I’m glad you have this working, just to confirm, was that plugin this one?

https://gist.github.com/Pebblo/976ed35816bd3b9a6d03

Also in terms of which .htaccess file you should use, it usually depends on the rule you are applying and how specific you want that to be.

The changes within account/.htaccess apply to ALL of the sites within your account.

account/site.com/.htacess applies only to that specific site.

In this case AddType application/ms-excel .csv basically tells yours browser to treat a .CSV as a file to download rather than just opening it within the browser so it should not have any negative effects on other sites but the above is just something to be aware of.


b2995

December 30, 2015 at 10:07 am

Hey Tony! Yes, I guess that was the temporary fix at the time. I disabled it and it now works like a charm ๐Ÿ˜‰


Lorenzo Orlando Caum

  • Support Staff

December 30, 2015 at 11:19 am

Hello, I’m glad to hear this is working again. I’ll update your support post to resolved.


Lorenzo

The support post ‘All Registrations Download’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso