- Posts: 56
- Karma: 2
- Thank you received: 1

# Relevance formulas don't work

4 years 9 months ago - 4 years 9 months ago #99053
by ROSt52

ROSt52 created the topic: 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.

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: 4 years 9 months ago by ROSt52.

Please Log in or Create an account to join the conversation.

4 years 9 months ago - 4 years 9 months ago #99056
by mdekker
~~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

mdekker replied the topic: Relevance formulas don't work

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

---

Menno Dekker

Last Edit: 4 years 9 months ago by mdekker.

Please Log in or Create an account to join the conversation.

4 years 9 months ago #99060
by ROSt52

ROSt52 replied the topic: 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!

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!

Please Log in or Create an account to join the conversation.

4 years 9 months ago #99061
by mdekker

---

Menno Dekker

mdekker replied the topic: Relevance formulas don't work

Just rename your question to q25 and use ((q25.NAOK =="2"))

---

Menno Dekker

Please Log in or Create an account to join the conversation.

4 years 9 months ago - 4 years 9 months ago #99068
by ROSt52

ROSt52 replied the topic: 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

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: 4 years 9 months ago by ROSt52.

Please Log in or Create an account to join the conversation.

4 years 9 months ago #99071
by mdekker

---

Menno Dekker

mdekker replied the topic: 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.)

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

---

Menno Dekker

Please Log in or Create an account to join the conversation.

4 years 9 months ago #99089
by ROSt52

ROSt52 replied the topic: 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?

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?

Please Log in or Create an account to join the conversation.