topic Re: How can I copy records into a currently published Survey? in ArcGIS Survey123 Questions

How can I copy records into a currently published Survey?

ThomasHamill — Wed, 13 Apr 2016 13:24:48 GMT

I'm trying to copy some existing survey records from a separate local geodatabase to a currently published survey on AGOL. The schema is the same for both. I've been trying to do this by opening the currently published survey on ArcGIS desktop (using the item.pitem in desktop) with 'Create Local Copy For Editing' and then 'Synchronize Local Edits With Server.' I can copy and paste records in successfully, but when I synchronize local edits with the server, the records don't 'take.' I'm not encountering an error message, the records just don't populate in AGOL. Is there another way I should approach this? Ideally, we want our client to be able to collect records primarily with Survey123 and be able to view and edit these records through ArcGIS Collector.

Re: How can I copy records into a currently published Survey?

CarmelConnolly — Wed, 13 Apr 2016 13:27:43 GMT

Hi Thomas,

Have you tried in ArcGIS Pro? You're able to edit ArcGIS Online feature services directly there without having to take them offline.

Carmel

Re: How can I copy records into a currently published Survey?

ThomasHamill — Wed, 13 Apr 2016 13:48:24 GMT

Hi Carmel,

I have not tried that yet--we haven't yet tested or implemented ArcGIS Pro in our department and I'm not confident we will be doing this until a while later. Is it possible to have ArcGIS Pro and ArcGIS 10 on the same machine? What are my other options?

Tom

Re: How can I copy records into a currently published Survey?

CarmelConnolly — Wed, 13 Apr 2016 14:02:13 GMT

Hi Tom,

Yep, you can have ArcGIS Pro and any version of ArcGIS for Desktop on your machine, they run independently of each other.

Have you been able to try your workflow with a regular ArcGIS Online feature service? The Survey123 feature services I've looked appear to function slightly differently.

Carmel

Re: How can I copy records into a currently published Survey?

ThomasHamill — Thu, 14 Apr 2016 14:02:48 GMT

I haven't tested the workflow with a regular feature service, but may try this. I understand how a schema published with Survey123 could react differently to server/sync.

We may also move forward with an install of Pro on one of our machines. We have 2 Editor licenses and a handful of Basic. Will an install of Pro permanently hold one of these?

Tom

Re: How can I copy records into a currently published Survey?

CarmelConnolly — Fri, 15 Apr 2016 07:29:53 GMT

Hi Thomas,

I'd be interested to hear how you get on with your testing!

ArcGIS Pro is licensed through ArcGIS Online based on the number of Desktop licenses you have - for example for your 2 Editor licenses, you will have at least 2 ArcGIS Online named users, and in there you can assign an ArcGIS Pro license to one of these users. More information can be found here: Manage ArcGIS Pro licenses—ArcGIS Pro | ArcGIS for Desktop . Assigning licenses in this way means that ArcGIS Pro does not permanently hold any of the licenses.

Carmel

Re: How can I copy records into a currently published Survey?

ThomasHamill — Fri, 15 Apr 2016 17:23:03 GMT

Thanks for your help. I have Pro on my machine now. How can I add the feature service for the data from ArcGIS Online to my ArcGIS Pro project? I haven't been able to find this walk-through and the link is broken if I import to the project from my previous MXD. I see that I can't add the item.pitem through the add data menu. The data I'd like to move records into is still in My Content on AGOL.

Tom

Re: How can I copy records into a currently published Survey?

ThomasHamill — Fri, 15 Apr 2016 20:44:52 GMT

I tested the edit and sync with a published service that wasn't through Survey123, shared as service through desktop instead, though it had the same schema as what gets established by Survey123 !. A message saying 'Validating Replica Schema...' appears for a few seconds before ArcMap crashes and prompts me to send an error report. I sent the error report with my email address if that makes a difference.

Tom

Re: How can I copy records into a currently published Survey?

CarmelConnolly — Mon, 18 Apr 2016 17:00:43 GMT

Hi Tom,

To add data from your ArcGIS Online account, click Add Data then under Portal choose My Content:

