topic Re: survey Failed to export to GDB in ArcGIS Survey123 Questions

survey Failed to export to GDB

WhitneyWeber — Thu, 06 Jun 2019 15:41:06 GMT

I have a survey which contains polygon and line feature classes (collected via Collector) that are related to the main survey's points via relationship classes. Unfortunately, when I try to Export to gdb from survey123.arcgis.com, I get a Failed to export error. Does anyone know what causes this or how I can resolve the problem?

Re: survey Failed to export to GDB

WhitneyWeber — Fri, 07 Jun 2019 18:18:27 GMT

Unable to export my survey to gdb via survey123.arcgis.com (see error above), I tried another way. Interestingly, I was able to successfully download the survey to gdb via the Python script referenced in this document. Has anyone had this problem before or know what causes it/how to avoid it?

Re: survey Failed to export to GDB

BrandonArmstrong — Mon, 10 Jun 2019 16:51:22 GMT

Hi Whitney,

What happens when you attempt to export the data from the Item Details page within ArcGIS Online?

Re: survey Failed to export to GDB

WhitneyWeber — Mon, 10 Jun 2019 19:23:39 GMT

Brandon,

I get the following error, regardless of what file title or folder I use, so the error is not correct:

An existing File Geodatabase item was found with the same title, 'gobbledygook'. Please choose a unique title and try again.

Re: survey Failed to export to GDB

EstellaSmith — Fri, 21 Jun 2019 13:40:01 GMT

Whitney,

I'm getting the same error message when trying to export my points from Survey123 under the Data section.

Re: survey Failed to export to GDB

Anonymous User — Fri, 21 Jun 2019 13:51:02 GMT

I am also receiving this error, but only when selecting the File Geodatabase as an export format. I am however, able to go into the Feature Details, then into the REST page to produce a usable FGDB.

Then using the "Create Replica" at the bottom of the page allows me to pull the FGDB from the AGO website.

Re: survey Failed to export to GDB

WhitneyWeber — Fri, 21 Jun 2019 15:04:07 GMT

Estella,

Following are two workarounds that have worked for me:

In arcgis.com, navigate to the Feature Layer (hosted) used by the survey.
Within the details of the feature layer, choose Export Data, Export to FGDB.
If, despite the Title you give the file, it refuses to export, do so with the python script as explained in this solution.
Go to the Content tab and select the folder in which the FGDB was saved and the saved File Geodatabase should be listed.
Select the saved File Geodatabase and in the details page, to Download the file.

I can't explain why it fails sometimes in Survey123 - I'm guessing it's a bug.

Whitney

Re: survey Failed to export to GDB

WhitneyWeber — Fri, 21 Jun 2019 15:04:27 GMT

Mike,

Following are two workarounds that have worked for me:

In arcgis.com, navigate to the Feature Layer (hosted) used by the survey.
Within the details of the feature layer, choose Export Data, Export to FGDB.
If, despite the Title you give the file, it refuses to export, do so with the python script as explained in this solution.
Go to the Content tab and select the folder in which the FGDB was saved and the saved File Geodatabase should be listed.
Select the saved File Geodatabase and in the details page, to Download the file.

I can't explain why it fails sometimes in Survey123 - I'm guessing it's a bug.

Whitney

Re: survey Failed to export to GDB

Anonymous User — Fri, 21 Jun 2019 16:43:26 GMT

Hey Whitney,

Thanks for the workaround, but I am able to pull the data in the FGDB format using the REST API dialog without issues. However, to add more mystery to this thread; I found these within "My Main Content" folder today; which means the process is still being carried out int eh background, but the delivery of the data package is not working within the Survey123 or ArcGIS Online GUI programming; or something along those lines.

I almost never save the FGDB's within my AGO account and I know I did not save these here and that makes me think it is something to do with the behind the scene coding for status updating and delivering requested data package.

Re: survey Failed to export to GDB

WhitneyWeber — Fri, 21 Jun 2019 17:16:46 GMT

Yeah, I noticed those too. If you review my instructions, that's how I was downloading the FGDB after exporting. You were using a different method, which also works, evidently and is good to know. Notice I also linked to another solution which allows for downloading to fgdb via a python script. I've used that method too. Helpful to have various ways given that the download from Survey123 isn't always working for whatever reason. I'm happy to know it's not just my survey/data, which is failing!

Re: survey Failed to export to GDB

Anonymous User — Fri, 28 Jun 2019 11:22:52 GMT

This is the first time that I had encountered an issue with the downloading of the FGDB from the Survey123 website, but it is definitely nice to have workarounds as just in case.

Re: survey Failed to export to GDB

