Latest Contributions by AnthonyCheesman1

‎01-02-2018

Thanks Philip. I'll have a crack at this tomorrow morning and report back. Really appreciate the quick response.

‎01-01-2018

Hello everyone and happy new year! I'm starting out my new year by trying to build what should be a pretty simple Survey123 project. However, every time I try to build the survey I am receiving a strange error that I cannot resolve. For context, I am using Survey123 Connect for ArcGIS (Version 2.3.24) and am using the 'Advanced' option. Error as below: The error is occurring on a couple of different fields. I don't think I'm doing anything too complicated - the fields I am getting issues on are: 1 - Record date / time. I would like this field to be hidden (using type = hidden), autopopulate with current date / time (calculation = now()). Using bind::esri:fieldType = esriFieldTypeDate 2 - Record lat / long of geopoint location. Both of these fields are hidden (type = hidden), calculation = pulldata("@geopoint",${LOCATION},"y") ("y" for lat and "x" for long). Using bind::esri:fieldType = esriFieldTypeDouble The issue seems to relate to the bind::esri:fieldType column, as when I remove these values, the issue goes away. My understanding however is that as I would like these particular questions to be hidden, that I need to use this column. Can anyone shed any light on this? Copy of the xlsforms spreadsheet attached for your reference. Many thanks.

‎08-27-2017

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?

‎08-27-2017

I've now probably answered my own question on this - the answer being NO. My workaround is that I've created a view of the feature service that I wish to query, with only the fields that I want returned to the user in the csv table.

‎08-25-2017

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!

‎08-15-2017

Thanks James. I just replied in another thread as well, but I managed to get it working last night by recreating the xform and feature service with shorter, less complex labels and also no special characters.

‎08-15-2017

Hi Dan I think I got to the bottom of the issue yesterday (well, more to the point, I changed something and it started working, whether or not that was the cause or not, I don't know). I think the issue was that the Label field in xforms gets translated to the field aliasname in the feature service. The way I had my form constructed was having the question text in the label field on xforms, which meant very long aliasnames (up to 200 char) and special characters as well. Once I redesigned my form, and moved the question text into either a note format or into the hint field, I was able to specify much less complex names for the labels. Once this was complete I was able to create a local copy for editing and then sync changes. In another thread two other options have been pointed out also: # Use ArcGIS Pro as it will allow native editing of feature services without the need to go offline # Use the ::esri::bind options in XForms where you can override field names, aliases, types and lengths. Thanks again.

‎08-14-2017

Hi This follows on from a question I had earlier about issues I was experiencing in trying to create a local copy of data for editing. I suspect it is to do with field aliases (which are sourced from the Label column in XForms). I've made some changes to my Xforms document and republished the survey (deliberate changes so as to not force re-creation of the feature service). The changes are primarily to the Label field to shorten it up and remove any special characters that may be causing issues. My question is - will these changes flow through to the feature service, or will the FS remain static with the original schema that was generated on initial upload?

‎08-14-2017

(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!

‎08-14-2017

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!

‎06-21-2017

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!

‎06-02-2017

Gday James, thanks for taking the time to reply. Unfortunately in this circumstance, I don't think the two survey approach will work, as users will be working predominantly offline and out of mobile range. However, I had a play yesterday with removing the default now() value, leaving it to the user to manually set date and time. On iOS, as soon as the date is set, the time seems to autopopulate correctly. I am yet to test this on an Android device though. So my solution will be to remove the default value, and leave it to the user to set. The second part of the survey will be hidden behind a conditional question, and will only be exposed once the condition is met. Finally I'll have the users save the first survey entry as a draft, and then finalise the same survey for completion once they are ready.

‎05-31-2017

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.

‎04-13-2017

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!

‎04-03-2017

Thank you Kelly! This worked perfectly.

Online Status	Offline
Date Last Visited	‎12-01-2020 10:55 PM

My Ideas

Latest Contributions by AnthonyCheesman1

Re: Survey123 - strange error when trying to build survey from XLSforms

Survey123 - strange error when trying to build survey from XLSforms

Querying dates using REST API

Re: ArcREST createReplica - can I specify a subset of fields to return in the replica?

ArcREST createReplica - can I specify a subset of fields to return in the replica?

Re: Issues creating local copy of feature service for editing

Re: Issues creating local copy for editing

Making changes to S123 feature service after creation

Issues creating local copy of feature service for editing

Issues creating local copy for editing

Survey 123 - Accessing 'Group' of previously answered question

Re: Recording time in two separate fields in Survey123

Recording time in two separate fields in Survey123

Survey 123 - populate answer based on earlier survey entry

Re: ArcGIS Online - Custom date labels

Re: Overwrite a Feature Service that has a Hosted ...

Re: arcpy.da.InsertCursor returning 'RuntimeError'...

Re: Why do my raster cells seem to have a 'border'...

Re: Install python module from within script

Re: Install python module from within script