topic Re: Text field doesn't export in ArcGIS Survey123 Questions

Text field doesn't export

AylaZiger — Thu, 21 Oct 2021 07:54:42 GMT

Hello!

I am having some trouble while trying to export the data collected through Survey123. There is one text field exported without the data. This specific question has some rules in the Relevant field. I think I might have missed out something and wish some of you could help me find a solution for that.

The survey has a select one question (q02_Logradouro) in wich the we can choose between street, avenue, road, etc.. Then, for each one of these options, there is a text field related (q02_Logradouro_Rua; q02_Logradouro_Avenida; q02_Logradouro_Rodovia; q02_Logradouro_Alameda; q02_Logradouro_Travessa) for us to enter the name of the street, avenue, road, etc., each one shown only if the correspondent option is selected. There is a "other" option with the same logic, and it is working perfectly fine.

The problem here is that the text field for the name of the street, avenue or road isn't exported among the other data collected. I've already tried exporting it in FGDB and CSV. Also, on the Survey123 Data tab, the data corresponding to the text field appears normally when I search it on the complete entry, but still doesn't appear on the Survey123 spreadsheed.

I've attached some screenshots of the xlsform, the exported data and the Survey123 spreadsheet (had to blur personal information out of it), as well as the survey xlsform itself, hoping that it can help you understand the context better and maybe help me find a solution for this.

Thanks for your attention.

Re: Text field doesn't export

DeonLengton — Thu, 21 Oct 2021 09:34:10 GMT

I don't think the issue is in the design of your survey - I looked for reserved keywords in your field names but doesn't seem that you have any of those.

I would then wonder if it isn't a special character perhaps in the data of your street names?

If you go to the REST endpoint of your layer and do a query there, do you see the data there?

On the Feature Layer page of your survey:

Click on Overview

Click on the Feature Layer of your survey to open it up

Scroll down till you see URL at the bottom right

Open the URL up

On the REST landing page of your service:

Click on Query

In the where clause, type 1=1

And in the Output fields type a star: *

Then click on Query (Get)

Re: Text field doesn't export

AylaZiger — Thu, 21 Oct 2021 21:25:59 GMT

Hi!

Thank you for your time, Deon!

I can't find the Query option on the REST landing page.

Re: Text field doesn't export

AylaZiger — Mon, 25 Oct 2021 05:08:19 GMT

Still haven't figured it out. If someone has an insight on this, it is more than welcome.

Re: Text field doesn't export

Nicole_Ueberschär — Mon, 25 Oct 2021 11:31:59 GMT

Does the data not show in general for all entries or only for certain filled information? I just tried to reproduce the issue and I am wondering if you maybe just not see the right column? I am having 5 columns with the same label that all show the data correctly.

Sometimes, when you add additional fields after publishing the survey, the new fields are added at the end of the table. So maybe check in the list of attributes if you are seeing all of them (far right of the attribute table in Survey123):

If this is not helping, I normally start from scratch again to find the problem. In this case I published now for example only the problematic fields in their context to test them.

Good luck!

Re: Text field doesn't export

AylaZiger — Fri, 05 Nov 2021 11:21:58 GMT

Thank you, Nicole!! That was exactly what happened.