topic Re: Exporting data from Survey 123 in ArcGIS Survey123 Questions

Exporting data from Survey 123

SLouq — Thu, 31 May 2018 14:14:40 GMT

I have some data that was collected on an ipad out in the field which is connected to Survey 123. I want to Export the data to an Excel sheet but the Export tab is greyed out at the top of Survey 123. When I hover over the tab a message pops up saying, 'Export cannot work since Extract Capability is missing in the underlying feature service. Can anybody tell me what is going on?

Thanks

Re: Exporting data from Survey 123

CarmelConnolly — Fri, 01 Jun 2018 16:05:23 GMT

Hi Scott,

Can you try heading to your Content page in ArcGIS Online > Navigate to the survey folder > Open the item details pages of the survet feature service > Settings > Scroll down to the bottom and enable Export Data

> Click Save.

Head back to Survey123 and see if the Export tab is live now.

Carmel

Re: Exporting data from Survey 123

SLouq — Fri, 01 Jun 2018 16:13:25 GMT

Thank you Carmel!

Re: Exporting data from Survey 123

DavidHockman-Wert — Tue, 19 Jun 2018 00:02:54 GMT

Hi Carmel,

Is this a new setting? Or did it get changed automatically in the recent past?

I only noticed today that Survey123 surveys that I had exported/downloaded multiple times in the past (months ago) were unable to be exported. Thank goodness I found your solution in this thread, or I wouldn't have known how to fix what had not been a problem previously.

Thanks,

Dave

Re: Exporting data from Survey 123

CarmelConnolly — Tue, 19 Jun 2018 07:37:38 GMT

Hi David,

I'm not sure if settings have been changed - tagging Survey123 for ArcGIS‌ to see if the team are able to shed any light!

Carmel

Re: Exporting data from Survey 123

ClaudiaBlagu2 — Tue, 26 Jun 2018 09:53:53 GMT

Hi,

I have the same issue, but I cannot find any option to Export Data. Is there any difference if I have it over the ArcGIS Server and is linked to a layer in my database? Should I enable there some things also?

Many thanks,

Claudia Blagu

Re: Exporting data from Survey 123

CarmelConnolly — Wed, 27 Jun 2018 11:42:03 GMT

Hi Claudia,

Can you try navigating to Server Manager > Edit the service properties > Capailities > Feature Access > Enable Extract:

If that doesn't work let me know! There are some subtle differences between Survey123 services created through ArcGIS Online, hosted in ArcGIS Enterprise and using existing data.

Carmel

Re: Exporting data from Survey 123

WendiPedersen — Thu, 18 Apr 2019 14:30:39 GMT

I am having the same issue with Survey 123 on my portal. only I cannot implement the solution you just gave because those options don't appear on my server administrator. So what may be the reason why I don't have the option shown above as well as not the button to allow data to be exported?

Thanks!

Wendi

Re: Exporting data from Survey 123

CarmelConnolly — Thu, 18 Apr 2019 14:36:56 GMT

Hi Wendi,

What version of ArcGIS Enterprise are you running? Where is the source of the layer in question? Is it a hosted data store layer or coming from an enterprise geodatabase (SQL/Oracle)?

Can you perform any analysis on this layer through a webmap?

Carmel

Re: Exporting data from Survey 123

WendiPedersen — Thu, 18 Apr 2019 14:46:33 GMT

We are using version 10.6.1 Enterprise. The layer is hosted in the ArcGIS datastore on the server. Would it be that we need to transfer everything to the enterprise geodatabase to solve the issue?

Also, I just ran a buffer analysis and it worked. others did not work because there are less than 60 points in the dataset from the survey at the moment.

Thanks so much!

Wendi

Re: Exporting data from Survey 123

CarmelConnolly — Thu, 18 Apr 2019 14:49:46 GMT

Hi Wendi,

Can you navigate to the Item Details page of the hosted feature layer in your portal > Settings > Feature Layer (Hosted) > Is there an Export Data option here?

Carmel

Re: Exporting data from Survey 123

WendiPedersen — Thu, 18 Apr 2019 14:56:56 GMT

Ya we checked this and the option is missing in both the general and feature layer tabs

Re: Exporting data from Survey 123

CarmelConnolly — Thu, 18 Apr 2019 15:05:28 GMT

Hi Wendi,

Seems to be some differences here. How was this layer created? Through the Survey123 publishing process, saved from a csv added to a webmap or another method?

Carmel

Re: Exporting data from Survey 123

WendiPedersen — Thu, 18 Apr 2019 15:07:32 GMT

It was created through the Survey 123 publishing process

Re: Exporting data from Survey 123

CarmelConnolly — Thu, 18 Apr 2019 15:20:34 GMT

I see, something seems amiss with this Survey123 layer, it's got limited functionality that I would expect with a layer view or layer created from a csv/shapefile. - the help says the results of your survey can't be exported into KML or XLSX (Excel) formats but other formats are supported: https://doc.arcgis.com/en/survey123/reference/survey123withenterprise.htm#ESRI_SECTION1_F5A1901B74F54A728668DC98AA2FDFCB

I recommend getting in touch with your local Support team, doing something like a screenshare might get to the bottom of this!

Carmel

Re: Exporting data from Survey 123

WendiPedersen — Thu, 18 Apr 2019 16:05:10 GMT

Thanks for your help. So it seems that this was because the Survey123 services "forgot" it was a hosted service. This happened because at some point our server was removed as the "hosting server" in the portal and then re-set as hosting server. Even though it was reset it caused the hosted services to forget what they were.

Re: Exporting data from Survey 123

DavidForbuss1 — Wed, 15 May 2019 23:48:17 GMT

I'm having this issue as well. It seems that I'm the only one that is able to export (I created/own the survey), but nobody else in our organization is able to. They are able to view the survey data via the Survey123 web interface, but their export button is greyed out.

Re: Exporting data from Survey 123

SLouq — Thu, 16 May 2019 13:03:00 GMT

Hi David,

Make sure the 'Export' option is checked in Settings for the feature you want to export

Re: Exporting data from Survey 123

StefaanMinne — Thu, 29 Aug 2019 08:15:11 GMT

For the feature layer (hosted, view) aka _stakeholder, not only the setting : "allow export .... " should be enabled, also enable editing needs to be activated, at least on our portal server .

good luck

Re: Exporting data from Survey 123

BugPie — Wed, 15 Jan 2020 17:11:57 GMT

Did your org find a solution or workaround for this? Seems as though we are in the same boat. Have a ticket open but I'm antsy....