Latest Contributions by DominicRobergeIADOT

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\\DATABASENAME@DIRECTCONNECT.sde\\coa_working.COA_GIS.Parcels_point_edit_assessor__ATTACH" ##inTable=arcpy.GetParameterAsText(0) fc = "Database Connections\\DATABASENAME@DIRECTCONNECT.sde\\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

Hey pmccord, for your first question, I had a similar problem and I solved it with the following flow: 1) I exported the Notebook to python 2) In SQL Server, I created a  SQL Server Agent job to run my script 3) In SQL Server, I created a Stored Procedures to trigger the SQL Agent job created @ previous step 3) In MS Power Automate I created a flow to manually trigger the stored procedures created @ previous step 4) have the end users install the Power Automate App on their phone and push the button to reset their data any time they need to. if this is something that could work for you, I would be more than happy to share the flow in details with screenshots. Good luck! D ... View more

humm interesting. Can You open the py file using the IDLE try to run it see if you are getting any error messages. (right click on the file and select Edit with IDLE). I use this all the time and it works on desktop and servers   ... View more

Hello,   I know it's an old post, but I am having the same issue as described above.... what could be the cause? ... View more

Thank you Jordan!   working perfectly!👏 ... View more

Hello    I believed I solved my problem related to the error 3079 Domain already exists. In my feature class, I had a Domain with a special character in the name (Yes/No as name).... I renamed to Yes_No , all my fields using that domain got updated, I refreshed my map service and I was able to load my web map in Collector and Field maps without issues. Good luck! D ... View more

Hello Mindy   were you able to solve your problem with tech support?  I am experiencing the same type of issue, with a map service and web map that has been working for years... I do have an open ticket with Support as well but I am curious has how other users solve this issue.   Thanks! ... View more

Same here. Some of our Assignments have multiple tasks executed by multiple crews. So Dispatcher would create the initial assignment (TASK A to crew A). Once crew A complete Task A, they would assigned Task B to crew B and so on. So having the Work Name and assignment Type in the assignment feature layer would help a lot.  ... View more