Latest Contributions by JamesCrandall

Completely missed that looking at the docs. Thanks again! ... View more

Awesome.  Is that the "boundary" or most outer ring? Thanks! ... View more

it's maddening.  Thanks for that tip Dan! ... View more

I think it's just easier to insert the rings as a single polygon feature into an "in_memory" feature class first.  What I didn't reveal was what ultimately I was doing -- clipping. The issue I had was that I was using a polygon to clip with but because there were multiple rings in each feature I was not correctly handling things.  To simplify it all, I can just insert the rings from a feature into a feature class and then execute my clip from two whole feature classes. Sorry there's little detail in this but I think I have it covered. ... View more

We have several WAB applications deployed that were developed with various versions of Web AppBuilder (Developer Edition), many of which have the Enhanced Search widget.  We're planning an entire rebuild and redeploy of all of these WAB products using the most current Web AppBuilder (Developer Edition) version 2.9. Will the current eSearch widget version 2.7 work or should we reconsider? Thanks! ... View more

Thanks for that.  I should have mentioned the additional detail you provided, it's probably important: Hosted FS Source to a Survey123 survey Attachments Thanks again! ... View more

Thanks!  Invite to group sent.  There's only 1 hosted FS in there. ... View more

I get a KeyError: 'GlobalID' on the last line in this block:         # Add Attachments         # Create Match Table         if whereClause != '1=1':             attachmentGlobalIDs = []             for x in data['layers'][0]['features']:                 print x['attributes'][OID]                 if x['attributes'][OID] in OIDs:                     attachmentGlobalIDs.append(x['attributes']['GlobalID']) <--KeyError thrown here ‍‍‍‍‍‍‍‍ ... View more

Hi Jake -- I'm running this as a scheduled task (a . bat executes the .py script), so no Toolbox implementation.  The whereClause is how I posted in my last reply -- I just want to change to only use features from the service after an input date using the CreationDate column.  The whereClause works and applied correctly and the script runs most the way thru.  It fails when attempting to add attachments and create the match table. Here's the first whereClause statement(s) setup (whereClause2 is for the date filter, I left the original whereClause the same):     # Return largest ObjectID     whereClause = '1=1'     whereClause2 = "CreationDate>'{}'".format(inputD)     if whereClause == '':         whereClause = '1=1'     #params = urllib.urlencode({'f': 'pjson', 'where': "CreationDate>'{}'".format(inputDate), 'outFields': '*', 'token': token, 'returnGeometry': 'true'})     params = {'where': whereClause2, 'returnIdsOnly': 'true', 'token': token, 'f': 'json'}     req = urllib2.Request(baseURL, urllib.urlencode(params))     print baseURL     response = urllib2.urlopen(req)     data = json.load(response)     try:         data['objectIds'].sort()     except:         arcpy.AddError("\nURL is incorrect.  Or, Service is secure, please enter username and password.\n")         #sys.exit()     OIDs = data['objectIds']     arcpy.AddMessage(OIDs)     count = len(data['objectIds'])     iteration = int(data['objectIds'][-1])     minOID = int(data['objectIds'][0]) - 1     OID = data['objectIdFieldName']‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I get the correct list of OIDs.  Also, I can see that it retrieves the attachments & creates replica just fine It fails in the section         # Add Attachments         # Create Match Table         if whereClause != '1=1':             attachmentGlobalIDs = []             for x in data['layers'][0]['features']:                 if x['attributes'][OID] in OIDs:                     attachmentGlobalIDs.append(x['attributes']['GlobalID'])         try:             for x in data['layers'][0]['attachments']:                 if whereClause != '1=1':                     for attachmentGlobalID in attachmentGlobalIDs:                         if x['parentGlobalId'] == attachmentGlobalID:                             gaUrl = x['url']                             gaFolder = cwd + os.sep + x['parentGlobalId']                             if not os.path.exists(gaFolder):                                 os.makedirs(gaFolder)                             gaName = x['name']                             gaValues = {'token' : token }                             gaData = urllib.urlencode(gaValues)                             try:                                 urllib.urlretrieve(url=gaUrl + '/' + gaName, filename=os.path.join(gaFolder, gaName),data=gaData)                             except:                                 PrintException("Error Retrieving Attachments")                             rows = arcpy.da.InsertCursor(fc + "__ATTACH", ["GlobalID_Str", "PhotoPath"])                             rows.insertRow((x['parentGlobalId'], cwd + os.sep + x['parentGlobalId'] + os.sep + x['name']))                             del rows                             hasrow = True‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Specifically, it throws an error here          if hasrow == True:                 try:                     arcpy.AddMessage("Adding attachments")                     arcpy.AddAttachments_management(fc, 'GlobalID_Str', fc + '__ATTACH', 'GlobalID_Str', 'PhotoPath')                 except:                     PrintException("Error Retrieving Attachments")             try:                 arcpy.MakeTableView_management(fc + '__ATTACH', "tblView")                 arcpy.SelectLayerByAttribute_management("tblView", "NEW_SELECTION", "DATA_SIZE = 0")                 arcpy.DeleteRows_management("tblView")                 arcpy.DeleteField_management(fc + '__ATTACH', 'GlobalID_Str')                 arcpy.DeleteField_management(fc + '__ATTACH', 'PhotoPath')             except Exception, e:                 print "Error removing empty rows from attachment table"                 PrintException("Error removing empty rows from attachment table")                 pass‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The except block throws the print "Error removing empty rows from attachment table". ... View more

Jake, I've been trying to apply an additional filter on the initial whereClause variable so that it only pulls feature from my Hosted Feature Service after a specified date.  I tried at about line # 220 of the script so that the params variable includes the updated whereClause -- this is what I'm changing from:     # Return largest ObjectID     if whereClause == '':         whereClause = '1=1'     params = {'where': whereClause, 'returnIdsOnly': 'true', 'token': token, 'f': 'json'}     data = urllib.parse.urlencode(params)     data = data.encode('ascii') # data should be bytes     req = urllib.request.Request(baseURL, data)     response = urllib.request.urlopen(req)     data = response.read().decode("utf-8")     json_acceptable_string = data.replace("'", "\"")     data = json.loads(json_acceptable_string)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ To: # Return largest ObjectID     #whereClause = '1=1'     whereClause = "CreationDate>'{}'".format(inputD)     if whereClause == '':         whereClause = '1=1'     #params = urllib.urlencode({'f': 'pjson', 'where': "CreationDate>'{}'".format(inputDate), 'outFields': '*', 'token': token, 'returnGeometry': 'true'})     params = {'where': whereClause, 'returnIdsOnly': 'true', 'token': token, 'f': 'json'}     req = urllib2.Request(baseURL, urllib.urlencode(params))     print baseURL     response = urllib2.urlopen(req)     data = json.load(response)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ However, anywhere else in the code where it checks for "if whereClause != '1=1':" then it seems to run into issues.  Perhaps because it is using a Replica (which is out of sync with the queries feature service?). Is there a straight forward way to alter this script so that the initial whereClause/params filtered on an input date? Thanks ... View more

Congratulations Robert -- well deserved! ... View more

Hi Tina, I was trying to run this on a Windows Server 2008 R2 box that is a designated "developer" environment for us. FYI: I ended up installing AppStudio on a local computer to test it out (Windows7 machine).  However, our org is rapidly moving to Virtual Desktop environments, I will have to coordinate to get it installed there. ... View more

3.0.53 AppStudio_x64_3_0_53.exe is the file I downloaded.  ... View more