Latest Contributions by AnthonyRyanEQL

Kathy, Good luck with this and hope you get a response. I have tried for many days a few months ago with no luck. I placed a support call and provided feedback on the technical article with no luck either. I may have narrowed it down but uncertain if it was the problem but it relat to assigning the primary key to one of my fields. If I left it off it seemed to work. The issue I found was the steps in the technical article to create the table, constraint, etc. is different to the SQL generated when you look at a feature class within SQL Developer which was created by create feature class right click context menu on the database connection in ArcCatalog. This is an area lacking documentation and when it comes to large organisations where the DBA only uses sql files to build your database, etc it's the only way it can be done. ... View more

Mark, How would you expect this function to handle information in the workorderid field, etc? Interested in your thoughts or how do you cope with that at the moment? Thanks ... View more

Meg, Are you referring to this in AGOL now about adding a user to a group immediately? Do agree with better user management especially with creating a group of users and adding that user group list to the Portal group something similar to AD functionality ... View more

Hugo, Survey123 data is stored as a hosted feature service in AGOL. You can query the data the same as any other feature service (eg. ..../FeatureServer/0/query?). Remember surveys can have relationships and these are generally another layer within the feature service you can query as well. The way you suggested is correct Login generate token query feature service with token attachment return what you need and display, etc. as you want Regards ... View more

This idea should also include Portal for ArcGIS as well. Going through these steps (How To: Configure Portal for ArcGIS with custom symbology ) is very painful and time consuming especially when talking about 100-200 symbols ... View more

Craig, Assignment GlobalID will be critical for us because the way our assets for property (eg. fire panels, doors, water backflow valves) are managed for inspection. We don't use a Work Order system (it's actually a spreadsheet) and therefore can't get a unqiue Work Order ID. The AssetID is going to be used as the Work Order ID so the asset for inspection can be easily seen in the Workforce app. All of our analytics we be done on the relationship of the assignment's GlobalID passed into a hidden text field within Survey123. We would still like to pass Work Order ID field as well to show the contractor in Survey123 that is what they are inspecting. Thanks ... View more

Craig, When you say have the ability, do you mean that it's configurable with only those fields to chose from or other fileds can be selected (eg. GlobalID). Thanks ... View more

What would like to update? If you keep the same name when the service is being republished, there is nothing to update. ... View more

This has happened to me a few times. The only way I know how to fix it is to started again. Delete the portal item for the service Delete the service on server Open ArcGIS Admin and check the correct portal url is used in Managed Portal Connections. HIghlight, click Connect & Save to make sure. Open ArcMap and publish again. Make sure your portal groups are available in the Sharing section of the wizard Good luck ... View more

Gianni, Thanks for the reply but this has clouded my idea. My idea still stands to add the ability to pass parameters to a survey. During the configuring process of assigning a survey123 survey to a workforce assignment_type, allow the user to select which fields from the workforce assignment can be passed to allow pre population of survey fields (eg. workorderid) to enable a linkage between scheduled work & condition assessment, etc. for future analysis, etc. i'm not after anything complicated, just fields being pre populated of a particular survey as defined by the assignment_type configuration. i have seen the workforce project json configuration by using ago_assistant tool and know it could be hacked by altering the custom URL scheme for the particular assignment_type but this shouldn't be the way to do it and it would be considered unsupported. Thanks ... View more

Gianni, Could you explain a little more on what you mean about 'the filter/order the inbox features'? I assumed this would have been considered, etc. when the format/functionality of Survey123's custom URL scheme was developed. Thanks ... View more

I have managed to create the SQL that will consistently allow me to publish a map service with feature access from. SQL Create Table TESTTAB1008(                          OBJECTID INTEGER,                          SHAPE MDSYS.SDO_GEOMETRY,                          TEXT_DATATYPE NVARCHAR2(50),                          Constraint PK_TESTTAB1008_OBJECTID Primary Key(OBJECTID)                              Using Index (Create Unique Index IDX_TESTTAB1008_OBJECTID On TESTTAB1008(OBJECTID))                         ); Comment on Column TESTTAB1008.OBJECTID Is 'ESRI auto-incrementing'; Delete From USER_SDO_GEOM_METADATA Where TABLE_NAME='TESTTAB1008'   And COLUMN_NAME='SHAPE'; Insert Into USER_SDO_GEOM_METADATA     Values (             'TESTTAB1008',             'SHAPE',             MDSYS.SDO_DIM_ARRAY(                                 MDSYS.SDO_DIM_ELEMENT('Longitude', -180, 180, .00000005),                                 MDSYS.SDO_DIM_ELEMENT('Latitude', -90, 90, .00000005)                                ),             4283); Create Index IDX_TESTTAB1008_SHAPE On TESTTAB1008(SHAPE)     INDEXTYPE Is MDSYS.SPATIAL_INDEX Parameters('SDO_COMMIT_INTERVAL = 1000') NOPARALLEL; Select OBJECT_ID From ALL_OBJECTS Where OBJECT_TYPE='TABLE'   And OWNER='PLANTRATING_MAIN'   And OBJECT_NAME='TESTTAB1008'; Create Sequence SEQ_9197425  -- OBJECT_ID from above query MinValue 1 Start With 1 Increment By 1 MaxValue 2147483647 NoCache Order; Create Or Replace Trigger BIFER_9197425  -- OBJECT_ID from above query     Before Insert     On TESTTAB1008     For Each Row         Declare             Begin         -- Assign the primary to the new record --         Select SEQ_9197425.NextVal Into :new.OBJECTID From DUAL;             End; Grant Select On TESTTAB1008 To Public; Commit; The next problem is it won't allow me to insert data via a webmap created in Portal 10.3.1 It's generating an error without the editor popping up Console error Request body Response body Results in Oracle database Our database is Oracle Spatial 10g using Oracle 11g client on my desktop with Oracle 12c client on ArcGIS server The feature class in Oracle has a SRID set against it (SRID: 4283 - GDA94) The feature class I created before using the database connection's new->feature class right click context menu uses the same SRID without any issues. Does this happen with your version? ... View more

Rex, Thank you for the SQL. I had to alter the trigger relating to getting the next value from the sequence to get it work. It worked the first time I ran the SQL. Made some changes to table name, etc. to minic a new feature class and no luck (getting the same error as above). Currently doing more testing. It is very odd behavour. ... View more

Alan, It is. We have used this to summate point data relative close to each other (eg. inspection data from Survey123). ... View more