Cannot create a list of countries in a dropdown

More
2 months 5 days ago #196028 by ymca
Wow this is so strange.
I don't know if it's a problem with the php.ini max var settings or Limesurvey or both.
I was trying to make a question with a dropdown of 249 countries.
At the begining I made it with "Multiple choice type:M" but I changed it to "Single choice questions=>list dropdown type:i".

Then I saw the countries were not in order of a-z so I tried to change it.
Then I saw it saved a small portion of the first countries.
I've tried to work around it and first save the countries, save, and then write the question.
Well... The countries answer list was saved just fine but the answer was blank.
it seems that no matter what I do, it will not make all things save together.
Or there will be no order to the answer
Or there will be ordered answer but no question
Or there will be order but small portion of the answers and a question.
:ohmy: :unsure: :pinch:

Please Log in to join the conversation.

LimeSurvey Partners
More
2 months 5 days ago #196031 by holch
Which LS Version?
Do you have the list for us to test?

If you could do it the first time, then max vars can't be the problem.

You probably did not delete everything necessary or not substitute correctly, but rather added the new list at the end of the old list.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
2 months 5 days ago #196032 by Joffm

At the begining I made it with "Multiple choice type:M" but I changed it to "Single choice questions=>list dropdown type:i".

What did you "make"?

Then I saw the countries were not in order of a-z so I tried to change it.

Well, you have the labelset of countries.
So, import it in "Manage Label Sets"
Create your question and add it with "Predefined label sets"
And you see the answers are in alphabetical order of country name.

even if the code is not.

And you see, everything is fine.


This was shown in version 4.1.11.

And as I said before, I will not answer anymore, if you keep asking like "I tried, but it doesn't work" without showing us what you tried by attaching your lss export or at least show some screenshots.
And as usual you did not mention your LS version.

Joffm


Volunteers are not paid.
Not because they are worthless, but because they are priceless
Attachments:

Please Log in to join the conversation.

More
2 months 5 days ago - 2 months 5 days ago #196034 by ymca
Version 4.1.12+200324

ohh also here I have problems.
Couldn't upload the "countries list.lsl" file, so renamed it to "countries list.lsl.lsq".

I have tried many things.
Now did it again:
I have a testing survey "multiple 3 level.lss"
Made the question in this group "testing countries.lsg".
Imported my label set that I had "countries list" and it saved OK and fast (usually it's slow)
Watched the group preview and saw the list was in a random order
Attachments:
Last edit: 2 months 5 days ago by ymca.

Please Log in to join the conversation.

More
2 months 5 days ago - 2 months 5 days ago #196035 by holch

I have tried many things.

Well, to fix it you need to do many other things... ;-)

As Joffm, help us to help you by providing information. If you go to your mechanic and tell him, my car does not run, do something. He'll do loads of tests, and it will cost you a lot of money.

Here, as no one gets paid for this, it just results in frustrated helpers that one day, when they see the post was by "ymca" will not even open it.

I opened your LSS file. There is NOTHING in it. NO question group, no question, nothing. What are we supposed to do with this? Why don't you give us your LSS file with all the "many things" you have tried? Then we can see what you have actually done, what is wrong, what is not working.

Tried to import your LSG file, but got an error message, because my installation does not have the database column "encrypted". I guess I'll have to install 4.x sooner or later.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
Last edit: 2 months 5 days ago by holch.

Please Log in to join the conversation.

More
2 months 5 days ago - 2 months 5 days ago #196036 by ymca
I'm trying to do what the mechanic tells me to do to help.

Here, as no one gets paid for this, it just results in frustrated helpers that one day, when they see the post was by "ymca" will not even open it.

I'm sorry I don't have a linear way of thinking. I'm very grateful for all the help, and frustrated that all the problems come to me (Corona is enough for me, no need for more :().

I opened your LSS file. There is NOTHING in it.

What do you want me to say?
I have exported it from the survey.
Also sometimes I get 404 when doing that (sure another problem for me :blink: ) when clicking on the structure=>group2=>export group.
Exported it again
Attachments:
Last edit: 2 months 5 days ago by ymca.

Please Log in to join the conversation.

More
2 months 5 days ago #196037 by Joffm
So, what's your problem with your country question?
I set "Sort answers alphabetically" to "YES" and

Couldn't upload the "countries list.lsl" file, so renamed it to "countries list.lsl.lsq".

What did you do exactly?
What happened, when you in "Configuration / Manage label sets" selected "Create or import new label set", then
in "Import label set" selected the *.lsl file and clicked "import"?
Was there an error message, or?

FYI: The file extensions mean:
lss : survey export (this is the only file type you should attach here)
lsg : group export
lsq : question export
lsl : label set export


Volunteers are not paid.
Not because they are worthless, but because they are priceless
Attachments:
The following user(s) said Thank You: ymca

Please Log in to join the conversation.

More
2 months 5 days ago #196038 by holch
I assume that the problem with the LSL file is with uploading it to the forum, not to Limesurvey itself. There was a time where you could not upload LSG or LSQ because the software wouldn't allow it. I guess it is the same problem with LSL. The person who setup the website / forum didn't think of all the LS files you could export.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
2 months 5 days ago #196039 by Joffm
holch, you're right.

I couldn't think of uploading this file, that was downloadad from the "label set templates" section.

Joffm


Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

More
2 months 5 days ago - 2 months 5 days ago #196040 by ymca

I set "Sort answers alphabetically" to "YES" and

:pinch: I missed that (maybe stress :P ).
Thank you so much.

Was there an error message, or?

Yes 404. Then clicked again on the group/survey and I managed.
Last edit: 2 months 5 days ago by ymca.

Please Log in to join the conversation.

More
2 months 5 days ago - 2 months 5 days ago #196041 by ymca
I had a problem when I tried to update the question to change it to "Sort answers alphabetically" it didnt load half of the window (the answer section).
I opened the site in a different browser and it worked.
I think it didn't work because I had too many tabs open.
Also I think why I still have a problem with the countries list.
I have 1 question at the start of the survey asking "where are you from?" and the list of countries are there.
And at the end of the survey I have another question about countries with the countries list.
Now It make sense why the system still makes it random even after clicking the "Sort answers alphabetically".
Isn't saving the same question in a separate group fixing the problem of same question/answer code?
Last edit: 2 months 5 days ago by ymca.

Please Log in to join the conversation.

More
2 months 5 days ago - 2 months 5 days ago #196043 by ymca
Deleted 3 question tests of countries list.
The original question seems to work.
Only "Åland Islands" is after the last country "Zimbabwe" (first countries question it's second after Afghanistan) when I used the "Sort answers alphabetically" when previewing the survey in the countries question.
Last edit: 2 months 5 days ago by ymca.

Please Log in to join the conversation.

More
2 months 5 days 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
Attachments:

Please Log in to join the conversation.

More
2 months 19 hours 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:
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

Please Log in to join the conversation.

More
2 months 5 hours ago #196413 by ymca
I gave up and changed it from "Åland Islands" to "Aland Islands".

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now