Back to limesurvey.org

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

More
6 years 5 months ago #196028 by ymca
Cannot create a list of countries in a dropdown was created 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:
LS Version 4.2+
The topic has been locked.
Partner Banner
More
6 years 5 months ago #196031 by holch
Replied by holch on topic Cannot create a list of countries in a dropdown
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.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
More
6 years 5 months ago #196032 by Joffm
Replied by Joffm on topic Cannot create a list of countries in a dropdown

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
The topic has been locked.
More
6 years 5 months ago - 6 years 5 months ago #196034 by ymca
Replied by ymca on topic Cannot create a list of countries in a dropdown
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
LS Version 4.2+
Last edit: 6 years 5 months ago by ymca.
The topic has been locked.
More
6 years 5 months ago - 6 years 5 months ago #196035 by holch
Replied by holch on topic Cannot create a list of countries in a dropdown

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.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
Last edit: 6 years 5 months ago by holch.
The topic has been locked.
More
6 years 5 months ago - 6 years 5 months ago #196036 by ymca
Replied by ymca on topic Cannot create a list of countries in a dropdown
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
LS Version 4.2+
Last edit: 6 years 5 months ago by ymca.
The topic has been locked.
More
6 years 5 months ago #196037 by Joffm
Replied by Joffm on topic Cannot create a list of countries in a dropdown
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
The following user(s) said Thank You: ymca
The topic has been locked.
More
6 years 5 months ago #196038 by holch
Replied by holch on topic Cannot create a list of countries in a dropdown
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.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
More
6 years 5 months ago #196039 by Joffm
Replied by Joffm on topic Cannot create a list of countries in a dropdown
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
The topic has been locked.
More
6 years 5 months ago - 6 years 5 months ago #196040 by ymca
Replied by ymca on topic Cannot create a list of countries in a dropdown

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.
LS Version 4.2+
Last edit: 6 years 5 months ago by ymca.
The topic has been locked.
More
6 years 5 months ago - 6 years 5 months ago #196041 by ymca
Replied by ymca on topic Cannot create a list of countries in a dropdown
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?
LS Version 4.2+
Last edit: 6 years 5 months ago by ymca.
The topic has been locked.
More
6 years 5 months ago - 6 years 5 months ago #196043 by ymca
Replied by ymca on topic Cannot create a list of countries in a dropdown
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.
LS Version 4.2+
Last edit: 6 years 5 months ago by ymca.
The topic has been locked.
More
6 years 5 months ago #196046 by Joffm
Replied by Joffm on topic Cannot create a list of countries in a dropdown

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.
More
6 years 5 months ago #196398 by ymca
Replied by ymca on topic Cannot create a list of countries in a dropdown

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.
More
6 years 5 months ago #196413 by ymca
Replied by ymca on topic Cannot create a list of countries in a dropdown
I gave up and changed it from "Åland Islands" to "Aland Islands".
LS Version 4.2+
The topic has been locked.
Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source