Support

Home Forums Event Espresso Premium State info not exporting

State info not exporting

Posted: October 9, 2018 at 9:11 am


sarismedia

October 9, 2018 at 9:11 am

Hello –
In .csv export of registrants’ info, street address appears, but not State info. Please advise.
Thank you!
Sandra


Tony

  • Support Staff

October 9, 2018 at 10:19 am

Hi Sandra,

Are you collecting the state on the registration form (not the billing form)?

If you click to edit the contact details of one of the registrations – http://take.ms/bfaRS

Do you see the state field set there?


sarismedia

October 9, 2018 at 6:26 pm

I do see the state info there.


sarismedia

October 10, 2018 at 6:06 am

This reply has been marked as private.


Tony

  • Support Staff

October 10, 2018 at 8:37 am

So then how do I get that info to export?

If you can see it in the contact info then it should already export by default.

In the CSV do you see an empty column or no column at all?

By default, it should look something like this – http://take.ms/MY3ic

Also, is it possible to mass export all registrations, one page per registrant?

One per page in the CSV? We don’t have an option for this, each registration will create a new row in the CSV, but not a new page.

To export all registrations you go to Event Espresso -> Registrations.

At the bottom of the registration list will be an ‘All Registrations CSV’ button, click that to export all registrations across all events.

When you click that button, does it show another page showing X amount of rows written to the CSV repeatedly, or does it just download the CSV straight away?


sarismedia

October 10, 2018 at 8:44 am

This reply has been marked as private.


Tony

  • Support Staff

October 11, 2018 at 4:35 am

Tony -There is NO state info. I have Street Address, but no state.
Although it is listed on individual registrations.

Have you had any customizations done to the output of the CSV at all? The default state field is included in all CSV reports even if its empty the header should always be in the CSV unless it’s been removed.

For example, here is the CSV from a clean site with 0 registrations – http://take.ms/aH1w6

Note the State header is included, if you don’t have the header then there is something changing the fields in the CSV.

However, I believe we have close to 200 registrations, and I cannot download 1×1

To test the above you should be downloading all of the registrations in a single report to confirm the state info doesn’t display for all of them.

Did you follow the steps in the second part of my reply here: https://eventespresso.com/topic/state-info-not-exporting/#post-279688

The reason I ask is the last questions lets me know if your site is set to use the ‘batch’ CSV system or other ‘older’ CSV we have in place.

So to create a registration page for each attendee, I would have to do a mail merge, correct?

Sorry, but I don’t follow what you are trying to do.

What is a registration page in this context?


sarismedia

October 12, 2018 at 4:31 am

This reply has been marked as private.


Tony

  • Support Staff

October 12, 2018 at 5:10 am

Client would like individual registration page for each registrant.

A single excel worksheet for each row of the CSV export doesn’t make any sense, so I’m guessing I’m misunderstanding.

May I ask, why do you need a new page per registration?

RE: downloading CSV, I’m able to do that. But the city, state, zip is NOT appearing.

That doesn’t actually answer my question.

When you download the CSV, do you briefly see this something like this – http://take.ms/4MZvq

Or does the file instantly start downloading?

Now you have 3 columns missing rather than just one?

Has the CSV output been customized by a developer at all?


Josh

  • Support Staff

October 12, 2018 at 5:17 am

Hi,

I checked your site and I can see that the City, State and Zip code fields are actually just text fields and not the standard City, State and Zip code fields from the Address Question group. So when you look in the individual registration record, you’ll see the data from those fields under “Registration Form Answers” and not under “Contact Details”.

What you can do is remove those and any other address fields from the Hospital Registration Question Group, then activate the Address Question Group within the event (check the checkbox next to Address). This way, the built-in Address fields will be activated and the data can be passed to the CSV report as expected.


sarismedia

October 12, 2018 at 5:40 am

This reply has been marked as private.


Josh

  • Support Staff

October 12, 2018 at 5:45 am

I can look into that and get back with you.

May I ask though, why the private replies? Usually a private reply is used for sharing specific information about a site.


sarismedia

October 12, 2018 at 6:07 am

This reply has been marked as private.

The support post ‘State info not exporting’ 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