topic Re: Editing Related Tables in Collector in ArcGIS Collector Questions

Editing Related Tables in Collector

NilsBabel — Wed, 04 Feb 2015 15:13:10 GMT

Anybody editing related tables in Collector? The feature was just released in Collector for Android. I'm still waiting for it to be released for iPad before I make any changes to the schema I have set up in my web maps. I'm curious if anyone is using this feature and how they have it setup. Is it seamless to access and edit the related tables? Is it cumbersome or confusing for collector users? Are many to many relationships possible? Any feedback would be greatly appreciated.

Thanks!

Re: Editing Related Tables in Collector

RussRoberts — Wed, 04 Feb 2015 16:59:19 GMT

-When you have a feature service with related tables in a web map you must first enable the popup on the table. If the popup on the table is not enabled the related table will not be displayed in the Collector app.

-You access the related tables through the features popup. From there you can view, edit or delete the related records.

-M to N relationships are not supported in this release.

Russ

Re: Editing Related Tables in Collector

NilsBabel — Wed, 04 Feb 2015 17:06:58 GMT

Thanks Russ, what about adding a related record? Say I create a feature in collector and I want to add a record for it in a related table. Can you do that in Collector?

Re: Editing Related Tables in Collector

RussRoberts — Wed, 04 Feb 2015 17:18:25 GMT

Yup you can add new records to a feature when it supports a 1 to M relationship or if a feature does not have a related record yet in a 1 to 1 relationship.

Re: Editing Related Tables in Collector

MattMcGuire — Thu, 05 Feb 2015 22:22:06 GMT

After enabling the related table popup, I'm getting an "Unfortunately, Collector has stopped" message every time I try to open the features popup. I'm using a very basic set of points, a relationship class and related table in a 1-M relationship.

Any other reports of crashes?

Re: Editing Related Tables in Collector

RussRoberts — Thu, 05 Feb 2015 23:11:58 GMT

Can you share the map to a group and invite Collector4ArcGIS into that group and I can check out the map.

Thanks

Russ

Re: Editing Related Tables in Collector

MattMcGuire — Fri, 06 Feb 2015 17:36:58 GMT

Did so. Thanks!

Re: Editing Related Tables in Collector

RyanDay — Fri, 06 Feb 2015 17:37:42 GMT

Hi Russell,

I am also struggling with getting the related tables setup with collector. Thanks for the info on 'enabling pop-ups' via online, I was able to get this working with an ArcGIS online hosted feature service, but am trying to get it working with an Internally hosted 'Portal' and ArcGIS Server. Do you know what i'm missing with my published feature service, I can't seem to get the 'enable popups' button to show in the online map editor.

I have Sync enabled in the feature service...

Versioned feature class with relationship classes setup to the GlobalID of the origin table, anything else i need?

Re: Editing Related Tables in Collector

RussRoberts — Fri, 06 Feb 2015 18:48:17 GMT

The related table support for Portal is currently not present and will be coming in the next Portal update. Feature to Feature relationships will work in Portal but the Feature to Table support will come in the next update.

Russ

Re: Editing Related Tables in Collector

RyanDay — Fri, 06 Feb 2015 19:04:11 GMT

OK. To clarify, related tables in collector are currently only available via ArcGIS Online 'hosted' feature services then?

The other options being:

ArcGIS Portal hosted feature services,
ArcGIS Server Feature Service connected via Portal
ArcGIS Server Feature Service connected via ArcGIS Online

Do you know what patch or release date this will be available?

Re: Editing Related Tables in Collector

RussRoberts — Fri, 06 Feb 2015 19:20:03 GMT

The reason Portal related table support is not present is due to the web map authoring experience is slightly behind the AGOL map authoring experience. The Portal map author cannot enable related table popups on the table right now in their 10.3 release but will be there in Portal 10.3.1.

ArcGIS Server feature services and ArcGIS Online hosted feature services both support related tables and being used in Collector, the app just requires a popup enabled on the table.

I do not have an exact date for the next release but I will check with the Portal team and update this thread.

Re: Editing Related Tables in Collector

RyanDay — Sat, 07 Feb 2015 16:57:05 GMT

Thanks for the information.

I was able to point an ArcGIS Online instance to my internal AGS and get the enable popups for my related tables to show up. Although I do seem to be getting crashes when I go to 'Show details' of a saved feature, I think as Matt McGuire was saying earlier.

Re: Editing Related Tables in Collector

RussRoberts — Mon, 09 Feb 2015 16:41:57 GMT

Can you share your map with Collector4ArcGIS and I can see if I can reproduce the crash.

Thanks

Russ

Re: Editing Related Tables in Collector

MattMcGuire — Mon, 09 Feb 2015 20:17:36 GMT

I recreated the service to the minimal level to prove the concept to myself. Then I worked backwards reversing the changes until it stopped working again.

For what it's worth, here are the changes I made:

1) Moved the feature service to the root directory of my ArcGIS Server

2) Removed the requirement for HTTPS and a login to the feature service

3) Used a "publisher" account in AGOL (had been using an admin account)

4) Removed all fields save a couple of text fields

At this point, it was working great.

I added more fields back, and ultimately all fields back. Still working great
I tried the admin account. Still working great
returned the service to the secure folder, but with the permissions on the feature service itself wide open. Still working great
Changed the security settings on the Feature Service to allow access to all users who are logged in. Crashes when trying to open the feature popup.

The Feature Service works fine for editing in AGOL.

So there seems to be some problem with editing related tables using secure feature services using the Collector App.

EDIT: I created a feature layer in AGOL referencing the Feature Service in ArcGIS Server with saved credentials. Then I set the map to use the feature layer instead of the feature service directly. Now editing works on the secure service in ArcGIS Collector App for Android. So that's a work around, though not ideal.

Re: Editing Related Tables in Collector

MattMcGuire — Mon, 09 Feb 2015 21:41:40 GMT

See my response to myself above - I am getting the crashes only when trying to directly edit an ArcGIS Server feature service which requires a login.

Re: Editing Related Tables in Collector

RyanDay — Mon, 09 Feb 2015 22:26:36 GMT

Yea, I was about to respond...

After changing AGS feature service to public access, the crashing disappears @ 'Show Details'.

Just about to test your second point about embedding user/pass.

Using a feature layer... 'link?' that embeds user/pass and connects to an internal service worked for me as well.

Only crashed when the map had a direct link to my tokenized AGS feature service.

Re: Editing Related Tables in Collector

RussRoberts — Mon, 09 Feb 2015 22:38:29 GMT

Hey Matt,

I can repro your issue and we are looking into it.

Russ

Re: Editing Related Tables in Collector

MasonBailie — Mon, 09 Feb 2015 23:59:56 GMT

Russell Roberts‌ thank you for your answer to this question as everything works for me now after enabling the popup. Are there going to be any examples in the future on how to make related tables work? I searched for quite a while before going to the forums (probably my first mistake). Thanks for your help Russell!

Re: Editing Related Tables in Collector

RussRoberts — Wed, 11 Feb 2015 17:05:13 GMT

Yup, we are working on a blog covering the steps on how to get your map & data setup related records along with some tips. I'll post a link to the blog in this forum when its published.

Russ

Re: Editing Related Tables in Collector

NilsBabel — Fri, 13 Feb 2015 22:19:13 GMT

Thanks for all the great information. Sounds like it is getting there and some of you are already using it. I'll look forward to the Blog post coming out.