topic Re: Analyze Survey Error in ArcGIS Survey123 Questions

Analyze Survey Error

JimW — Mon, 28 Aug 2023 15:18:03 GMT

I am trying to use the Analyze survey tool in Survey123 Connect (v. 3.18.123). I get the following error when it is run:

I have analyzed several other surveys without issue.

What's going on?

Thanks.

Re: Analyze Survey Error

JayHodny — Mon, 28 Aug 2023 15:27:28 GMT

Hi Jim,

I found that if I run the tool with my XLS file still open, I get that error. If I then close, the tool runs. I also update the XLS form if it's an older version.

Regards, Jay

Re: Analyze Survey Error

JimW — Mon, 28 Aug 2023 15:32:24 GMT

Hi Jay.

Thanks for the reply and the suggestions.

Unfortunately, my XLS file was already closed and I already updated the XLS form to the latest version.

Re: Analyze Survey Error

ZacharySutherby — Mon, 28 Aug 2023 18:13:54 GMT

Hello @JimW,

Do you have a value in your calculation column that is just a number? Would you also be able to pass along your XLSForm for review on our end?

What's likely happening is there may be a value in the calculation column of your XLSForm that is an integer and the tool is failing because it's trying to compare a string to that integer. If this is the case this is a bug on the tool side.

Re: Analyze Survey Error

JimW — Mon, 28 Aug 2023 19:24:09 GMT

That was the issue. I had the number "1" in my calculation cell. I deleted it, ran the analyzer, fixed my file and then added the 1 back into the file.