Support

Home Forums Event Espresso Premium Downloading CSV Reports

Downloading CSV Reports

Posted: February 11, 2018 at 6:16 pm


boarddirection

February 11, 2018 at 6:16 pm

I am having issues downloading Registration CSV reports. The CSV file keeps getting saved as a temporary batch file in /wp-content/uploads/espresso/ instead of to my hard drive.

I have looked through the posts and thought is was an issue with Chrome, but I have also tried safari and microsoft edge. Exactly the same issue each time.


Tony

  • Support Staff

February 12, 2018 at 4:22 am

Hi there,

The CSV file keeps getting saved as a temporary batch file in /wp-content/uploads/espresso/ instead of to my hard drive.

It is expected that EE writes to the batch file until the registration export is ready, it EE should then trigger a download and remove the above file. What format is the filename in the above? Random characters?

Do you have a large number of registrations on your events?


boarddirection

February 12, 2018 at 4:45 pm

Hi Tony

After the batch file is process it is saving it to this pathway as a .csv. file: https://boardappointments.co.uk/wp-content/uploads/espresso/batch_temp_folder/bCiwgjzLe1EwgAJ/event-espresso-registrations-2018-02-12%2023-39-05.csv

It then opens up in my browser with 2 file extension .csv.html. The .csv file is not being downloaded to my hard drive. It just displays as html eg:

Event,”Transaction ID[TXN_ID]”,”Attendee ID[ATT_ID]”,”Registration ID[REG_ID]”,”Time registration occurred[REG_date]”,”Unique Code for this registration[REG_code]”,”Count of this registration in the group registration [REG_count]”,”Registration’s share of the transaction total[REG_final_price]”,Currency,”Registration Status”,”Transaction Status”,”Transaction Amount Due”,”Amount Paid”,”Payment Date(s)”,”Payment Method(s)”,”Gateway Transaction ID(s)”,Check-Ins,”Ticket Name”,”Datetimes of Ticket”,”First Name[ATT_fname]”,”Last Name[ATT_lname]”,”Email Address[ATT_email]”,”Address Part 1[ATT_address]”,”Address Part 2[ATT_address2]”,City[ATT_city],State[STA_ID],Country[CNT_ISO],”ZIP/Postal Code[ATT_zip]”,Phone[ATT_phone] “Board Search Breakfast – London – Discount (27369)”,46,27434,48,”2018-02-12 09:58:00″,46-8-1-84c5,”1 of 1″,29.00,GBP,Approved,Complete,29.00,29.00,”2018-02-12 10:00:21″,Stripe,ch_1Bue6kFCqj1pXGTv2U3nbaH9,0,”Discounted Ticket (Limited Number Available) – February 15″,”2018-02-15 08:00:00″,Chris,Woodward,chrisw@grosvenortrustcorp.co.uk,,,,,,,02033725369 “Board Search Breakfast – London – Discount (27369)”,44,27428,46,”2018-02-10 13:48:00″,44-8-1-b767,”1 of 1″,29.00,GBP,Approved,Complete,29.00,29.00,”2018-02-10 13:52:46″,Stripe,ch_1BtymaFCqj1pXGTvQ1xA2JEb,0,”Discounted Ticket (Limited Number Available) – February 15″,”2018-02-15 08:00:00″,Graeme,Daniel,graemedaniel1@gmail.com,,,,,,,”07887 648535″ “Board Search Breakfast – London – Discount (27369)”,43,27400,45,”2018-02-09 12:29:00″,43-8-1-96b8,”1 of

I have checked by browser setting and tried in Chrome, Safari & Edge…. all to the same thing.


Tony

  • Support Staff

February 13, 2018 at 7:28 am

Hmm ok, it sounds like your server is sending an incorrect MIME type for the CSV so you browsers are just opening the file.

Are you comfortable using FTP? If so can you add this line to your wp-config.php file:

define('EE_USE_OLD_CSV_REPORT_CLASS', true);

Somewhere above where it has /* That's all, stop editing! Happy blogging. */

Then retest an export, does the same happen then?

The support post ‘Downloading CSV Reports’ 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