Latest Contributions by danbecker

I do something similar; default when survey123 form is submitted is already_emailed = NO. I just run the .py via task scheduler, kick out an email with a PDF report, then set already_emailed = YES via REST API. Here's some pseudo code, (no code bashing please ) def gentoken(username, password, referer, expiration=5):       query_dict = {'username': username,                     'password': password,                     'expiration': str(expiration),                     'client': 'referer',                     'referer': referer,                     'f': 'json'}     tokenUrl = "https://ourportal.com/portal/sharing/rest/generateToken"             tokenResponse = urllib.urlopen(tokenUrl, urllib.urlencode(query_dict))          token = json.loads(tokenResponse.read())                 if "token" not in token:           print token['messages']           exit()       else:           # Return the token to the function which called for it           return token['token'] def applyUpdates(featureList,accessToken): #returns json string of POST reply     payload = {'updates': json.dumps(featureList),                 'token': accessToken,                'useGlobalIds': 'true',                'f': 'json'}     query_string = urllib.urlencode(payload)     q = "/applyEdits"     url = baseURL + layerID + q     req = urllib2.Request(url,query_string)     resp = urllib2.urlopen(req)         return json.loads(resp.read()) #URL of hosted feature service baseURL = 'https://ourportal.com/server/rest/services/Hosted/service_9ca0ddc438704f38970558c39a245ef1/FeatureServer/' #layer id in feature service we want to work with layerID = '0' #REST query string where = '"already_emailed" = ' + "'NO'" #REST query fields fields = '*' #lets get a token    token = gentoken(USERNAME, PASSWORD, REFER) #construct REST query query = "/query?where={}&outFields={}&returnGeometry=true&f=json&token={}".format(where, fields, token) fsURL = baseURL + layerID + query fs = arcpy.FeatureSet() #load json string from server into feature set fs.load(fsURL) #convert json string from server into py dictionary pDict = json.loads(fs.JSON) #unecessary, but lets load our edited feat dict to a new list to send back to server newFeatList = [] for feat in pDict['features']: #returns list of features     newDict = {}     newDict['geometry'] = feat['geometry']     glid = feat['attributes']['globalid']     oid = feat['attributes']['objectid']     newDict['attributes']={'globalid':glid,'objectid':oid,'already_emailed':'YES'} #editing already_emailed here     newFeatList.append(newDict) ... View more

Same here, utcOffset isn't working. We have ArcGIS enterprise, survey was created/published using survey123 Connect. Trying to set utcOffset on a dateTime question so the output reports don't print UTC time, which is confusing to field crews reviewing the recently submitted data because it causes the date to sometimes be +1 day since PST is UTC-8. ... View more

Confirmed on my end also. 1) I had a survey with start/end fields, tried to edit a different survey question and re-publish; result was the timeInterval error. 2) deleted the start/end fields, republished successfully. The re-publish wipped out the data due to schema changes, so now I had a feat. service with no data. 3) I then added the start/end fields back into the survey and re-published again; successful. So I have the start/end fields in the survey now, odd how the issue happens sometimes, not others. ... View more

I've done more troubleshooting since my post a couple of weeks ago. It seems to be a problem with repeats, and not anything to do with the underlying form xls file. I had a working, existing survey that was published to Portal/Server 10.6, the feat. service did not contain any data, it was blank. The survey consisted of 2 repeats, each with 2 text fields, nothing overly complicated. I then tried to add a single text entry outside of the repeats, republish, then encountered the timeinterval error. I had to delete the survey, form, service and folder from portal and start over. I first tried publishing a survey with just the repeats, same timeinterval error. I deleted everything and started re-publishing the survey one group at a time, every attempt to re-publish was successful. Every group of questions that were published were NOT repeats. I then added the 2 repeats, republished and everything worked. Really strange behavior and will likely be difficult to repro. But seems to be related to repeats, and re-publishing (editing) existing features services. Jon - Did your survey have atleast 1 repeat in it? ... View more

after a day of trial/error with attribute rules, I just discovered they are NOT enforced on downloaded maps in Collector. Since they are applied at the database level, you don't get the validation error until you sync the offline data. Even worse is that since the db won't allow the features to be written (validation errors) the violating records are forever gone. Maybe you can dump them with iTunes from the runtime gdb, not sure. Glad I discovered this before deploying on a real project. Another gripe is that after attribute rules are added in ArcGIS Pro 2.1.1 you cannot work with the enterprise gdb in ArcMap any longer since it doesn't have the ability to work with attribute rules. Bummer. A new Collector update, that recognizes Arcade expressions is in dire need. Then, validation rules could be applied at the app level. ... View more

A1) Portal and server are federated, using built-in portal users/roles. Portal and datastore are on seperate VMs, guest OS is Ubuntu Server 16.04. Server and web adaptor are on the same VM, guest OS is Win Server 2012 R2. A2) Problematic log is attached. I deleted most of the domain records, they were lengthy. A3) Advanced template, single question publishes fine, no issue. Following A3: I opened the 2 .xls files side-by-side. I started copying single rows from the problematic .xls (Form1), then pasted values into the advanced template .xls (Form2). I opened the Form2 folder, and deleted the .itemInfo file In portal, I deleted the Survey-Form2 folder I republished Form2. Repeat this sequence for each new row added from Form1 to Form2. I got to the end of the survey, no errors in publishing!!! There must have been an issue with the Form1 .xls file. thanks. ... View more

thanks for the inspiration! I did something very similar, but created a PDF via XML/XSLT. survey123 sets ${already_emailed} = 'NO' by default query hosted feat. service for already_emailed = 'NO', return FeatureSet (bummer how this doesn't contain domains) via REST query domain info for each field via REST: /service_1232/FeatureServer/layerID logged BUG-000111606, queryDomains doesn't work for hosted feat. services set already_emailed = 'YES' via REST: /applyEdits open template XML file, loop over featureSet. Populate fields, use XML attributes to specify field has domain/not. style XML file using XSLT template via Etree module. This exports an .html file Convert .html to .pdf via pdfkit module Email PDF report to project manager via cronjob Best part is that all we have to do is point this .py to a new hosted feat. service (survey123 database) and it will start firing off new reports based on any fields! ... View more