Latest Contributions by KellyMeehan

rvburton Please let me know if you have any clue, or might need more information to potentially help, if you could! ... View more

So I've been following these instructions. This is my code: ---------------------------------------------------------------------------------------------------------- import arcpy masterFC = r"C:\Users\kameehan\OneDrive - Westwood Active Directory\Documents\Project_Documents\UI_Railroad\Shapefiles\Observations_FGDB\UI_Walkdown_Observations.gdb\Observations" masterFlds = ['GlobalID', 'NAME'] # Use list comprehension to build a dictionary from a da SearchCursor masterDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(masterFC, masterFlds)} print(masterDict) relatedTbl = r'C:\Users\kameehan\OneDrive - Westwood Active Directory\Documents\Project_Documents\UI_Railroad\Shapefiles\Observations_FGDB\UI_Walkdown_Observations.gdb\Observations_ATTACH' relatedFlds = ['REL_GLOBALID', 'ATT_NAME', 'DATA'] fileLocation = r'C:\Users\kameehan\OneDrive - Westwood Active Directory\Documents\Project_Documents\UI_Railroad\Shapefiles\Observations_FGDB\UI_Walkdown_Observations.gdb\Observations_ATTACH' with arcpy.da.SearchCursor(relatedTbl, relatedFlds) as cursor: for item in cursor: # item[0] is related GlobalID; take first item in masterDict tuple with that key f1 = masterDict[item[0]][0].replace(" ","_") # replacing spaces # assuming attachment name starts with "attachment", remove that part and keep rest f2 = item[1][10:] # can use .split('.')[1:] or similar to get just extension # make new filename filename = "ATT_{}_{}".format(f1, f2) print (filename) open(fileLocation + os.sep + filename, 'wb').write(item[2].tobytes()) del cursor --------------------------------------------------------------------------------------------------------------------------- and I keep getting this error: Traceback (most recent call last): File "C:\Users\kameehan\OneDrive - Westwood Active Directory\Documents\ExportAttachments2.py", line 16, in <module> with arcpy.da.SearchCursor(relatedTbl, relatedFlds) as cursor: RuntimeError: cannot open 'C:\Users\kameehan\OneDrive - Westwood Active Directory\Documents\Project_Documents\UI_Railroad\Shapefiles\Observations_FGDB\UI_Walkdown_Observations.gdb\Observations_ATTACH' Failed to execute (ExportAttachments2). And I'm not sure how to fix it or what is wrong. As in why won't it open that file path? ... View more