|
bhhsflpg
|
December 5, 2024 at 10:35 am
Hi, we recently created a new event that has a set of custom questions applied. That data is not being included in the registrations export in its entirety. Only one of the question’s answers is included.
Is there a way to correct that? We’d be fine if all question answers were included on exports as a default.
Sidenote – not a developer, so hoping there’s an easy option here.
|
|
Garth
|
December 5, 2024 at 12:13 pm
Hi there,
Verify Question Group Settings
Custom questions need to be assigned to a question group that is applied to the event:
1. Go to Event Espresso > Registration Form > Question Groups.
2. Confirm that all the necessary custom questions are part of the applied question group for your event.
3. Check that the group is assigned under Event (edit the event) > Registration Options (metabox) > Questions for Primary Registrant/Additional Registrants (metabox).
Docs: https://support.eventespresso.com/article/547-questions-ver-3-registration-form-ver-4
Are the registrations answers included in the individual’s registration record? Find a registration for that event, click the Clipboard icon to see the registration record, scroll to the bottom section with Custom Questions. Do you see the attendee’s answers to the custom questions?
Lastly, I’m curious your process (which clicks) you use to get the csv file downloaded. Which page or list table are you using to get the csv report? Do you go to Events > click the Registrations link under the event name, then scroll to the bottom and click CSV REport?
Let me know what you find.
|
|
bhhsflpg
|
December 5, 2024 at 12:34 pm
Have tried responding twice and looks like it’s not posting. Going to reply in sections to see if I can figure out why it’s not posting properly.
|
|
bhhsflpg
|
December 5, 2024 at 12:35 pm
This reply has been marked as private.
|
|
bhhsflpg
|
December 5, 2024 at 12:36 pm
This reply has been marked as private.
|
|
bhhsflpg
|
December 5, 2024 at 12:38 pm
This reply has been marked as private.
|
|
Garth
|
December 5, 2024 at 1:08 pm
It looks like you’re using the old editor. Would you mind trying the new editor? https://support.eventespresso.com/article/595-advanced-editor
|
|
bhhsflpg
|
December 5, 2024 at 1:36 pm
I switched to the new editor. The results on the export file have not changed. Just tried a new export after that switch.
|
|
Tony
|
December 6, 2024 at 5:28 am
Hi there,
What you have in the screenshots should be showing the registration questions in the CSV.
Is there a way to correct that? We’d be fine if all question answers were included on exports as a default.
This is indeed the default behaviour, all custom questions assigned to an event should already be included within the CSV for that event by default.
However, the output for CSV’s is filtered so I’m wondering if we’ve ever worked through customizing the CSV previously for you and now the fields that code allows through aren’t what you need.
In your plugin list do you have an ‘Custom functions plugin’ or similar listed?
|
|
bhhsflpg
|
December 9, 2024 at 7:16 am
This reply has been marked as private.
|
|
Tony
|
December 9, 2024 at 9:30 am
Hmmm, so the styles.css, if css, that doesn’t change anything within the CSV.
No functions.php in the child theme?
The custom functions plugin has one function hooking into FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array, that does change the CSV, but wont be causing this (it only adds a single column and returns, that’s fine).
Thats working as I can see your Registraion URL link[REG_url_link] column in the export.
—
Actually, I think I see the problem.
The registration report uses the ‘Question Label (admin-only)’ to add the registration question to the report, many of your questions (especially those assigned to that event) have that field empty.
Short answer to fixing this…
Edit the questions and set unique ‘Question Label (admin-only)’ values for each question (You can use the same value as ‘Question Text’ for each one).
—
Long answer:
Having an empty ‘Question Label (admin-only)’ means have multiple questions formatted something like this:
{Column Label} => {Column Value}
[
'' = > 'Answer 1',
'' = > 'Answer 2',
'' = > 'Answer 3',
]
The CSV function comes along and loops through each of those, adding them into the array, but because ‘Column Label’ is empty it can’t make unique columns and the loop goes over each row adding the value into the same ’empty’ column name. So the only answer from above that shows up is ‘Answer 3’ as it keeps overwriting itself until it got to the last answer.
The clue for this is column AC, the column title is empty so EVERY question that has an empty ‘Question Label (admin-only)’ overwrite the value until its the last question.
|
|
bhhsflpg
|
December 9, 2024 at 10:00 am
So I just tried to add, them and the values I’m adding aren’t saved. I was initially using hypens and/or unscores so tried saving with only letter characters with no spaces and it still doesn’t save?
|
|
Tony
|
December 9, 2024 at 10:14 am
:S Odd!
Can I take a look, please?
I’ll need WP-Admin creds and (if you have them) FTP credentials which you can send over using this form:
https://eventespresso.com/send-login-details/
|
|
bhhsflpg
|
December 9, 2024 at 11:10 am
Form completed! ty!
|
|
Tony
|
December 9, 2024 at 4:59 pm
Ok, try setting the ‘Question Label (admin-only)’ fields now.
Note if you edit a question and hit save with a blank ‘Question Label (admin-only)’ field it will dynamically create one from the ‘Question Text’ field.
Set your Question Label (admin-only) fields on your questions and then run a CSV export to see if all the questions now show.
|