CoryBolen1 — Wed, 17 Jul 2019 13:56:14 GMT

I am having this same issue of downloading the associated Survey123 hosted feature layer to a file geodatabase. I tried all of Whitney's options and work arounds. Any other ideas?

Re: survey Failed to export to GDB

CoryBolen1 — Wed, 17 Jul 2019 13:57:54 GMT

Hi Mike - Is there a document of any sort or steps that you can share in regards to the workflow you descrived to produce a FGDB of a Survey123 hosted feature layer?

I tried Whitney's work around options with no luck.

Thanks,

Cory

Re: survey Failed to export to GDB

Anonymous User — Thu, 18 Jul 2019 00:28:06 GMT

Hey Cory,

Here is the best that I can do...

GO to the details page of the hosted feature service that you are interested in downloading data from.
On this page to the right-hand side of the page will be "Details" section
Directly under the word "Details" is a Source: Feature Service and you will notice that it is a hyperlink. Click on it.
This will send you to the ArcGIS REST Services Directory.
Here you will see a lot of useful information about your survey. You will see each of the layers and related table/features if your survey has them.
Pay attention to the numbers within the "()" at the end of each layer or tables name. as this will help within the next couple of steps.
If you click on any of the names then you will brought to another page that contains the schema for each of them.
Scroll to the bottom of this page and locate the "Create Replica" at the bottom of the page and click on it.
This will lead you to a GUI that will allow you to request through the ArcGIS REST API to create and download an FGDB.
Remember the numbers after the layers in "()" as you will need them in this instances. If there is one layer that you are after, then you can enter just the number of the layer. However, if you are attempting to download the entire Hosted Feature service then you will need to enter all of the numbers. separated by a comma.
If you would adjust this dialog to look like the screen shot and click on "Create Replica", then the GUI will make a request using the REST API to create a replica with the layer(s) and any associated attachments.
The page will refresh and you will see a hyperlink at the bottom of the page. Click on that link and it will take you to another page that you will be able to download the zipped FGDB from.
I use FireFox as y web browser and in order to see if the FGDB is ready for download I have to manually refresh the web browser by clicking on the refresh button. However if you use a different browser, then you might be able to click on the refresh
Once the FGDB is ready for download, then there will be a link that you can click on and it will start the download.

Cheers!

Mike

Re: survey Failed to export to GDB

CoryBolen1 — Thu, 18 Jul 2019 13:25:07 GMT

Perfect, it worked. Thank you for your detailed response!

Re: survey Failed to export to GDB

Anonymous User — Thu, 18 Jul 2019 20:31:26 GMT

Hey Cory, no worries and anytime..I have received so much help from the community that it is good to reciprocate the karma...

Re: survey Failed to export to GDB

JamesTedrick — Wed, 07 Aug 2019 16:13:30 GMT

Hi Cory,

How many records are you attempting to download? Does the feature class have one layer or multiple layers?

Re: survey Failed to export to GDB

TI — Tue, 07 Apr 2020 23:12:38 GMT

I'm having this problem with a survey that only has 9 records, but hundreds of questions (attributes).

I'm trying to use the REST/Replica work-around, but I'm having various problems getting it to work depending on the options I choose.

For all my test runs, I'm entering:

Name=TEST
Layers=0
Data Format=FILEGDB
Sync Model=none
- without this, I get the error: Create replica to FILEGDB data format is supported for "none" sync model type only.
Attachments Sync Direction=bidirectional
- without this, I get the error: CreateReplica with returnAttachments=(True) and attachmentsSyncDireciton=(none) is not supported.

I just get the error "Exporting data for layer 0 failed".

This occurs whether I have Return attachments "true" or "false".

Can anybody provide more information in how to use this Create Replica form in the case of downloading Survey123 data? Any other form items I need to change to get this to work?

Has anybody got it to work with attachments?

Even without attachments, It fails with some unexplained error. Any ideas?

Re: survey Failed to export to GDB

TI — Wed, 08 Apr 2020 01:06:07 GMT

PS. I've just found this "under consideration" bug: BUG-000113141: Exporting survey results to file geodatabase format ..

Which indicates that it's not possible to export to File Geodatabase if there are survey labels (attribute aliases?) greater than 255 characters.

However, this does not apply to our survey that we're having trouble with.

Re: survey Failed to export to GDB

Katie_Clark — Wed, 08 Apr 2020 20:51:59 GMT

We have this happen all the time with our surveys and have to download the file geodatabases via the workaround through the REST endpoint.

Unfortunately, I double checked and we don't have any labels longer than 255 characters. So maybe there is some other kind of bug as well?