Latest Contributions by DominicRobergeIADOT

Hello, for me all me SDE connections are in the same folder (workspace) so if you define the workspace, you should get your listing of SDE databases. Worked for me. 🙂 (in Catalog, right click the SDE connection, select properties and look at the path of the "name") import arcpy arcpy.env.workspace = r"C:\Users\USERNAME\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog" # List all file geodatabases in the current workspace workspaces = arcpy.ListWorkspaces("*", "SDE") for workspace in workspaces: print workspace     ... View more

those little things 🙂 FYI, if you try to use that expression in Fields Maps... it won't work..I have been working with ESRI Tech Support on that and this morning they logged it as a bug (I was using almost the same code to bring attachments in the popup) Reference number:- BUG-000144024 Public Status:- New Synopsis:- The arcade expression to count the number of attachments fails to honor in the ArcGIS Field Maps. ... View more

Hi Keith can you click the "+" sign then the list of values will be generated and you can select what ever you want. ... View more

perhaps there is an issue with the formula. Other things to keep in mind.  1) make sure you have all options available when creating the symbology (in my case I don't have records with value 'test2' yet therefore it's not an option when creating the symbology)   2) Otherwise, make sure to select the Other option it should work. Good luck! ... View more

hummm I just tested it here using the following code var drTest = $feature.testDefaultValue; var drNewVal = When( drTest =='dr_test',"Code1", drTest =='test1',"Code2", "complete" ) return drNewVal;   and that got me this:   ... View more

Hey Kevin   could you try to use a Notebook in ArcGIS Pro? I do something similar but my source is a AGOL hosted feature layer.    ... View more

Hey Robert what if you try this. That should give you a "clean" name for your FGDB for fd in datasetList: print(fd) fdSplit = fd.split('.') print(fdSplit[2]) arcpy.CreateFeatureDataset_management(outFolderPath, fdSplit[2]) ... View more

try this: for dataset in arcpy.ListDatasets("", "Feature"): print (dataset) for fc in arcpy.ListFeatureClasses(feature_dataset=dataset): print(" " +fc)   ... View more

Hey Paul   Not sure if you solved your problem but I have a script that does exactly what you are trying to accomplish Let me know if you have any questions (in my case I had to filtered for start and end dates but you can remove that) def main(): import arcpy from arcpy import da import os inTable = "Database Connections\\[email protected]\\coa_working.COA_GIS.Parcels_point_edit_assessor__ATTACH" ##inTable=arcpy.GetParameterAsText(0) fc = "Database Connections\\[email protected]\\coa_working.COA_GIS.Parcels_point_edit_assessor" ##fc = arcpy.GetParameterAsText(1) fldRelatedInfo = 'PARCELID' # should be valid column in FC ##fldRelatedInfo = arcpy.GetParameterAsText(2) fileLocation = "d:\\temp\\assessor\\Attch_input" ##fileLocation = arcpy.GetParameterAsText(3) ##print fileLocation #dStartDate = arcpy.GetParameterAsText(4) dStartDate = '10/01/2019' #dEndDate = arcpy.GetParameterAsText(5) dEndDate = '03/15/2020' expresDate = "[last_edited_date]>='" + dStartDate + "' and [last_edited_date]<'" +dEndDate + "'" print expresDate ##~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ## ##Sterp 1: ## ##Query records that are between the selected dates ## print "Entering FC search records between dates" ## ##expresDate = "[PicTaken] = 'Yes' and [last_edited_date]>='" + dStartDate + "' and [last_edited_date]<'" +dEndDate + "'" ## print expresDate with da.SearchCursor(fc, ['GlobalID', 'PARCELID'],where_clause=expresDate) as cursor: NewRec = [] multipleVals = {} rowcountNewRec = 0 for item in cursor: ##Initial counter ##print item[0] tmf = {item[0]:item[1]} multipleVals.update(tmf) NewRec.append(item[0]) rowcountNewRec = rowcountNewRec+1 print len(NewRec) ##~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ##Sterp 2: ##Query records from the attached table that matches the previous selection print "Entering Attachment Searchcursor" ##Search from the attachment table for itemAttch in multipleVals: ##print "--------------- " + itemAttch + " ---- " + multipleVals[itemAttch] attExpression = arcpy.AddFieldDelimiters(inTable, 'REL_GLOBALID') + " = '{0}'".format(itemAttch) print attExpression with da.SearchCursor(inTable, ['DATA', 'ATT_NAME', 'ATTACHMENTID', 'REL_GLOBALID'], where_clause=attExpression) as cursor: filesNew = [] rowcount = 1 for item in cursor: ##Initial counter relOID = item[3] print relOID ##Check to see if the selected records in the List created from the date range if relOID in NewRec: print "We found a new picture -- " + relOID else: print "-- Not relevent" ##print rowcount ##Check to see if the record already has a picture, if it does find the # and assigned the if relOID in filesNew: filesNew.append(relOID) iCount = filesNew.count(relOID) rowcount = iCount else: rowcount = 1 filesNew.append(relOID) # access related information... Choose Geocode or parcelid???? print "looking for related info" ##myRelatedInfo = QueryRelatedData(fc, fldRelatedInfo, relOID) myRelatedInfo = multipleVals[itemAttch] print "****** " +myRelatedInfo attachment = item[0] filename = myRelatedInfo + "-0" + str(rowcount) + ".jpg" ##filenum + str(item[1]) print filename ##Save JPG in a folder open(fileLocation + os.sep + filename, 'wb').write(attachment.tobytes()) print "File has been created" del filename del attachment if __name__ == '__main__': main() ##~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~   should return something like this (PARCELID-XX.jpg)  XX=number of attachments)     ... View more

you still should have C:\Python27\ArcGIS10.6\Lib\site-packages then open the Desktop10.6.pth with notepad I am using 10.8 and got this C:\Python27\ArcGIS10.8\Lib\site-packages\Desktop10.8.pth   ... View more

  look at this link in the Paths and import section https://desktop.arcgis.com/en/arcmap/10.6/analyze/python/importing-arcpy.htm       ... View more