Dear OFT, Thank you very much for wonderful arena application. I imported a survey into Arena prepared in OFC. Some more error is producing and I am trobleshoting them and getting success. But in below case I tried to change the script from OFC to Arena format it is not working.The result shows blank and there is no error in arena. Do my arena script has error? I must be missing something but could not able to figure it out.The result shows same value in excel and collect but not in arena. plese suggest me the correction. Thank you very much.

My Formula

Excel

(EXP(VLOOKUP(DataEntrySheet!D2,value!$B$2:$G$24,2,FALSE)+ VLOOKUP(DataEntrySheet!D2,value!$B$2:$G$24,3,FALSE)LN(DataEntrySheet!F2)+ VLOOKUP(DataEntrySheet!D2,value!$B$2:$G$24,4,FALSE)LN(DataEntrySheet!G2)))/1000

OFC

math:pow(2.71828182845905,idm:speciesListData('trees', 'a', species)+idm:speciesListData('trees', 'b', species)math:log(dbh)+idm:speciesListData('trees', 'c', species)math:log(height)) div 1000

Arena

Math.pow(2.71828182845905, taxonProp('trees', 'a', species) + taxonProp('trees', 'b', species) * Math.log(dbh) + taxonProp('trees', 'c', species) * Math.log(height)) / 1000

asked 04 Aug, 06:00

Rajkumar's gravatar image

Rajkumar
17611951
accept rate: 4%

edited 18 Oct, 10:24

OF%20Collect's gravatar image

OF Collect ♦♦
4.0k18


Dear user,
Thanks for reporting these issues, we are working already to a new version of Arena that will be released soon, we will let you know when it will be ready.
Thanks again,
Open Foris Team

permanent link

answered 04 Aug, 17:40

OF%20Collect's gravatar image

OF Collect ♦♦
4.0k18
accept rate: 21%

Dear user,
Please try to split the expression into several "read only" attributes and check if all the parts of the expression are working as expected.
Many thanks,
Open Foris Team

permanent link

answered 04 Aug, 13:01

OF%20Collect's gravatar image

OF Collect ♦♦
4.0k18
accept rate: 21%

Dear Rajkumar,
The problem has been fixed with the latest version of Arena (1.2.1).
Please check that it works in your survey.
Many thanks,
Open Foris Team

permanent link

answered 18 Oct, 09:04

OF%20Collect's gravatar image

OF Collect ♦♦
4.0k18
accept rate: 21%

Dear OFT, I already did that. I just wanted to return the value of species extra column but did not get success using like taxonProp('trees','a',species) piece of code. I have to be able to return value from extra column. Then I think I can do what I need right now.

Another bad behavior I noticed with the code Math.max(plot.tree.tree_no) + 1 does not produce anything but blank cell. Math.max(tree.tree_no) + 1 produces 3,6,9 or so on. I have attached a video that describes how badly behaves the system.

https://youtu.be/QASaUASI6b0

permanent link

answered 04 Aug, 15:57

Rajkumar's gravatar image

Rajkumar
17611951
accept rate: 4%

edited 04 Aug, 18:02

Dear user,
A new version of Arena has been released with a bunch of updates related to the evaluation of expressions.
Please let us know if your expressions are working as expected.
Many thanks,
Open Foris Team

permanent link

answered 13 Oct, 11:27

OF%20Collect's gravatar image

OF Collect ♦♦
4.0k18
accept rate: 21%

Dear Team, It is still not working. I have to calculate value using this expression taxonProp('trees','bg',species) . In text field it is shown the formula itself not value, but in numeric field it is blank field. This problem is stopping me further form development. Thanks for your continious support.

permanent link

answered 14 Oct, 16:42

Rajkumar's gravatar image

Rajkumar
17611951
accept rate: 4%

Dear OFC, Thank you very much for updating Arena. I did some trick to produce my result. taxonProp is still not working with messing other expression. But it is working creating extra node for extra property. Now it is working. My serious concern about arena will be describing the issue in new question. Thank you.

permanent link

answered 28 Oct, 05:55

Rajkumar's gravatar image

Rajkumar
17611951
accept rate: 4%

Dear Rajkumar, can you give us some more details? Is the function taxonProp working or not in your case? If you want we can contact you to your private email address to better understand your issue. Many thanks.

(28 Oct, 11:53) OF Collect ♦♦ OF%20Collect's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×4

question asked: 04 Aug, 06:00

question was seen: 225 times

last updated: 28 Oct, 11:53