topic Re: Error converting XLSForm [Errno 2] in ArcGIS Survey123 Questions

Error converting XLSForm [Errno 2]

ANRGIS — Thu, 01 Sep 2022 18:56:51 GMT

[Errno 2] No such file or directory: '/tmp/survey123-form-converter/outputs/xls2xform/_requestId_/' with the name of the survey.xlsx.xml

This is occurring when the XLSForm is saved. It will get to the converting stage, then fail. Sometimes if I press save again, sometimes it'll error several times in a row. It's consistently intermittent (if that's such a thing). I can usually get it to save if I'm persistent, but when doing development on a big survey where I need to see the changes I've been making in the survey, it's becoming annoying and time consuming. I've searched and can't seem to find any related questions/posts. Does anybody have any ideas what might be causing this? I've even created a new survey and used my XLS document in the new survey and get the same results. Publishing the survey succeeds.

I'm at a bit of a loss...
Thanks for any help.

Re: Error converting XLSForm [Errno 2]

Alena — Thu, 01 Sep 2022 19:23:07 GMT

I have the same issue. I posted also. https://community.esri.com/t5/arcgis-survey123-questions/survey123-connect-version-3-15-error-can-t-find/m-p/1207776#M44552

Re: Error converting XLSForm [Errno 2]

ANRGIS — Thu, 01 Sep 2022 19:56:39 GMT

Ah... Misery loves company! Thanks, I subscribed to your post as well.
It seems to be better this afternoon. It must be an api issue.

Re: Error converting XLSForm [Errno 2]

AllanBrown — Fri, 02 Sep 2022 01:09:37 GMT

I have the same problem.

Re: Error converting XLSForm [Errno 2]

ChrisRoberts2 — Fri, 02 Sep 2022 01:17:08 GMT

Just started seeing the same issue myself. A form that was saving fine yesterday is getting errors this morning. Yet if I hit save a second time it saves without errors.

Re: Error converting XLSForm [Errno 2]

ANRGIS — Fri, 02 Sep 2022 12:06:36 GMT

For those in this thread... A suggestion was to try and clear up bloat in your excel file. I found that in my xlsx file, I had columns that were formatted with their column number, perhaps an artifact of a previous copy/paste or something along those lines.... I simply selected all the cells that were not being used and deleted them. It seems to have helped.

Re: Error converting XLSForm [Errno 2]

BillSimper — Thu, 06 Oct 2022 22:07:44 GMT

I'm having this problem too. The only survey that is causing it makes extensive use of 'linked content' specifically CSV files uploaded to ArcGIS Online and used for choice lists using the select_one_from_file field type.

Re: Error converting XLSForm [Errno 2]

Noushinad60 — Mon, 17 Oct 2022 20:59:52 GMT

I have the same issue. Rather than click on save in XLSForm. Click on update on the survey.

I hope that works for you.

Re: Error converting XLSForm [Errno 2]

JoseBarrios1 — Wed, 26 Oct 2022 15:00:19 GMT

Same problem with 3.14.281...Error converting XLSForm [Errno 2]

Re: Error converting XLSForm [Errno 2]

JessicaJThompson — Mon, 06 Feb 2023 16:32:06 GMT

I am having the same issue with a few surveys. Any Answers for this? The "use update in connect instead of save in Excel" didn't solve the issue.

Thanks!

@ANRGIS