Survey123 Connect - Schema Preview Empty

[OscarSepulveda_III]

The Schema Preview within Survey123 Connect (v. 2.3.24) is empty for my form.  I have tried deleting the form folder and creating a new form utilizing the generic advanced template without success....

Anyone else have this problem?  

[Anonymous User]

Hi Adam,

It sounds like a parameter, calculation or change you have made to the xls template (by deleting columns etc) may have broken the processing Connect does to validate the form. Can you please provide a copy of your xlxs file so we can look into the issue further?

Phil.

[AdamDaily]

Sure, but I don't see a way to attach and send it to you on here. Can I email a copy?

[Anonymous User]

Hi Adam,

When you reply to this message use the "Use advanced editor" option which is located in top right corner of reply window (see below screenshot), and you will see the option to attach file. Make sure you open this post in full, and not just view in your Inbox in GeoNet, otherwise you will not see that option:

To open the post in full go to this url: https://community.esri.com/thread/201450-survey123-connect-schema-preview-empty 

Phil.

[BrandonArmstrong]

Hi Adam Daily‌,

After taking a look at your XLSForm, it appears that you are using 'pulldata' to reference an external CSV.  As you did not provide either CSV referenced within your form, I removed the calculations referencing them, and refreshed the form.  After doing so, the Schema Preview returned.  I was then able to re-enter them and refresh, which continued displaying the Schema Preview.

Are you aware of any actions that you implemented in regards to referencing the external content that may have affected the functionality?  Can you please try to remove the calculations referencing your external content, refresh the form, and see your results?  In addition, please try to re-enter the calculations and let us know your results.

Thank you,

Brandon

[AdamDaily]

Thanks Brandon for taking a look. Since I sent that I have remade the survey and made changes to the CSV file so it would be hard to go back and retrace my steps if it had something to do with the csv file. 

When Survey was trying to pulldata or draw from a select_one list it appeared it was referencing incorrect cells, thus making my "relevant" statements on other questions to not function properly. I don't think cell number would matter since its searching for a value, but I did first notice this issue after I had deleted rows in the survey and choices worksheets.

I've seen this with 2 surveys now. I often move rows around within the Survey sheet and make changes to the csv files without issue. Since noticing this problem I no longer delete rows in the Choices worksheet of a survey (I delete values within the rows instead) and I have not experienced the problem since.

[KristenJurica]

Has anyone had any luck resolving this issue? I've been working on this for the past few days with no progress.

I ran into problems after reordering repeats then when trying to use relevant statements on groups. For both scenarios the questions don't appear in the form preview and the schema preview is unavailable.

I've updated Survey123 Connect to 2.5.44, manually refreshed my survey, and republished my feature service and restarted the survey creation process. I'm able to look at the xml file for the survey, but the schema preview is still empty. I agree with Adam in that the problem could be with reordering or relevant properties (and maybe repeats), but I've done this with earlier surveys and had no issue. I haven't deleted any columns or changed the schema.

Ideas?

[BrandonArmstrong]

Hi Kristen,

If possible, can you please provide your XLSForm so that we can investigate?  If you would prefer to share it privately, please let me know and I will send you a private message through GeoNet or send you an email.

Thank you,

Brandon

[KristenJurica]

Brandon,

The problem was with the pulldata calculation. After removing it, refreshing my survey, then replacing it in the survey it worked just fine.

Thank you!

[deleted-user-ROabVzfY3erf]

Hi Phil,

Sorry it took so long to reply but I just managed to get the issue fix.

All I did was in Chrome I have to clear the browsing data: browsing history, cookies and other data, cached images and other files.

The Chrome version is Version 63.0.3239.132.

Thanks

Carlos

[AdamDaily]

Carlos,

Can you back up a bit and explain what your issue was and what clearing Chromes browsing history did for Survey? Are you saying that fixed an issue with not being able to start a new survey or preview completed surveys? Are these surveys you collected on your machine using a already published and hosted Survey in AGOL? 

It sounds like a different issue then the schema not appearing in Survey Connect before a survey gets published. I'm trying to understand the issue and what the connection to chrome history is.