Hi Xander!
I know this thread is quite old, but I thought I'd give it a try anyway. I'm trying to implement your "QueryRelated Data" function in 10.3 and I'm getting the runtime errors below.
Runtime error
Traceback (most recent call last):
File "<string>", line 36, in <module>
File "<string>", line 17, in main
RuntimeError: cannot open 'C:\PhotoLog\AGO\gdb\GPO_PhotoLog.gdb\Photo_Video_Documentation_ATTACH'
Has anything changed with 10.3 that would cause these errors? I've provided my code as well. Any help would be greatly appreciated!
def main():
global arcpy
import arcpy, os
# fixed settings
fldBLOB = 'DATA'
fldAttName = 'ATT_NAME'
fldRelGID = 'REL_GLOBALID'
# your settings (edit these)
## related feature class
fc = r"C:\PhotoLog\AGO\gdb\GPO_PhotoLog.gdb\Photo_Video_Documentation"
## attachment table
tbl = r"C:\PhotoLog\AGO\gdb\GPO_PhotoLog.gdb\Photo_Video_Documentation_ATTACH"
fldRelatedInfo = 'CreationDate' # should be valid column in FC
with arcpy.da.SearchCursor(tbl,[fldBLOB,fldAttName,fldRelGID]) as cursor:
for row in cursor:
binaryRep = row[0]
fileName = row[1]
relGID = row[2]
# access related information
myRelatedInfo = QueryRelatedData(fc, fldRelatedInfo, relGID)
print myRelatedInfo
def QueryRelatedData(fc, fldRelatedInfo, relGID):
fldGID = 'GlobalID'
expression = arcpy.AddFieldDelimiters(fc, fldGID) + " = '{0}'".format(relGID)
with arcpy.da.SearchCursor(fc, (fldGID, fldRelatedInfo), where_clause=expression) as cursor:
for row in cursor:
return row[1]
break
del row
if __name__ == '__main__':
main()
