Collector Issues: Related Tables, Attachments and Opening with ArcMap

18464
40
Jump to solution
02-24-2015 01:29 PM
MasonBailie
New Contributor III

Thank you ESRI, this latest update has been excellent! My organization had actually been developing our own mobile app so that we could easily collect data (requiring relationships) in the field; when it was announced in 10.3, that these capabilities were being added to collector, we were very excited! That being said, I'm having a couple of issues--- I'm not sure if they are features that haven't been developed yet or if I'm doing something incorrect.

Refer to this map, it is just a test map so you can feel free to add your own features to test out the functionality:

http://grmw.maps.arcgis.com/home/item.html?id=050e93147b0c4df18644c45b7fca0ac5

My three tables look like this:

Restoration Projects:

     - Object ID

     - Project ID

     - Polygon Field

     - Name and a few more text fields that aren't important

Project Features:

     - Object ID

     - ProjectKey (related to Restoration Projects 'Project ID' Field)

     - Point Field

     - Date and other fields

     - Attachment

Monitoring Records:

     - Object ID

     - FeatureKey (related to Project Features 'Object ID' Field)

     - Date/comment and other fields

     - Attachment

Projects 1:M--> Project Features 1:M--> Monitoring Records

I can create ‘Projects’ in the app just fine. Displaying how many ‘Features’ a Project has in the popup works in the ArcGIS Online viewer but not Collector. In Collector, it leaves Feature Count blank.

Problem #1 - Collector seems to not show related table information correctly in popups

Creating a Feature works just as I'd hoped. You click on the Project area, go to "New" at the bottom of the pop up form and create a feature for that project. Collector smartly adds the correct ProjectKey information into that Feature so that my users do not have to know the Project ID or type it in continuously when they are creating Project Features. Everything works great here. I click view and can see my Project Feature has been added nicely and displays correctly. The problem lies in the next step, the nested related table, adding a “Monitoring Record” for that Feature. I click "New" at the bottom of the Feature, and immediately I notice that the FeatureKey is not filled in. This is a bummer since it worked so well for the Project Feature previously.

Problem #2 - My Monitoring Records do not automatically add the FeatureKey to the field

I do not want my co-workers to have to remember the FeatureKey that they are creating a Monitoring Record for (likely, they won't be able to). Oddly enough, if I leave that field blank while filling out the Monitoring Records form, the Monitoring Record is still related to the Project Feature. I'm not sure how, since that field appeared to be blank.

So I change my use back to the ArcGIS Online viewer: Project Data is correct, Feature data is correct and attachments are working, here’s the kicker--- and I cannot view the Monitoring Records attachment. (That seems to be the only problem with the Online viewer. Other than this, I'm very happy with how well that works.)

Problem #3 - I can't see attachments for my table

Next it's time to open the data in ArcMap. Online, I browse to My Content, click on my Feature Layer and select Open in ArcGIS for Desktop. It downloads a file that I click and opens up ArcMap (this is a very nice way to do this, simple and easy to use). I see my Project and Feature data. I click the Project I created and it shows the Feature relationship it has. That Feature has an attachment as well that loads via my Windows Photo Viewer. (Great!) And then I notice that my Feature does not have any Monitoring Records associated with it. I then click the "List By Source" and notice that my Monitoring Records table doesn't seem to be included with the Service.

Problem #4 - ArcGIS Online doesn't seem to attach my related table to the service given to ArcMap

Those are the issues I'm having. Sorry that was long winded, I wanted to explain my scenario thoroughly. I'm nervous writing all this as I'll probably get a response of "you did your relationship wrong," or something simple like that. But I hope I gave you guys enough information to see my problems.

Thanks again for the 10.3 release, it has some very exciting uses! If I need to attach any files for people to test out, let me know.

40 Replies
VickyS
by
Occasional Contributor

I can't take off the security right now as I am at home. I have made the web map available to everyone but you will be prompted for a user name. I need to check with IT before removing all the security.

This PDF details the MapServer service. Can I add you as a user to our account temporarily?

Thanks for your help

0 Kudos
RussRoberts
Esri Notable Contributor

You can create a group in AGOL and invite Collector4ArcGIS into that group and you do not need to expose any information in the post. In the group you can share services, maps and files that will help us out with the issue.

Thanks

Russ

VickyS
by
Occasional Contributor

Sorry, Ive worked out how to add you now. You should be able to see a couple of maps and services. One with stored credentials the other without. They are the same service and hosted internally (10.3).

Thank you!

Vicky

0 Kudos
RussRoberts
Esri Notable Contributor

The error is the data on the service is referencing the same data source in the enterprise database. This is currently not supported. Each layer/ & table will have to have its own data source in the database.

VickyS
by
Occasional Contributor

I don't really understand that. Can you give me an example? They do have individual data sources, they are in the same database but are separate feature classes/tables with relationships set up. It works on my iPhone but not on Android devices. Is this just a fluke?

Thank you for your help. It is very much appreciated!

0 Kudos
RussRoberts
Esri Notable Contributor

I can reproduce your error. I've entered an issue in for our dev team to look at. If possible please leave the group and service up.

Thanks

Russ

VickyS
by
Occasional Contributor

Yes, will do. Look forward to finding out the solution! Thank you, Vicky

0 Kudos
VickyS
by
Occasional Contributor

Hi Russell

Have you got any further with a solution to this bug? When will the next version be released.

Thanks

0 Kudos
RussRoberts
Esri Notable Contributor

Yup with the issue where the download on Android thinks the data is coming from the same data source but is actually trying to enter a layer into a replica twice has been addressed and will be in the next update which we are aiming to release in May.

0 Kudos
VickyS
by
Occasional Contributor

Is there any news on the bug fix release?

0 Kudos