topic Re: Relationship classes and offline editing in ArcGIS Collector Questions

Relationship classes and offline editing

WarrenMedernach — Fri, 05 Dec 2014 13:44:55 GMT

Hello all,

I have a feature class and SQL Server table that I'm trying to relate and make available for offline editing. I was able to successfully get attachments to a feature working, but I'm having some issues trying to get this to function with my SQL table and I'm assuming it is a schema, primary key issue.

From what I've read on relationship classes and preparing data for offline, layers that participate in a relationship must be related using a Global ID field as the primary key. So that said, how can this be accomplished if my data is structured such that I have a point feature class with a point 'name' field that is alpha-numeric, and this field is related to a SQL Server table (1:M) with the same alpha-numeric 'name' field?

Any suggestions would be greatly appreciated.

Warren M

Re: Relationship classes and offline editing

RussRoberts — Fri, 05 Dec 2014 19:08:41 GMT

They current version of Collector(10.2.7) does not supported relationship classes. This is coming in our 10.3 update which should be out in late December/early Jan.

Re: Relationship classes and offline editing

WarrenMedernach — Fri, 05 Dec 2014 19:23:11 GMT

Thanks for the info Russell.

But... isn't a feature class 'Attachment' simply a relationship class also? And this functions offline? What am I missing?

Warren

Re: Relationship classes and offline editing

RussRoberts — Fri, 05 Dec 2014 20:04:04 GMT

While attachments are an example of related information they are much simpler to model and support. Notably they contain no attributes that can be edited nor can they have nested relationships. Collector will be adding support for related data soon, please keep an eye on the blog and news for more information

Re: Relationship classes and offline editing

WarrenMedernach — Fri, 05 Dec 2014 20:06:06 GMT

Awesome, thanks again for the info.

Warren

Re: Relationship classes and offline editing

WarrenMedernach — Wed, 17 Dec 2014 15:12:04 GMT

Hi Russell,

As a followup to this question...

At 10.3 Collector will support relationship classes, so does that mean Collector will be able to add additional related records to an existing feature? For example, I have a point feature that has 'instrument readings' (1:M) stored in another table and the relationship class exists between these two classes. Will I be able to add a new 'reading' through the Collector UI?

Thanks

Warren

Re: Relationship classes and offline editing

RussRoberts — Wed, 17 Dec 2014 17:40:43 GMT

Yup you will be able to view, add, update and delete related records. The example you brought up will be supported. The only thing not supported in this initial release will be M:N relationships.

Russ

Re: Relationship classes and offline editing

WarrenMedernach — Wed, 17 Dec 2014 17:56:34 GMT

And with 10.3 now available, does this mean there is an update for Collector still to come, or should it be functioning now?

Thanks again!

Warren

Re: Relationship classes and offline editing

RussRoberts — Wed, 17 Dec 2014 18:04:31 GMT

There is a 10.3 Collector update coming in January that will bring this support to iOS and Android.

Re: Relationship classes and offline editing

WarrenMedernach — Wed, 17 Dec 2014 18:07:22 GMT

Perfect!

Thanks again for following this and answering all the questions!

Can't wait to get testing this!

Warren

Re: Relationship classes and offline editing

WarrenMedernach — Wed, 04 Feb 2015 18:47:44 GMT

Hey Russell,

I'm finally getting around to testing out this editing of related data in Collector and have another question:

Does the ArcGIS Server itself need to be at 10.3 as well for this to work in the Collector 10.3?

Our server is still at 10.2.2 and I can edit the related in ArcMap, but when I create the map in our arcgis online account I can 'see' the related records, but cannot see a mechanism for editing the records and the same thing applies when I view the map in Collector. So... I'm thinking our server needs to be at 10.3 as well.

Thanks!

Warren

Re: Relationship classes and offline editing

RussRoberts — Wed, 04 Feb 2015 19:13:10 GMT

Hey Warren,

Here is a link from our doc going over related records:

FAQs—Collector for ArcGIS | ArcGIS

Related data is supported when using ArcGIS Online hosted feature layers or versioned data from ArcGIS 10.3 for Server or later. In a future release of ArcGIS for Server support will be added for archive-enabled data. When using related data, it is strongly recommended that you use GlobalIDs when defining relationships. User-maintained relationships are not recommended.

Russ

Re: Relationship classes and offline editing

WarrenMedernach — Wed, 04 Feb 2015 20:07:50 GMT

Once again thank you Russell, and once again I'm looking in the wrong place I was searching through the 10.3 server docs and getting no where fast.