Array number type with 24 columns

More
1 month 1 week ago #199683 by Joffm
Hi,
it is not a validation, we talk about an equation.

And don't get confused with equal signs.
"==" means comparison, "=" means assigment.

So, what is your problem with creating a question of type equation before your array with the mentioned statements?
{tabelul_l1_c1=0}
{tabelul_l1_c2=0}
{tabelul_l1_c3=0}
...

Joffm


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

Please Log in to join the conversation.

More
1 month 1 week ago #199745 by nicolae_stan93
Hi,

Now I m trying to export the results on excel format but I got the attached error where said:
500: Internal Server Error
Class 'ZipArchive' not found.

From what I understand on similar question on Stackoverflow I need to install zip extension on my server. Is it correct?
Attachments:

Please Log in to join the conversation.

More
1 month 1 week ago #199751 by Joffm
What and how are you exporting?

When exporting your responses to EXCEL no zip file is created but a "results-survey123456.xlsx".

A zip file may be created when you download the attachments of "file upload" questions.

Joffm


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

Please Log in to join the conversation.

More
1 month 1 week ago #199758 by nicolae_stan93
Hello,

Was a user permission issue. I didn't have the right permission.
Fixed.
Thank you for response.

Please Log in to join the conversation.

More
1 month 1 week ago #199765 by DenisChenu

Joffm wrote: When exporting your responses to EXCEL no zip file is created but a "results-survey123456.xlsx".

xlsx, docx etc … are zip files :)
With specific files inside it

Same for ods :)

Then need specific zip extension for PHP

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development . I don't answer to private message.
Attachments:

Please Log in to join the conversation.

More
1 month 1 week ago #199771 by Joffm
@Denis,
of course you're right.
I myself unzipped a xlsx to edit some things inside.

Sorry

Joffm


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

Please Log in to join the conversation.

More
1 month 1 week ago #199779 by nicolae_stan93
Hello,

For exporting of array of number in excel on the specific format is any option because I didn't find. For example for a table of 2 rows and 2 columns all the answears are exported in excel in rows. I would like to be as it is in array number(table) format. So if a field is on column to in array in my excel to be exported on column 2, etc...
Attachments:

Please Log in to join the conversation.

More
1 month 1 week ago #199790 by nicolae_stan93
I don't know if I was really clear here. I like to export table (array number) as it is in survey format.
Columns from survey goes to columns in excel.
In this result export form survey rows and columns goes in excel to rows only so you have to figure out which one is row and which is column. After that I have to check which is column in excel and cut/paste.

Please Log in to join the conversation.

More
1 month 1 week ago #199797 by Joffm
Hi,
I think it was clear.

But nobody knows how to answer such a question.
How do you imagine this could be possible?


Where to begin:
You know format of relational databases?
You know the requirements of most analysis tools; I am sure you want to do some statistical tests like CHI2, t-Test, ANOVA, even factor- or cluster analysis. And all these work row wise.

Even EXCEL to be able to use "Pivot-tables".

You see, if you display it the way you described you can't calculate a simple mean of a cell in EXCEL without additional conditions.

In your first post about that you talked about a 2x2 matrix. Now if the next question is a 3x4 matrix? Or a multiple question? How do you want to display this?
Something like that?


Obviously this will not work.

have to figure out which one is row and which is column

As the format of export is well defined
Q_Y001_X001,Q_Y001_X002,Q_Y001_X003,...,Q_Y002_X001,Q_Y002_X002,
there shouldn't be anything to figure out.
Maybe, if you coded both (x and y)-axes "SQ001","SQ002",... it might be a bit confusing.
But as I saw, you coded "table1_l1_c1","table1_l1_c2",...

After that I have to check which is column in excel and cut/paste.

This you may do with a small macro in EXCEL, even because you have well defined codes for row and column.

And what is the reason to display such a matrix of a single respondent?
Usually you display the results of the entire survey or a subgroup ("males", "females").
And this is done by the cross tabulation of your statistic tool.

Joffm


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

Please Log in to join the conversation.

More
1 month 1 week ago #199808 by nicolae_stan93
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.
Attachments:

Please Log in to join the conversation.

More
1 month 1 week ago #199809 by Joffm
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

Please Log in to join the conversation.

More
1 month 1 week ago #199810 by nicolae_stan93
And the responses remain saved in the excel. I mean you could see what you response in the Excel?

Please Log in to join the conversation.

More
1 month 1 week ago #199822 by nicolae_stan93
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

Please Log in to join the conversation.

More
1 month 6 days ago #199964 by nicolae_stan93
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?

Please Log in to join the conversation.

More
1 month 6 days ago - 1 month 6 days ago #199965 by nicolae_stan93
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
Attachments:
Last edit: 1 month 6 days ago by nicolae_stan93.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now