Relevance formulas don't work

Mehr
4 Jahre 3 Monate her - 4 Jahre 3 Monate her #99053 von ROSt52
ROSt52 erstellte das Thema Relevance formulas don't work
I got a survey in a Calc spreadsheet translated and corrected some export errors which I observed and reported recently.

Currently it appears as if I have only 1 problem left: I cannot import relevance equations.

I exported a working survey into an TSV file and look at the syntax the relevance equations are written. Although my equations looked exactly the same as the exported ones, when I imported the TSV file, all works but not the relevance equation.
I observed that and export into a TSV file and an immediate re-import into a (new) survey stopped the originally functioning relevance equations.
The relevance equations are rather simple; see example: ((25.NAOK == "2")). “This question shall asked when question 25 has the anser 2” is what I want to state with this equation. This is also the form which I get when I export a survey into an TSV file.

Is this a export / import bug?
What do I make wrong?

Your help is highly appreciated.
Letzte Änderung: 4 Jahre 3 Monate her von ROSt52.

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her - 4 Jahre 3 Monate her #99056 von mdekker
mdekker antwortete auf das Thema: Relevance formulas don't work
Please file a bug report with a simple file that demonstrates the problem.

I see your question codes are wrong.... never start with a number... change it and it probably will work

---
Menno Dekker
Letzte Änderung: 4 Jahre 3 Monate her von mdekker.

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her #99060 von ROSt52
ROSt52 antwortete auf das Thema: Relevance formulas don't work
Hi, mdekker,

Thanks for the quick reply.

How does the equation need to look like? Could you please give me a hint, I expect/hope to continue from there.

I picked up the syntax I used from a TSV export.

Thanks in advance!

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her #99061 von mdekker
mdekker antwortete auf das Thema: Relevance formulas don't work
Just rename your question to q25 and use ((q25.NAOK =="2"))

---
Menno Dekker

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her - 4 Jahre 3 Monate her #99068 von ROSt52
ROSt52 antwortete auf das Thema: Relevance formulas don't work
Hi Menno,

Thanks again for your reply. My reply has 2 parts: 1 - How to fix the formula in the TSV file for import, and 2 - Observations - bug report


Part1 - How to fix the formula in the TSV file for import:

I added a "Q" in front of every question number in the TSV file and imported the survey but still it doesn't work.

My survey is a rather simple one and I have only 3 equations which look now:

((Q13.NAOK == "1" or Q13.NAOK == "2"))

((Q25.NAOK == "2"))

((( ! is_empty(Q28.NAOK) && (Q28.NAOK < "5"))))

I also look intensively into the manual but I could not find the explanations, which I need here. I

assume that I missed the relevant text.

Could you possibly help me directly with my formulas and point to the relevant part in the manual?





Part2 - Observations - bug report

What follows are my observations and this information can be regarded as a bug report. As I don't know a better place, I file it here. Should this be the wrong place, please advice.

Equation in TSV
((Q13.NAOK == "1" or Q13.NAOK == "2"))
((Q25.NAOK == "2"))
((( ! is_empty(Q28.NAOK) && (Q28.NAOK < "5"))))
Import of TSV file
Function: Test this survey
Result: equations don't work

QA for inspection
Message: 4 questions contain errors
Equations look like:
((Q13.NAOK == "1" or Q13.NAOK == "2"))
((Q25.NAOK == "2"))
((( ! is_empty(Q28.NAOK) && (Q28.NAOK < "5"))))
The last equation is the same in 2 question => error in 4 questions
After fixing questions looked like:
((13.NAOK == "1" or 13.NAOK == "2"))
((25.NAOK == "2"))
((( ! is_empty(28.NAOK) && (28.NAOK < "5"))))
Function: Test this survey
Result: equations work


Export into TSV and
1 - opening in Notepad
((13.NAOK == "1" or 13.NAOK == "2"))
((25.NAOK == "2"))
((( ! is_empty(28.NAOK) && (28.NAOK < "5"))))
2 - Calc (UTF-8, tab)
((13.NAOK == "1" or 13.NAOK == "2"))
((25.NAOK == "2"))
((( ! is_empty(28.NAOK) && (28.NAOK < "5"))))

No change in exported TSV and re-import
Function: Test this survey
Result: equations don't work

OA for inspection
Message: 4 question contain errors
Questions look like:
((13.NAOK == "1" or 13.NAOK == "2"))
((25.NAOK == "2"))
((( ! is_empty(28.NAOK) && (28.NAOK < "5"))))
Fxing the question they look like:
((13.NAOK == "1" or 13.NAOK == "2"))
((25.NAOK == "2"))
((( ! is_empty(28.NAOK) && (28.NAOK < "5"))))
Function: Test this survey
Result: equations work

Under the assumption that I can fix (with Menno's Help!) the equations in the TSV file that they work after import, I conclude that there is an export error. Otherwise I have to assume that there is also an import error in the sense that however the equations are written they cannot be imported to function.

I will update this report and I am open to questions to support a bug fix.

I added three color screen shots of the equations, hoping that an expert can understand the red frame and the change.

Reinhold


Anhang EquationBeforeFixing_withQ.png nicht gefunden



Anhang EquationBeforeFixing.png nicht gefunden



Anhang EquationAfterFixing.png nicht gefunden

Letzte Änderung: 4 Jahre 3 Monate her von ROSt52.

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her #99071 von mdekker
mdekker antwortete auf das Thema: Relevance formulas don't work
We have our Bugtracker for bug reports. I think you did not change the question title. Please open a report in our Bugtracker, point to this topic and attach your tsv file to the bug report.

(I hope the Bugtracker keyword creates a link. If not you can find it in the top menu under community.)

---
Menno Dekker

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her #99089 von ROSt52
ROSt52 antwortete auf das Thema: Relevance formulas don't work
bug tracker - Although I am logged in here, I was asked to log into the bug tracker again. Do I need to create a new account and password for the bug tracker?

Is there a chance that you can help me with a way to write the equation in an TSV file or is it already clear for you that we have a bug?

Bitte Anmelden um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha