topic Re: Survey publishing error: supportsApplyEditsWithGlobalIds in ArcGIS Survey123 Questions

Survey publishing error: supportsApplyEditsWithGlobalIds

SamanthaNakata1 — Wed, 21 Jun 2017 22:36:09 GMT

I am currently trying to publish a survey with a custom SDE-based feature service. The service includes the point feature layer with a related table (relationship via a GUID; for repeats);the related table has attachments enabled.

The submission url in the form has been edited to that of the feature service, so something like:

http://utility.arcgis.com/usrsvcs/servers/.../rest/services/[FolderName]/[ServiceName]/FeatureServer

When attempting to publish the survey I receive the error:

The custom feature service submission url is not compatible with this survey (The feature service does not meet the requirements for a survey with repeats - supportsApplyEditsWithGlobalIds)

I have not been able to find much about this particular error online--anyone who overcame a similar issue? The error message seems to indicate an issue with the relationship to the related table? But I was able to publish a survey with this database structure previously with no problems. I have also tried to publish the survey with a GLOBAL ID-based relationship, but this also did not work.

Thanks all.

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

JamesTedrick — Wed, 21 Jun 2017 22:55:32 GMT

Hi Samantha,

Please refer to Use Survey123 with existing feature services—Survey123 for ArcGIS | ArcGIS for more information on feature service configuration. The easiest way to have a service compatible with Survey123 is to enable the 'Sync' operation on the Feature Service- this will set up the properties for the applyEditsWithGlobalIds to be true. If you can't get this property enabled, it's likely you've missed a configuration setting, such as ensuring that the service has a gloablid field.

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

deleted-user-W_yQcrEspYZL — Mon, 24 Jul 2017 18:16:27 GMT

James ~ I also have this problem. I checked my data and I have Global IDs and the feature service is set to sync. However, in the documentation you referenced, it says "The data cannot be versioned." Why is that the case? That's going to be a problem for us. Do you have a suggested work-around so we can continue to use a feature service that's linked to a versioned SDE? Thank you.

John

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

SamanthaNakata1 — Mon, 24 Jul 2017 18:23:01 GMT

Having noticed some other users having a similar issue, I thought it might be worthwhile to mention that my particular issue was traced back to ArcServer compatibility (related tables only supported with ArcServer 10.3.1+ using the lastest Survey123 version).

(For the record, I was not trying to use versioned data, so that wasn't a factor in my instance of the error.)

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

ScottLew1 — Fri, 29 Dec 2017 20:58:19 GMT

I also got a similar error, please see attached showing screen shots for reference.

I have a hosted feature layer on our organization’s AGO site. The layer has a related table which uses GlobalID's for the relationship – it was made using methodology described here.

Screen shot #1 shows the error, so I went to Apply Edits from the Supported Operations section at the bottom of the respective Service URL pages for the layer and related table (screen shots #2 and #3, which appears similar to this.

I selected "True" for Use GlobalIds for both and applied edits, but this didn't save the "True" setting.

Will having the Use GlobalIds set to "True" solve the issue and what role does the note on top "This operation is only supported via POST" play as far as publishing in Survey123?

As far as the submission_url on the Excel settings tab, the automatically generated URL is - https://www.arcgis.com/sharing/rest/content/items/0d7f1a3e66304036a69c52aa1d1c640e

The URL obtained from the item details page, as described here, is -

https://services1.arcgis.com/8CpMUd3fdw6aXef7/arcgis/rest/services/Controller_Related_Table/FeatureServer

The error message comes up when I use either of the URLs. Which URL should be used in order to publish in Survey123?

Thank you in advance.

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

SamanthaNakata1 — Fri, 29 Dec 2017 21:03:13 GMT

Hi Scott,

In my case it was not a URL issue but rather an ArcGIS for Server version issue--supportsApplyEditsWithGlobalIds error did not go away, because related tables are not supported pre 10.3, in our case.

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

JohnathanHasthorpe — Tue, 02 Jan 2018 00:13:34 GMT

Hi Scott

When defining the submission_url for a survey - you need to paste in the url of the service item, not the actual service url. Also, the error message you are getting indicates that the service does not have the property of supportsApplyEditsWithGlobalId set to true.

For a feature service to support applying edits with Global IDs, the following requirements must be met:

The layers in the feature service must have a globalid column with a unique index.
The data cannot be versioned.

A quick way of implementing the above is to enable the sync capability on publishing the feature service. Once you do this you should be able to publish the survey in connect.

Cheers

John

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

ScottLew1 — Tue, 02 Jan 2018 20:40:49 GMT

Hi John,

Thank you for your response.

I set the Enable Sync and confirmed the feature layer is not versioned; however, the supportsApplyEditsWithGlobalId message still appeared with the automatically generated submission_url.

I pasted the URL of the service item to replace the automatically generated URL and the supportsApplyEditsWithGlobalId message no longer appeared; however, another message, Request error Missing serviceItemId appeared (please see attached screen shots showing the different URLs and error messages).

Any idea on what is causing this? Why do you think supportsApplyEditsWithGlobalId appeared, even after setting Enable Sync and confirming the feature layer is not versioned? Thanks in advance.

Best,

Scott

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

JohnathanHasthorpe — Wed, 03 Jan 2018 00:49:50 GMT

Hi Scott

The correct url is: .https://www.arcgis.com/sharing/rest/content/items/5c312f83a4d4420ba1d70441b9986eb3

This will ensure that you don't get the serviceItemId error.

If you go into the the service url and then view it in JSON:

Can you check the status of the of following property:

"supportsApplyEditsWithGlobalIds"

It sounds like this is set to false when it should be set to true - please confirm.

To enable, you should make sure you follow the guidance here: Use Survey123 with existing feature services—Survey123 for ArcGIS | ArcGIS

You will need to check the layers in the feature service have a globalid column with a unique index. This will need to be done by looking at the data layers in desktop before publishing the service.

In terms of the sync capability - this only works if enabled in desktop on publishing (not in ArcGIS Online).

Thanks
John

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

ScottLew1 — Wed, 03 Jan 2018 21:34:20 GMT

Hi John,

Attached is a zipped FGDB; it is a revised copy of the FGDB posted to my organization’s ArcGIS Online site to create the Feature Layer I am trying to publish in Survey123 Connect. Please note some records in both the feature class and related table have field photo attachments.

I created the feature class and related table in the FGDB based on guidelines from this blog – https://community.esri.com/people/MKellyesri-ireland-ie-esridist/blog/2016/11/18/related-data-in-arcgis-online

Regarding the status for ‘supportsApplyEditsWithGlobalIds’, below is the JSON screen shot showing:

· "isDataVersioned" : false

· "supportsApplyEditsWithGlobalIds" : true

Thank you for your time.

Best,

Scott

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

JohnathanHasthorpe — Sun, 28 Jan 2018 00:34:01 GMT

Hi Scott,

You need to ensure that you build the relate based on the GlobalID field of the parent layer and GUID field (parentglobalid) of the child table. The original workflow you followed was not designed for Survey123 feature services.

Thanks

John

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

PaulCone2 — Wed, 21 Feb 2018 23:48:30 GMT

I'm stuck on this error, too. I have a service (used for building inspections) that I have been using on Collector for a couple of years, and now I'm trying to transition to Survey123. I created a new survey using that service, but then as I was working on it in Connect, adding logic to the form and such, it became apparent that I would need to create a new service because of the way the logic needed to work against the schema. So I modified my source file geodatabase and then I recreated the join using GlobalID and GUID, and then created a new service. But I don't want to lose all the work I did on the form so I am trying to publish the form into the new service, but then I get the error. I've double-checked the join and Sync is set but I still get supportsApplyEditsWithGlobalIds as false and it won't go. What else is there to check?

Paul

P.S. I'm running beta 2.7.13.

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

JamesTedrick — Thu, 22 Feb 2018 20:48:55 GMT

Per Layer (Feature Service)—ArcGIS REST API: Services Directory | ArcGIS for Developers :

supportsApplyEditsWithGlobalIds will be true if the layer supports applying edits where globalid values provided by the client are used. In order for supportsApplyEditsWithGlobalIds to be true, layers must have a globalid column and have isDataVersioned as false. Layers with hasAttachments as true additionally require attachments with globalids and attachments related to features via the features globalid.

The two things to check would be versioning and if the attachments are set up to use globalids.

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

PaulCone2 — Fri, 23 Feb 2018 23:51:33 GMT

Thank you James -- I'm pretty sure it's because I neglected to update the relationship with the inspections attachments (i.e. photos) to use GlobalIDs instead of OBJECTIDs. So do I use GlobalID on both, or do I have to set up a GUID field on the latter? I'm still a little murky on GlobalID vs GUID. I found this post but it doesn't completely answer the question...

https://www.reddit.com/r/gis/comments/2qqoib/arcmap_guid_vs_global_id/

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

JohnathanHasthorpe — Sun, 25 Feb 2018 02:34:33 GMT

Hi Paul - you will need to build the relationship based on GlobalID for the parent featureclass and GUID for the child table (you will need to create this).

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

PaulCone2 — Mon, 26 Feb 2018 23:01:10 GMT

@Johnathan, I think you might be misunderstanding my complete schema so I'll explain it.

It is for building inspections, post-earthquake, using the ATC-20 form. So we start with a feature class (building footprints), and then we have a one-to-many relationship with inspections, now using GlobalID and GUID. Each inspection though can have multiple photos taken in the field, so that is another one-to-many relationship. So it's feature class, to a related table, and the items in that related table can have attachments in another related table. My question is for the photos related to the inspections, which are related back to the building footprints, how does the relationship need to be created? Is it GlobalID (of the inspection) to GUID (of the photo)? In any case I can't create a GUID value for an attachment that hasn't been created yet.

For what it's worth, this setup has worked fine in Collector without any GlobalIDs or GUIDs for a couple of years now.

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

JohnathanHasthorpe — Tue, 27 Feb 2018 12:26:38 GMT

Sorry Paul - I miss read your comment. Yes - you will need to use GlobalIDs for the relationship between the attachment and the inspections table. So you need to make sure the inspections table has a valid GlobalID field and then you can enable attachments on it in the GDB.

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

PaulCone2 — Wed, 28 Feb 2018 00:24:05 GMT

Thank you James and Johnathan for your help so far. To tangent a bit... how do you get the name of the attachments to the inspections table, which is related to the building footprints? I followed Ismael's instructions here but I keep getting "Table photorepeat not found". I also found a few references to repeating photo attachments, but nothing definitive...

https://community.esri.com/thread/176053

https://community.esri.com/thread/188443-is-it-possible-to-use-a-repeat-with-attachments-in-survey123#comment-659464

And here is a snip from my survey. Note that this is in a group (i.e. the related table with the inspection)...

begin repeat	photorepeat	Photos
image	photo	Photo
end repeat

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

JohnathanHasthorpe — Mon, 05 Mar 2018 04:20:15 GMT

Hi Paul

As a recap you have a buildings (feature-layer) and inspections (table) and you have enabled attachments on the inspections table. This means that your survey would have building questions and then a repeat called inspections (or something like that) containing the questions for the inspections table.

You don't need to include the related table for your photos in the survey - this is why you are getting the error. Any image attachments will be added to the inspection record on collection, and then linked to the appropriate survey question via a keyword (the keyword equals the image question name) for the purpose of display. So all you need to do is to add one or more image questions inside the inspections repeat. You can all them whatever you want and have as many as you want - they don't become fields in the inspection table. The only requirement is that you have enable attachments on the table, which I know you have.

So to answer you question: how do you get the name of the attachments to the inspections table: you can't. Attachments do not have a corresponding field, they are just related to the feature/record they were collected against. The Survey123 website is however able to use the keyword/question name property for an attachment to make it possible to view and print image questions like they are fields.

I hope this helps

John

Re: Survey publishing error: supportsApplyEditsWithGlobalIds

PaulCone2 — Mon, 05 Mar 2018 18:40:55 GMT

John,

You are correct in your description of the relationships. However, your statement "add one or more image questions inside the inspections repeat" seems to indicate that I should add multiple questions for photos -- which is method one, in Ismael's comments here -- but that is not what I want to do, because I want the user to be able to add one photo, or 10 photos, or 100 photos, and not be limited. So I want to follow the second method, which indicates I should use a photo in a repeat, so in order to do that there must be a name, per the image in Ismael's post -- I think this is what you might be getting at when you say, "If you were to add an image within the repeat, it would be modeled as attachments to the related table." How do I tell Survey123 to take repeated photos and model those attachments without a value in the name column?

I'd be happy to post attachments and give you access to the survey URL if that would help.

Paul