Support

Home Forums Event Espresso Premium Filtered CSV Report exports State Name instead of State ID

Filtered CSV Report exports State Name instead of State ID

Posted: March 21, 2022 at 3:42 pm


shoreshdavid

March 21, 2022 at 3:42 pm

Hello,

For one of our events we’re printing badges that will display each Attendee’s city and state. However, the exported CSV shows the full State Name instead of two letter State ID.

I have gone through every setting screen that I could think of, and searched the forum. Perhaps I’ve missed something? Is there a way to change this so that the “State” field in all filtered CSV Reports always use the State ID instead?

Kind Regards,
Chris


Tony

  • Support Staff

March 22, 2022 at 6:59 am

Hi Chris,

The Registration report uses the full state name as we found that’s what most people requested. It is possible to change it using a snippet and we have an example of doing so here:

https://github.com/eventespresso/ee-code-snippet-library/blob/master/admin/registration-reports/core/jf_ee_csv_report_change_state_to_abbreviation.php

You can add that to a custom functions plugin on your site, we have some documentation on creating one here:

https://eventespresso.com/wiki/create-site-specific-plugin-wordpress-site/


shoreshdavid

March 22, 2022 at 5:37 pm

Hi Tony,

Using two letter abbreviations for states is what’s typically done in the continental USA. It would be nice if there was a toggle somewhere in the admin. Our functions.php file has quite a few EE code snippets.

Thank you! πŸ™‚ I can confirm that this has been resolved.

Kind Regards,
Chris


Tony

  • Support Staff

March 23, 2022 at 5:43 am

We’ve discussed having various options within the admin, but the problem is we have so many different features with so many different ‘wants’ for each feature that if we start down that path we will very quickly end up with a ‘wall of options’.

EE3 had this to a degree and it causes more confusion than it solves in the long run.

We aim for smart default and have the option to change various options/outputs/etc with a snippet, that way the users that need to make a change have the option to without a bunch of options for those that don’t.

I’d recommend using a custom functions plugin over your theme’s functions.php, simply because if you change themes you end up losing the custom functionality you’ve added, but, I’m arguing semantics here πŸ™‚


shoreshdavid

April 6, 2022 at 4:00 pm

Understandable. Thank you, Tony. This ticket can be marked “Resolved”.


Tony

  • Support Staff

April 7, 2022 at 9:34 am

You’re most welcome, I’ll mark this resolved (which also closes the ticket).

Any further questions/issues please feel free to open another πŸ™‚

The support post ‘Filtered CSV Report exports State Name instead of State ID’ 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