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?
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.
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.
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?
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.
Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
