Text field doesn't export

1716
5
Jump to solution
10-21-2021 12:51 AM
AylaZiger
New Contributor II

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.

0 Kudos
1 Solution

Accepted Solutions
Nicole_Ueberschär
Esri Regular Contributor

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.

geonet.PNG

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):

Attributes.PNG

 

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!

View solution in original post

5 Replies
DeonLengton
Esri Contributor

Hi

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 

DeonLengton_3-1634808612840.png

 

Scroll down till you see URL at the bottom right

DeonLengton_1-1634808401303.png

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: * 

DeonLengton_4-1634808739799.png

Then click on Query (Get)

AylaZiger
New Contributor II

Hi!

Thank you for your time, Deon!

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

AylaZiger_0-1634851500907.png

AylaZiger_1-1634851538709.png

 

 

0 Kudos
AylaZiger
New Contributor II

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

0 Kudos
Nicole_Ueberschär
Esri Regular Contributor

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.

geonet.PNG

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):

Attributes.PNG

 

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!

AylaZiger
New Contributor II

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

0 Kudos