topic Re: Error converting XLSForm in ArcGIS Survey123 Questions

Error converting XLSForm

DanielKonzek — Mon, 24 Jul 2017 15:08:06 GMT

I have a survey with a lengthy choice list. I added about 20 new options to this list and now my survey will not load in Survey123 Connect and gives the message: "Error Converting XLSForm" without any further details. When I copy the XLSForm and create a new survey from the copy the form loads just fine. Any recommendations on how to fix this?

Thank you,

Dan

Re: Error converting XLSForm

JohnathanHasthorpe — Mon, 24 Jul 2017 23:57:24 GMT

Hi Dan - Can you confirm whether the form has an external select in it? Also can you upload the survey?

Thanks
John

Re: Error converting XLSForm

DanielKonzek — Tue, 25 Jul 2017 13:24:09 GMT

No, It does not.

The same list (plant species) is used in two other surveys without issue. The survey giving me problems is the longest and most complex of the three surveys though. I created a copy of the XLS form and brought it back into Survey123 Connect as a new survey yesterday and the form worked. I've attached the XLS form for your review. We have a significant amount of data that has been collected using the original version of this form (the version that is no longer working). Is there a way to use the new version of the form (the one that is working) and associate it with the current feature layer for the original form (the one that is not working). The XLS forms are identical.

Thank you,

Dan

Re: Error converting XLSForm

JohnathanHasthorpe — Thu, 27 Jul 2017 13:44:40 GMT

Hi - I will take a look at the form and get back to you. But in the mean time - yes you can point the new form to the existing service. To do this you need to use the submission_url in the settings page of the new survey and update it with the url of the service. For more information on this see:

Author a survey that matches a feature service

Use Survey123 with existing feature services—Survey123 for ArcGIS | ArcGIS

Re: Error converting XLSForm

JohnathanHasthorpe — Fri, 28 Jul 2017 04:33:56 GMT

I tested the survey and all worked fine. Can you confirm if you are using Windows?

Re: Error converting XLSForm

DanielKonzek — Fri, 28 Jul 2017 13:54:55 GMT

I realized yesterday that the survey loads fine in connect when not associated with a feature service. Once I added the feature service url to the submission_url field that the form would not load. I then deleted 30 options from my choices list and the survey loads. Is there a limitation on the size or complexity of the feature service that I am running into?

Re: Error converting XLSForm

JohnathanHasthorpe — Wed, 02 Aug 2017 07:40:53 GMT

You should not be hitting any limit with your survey. Can you provide more information on the feature service you specified in the submission url? Was that created with the old version of the survey, or the version of the survey that had the additional choices in it?

Re: Error converting XLSForm

PatrickDel_Pizzo — Wed, 02 Aug 2017 17:03:28 GMT

I've been experiencing similar problems but it seems to come and go. Suddenly it will be loading fine with no changes made. I haven't been able to identify a cause.

Re: Error converting XLSForm

JohnathanHasthorpe — Mon, 07 Aug 2017 01:29:49 GMT

Hi Patrick - are you using Windows?

Re: Error converting XLSForm

PatrickDel_Pizzo — Mon, 07 Aug 2017 11:33:36 GMT

Android devices are being used in the field.

Re: Error converting XLSForm

WellingtonChristian_Rodrigues_ — Mon, 07 Aug 2017 11:34:14 GMT

Patrick,

Do you have Survey123Connect for ArcGIS at the same Base Enterprise machine?

Re: Error converting XLSForm

PatrickDel_Pizzo — Mon, 07 Aug 2017 12:52:50 GMT

Survey123 Connect is on a windows based laptop with an enterprise connection. The app is being run on droid phones in the field.

Re: Error converting XLSForm

TimothyKing3 — Sat, 04 Apr 2020 19:40:55 GMT

I am having the same issue. I have a hosted feature layer that I created with a file geodatabase and when I use the layer to create a new 123 form I get the error Error Converting XLSFOrm and the following.

Going to try some other things out.

Thanks,

LTK

Re: Error converting XLSForm

TimothyKing3 — Sun, 05 Apr 2020 12:02:18 GMT

I was able to figure it out. One of the staff names had a character above the e for accent and when i changed it in the field name it worked fine!

3.9 is a great release!

Re: Error converting XLSForm

GIS_EP — Thu, 24 Mar 2022 23:31:09 GMT

Hi, I'm facing the similar issue and yes, I'm using windows.

Can you please explain why it's happening?