topic Problem exporting Survey123 data in ArcGIS Survey123 Questions

Problem exporting Survey123 data

JoshHabel — Thu, 01 Feb 2018 21:43:29 GMT

Hello,

I am trying to export inspection data from Survey123 for use in Excel. The problem is that for any of my drop down list questions I only seem to get the "Domain Codes" instead of the actual value. I know there must be a way around this but so far it doesn't matter what I try. I used the export to excel, fgdb, and shapefile but no go. Have I set something up wrong on the Survey123 side? I used Survey123 Connect to build my forms. Any hints or suggestions would be greatly appreciated.

Thanks

Josh

Re: Problem exporting Survey123 data

JamesTedrick — Thu, 01 Feb 2018 23:16:07 GMT

Hi Josh,

This is the expected behavior - ArcGIS Online currently exports only the codes of choices, not the labels of choices.

Re: Problem exporting Survey123 data

Wimvan_der_Drift — Thu, 08 Mar 2018 12:46:54 GMT

hi there, i have the same behaviour , I hope this issue is picked up soon / Wim vdDrift

Re: Problem exporting Survey123 data

JasonRoecker — Wed, 11 Apr 2018 16:47:09 GMT

What is the work around to get usable Excel data out of Survey123?

Re: Problem exporting Survey123 data

JamesTedrick — Wed, 11 Apr 2018 17:48:43 GMT

Hi Jason,

The Excel to Table tool in ArcGIS Desktop has the option to use the domain labels instead of values. Additionally, the web designer now supports changing the value names during the publishing process, allowing the exported Excel table to have more meaningful values.

Re: Problem exporting Survey123 data

JasonRoecker — Wed, 11 Apr 2018 18:58:00 GMT

Thank you, James

Is the changing the value names during the publishing process something that is not accessible in the trial version? I cannot seem to find the Publish Options otherwise.

Regards

Re: Problem exporting Survey123 data

JamesTedrick — Wed, 11 Apr 2018 22:09:10 GMT

Hi Jason,

Nothing is limited in the trial version. Changing the names is available by clicking on the 'Modify Schema' link after pressing the 'Publish' button on the web designer.

Re: Problem exporting Survey123 data

JasonRoecker — Wed, 11 Apr 2018 22:12:25 GMT

Thanks again!

I actually figured it out. I had already published a test survey and the schema was set at that point, at least that's my understanding.

Regards

Get Outlook for iOS<https://aka.ms/o0ukef>