- This topic has 2 replies, 2 voices, and was last updated 6 years, 9 months ago by .
Viewing 3 posts - 1 through 3 (of 3 total)
Viewing 3 posts - 1 through 3 (of 3 total)
- The forum ‘Generic’ is closed to new topics and replies.
Events Made Easy › Forums › Generic › 2.0.19 – countries not shown / exported
Hi Franky,
i like the new feature “Use and enfore a list of states/countries for RSVP and people/members” and maybe that’s not a bug, but since update to 2.0.19, countries will not be exported, the field is empty!
I know, i have to generate a list of countries i want to provide in our registration form. I filled all the countries i need into the list and left the localiosation-code empty as suggested.
Most of our attendes used correct (alpha-2) country codes like AT, DE, CH (as i used in my list) on registering to an event, but the country field is still empty on export.
If i edit a person and set the country from the list, the field will be filled. A look into the database shows the full country name. Is there a way – other then messing around with the database – to get the correct values into the field?
Rgds,
Werner
Is this about older registrations (from before this version) or new ones (with the correct state/country choices)?
Because the new one is not compatible with the old data in that regard. What you could do is (unfortunately), go in the database and copy from the (for now still existing) column country to the new column country_code (and idem for state).
In mysql (an example):
update wp_eme_people set country_code=country
update wp_eme_people set state_code=state
I updated all person data with “old” country-data manually in the database. Now all country data is shown and exported correct again.