Survey123 exporting name rather than label

9052
34
12-06-2017 03:39 PM
GarretDubois
New Contributor II

I have a field in my survey that is showing the information in the name column rather than the label column when the data is viewed in survey123 for ArcGIS, or exported from survey123 to AGOL.

There are other rows that are similar in the survey but are showing up correctly in the data tables when viewed in survey123 for ArcGIS.

Question 1. Does anyone know why this is happening?

Question 2. Is there a way to fix this problem?

0 Kudos
34 Replies
JohnathanHasthorpe
Esri Regular Contributor

Hi Garret

What question type are you using for the problem fields - are they select_one? If so, this is a known limitation.

It might be helpful if you share the survey and highlight the problem questions.

Thanks

John

0 Kudos
GarretDubois
New Contributor II

Good morning Johnathan,

The question type is a “select one” question and directly below it in the survey is a similar question that displays properly.

Attached is the survey and the problem question (select_one dca_code) is highlighted in yellow. The problem is that when we view the submitted data in Survey123 for Arcgis or export it from there, that the column is populated with the information in the name column which is just a number, rather than the information in the label column which is the name of an insect or fungus.

Thanks for your help

Garret Dubois

Biological Science Technician

Forest Service

Alaska Region, S&PF Forest Health Protection

p: 907-374-3758

garretddubois@fs.fed.us<mailto:garretddubois@fs.fed.us>

3700 Airport Way

Fairbanks, AK 99709

www.fs.fed.us<http://www.fs.fed.us/>

<http://usda.gov/>[Forest Service Twitter]<https://twitter.com/forestservice>[USDA Facebook]<https://www.facebook.com/pages/US-Forest-Service/1431984283714112>

Caring for the land and serving people

0 Kudos
JamesTedrick
Esri Esteemed Contributor

Hi Garret,

This is a known issue with select_one questions. The data itself is written as the name column and a domain is created to so that the labels seen in Survey123 will be seen in ArcGIS Online; in all but file geodatabase exports, ArcGIS Online provides the code (choice names) instead of labels.  You can export the data with the labels via ArcGIS Desktop tools - see Problem: Coded value domain descriptions are not maintained after exporting data  .

0 Kudos
LorettaWinton1
New Contributor III

Hello,

Is there perhaps a fix for this by now? It is very vexing that some select_one questions (eg. Damage causing agent) show the value from the "name" column. Whilst most other select_one questions (eg. Host, Tree diameter, etc.) show the value from the "label" column. We want labels.

To make things even weirder, when I look at the individual response, "Damage causing agent" shows the path for the image that is in the choices list.

Any idea what is the cause and fix for these issues?

Thanks,

Lori

JohnathanHasthorpe
Esri Regular Contributor

Hi Lorretta - can you share your survey?

0 Kudos
LorettaWinton1
New Contributor III

I sent the .xls file via email because I couldn't figure out how to attach it here. But here are screen shot of what I mean. I thought I pasted them into the original email from earlier today, but now I notice they aren't there.

0 Kudos
LorettaWinton1
New Contributor III

Here it is!

Thanks

Lori (Loretta) Winton, PhD

Forest Pathologist, SouthCentral & Interior Alaska

Forest Service

Forest Health Protection, R10 Alaska Region

p: 907-743-9460

f: 907-743-9479

lmwinton@fs.fed.us<mailto:lmwinton@fs.fed.us>

LTER

University of Alaska Fairbanks

193 Arctic Health Research Building

PO Box 756780

Fairbanks, AK 99775-6780

www.fs.usda.gov/main/r10/forest-grasslandhealth<http://www.fs.usda.gov/main/r10/forest-grasslandhealth>

www.fs.fed.us<http://www.fs.fed.us/>

<http://usda.gov/>[Forest Service Twitter]<https://twitter.com/forestservice>[USDA Facebook]<https://www.facebook.com/pages/US-Forest-Service/1431984283714112>

Caring for the land and serving people

0 Kudos
ShanaGail1
Occasional Contributor

Help!  I also have this problem.  It's not an issue of exporting, it is that when I look at the data in the hosted feature layer it is not showing the label.  It is a select_one question, and it is not a cascading select. This is a huge problem for me - I had worked around it in a previous publishing of my Survey using a nested if, e.g.  if(selected(${auditorid}, 'abcd1'),'Tom Jones', if(selected(${auditorid}, 'abcd2'),'Calvin Klein',  if(selected(${auditorid}, 'abcd3'),'Tommy Hilfiger', if(selected(${auditorid}, 'abcd4'),'Peewee Herman',if(selected(${auditorid}, 'abcd5'),'Random Guy',if(selected(${auditorid}, 'abcd6'),'Strange Behavior','auditor name unknown')))))) . 

That clumsy workaround made due for the initial publishing of my Survey, but now 40 auditors want to use it and even if I was willing to continue the workaround, Excel has a limit of 7 nested if functions.  I'm supposed to add these new people next week...  I didn't see an answer here in the conversation.  If I'm missing it, apologies in advance.

Thanks, Shana

0 Kudos
ShanaGail1
Occasional Contributor

If this is of help to anyone else...  when I upgraded Survey123 Connect and Survey123 field app to the latest version, it started saving the label again in my Feature Layer.

0 Kudos