Latest Contributions by AnthonyCheesman1

Hi I'm using the arcrest Python module to automate regular extraction data from a AGOL feature service, which is generated from Survey 123. I would like to be able to query out subsets of records based on creation date, but cannot for the life of me work out the correct syntax to make this occur. I am using this script as my base: ArcREST/create_replica_portal_item.py at master · Esri/ArcREST · GitHub  With the date query being implemented on Line 65:     "where": "SURVEY_COMMENCED >= DATE '2017-08-01 00:00:00'" The field I am referencing is a datetime field, and all of the documentation I have found points to this being the correct syntax. Can anyone steer me in the right direction? ... View more

Hi I'm currently using the arcrest Python package to build a custom tool that will allow users to export a csv table of selected data from an AGOL feature service. The FS that will be providing the data is pretty verbose and not all fields are relevant to the end user of the csv table. Is there a method in createReplica that allows me to specify which fields I would like in the output table? Thanks! ... View more

(x/post from ArcGIS Online - posting here for visibility) Hi I'm having issues creating a local copy of a feature service for editing (service in ArcGIS Online, using ArcMap 10.3.1 on desktop). I can add the feature service to my ToC, but when I right-click to create a local copy, I receive the following error message: # I've inspected all of the field names of the service in question and all seem to be legitimate (all start with alpha characters, no special characters in strings etc). Field names are:   objectid globalid GUID_ DEVICE_ID SURVEY_COMMENCED SURVEY_COMPLETED JOB_NAME DATE_INITIATED FACILITATED_BY WORKGROUP Q1_COMPLETED_JSP Q2_CONTROLS_IMPLEMENTED Q3_WORKERS_BRIEFED Q4_BRIEFING_DETAILS Q5_ADDITIONAL_HAZARDS Q6_ADDITIONAL_HAZARDS_NOT_ON_LIST Q7_ADDITIONAL_CONTROL_MEASURES Q8_PART2_SUPERVISOR Q9_PART2_BRIEFING_DATETIME CHECK_JOB_COMPLETED Q10_INCIDENT_NEARMISS Q11_CONTROLS_INEFFECTIVE Q12_CONVERT_SWMS Q13_OTHER_ISSUES Q14_PART3_SUPERVISOR Q15_PART3_REVIEW_DATETIME CreationDate Creator EditDate Editor Shape   # The source of the feature service is Survey 123 (via XForms), which loads the question text as an alias against each field. These questions do contain special characters.   # I am loath to have to recreate my survey with different or shorter questions (as I am trying to replicate an existing business process), but if this is the fix, then so be it.   Has anyone come across this issue with creating local copies for editing? Have you found a fix or workaround? Thank you in advance! ... View more

Hello I'm working on developing a survey for vehicle pre start checklists. We operate a number of different vehicle types, and depending on the type of vehicle, I would like the user to be prompted with a particular start up checklist. Currently I have a choices list called 'vehicle list', with the name field being the vehicle registration, and the label field being a longer description of the vehicle. I have added an additional column called 'group' which describes which checklist the vehicle should complete. My question is - can I access this 'group' column somehow later in my form in the 'RELEVANT' field to determine whether a question is displayed? If I could ask this a different way - instead of having to check for individual registration numbers (eg ${VEHICLE} = "ABC123" or ${VEHICLE} = "BCD234" or ${VEHICLE} = "CDE345") - is there an expression I could use along the lines of ${VEHICLE}.group = "fleet" (where 'fleet' is the name of the checklist type / relates to the 'group' column I added earlier). Thank you in advance! ... View more

Hello I'm designing a survey which users will need to complete in 2 parts, at 2 separate times. I need to record the time of completion for both parts, and if possible I would like for the date and time to automatically populate. However - if I use now() as the default value for the fields, the time set at first completion is then overriden by the time of second completion. From speaking to an ESRI trainer earlier in the week, it *may* be possible to set a conditional calculation on the first field (ie 'if ${datetime1} is empty, now(), ignore') however I'm struggling with syntax to make this happen. Has anyone encountered a similar problem or could offer some suggestions on how I can solve this issue? Thank you in advance. ... View more

Hi My organisation runs a large fleet of vehicles. I would like to build a Survey 123 implementation of our vehicle log book (which is currently paper based). Sounds easy, huh? The survey asks for 2 odometer readings - START KM and FINISH KM. What I would like to be able to to do is to automatically populate the START KM field of a record with the FINISH KM value from the previous record from that vehicle. I would like for the user still to have the opportunity to edit the START KM, as there may be circumstances (eg log is not completed for a particular trip) where the prepopulated START KM is not correct. Is this possible, and how would I go about setting this up? Thanks in advance! ... View more