|
buooy
|
April 18, 2014 at 4:16 am
Hi there,
Is there a way i can add all countries to appear in the dropdown list in the forms? I understand how to do it one by one as explained here https://eventespresso.com/topic/ee4-venue-country-only-us-and-canada/
but that will take forever.
Thanks for your help!
|
|
Dean
|
April 18, 2014 at 5:20 am
Hi,
Right now there isn’t a list or an import way to do this. We purposefully left this as a limited selection as the vast majority of our user base tends to focus on events in 1 or only a few countries.
As such the only way would be manually or *maybe* by an SQL import into the database.
|
|
Stephen
|
April 18, 2014 at 5:53 am
We do events in around 10 countries, but the participants might come from all over the world. There should be full list of all countries in the dropdown when someone signs up for an event. The event country and the attendees nationality should not be treated as the same thing.
|
|
Lorenzo Orlando Caum
|
April 18, 2014 at 12:22 pm
Hello,
There are two options to change this. You can update the countries manually.
Alternatively, you could run a SQL query through a tool like phpmyadmin. You should only try this if you are experienced with working with the database.
Begin by performing a full WordPress backup.
Then login to your database through phpmyadmin or equivalent.
The following SQL query will enable all countries in the dropdown list:
https://gist.github.com/lorenzocaum/8293c68d5d1bc3bb6403
Be sure to update dbprefix to your actual database prefix and update the name of the database.
For example, if my database prefix was “wp” and the database name was “happy” — the the final sql query would look like this:
https://gist.github.com/lorenzocaum/bbff299517e5581b31ee
Again, be sure to backup your WordPress before attempting this query.
Other notes:
Event Espresso currently has states/provinces for USA & Canada. Attendees/registrants can add new ones using this option:
http://cl.ly/image/0m071o1a3s16
—
Lorenzo
|
