Support

Home Forums Community Forum CVS export doesn't work

CVS export doesn't work

Posted: September 21, 2016 at 6:16 am


haryia

September 21, 2016 at 6:16 am

In “Event Espresso – Registrations” i try to push “All Registrations CSV Report” but its export only a file with this data:

“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]”,”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]
,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,

and nothing more. Why?


Lorenzo Orlando Caum

  • Support Staff

September 23, 2016 at 9:11 am

Hello,

What version of Event Espresso are you experiencing this issue with?


Lorenzo


haryia

September 26, 2016 at 3:41 am

Hi the version is 4.8.35


Lorenzo Orlando Caum

  • Support Staff

September 26, 2016 at 12:49 pm

Hello again,

Thanks for the feedback on the version number. Are you seeing some text in the web browser window itself rather than it being downloaded as a file?

This could be caused by a conflict with another plugin or it could be a setting on the server.

Does it work as expected when only Event Espresso is activated? If not, then please try the steps below:

If you are able to see the CSV information but it is loading in a webpage, then please try the second solution on this page:

http://www.lasalle.edu/~blum/c341wks/CSVwithHTACCESS.php

If you click on the first button on that page, then you’ll see that it loads in your web browser. If you click on the second, then you’ll see that it downloads. We want your site to download the file. Could you try adding the following line to your htaccess file on your site?

AddType application/octet-stream .csv

The htaccess file can be found in the WordPress root which is the location for the wp-content, wp-admin, wp-includes and other files. You can access it by using an SFTP or FTP client such as FileZilla or Cyberduck.


Lorenzo


haryia

September 30, 2016 at 4:22 am

hi! I try to do that. Now i can’t export any file.
I obtain a white screen with this link in the address bar:

http://staging.eataly.com.br/wp-admin/admin.php?page=espresso_batch&return_url=%2F%2Fstaging.eataly.com.br%2Fwp-admin%2Fadmin.php%3Fpage%3Despresso_registrations&action=default&registrations_report_nonce=661c380a18&batch=file&job_handler=EventEspressoBatchRequest%5CJobHandlers%5CRegistrationsReport&default_nonce=2f17688734&return=registrations_report


Lorenzo Orlando Caum

  • Support Staff

September 30, 2016 at 6:23 am

Alright, go ahead and reverse those recent changes and try the alternative registration CSV system:

https://gist.github.com/lorenzocaum/4d3ac347b07a7c3004e8


Lorenzo


haryia

September 30, 2016 at 9:25 am

try to add a line in wp-config but I obtain again a white screen with this link in the address bar:

http://staging.eataly.com.br/wp-admin/admin.php?page=espresso_batch&return_url=%2F%2Fstaging.eataly.com.br%2Fwp-admin%2Fadmin.php%3Fpage%3Despresso_registrations&action=default&registrations_report_nonce=7ef31a6cc6&batch=file&job_handler=EventEspressoBatchRequest%5CJobHandlers%5CRegistrationsReport&default_nonce=fe0fb696dd&return=registrations_report


Lorenzo Orlando Caum

  • Support Staff

September 30, 2016 at 11:47 am

Hello,

The constant should be added towards the middle of the wp-config.php file rather than at the very end. It deactivates the batch system in favor of the alternative system.

Looking at the URL that you shared, it appears the batch system is still running so double-check the constant that you added to the wp-config.php file.


Lorenzo


haryia

October 4, 2016 at 5:01 am

Hi Lorenzo,
Now the file is inside the wp-config correctly. I try to download again the csv “All Registrations CSV” and i obtain a cvs file, but it is empty

Here the value in the columns
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]”,”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]

here the content..
,,,,,,,,,,,,,,,,

what can I do?


haryia

October 6, 2016 at 1:58 am

Sorry lorenzo, this is a very important issue, so what can I do for solve that? Can i have informations about that?
I want to buy event calendar and other plugins but without this csv feature i cannot continue to use that platform.


Lorenzo Orlando Caum

  • Support Staff

October 6, 2016 at 8:14 am

Hello,

Something else is affecting the generation of the file.

Do you see this issue with only Event Espresso and a default WordPress theme running?


Lorenzo


haryia

October 11, 2016 at 3:46 am

yes
and i try to disable all the plugin but nothing change… 🙁


haryia

October 20, 2016 at 9:13 am

ok now its works, thanks

The support post ‘CVS export doesn't work’ 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