POST
|
I connect my feature table and related table using a GUID. The idea of my field workers typing in a GUID to see the history of hydrant inspections makes this a nonstarter. Honestly having them type in anything is going to be a horrible user experience and I won't implement it. I understand this is beta software but not supporting related tables will make Dashboard appear half baked IMO.
... View more
11-01-2016
03:41 PM
|
6
|
0
|
5033
|
POST
|
Matthew - Does collector work differently with data stored in a SQL database than say ArcMap or a webmap in portal does? I have triggers set up on my SQL database (both in the table and view trigger folders) that fire when I do updates via ArcMap and through Portal but I can't get those triggers to fire when I make changes/updates using collector. My suspicion is that both ArcMap and Portal work on the 'table' and collector is working on the 'view' but I can't seem to confirm this. If I understood the logic on how Collector worked with the SQL database, I might be able to solve my problem. Thanks for you time Tom
... View more
01-19-2016
10:06 AM
|
0
|
0
|
808
|
POST
|
Very interesting. I have to say this article lead me to an error in my trigger. I was incorrectly using the OBJECTID within my update trigger and it recalculated all the inspections for an asset, which populated previous inspections with incorrect values. i.e. Most recent inspection 250 - 25 => Field3 = 225 Previous inspection 250 - 50 => Field3 = 200...however it was recalculated to 225 because the OBJECTID is the same. By changing my code to use GDB_ACHIEVE_OID I was able to preserve previous inspections. However the updated FIELD3 still won't show up on the device. Regardless that article helped to some degree, thanks.
... View more
12-23-2015
10:26 AM
|
0
|
0
|
808
|
POST
|
Tobias - Data was prepare per these instructions here. To be clear: versioning is disabled. Thanks Tom
... View more
12-23-2015
07:46 AM
|
0
|
2
|
808
|
POST
|
Hi Matthew - Thanks for the quick response. If by cache/resync you mean tapping 'SYNC' again on the main collector page, the answer is yes and the field is not updated. I have even added new inspection and all the records are not showing the update. I have also tapped 'refresh' from the menu and that doesn't update the records either. The only way I can see the updated Field3 (per my example) is by removing the app (i.e. manage>remove) then loading the app again. Which is an unacceptable workflow. Thanks Tom
... View more
12-22-2015
02:05 PM
|
0
|
4
|
808
|
POST
|
Hi All - I have a collector inspection app that needs to calculate a 3rd field. It's not vital that the 3rd field is calculated in the field however the 3rd field does need to be seen if the asset is revisited. To simplify I have a table in a relationship class with the fields: Field1, Field2 and Field3. (Basically this was built following Jeff's Hydrant example) Worker collects values: Field1 = 250 and Field2 = 50. Field3 is NOT collected (Field3 = 0) Worker returns to office performs a sync, I setup an update trigger within SQL database that calculates Field3 = Field1- Field2 (in this example Field3 = 200) When the data is viewed in Portal I see all the fields with correct data values. The problem that I'm seeing is that the data(inspection record) on the device doesn't get updated to show that Field3 = 200. The only way (at the moment) to see the updated values is if I removed the collector app and reload it on the device. There has to be a way to see the updated values after my trigger is executed. But I don't know how to "push" it back to the device. Anybody have any ideas? Thanks Tom
... View more
12-22-2015
11:42 AM
|
0
|
7
|
3350
|
POST
|
Carl - Thanks for the quick response and confirming what I suspected. I don't know about Survey123. I don't see it helping with my current project but it definitely might help with another. Thanks Tom
... View more
10-15-2015
11:51 AM
|
0
|
0
|
491
|
POST
|
Hi All - I setup a inspection Collector app that pretty much follows Jeff Shaner's Feb 1015 blog posting. I was wondering if there is a way to calculate a field on the fly after data is entered, maybe by setting up some kind of a trigger to run a script...or maybe another way? Example: Field worker enters in 2 numbers, 100 and 25 and saves the data. A third field is then calculated based on the numbers entered (100-25) for a value of 75, then the data is displayed within the app. Field1: 100 Field2: 25 Field3: 75 Thanks in advance. Tom
... View more
10-15-2015
08:54 AM
|
0
|
3
|
2180
|
POST
|
Hi Erin - Thanks for the response. Since this was just one layer, no editing and the application is in house, I just added the SDE data directly to the MXD and used my original logic. I didn't have time to investigate the paradigm of IMapServerSublayer. Hopefully others will find value from this thread. Thanks Tom
... View more
08-18-2014
02:00 PM
|
0
|
1
|
371
|
POST
|
Hi All - I'm building an Add-in for ArcMap (using C# and ArcObjects) that provides a custom dialog with a textbox that expects a parcel APN number; entered by the user. If the APN is valid, zoom to the location. When I began developing this tool I took a subset of my Map Service parcel data and created a gdb. I got everything working and assumed...(wrongly)... that I could simply change the CLSID reference in the code from working with geodatabase layers to MapServer sublayer. As I stated, this was wrong. It now appears that I have an invalid cast. Can anyone suggest how I might be able to save most of this code without having to rewrite it to work with a map service? The map service supports the Query operation, I suspect the answer lies within IQuery. On the positive side, I have created a tool that will successfully close ArcMap...rather quickly too I might add. <Add-in code snippet> IMxDocument pMxDoc = ArcMap.Document; pMap = pMxDoc.FocusMap; IEnumLayer pEnumLayer = null; // string LayerCLSID = "{E156D7E5-22AF-11D3-9F99-00C04F6BC78E}"; string LayerCLSID = "{B059B902-5C7A-4287-982E-EF0BC77C6AAB}"; // IMapServerSublayer ESRI.ArcGIS.esriSystem.UID uid = new ESRI.ArcGIS.esriSystem.UIDClass(); uid.Value = LayerCLSID; pEnumLayer = pMap.get_Layers(((ESRI.ArcGIS.esriSystem.UID)(uid)), true); pEnumLayer.Reset(); ILayer layer = pEnumLayer.Next(); ILayer selLayer = null; while (!(layer == null)) { if (layer.Name == "Riverside Parcels") { selLayer = layer; string sqlStatement = "APN = '" + textBox1.Text + "'"; IFeatureSelection fSelection = selLayer as IFeatureSelection; // <= **** Invalid Cast? **** IQueryFilter qFilter = new QueryFilterClass(); esriSelectionResultEnum selectionResult = new esriSelectionResultEnum(); qFilter.WhereClause = sqlStatement; fSelection.SelectFeatures(qFilter,selectionResult,false); }//closes if layer = pEnumLayer.Next(); }//closes while Thanks Tom
... View more
08-14-2014
11:59 AM
|
0
|
3
|
2725
|
POST
|
Hi Jeff - Thanks for the reply. I actually punted on this approach and took advantage of the selection set create by the all the native selection tools. My Add-in simply does a summarize on the current selection set. Dropped from 3 tools to one. All the best Tom
... View more
08-14-2014
11:30 AM
|
0
|
0
|
476
|
POST
|
I'm creating an Add-in using ArcObjects and C#, technology I haven't used in 10 plus years. I'm creating 3 tools that work on a specific polygon layer. Tool 1 - Select by Line; summarize selected polygon areas Tool 2 - Select by Polygon; summarize selected polygon areas Tool 3 - Select by Rectangle; summarize selected polygon areas I found this sample; ArcObjects Help for .NET developers ...and it works great for selecting my polygons using a line. I was able to convert it pretty easily to selecting my polygons by using a polygon. I changed theses lines; private INewLineFeedback m_lineFeedback; IPolyline polyline; to private INewPolygonFeedback m_lineFeedback; IPolygon polygon; (and fixed all the errors that were generated.) Now I want to do something like this; private INewRectangleFeedback m_lineFeedback; IRectangle rectangle; It doesn't appear to be the same animal. Can anyone give me a nudge as to the interfaces I need to implement? I know I have to change some of the logic as well, since I'm not expecting a double click event (as shown in the sample). Thanks Tom
... View more
07-24-2014
04:27 PM
|
0
|
2
|
2263
|
Title | Kudos | Posted |
---|---|---|
6 | 11-01-2016 03:41 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|