If you're signed into your ArcGIS Online account, you'll be able to see your data.

I've been able to add my Survey123 feature service, append more data to it and it's been updated grand in Online!

Carmel

Re: How can I copy records into a currently published Survey?

ThomasHamill — Mon, 18 Apr 2016 18:30:04 GMT

This is helpful, thanks! What is the ArcGIS Pro equivalent of being in an edit session and copying features from an XY event layer into the Survey123 feature service? I can select the records I want to add to the Survey123 layer, but when I copy and paste, it just reproduces the XY event layer in the table of contents as opposed to prompting me to select the target layer for pasting features like in ArcGIS 10.

Thanks,

Tom

Re: How can I copy records into a currently published Survey?

CarmelConnolly — Tue, 19 Apr 2016 07:51:56 GMT

Hi Tom,

I'm not sure that the copy and paste functionality works in ArcGIS Pro, although I could be wrong! Instead, I'd convert the XY event layer into a feature class in a geodatabase, select the records I want to copy, and then use the Append tool to add these points to the Survey123 feature service (Input is the converted XY event layer and target is the Survey123 feature service)

Carmel

Re: How can I copy records into a currently published Survey?

ThomasHamill — Tue, 19 Apr 2016 21:04:07 GMT

I'm running into the following error when I try append:

ERROR 001156: Failed on input OID 1, could not write value 'NOT DETERMINED' to output field Maintenance

Failed to execute (Append).

Do the entries that correspond to select_one and select_multiple fields have to be the choice 'name' or the 'choice' label to be able to append?

The value from the XY table based on the existing data is 'NOT DETERMINED' and my guess is it can't append to the service because the choices/domains in its service schema are slightly different. When building the XLS, I used 'NotDetermined' for 'name' because spaces need to be removed and 'NOT DETERMINED' for 'choice.' I haven't looked to see what the domain is in the schema of the service, whether gets established as one or the other...

Seems like I may need to clean up my client's existing data more to get everything to fit together, but maybe there's still some mistake that isn't obvious to me?

Tom

Re: How can I copy records into a currently published Survey?

ThomasHamill — Mon, 25 Apr 2016 17:11:06 GMT

Hi Carmel,

do you think the problem I'm having with the Append tool is related to choice 'names' and choice 'labels' in the Survey? It appears these are treated like domains if I download an FGDB of the published survey, but I am able to paste records into the local FGDB without any problem. What are some other things I could try to find a solution to this?

Thanks,

Tom

Re: How can I copy records into a currently published Survey?

HannahFerrier — Mon, 02 May 2016 06:26:50 GMT

Just to confirm for you Tom,

When you create a choices list in Survey123, it is converted into a coded value domain in the resulting feature service when you publish your survey.

This is to make it easier for non-Survey123 users to edit the feature service.

Hannah

Re: How can I copy records into a currently published Survey?

ThomasHamill — Mon, 02 May 2016 13:36:47 GMT

Thank you, Hannah. I'm not sure what is preventing me from appending records to the Survey123 feature service. Here are the things I've tried:

Appending records from a local FGDB feature class (generated from XY event layer) directly to the Survey123 feature service on AGOL using ArcGIS Pro 1.0.
- Result is ERROR 001156, Append fails

Appending records from a local FGDB feature class (whose schema matches the Survey123 feature service because it was first downloaded from the published Survey123 service and saved locally).
- Records were first copied from the above-mentioned XY event layer into the local FGDB. Edits copied locally could be saved.
- Then when copying from the local FGDB to the Survey123 feature service, the result is Warning 000594, general function failure on all records.

Copying features from local FGDB feature class (generated from XY event layer) within ArcMap 10.3.
- Edit Features-->Create Local Copy For Editing-->Records copied from local FGDB to this new local copy of service (records appear to have copied)-->Synchronize Local Edits with Server-->No error message, but edits do not successfully 'take' after the sync.

Do you have suggestions for other things I might try to resolve this? My goal is to incorporate existing records into a client's new Survey123 service. I'd be happy to share the table of records and my XLS form with you if it would be helpful.

Thank you,

Tom