Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Cannot create a list of countries in a dropdown

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 3 weeks ago #196046 by Joffm

Only "Åland Islands" is after the last country "Zimbabwe"

Well, that depends on the used character set and sort algorithm.

But be creative.
Enter the countries manually.

Because all these *.lsx files are *.xml files I renamend the label set to "list_of_countries_iso3166-1_alpha2.xml".
Opened it in EXCEL, extracted the two columns I needed (Code & name)
and concatinated to "Code;Name"
Copied and pasted this column into the "Quick add" of LS.

And now (without internal sorting) "Åland Islands" is the second, and everything is even better.

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • ymca
  • ymca's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
4 years 3 weeks ago #196398 by ymca

Joffm wrote:

Only "Åland Islands" is after the last country "Zimbabwe"

Well, that depends on the used character set and sort algorithm.

But be creative.
Enter the countries manually.

Because all these *.lsx files are *.xml files I renamend the label set to "list_of_countries_iso3166-1_alpha2.xml".
Opened it in EXCEL, extracted the two columns I needed (Code & name)
and concatinated to "Code;Name"
Copied and pasted this column into the "Quick add" of LS.

That is exactly what I did the first time I've seen the problem.
My friend helped me with the Excel file and sorted it there.
I then copied it to the "quick add" and the first question list was fine, but not the other question lists.
I have tried it now again to be sure it's not because of my overloaded tab browser, but "Åland Islands" is still the last country.
I'm glad it's working for you.
Here's my list:
Code:
AF;Afghanistan
AX;Åland Islands
AL;Albania
DZ;Algeria
AS;American Samoa
AD;Andorra
AO;Angola
AI;Anguilla
AQ;Antarctica
AG;Antigua and Barbuda
AR;Argentina
AM;Armenia
AW;Aruba
AU;Australia
AT;Austria
AZ;Azerbaijan
BS;Bahamas
BH;Bahrain
BD;Bangladesh
BB;Barbados
BY;Belarus
BE;Belgium
BZ;Belize
BJ;Benin
BM;Bermuda
BT;Bhutan
BO;Bolivia (Plurinational State of)
BQ;Bonaire, Sint Eustatius and Saba
BA;Bosnia and Herzegovina
BW;Botswana
BV;Bouvet Island
BR;Brazil
IO;British Indian Ocean Territory
BN;Brunei Darussalam
BG;Bulgaria
BF;Burkina Faso
BI;Burundi
CV;Cabo Verde
KH;Cambodia
CM;Cameroon
CA;Canada
KY;Cayman Islands
CF;Central African Republic
TD;Chad
CL;Chile
CN;China
CX;Christmas Island
CC;Cocos (Keeling) Islands
CO;Colombia
KM;Comoros
CG;Congo
CD;Congo (Democratic Republic of the)
CK;Cook Islands
CR;Costa Rica
CI;Côte d'Ivoire
HR;Croatia
CU;Cuba
CW;Curaçao
CY;Cyprus
CZ;Czech Republic
DK;Denmark
DJ;Djibouti
DM;Dominica
DO;Dominican Republic
EC;Ecuador
EG;Egypt
SV;El Salvador
GQ;Equatorial Guinea
ER;Eritrea
EE;Estonia
ET;Ethiopia
FK;Falkland Islands (Malvinas)
FO;Faroe Islands
FJ;Fiji
FI;Finland
FR;France
GF;French Guiana
PF;French Polynesia
TF;French Southern Territories
GA;Gabon
GM;Gambia
GE;Georgia
DE;Germany
GH;Ghana
GI;Gibraltar
GR;Greece
GL;Greenland
GD;Grenada
GP;Guadeloupe
GU;Guam
GT;Guatemala
GG;Guernsey
GN;Guinea
GW;Guinea-Bissau
GY;Guyana
HT;Haiti
HM;Heard Island and McDonald Islands
VA;Holy See
HN;Honduras
HK;Hong Kong
HU;Hungary
IS;Iceland
IN;India
ID;Indonesia
IR;Iran (Islamic Republic of)
IQ;Iraq
IE;Ireland
IM;Isle of Man
IL;Israel
IT;Italy
JM;Jamaica
JP;Japan
JE;Jersey
JO;Jordan
KZ;Kazakhstan
KE;Kenya
KI;Kiribati
KP;Korea (Democratic People's Republic of)
KR;Korea (Republic of)
KW;Kuwait
KG;Kyrgyzstan
LA;Lao People's Democratic Republic
LV;Latvia
LB;Lebanon
LS;Lesotho
LR;Liberia
LY;Libya
LI;Liechtenstein
LT;Lithuania
LU;Luxembourg
MO;Macao
MK;Macedonia (the former Yugoslav Republic of)
MG;Madagascar
MW;Malawi
MY;Malaysia
MV;Maldives
ML;Mali
MT;Malta
MH;Marshall Islands
MQ;Martinique
MR;Mauritania
MU;Mauritius
YT;Mayotte
MX;Mexico
FM;Micronesia (Federated States of)
MD;Moldova (Republic of)
MC;Monaco
MN;Mongolia
ME;Montenegro
MS;Montserrat
MA;Morocco
MZ;Mozambique
MM;Myanmar
NA;Namibia
NR;Nauru
NP;Nepal
NL;Netherlands
NC;New Caledonia
NZ;New Zealand
NI;Nicaragua
NE;Niger
NG;Nigeria
NU;Niue
NF;Norfolk Island
MP;Northern Mariana Islands
NO;Norway
OM;Oman
PK;Pakistan
PW;Palau
PS;Palestinian Authority
PA;Panama
PG;Papua New Guinea
PY;Paraguay
PE;Peru
PH;Philippines
PN;Pitcairn
PL;Poland
PT;Portugal
PR;Puerto Rico
QA;Qatar
RE;Réunion
RO;Romania
RU;Russian Federation
RW;Rwanda
BL;Saint Barthélemy
SH;Saint Helena, Ascension and Tristan da Cunha
KN;Saint Kitts and Nevis
LC;Saint Lucia
MF;Saint Martin (French part)
PM;Saint Pierre and Miquelon
VC;Saint Vincent and the Grenadines
WS;Samoa
SM;San Marino
ST;Sao Tome and Principe
SA;Saudi Arabia
SN;Senegal
RS;Serbia
SC;Seychelles
SL;Sierra Leone
SG;Singapore
SX;Sint Maarten (Dutch part)
SK;Slovakia
SI;Slovenia
SB;Solomon Islands
SO;Somalia
ZA;South Africa
GS;South Georgia and the South Sandwich Islands
SS;South Sudan
ES;Spain
LK;Sri Lanka
SD;Sudan
SR;Suriname
SJ;Svalbard and Jan Mayen
SZ;Swaziland
SE;Sweden
CH;Switzerland
SY;Syrian Arab Republic
TW;Taiwan, Province of China
TJ;Tajikistan
TZ;Tanzania, United Republic of
TH;Thailand
TL;Timor-Leste
TG;Togo
TK;Tokelau
TO;Tonga
TT;Trinidad and Tobago
TN;Tunisia
TR;Turkey
TM;Turkmenistan
TC;Turks and Caicos Islands
TV;Tuvalu
UG;Uganda
UA;Ukraine
AE;United Arab Emirates
GB;United Kingdom of Great Britain and Northern Ireland
UM;United States Minor Outlying Islands
US;United States of America
UY;Uruguay
UZ;Uzbekistan
VU;Vanuatu
VE;Venezuela (Bolivarian Republic of)
VN;Viet Nam
VG;Virgin Islands (British)
VI;Virgin Islands (U.S.)
WF;Wallis and Futuna
EH;Western Sahara
YE;Yemen
ZM;Zambia
ZW;Zimbabwe

LS Version 4.2+
The topic has been locked.
  • ymca
  • ymca's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
4 years 3 weeks ago #196413 by ymca
I gave up and changed it from "Åland Islands" to "Aland Islands".

LS Version 4.2+
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose