Posted: 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 http://staging.eventespresso.com/topic/ee4-venue-country-only-us-and-canada/ Thanks for your help! | |
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. | |
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. | |
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 — | |
The support post ‘Adding All Countries in Dropdown List’ 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.