Support

Home Forums Event Espresso Premium CSV Export not including all data

CSV Export not including all data

Posted: October 9, 2023 at 1:56 pm


Vaswcd_Admin

October 9, 2023 at 1:56 pm

When downloading registration data the report is missing an entire question for all registrants. The question is being answered during registration but the report is not including that question.


Rio

  • Support Staff

October 9, 2023 at 6:44 pm

I’m having hard time accessing your site. Your site can’t be reached and took too long to respond. Can you check with your hosting with regards to this.

please tell me also your site WP version, EE plugin version, php and mysql. https://monosnap.com/file/ZGfvGbyq05p9BfrlelcBgWVmFE8UFU

thanks


Vaswcd_Admin

October 10, 2023 at 6:43 am

Not sure what was happening with the site being slow. Here is the link to confirm https://vaswcd.org/.

WordPress Version: 5.8.7

PHP Version: 7.4.33

MySQL Version: 10.3.39

Event Espresso Version: 5.0.10.p

WordPress Address (URL): https://vaswcd.org

Site address (URL): https://vaswcd.org


Tony

  • Support Staff

October 10, 2023 at 9:05 am

Hi there,

When EE generates the CSV report it uses the ‘Question Label (admin-only)’ value for the headers.

We had a report recently from a user using the same value for multiple questions (in fact, all of the questions in a group) which meant that when EE looped over the questions to add them into the CSV it was just overwriting the last question with the next.

Something like this:

foreach($questions as $question) {
    $csv_data[$question->admin_label] = $question->answer;
}

This means if more than 1 question has the same label you will only see the ‘last’ question to process in the CSV.

If you look at the missing question and check the Questin label value, is that header already set in the CSV with the answer for another question? If so edit the ‘missing’ question and change the question label value to something unique to the question and it should show up.


Vaswcd_Admin

October 10, 2023 at 10:26 am

Thank you! That worked


Tony

  • Support Staff

October 10, 2023 at 3:11 pm

Awesome, I’m glad that fixed it 🙂

The support post ‘CSV Export not including all data’ 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