Select to view content in your preferred language

Export data results in choice0, choice1, choice2 values in CSV

4521
13
12-13-2016 03:00 PM
KatjaKrivoruchko
Occasional Contributor

I have created a survey using Survey123 Web, submitted a couple of test forms, and exported the data to CSV. In the output, I see values like choice0, choice2, choice4, etc. instead of the actual choices as in the form. For example, for "Are you living in a vehicle?" question, the possible answer are Yes or No. However, I am seeing answer "choice0" and "choice2" in the output. Same for "Length of Current Homelessness" question - "choice0" instead of actual options from the form.

Is this a known issue? How do I get actual values to show up? The Analyze tab on the website shows actual values, so I know the data is there...

13 Replies
by Anonymous User
Not applicable

I am not understanding how expanding showed you what the choices are?

0 Kudos
JohnPlunkett
Esri Contributor

Hello - not sure if this is what you are after - but I worked with a customer with a similiar issue - waht we did was before publishing the Survey when using the designer we changed the Schema before publishing

So you change the choices and fields to what you desire

by Anonymous User
Not applicable

What did you change in the Schema?

I am getting the Name not the label, and the Name does me no good...

0 Kudos
by Anonymous User
Not applicable

If I publish from Connect to override Survey so the Names display instead of Choice0, Choice1, Choice2 will I lose the data that is already inputted?

0 Kudos