Welcome, Guest
Username: Password: Remember me

TOPIC: Relevance formulas don't work

Relevance formulas don't work 1 year 1 week ago #99053

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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.
Last Edit: 1 year 1 week ago by ROSt52.
The administrator has disabled public write access.

Relevance formulas don't work 1 year 1 week ago #99056

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
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
Last Edit: 1 year 1 week ago by mdekker.
The administrator has disabled public write access.

Relevance formulas don't work 1 year 1 week ago #99060

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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!
The administrator has disabled public write access.

Relevance formulas don't work 1 year 1 week ago #99061

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
Just rename your question to q25 and use ((q25.NAOK =="2"))
---
Menno Dekker
The administrator has disabled public write access.

Relevance formulas don't work 1 year 1 week ago #99068

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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


Attachment EquationBeforeFixing_withQ.png not found



Attachment EquationBeforeFixing.png not found



Attachment EquationAfterFixing.png not found

Last Edit: 1 year 1 week ago by ROSt52.
The administrator has disabled public write access.

Relevance formulas don't work 1 year 1 week ago #99071

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
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
The administrator has disabled public write access.

Relevance formulas don't work 1 year 1 week ago #99089

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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?
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.109 seconds
Donation Image