I just started using version 3.15 Survey123 Connect. I keep getting various errors that the *xlsx.xml doesn't exist. I tried it on 2 different computers for version 3.15. The issue pops up when I edit current forms and when I create new forms. I have not moved any files. Any ideas what the issue might be? Thanks.
This issue looks to be due to extra bloat in XLSFroms. For example if there are a number of extra columns or rows in the XLSForm that aren't used but are making the file size larger may cause this conversion error.
If you delete any extra columns on all the worksheets in the XLSForm to reduce the file size that should help resolve the issue.
I have a client and several colleagues from the organization present with the same inconvenience, what you indicate was applied but the error still persists, it was tested in several versions 3.15 and 3.16, it still presents the error.
To know if they already reported it as a system error, you don't know if there is another method to apply it.
Is the behavior consistently happening (every form update) with one or more surveys, or does the error periodically happen on form update?
If possible may I ask for a copy of the XLSForm that's encountering the behavior for testing on our end? Feel free to send it to ZSutherby@esri.com and I can take a look into it.
Hello @ZacharySutherby I have deleted extra columns and it is still happening. For some time it has happened periodically and then resolved when I tried later. But this time it is not coming around.
Any full solution to this?
We do have a fix for this issue coming with our 3.17 release later this month. For the time being if you change your API URL in Connect to https://survey123qa.arcgis.com/api that environment has the fix on it at this time.
To change the API URL in Connect select the profile icon or hamburger on the top right and select Settings. Select the Services and add the qa after survey123 in the URL:
It is recommended that after Survey123 3.17 releases you switch the API URL back to the original https://survey123.arcgis.com/api.