please help with assessment saving to db, i tried all possible ways!

More
4 years 2 weeks ago #99660 by itsme
itsme created the topic: please help with assessment saving to db, i tried all possible ways!
Hi guys

I'm trying to make an array assessment results being saved to database (normal array) of 2 questions, one is calculating the columns as 0,1,2,3 and one is calculating differently as 4,5,6,7

lime survey version 1.92+
using group by group

in this group, i put only these 2 array questions and added another question with "always hide this question" then added the java script mentioned here:
www.limesurvey.org/de/forum/can-i-do-thi...tabase?lang=en#73833

without results

also tried using the Expression Manager and crated new question as equation type and in question text:

sum(ct_g2_q01.NAOK,ctspq_g2_q02.NAOK)
also tried
sum(ct_g2_q01.value.NAOK,ct_g2_q02.value.NAOK)
also tried
sum(ct_g2_q01.value,ct_g2_q02.value)

no use at all, the numeric field (for java) and the equation field (for equation) is always kept empty, no use what i try

i have been reading the Expression Manager thing over and over even i got depressed but nothing worked for me, please guys help me save this array assessment results to database

by the way, in assessment range values in the end page is working fine, gives me the results
also if i place holder in the end page in template, it gives it ok,,, but i am not able to save it along with the database

is there anyway to save the results of the range of assessment as well to database? i mean, i've put in the assessment page that if score is 1-6 then inform participant that he is fine, if 7-10 he is abnormal, it is showing ok in the end page, but can i save this value to database also???

please help guys, appreciated any hint or lead to what i can do

Mike

Please Log in to join the conversation.

More
4 years 2 weeks ago #99661 by jelo
jelo replied the topic: please help with assessment saving to db, i tried all possible ways!
Thinks you should attach a surveyfile of your two,three questions here to get the whole picture.

E.g.: Is the QCode correct?
manual.limesurvey.org/Expression_Manager#Qcode_Variable_Naming

Perhaps you have found a bug with your Limesurvey installation.
Try your stripped down surveyfile on the Demo installation here to check that too.
The following user(s) said Thank You: itsme

Please Log in to join the conversation.

More
4 years 2 weeks ago #99668 by DenisChenu
DenisChenu replied the topic: please help with assessment saving to db, i tried all possible ways!
Hi,

Don't use Text question type/hide attribute.
Use directly a equation question type : it made for this.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: itsme

Please Log in to join the conversation.

More
4 years 2 weeks ago #99680 by itsme
itsme replied the topic: please help with assessment saving to db, i tried all possible ways!
hello again and thanks for the quick reply

actually i couldn't understand this Qcode thing, it is too complicated and don't know which of the arrays is flixable or not, there not examples for the array with assessemnt like the one i am working on... so i have tried all what is written one by one, no use :ohmy:

the survey is here, i've kept the group of 2 questions and 1 question for calcuation (equpation)

stardvb.com/vpn/limesurvey_survey_75233.lss

the first 2 questions are array, and i've made them in 2 questions (although the headers are the same) in order to assess them differently...

if you notice, the assessment is working fine and it give the values when done in the end page, i also added in my template the {current total short code} it is working fine,, but i want this calculation value to be saved to database!! and also to have the output results (normal, abnormal ,borderline) as to be in the database along with the answers record

using ls 1.92

appreciated any input

Mike

Please Log in to join the conversation.

More
4 years 2 weeks ago #99700 by itsme
itsme replied the topic: please help with assessment saving to db, i tried all possible ways!
hello, anybody please advise

Please Log in to join the conversation.

More
4 years 2 weeks ago #99701 by Ben_V
Ben_V replied the topic: please help with assessment saving to db, i tried all possible ways!
Hello,

1) As already said by Denis, use a hidden equation type question to grab the assessment value.

2) Avoid the use of javascript based workarounds described elsewhere in the forum (only indicated for versions before 1.92)

3) Go to this old post , install the survey sample (assess.lss) and play around to understand how this works

Hope this helps you....

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

Please Log in to join the conversation.

More
4 years 2 weeks ago #99703 by itsme
itsme replied the topic: please help with assessment saving to db, i tried all possible ways!
hi and thanks a lot for your reply

i've done that actually but didn't work, i changed the question codes to q1 and q2 to cope with the example but keep showing undefined variable in the equation question!

my questions are "array" not radio buttons with comments and i am stuck in the middle of this, please have a look at my given survey above and just put the formula for me

i would like to save the assessment results as well that which is shown in the end of the survey (assessment page - end page) so please help in this as well

I know we are newbies and might bother you a little, believe me i've searched all over the forums and played around for long time without active results, i appreciate any input can help me finish this

thanks a lot in advanced

Mike

Please Log in to join the conversation.

More
4 years 2 weeks ago - 4 years 2 weeks ago #99728 by amit01
amit01 replied the topic: please help with assessment saving to db, i tried all possible ways!
Hello,
I tried the attached survey and found that you are using incorrect expression.

Please use the subquestion code as well in the expression

The correct expression would be :
{sum(ct_g1_q01_SQ001.NAOK, ct_g1_q02_SQ001.NAOK)}

Hope this helps!!

--
amit
Last Edit: 4 years 2 weeks ago by amit01. Reason: missed expressions tag

Please Log in to join the conversation.

More
4 years 2 weeks ago #99729 by itsme
itsme replied the topic: please help with assessment saving to db, i tried all possible ways!
thank you amit
i tried that but didn't work
can you please make changes to the same example i attached and reupload, it doesn't make sense and drives me crazy :(

Please Log in to join the conversation.

More
4 years 2 weeks ago - 4 years 2 weeks ago #99732 by amit01
amit01 replied the topic: please help with assessment saving to db, i tried all possible ways!
Here it is:

File Attachment:

File Name: h0c777bb_2...9-10.lss
File Size:38 KB


Maybe try using "value" instead of "NAOK" in the expression.

--
amit
Attachments:
Last Edit: 4 years 2 weeks ago by amit01. Reason: Missed the attachement

Please Log in to join the conversation.

More
4 years 1 week ago #99766 by itsme
itsme replied the topic: please help with assessment saving to db, i tried all possible ways!
perfect, now it works !!! thanks a lot my dear, appreciated a lot ;)

best regards
Mike

Please Log in to join the conversation.

More
4 years 1 week ago #99794 by Mazi
Mazi replied the topic: please help with assessment saving to db, i tried all possible ways!
Please add your example here to help others: manual.limesurvey.org/Expression_Manager_Examples

Thanks!


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
4 years 1 week ago - 4 years 1 week ago #99811 by itsme
itsme replied the topic: please help with assessment saving to db, i tried all possible ways!
done but i am not familiar with wiki, please check the same link and see if needs modification or something!?
thanks a lot guys, amit, DenisChenu, benoit, and Mazi :)
Last Edit: 4 years 1 week ago by itsme.

Please Log in to join the conversation.

More
4 years 1 week ago #99815 by Mazi
Mazi replied the topic: please help with assessment saving to db, i tried all possible ways!
I adjusted it a little. Thanks for sharing your solution!


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now