Welcome to the LimeSurvey Community Forum

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

Array number type with 24 columns

  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago #199808 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
Hello,

Thank for the response.

Right now I m trying to export the response in Excel but the response didn't save in Excel. And after I push the submit button it didn't appear any message of finishing, it's just like I press refresh button. Could this be because of to many structure on my survey. In this example (*.lss) I attached I have 4 array numbers.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 11 months ago #199809 by Joffm
Replied by Joffm on topic Array number type with 24 columns
I should say,

revise your design.
At least put your several t-questions into separate groups.

If you display everything on one page, your "max_input_vars" value may be far too low.

I could submit the questionnaire; and export as well.

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago #199810 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
And the responses remain saved in the excel. I mean you could see what you response in the Excel?
The topic has been locked.
  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago #199822 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
Hi,

I changed on a Windows machine in localhost my php.ini into 5000 and restart XAMPP and works.
I will change on linux environment and restart apache service to see if it works.
Thanks a lot
The topic has been locked.
  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago #199964 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
Hey,

After I read again your suggestion I check to see how to put every question on a diffrente page. So I find the option "Question by question". But I have some asignment like this (t573_l1_c3=0,t573_l1_c4=0,t573_l1_c5=0,t573_l1_c6=0,t573_l1_c7=0,
t573_l2_c3=0,t573_l2_c4=0,t573_l2_c5=0,t573_l2_c6=0,t573_l2_c7=0) for all question.
The problem is that when I want to go to another page after pressing the submit the survey is not permiting to go because I have some validation and the value change to 0 as I put them initial. So the problem is that even though I change the value of 0 after submit the value still remain to 0 or what I assign for that field. Is there any button to get my inserted value or I will not complete the fields with anything on Sub-question validation equation section?
The topic has been locked.
  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago - 3 years 11 months ago #199965 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
You have to select Ag. Alba Iulia from drop down to appear that array number with every question on new page.

File Attachment:

File Name: AlbaIulia.lss
File Size:638 KB
Last edit: 3 years 11 months ago by nicolae_stan93.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 11 months ago - 3 years 11 months ago #199967 by Joffm
Replied by Joffm on topic Array number type with 24 columns
What is that?

You write

But I have some asignment like this (t573_l1_c3=0,t573_l1_c4=0,t573_l1_c5=0,t573_l1_c6=0,t573_l1_c7=0,
t573_l2_c3=0,t573_l2_c4=0,t573_l2_c5=0,t573_l2_c6=0,t573_l2_c7=0) for all question.


and your first screenshot shows a validation equation with wrong syntax


1. You shouldn't use "subquestion validation", but "question validation"
2. Here there are a lot of comma separated assignments, but no validation.
A validation is a comparison like "Is the value equal X", OR value==X.
Remember "0" is the assignment operator to set something, "==" is the comparison operator.
manual.limesurvey.org/ExpressionScript_-_Presentation#Operators
If it is equal the validation is TRUE else FALSE and you cannot proceed to the next question.

And, please read the manual about ExpressionScript.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 3 years 11 months ago by Joffm.
The topic has been locked.
  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago - 3 years 11 months ago #199975 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
I put my survey on diffrent pages to overcome issue with var_max_input (because I change it to 5000 and did nt word)but now I saw that only the response from last page are saved in excel. The other one are not present. Did I miss something regarding settings for pages to be saved (question by question)?
Last edit: 3 years 11 months ago by nicolae_stan93.
The topic has been locked.
  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago #199981 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
Thanks I delete all the asignment operation. I saw that appear on table fields when open the survey and I thought that would be nice to initialeze with zero the fields of array of number.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 11 months ago - 3 years 11 months ago #199988 by Joffm
Replied by Joffm on topic Array number type with 24 columns
Here an example how you could structure, pre-set and validate.

Pre-setting and validation only for t51.


File Attachment:

File Name: limesurvey...8922.lss
File Size:434 KB

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 3 years 11 months ago by Joffm.
The following user(s) said Thank You: nicolae_stan93
The topic has been locked.
  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago #199993 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
Hi,

I have this issue where I set "question by question" to display and for a choice in drop down there are 8 array number. After I complete all of them on the response I got just the response from one array of number. I mention that I changed max_input_vars at 9999 and restarte httpd(apache) server.
The topic has been locked.
  • nicolae_stan93
  • nicolae_stan93's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 11 months ago #200001 by nicolae_stan93
Replied by nicolae_stan93 on topic Array number type with 24 columns
I tested on a localhost the same survey and it save all the response from all 8 tables (array number) input in excel. And here I have just only 5000 for max_input_vars in php.ini.
Could it be a parameter set wrong on server for not saving all the responses ?
Because the same survey works in my Windows/XAMPP enviroment but not with linux/apache env.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose