topic Survey123 Connect Crashing from CSV File in ArcGIS Survey123 Questions

Survey123 Connect Crashing from CSV File

SeanHorman — Mon, 25 Mar 2019 13:14:02 GMT

I have a CSV with 4700 rows, 20 columns. When I open the survey in connect it crashes. If I remove the CSV file from the media folder everything works fine.

So my question is, would it be the size of the file causing the issue?

Re: Survey123 Connect Crashing from CSV File

DougBrowning — Mon, 25 Mar 2019 16:30:00 GMT

I assume you mean a external_choices sheet? If so make sure there are no special chars in your name OR label Or any other custom field. Big one is commas. I had a few buried in my choice list labels and it messed up a bunch of stuff. Also watch out for \, etc.

Also can try a copy to a brand new Excel and save. Make sure to do Paste Values when you do this.

Re: Survey123 Connect Crashing from CSV File

SeanHorman — Mon, 25 Mar 2019 16:47:18 GMT

Yeah using it as a pulldata sheet to perform some calculations based off survey selections. I thought that may have been the problem so I went through and removed everything even spaces, still same situation of crashing.

I have found that after successfully launching the survey if I move the file back into the media folder it will perform as normal. This is causing some real head scratching for myself, I even uninstalled/reinstalled Connect.

Re: Survey123 Connect Crashing from CSV File

DougBrowning — Mon, 25 Mar 2019 16:52:03 GMT

Have you tried deleting the xls it makes complexity from the file system (move it no real delete) and let Connect remake it from the external_choices?

Re: Survey123 Connect Crashing from CSV File

DougBrowning — Mon, 25 Mar 2019 16:57:17 GMT

Looking at your sheet I have two more guesses.

One is your values in the first column are really long. One was 82 chars. Not sure if you are hitting a limit.

Two is you have columns with only numbers as the Name of the column. Try something like Column1 instead of just 1.

Re: Survey123 Connect Crashing from CSV File

SeanHorman — Mon, 25 Mar 2019 18:15:20 GMT

Ok replacing the column names from numbers 1,2,3,4,5,6 worked so far. Thank you for the suggestion, I'll update if I find anything else.

Thanks for the idea!