Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-sales domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the better-click-to-tweet domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-amazon domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-stats domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114
Adding All Countries in Dropdown List | Event Espresso - Staging Server

Support

Home › Forums › Event Espresso Premium › Adding All Countries in Dropdown List

Adding All Countries in Dropdown List

Posted: April 18, 2014 at 4:16 am

Viewing 2 reply threads


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 http://staging.eventespresso.com/topic/ee4-venue-country-only-us-and-canada/
but that will take forever.

Thanks for your help!


Dean

  • Support Staff

    •

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

  • Support Staff

    •

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
Viewing 2 reply threads

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.

The original Forum description...

Status: closed

Updated by Lorenzo Orlando Caum 10 years, 9 months ago ago

Topic Tags

Tagged: , ,

Notifications

This topic is: not resolved
Event Espresso - Staging Server