Observe code sample below. Once again I haven't tested the code, so be careful.
def main():
global arcpy
import arcpy, os
# fixed settings
fldBLOB = 'DATA'
fldAttName = 'ATT_NAME'
fldRelOID = 'REL_OBJECTID'
# your settings (edit these)
fc = r"C:\Project\_LearnPython\Attachments\test.gdb\Meldingen"
tbl = r"C:\Project\_LearnPython\Attachments\test.gdb\Meldingen__ATTACH"
outFolder = r"C:\Project\_LearnPython\Attachments"
fldRelatedInfo = 'SomeFieldInFeatureClass' # should be valid column in FC
with arcpy.SearchCursor(tbl) as cursor:
for row in cursor:
binaryRep = row.getValue(fldBLOB)
fileName = row.getValue(fldAttName)
relOID = row.getValue(fldRelOID)
# access related information
myRelatedInfo = QueryRelatedData(fc, fldRelatedInfo, relOID)
# do something with the related info
# save attachment to disk
open(outFolder + os.sep + fileName, 'wb').write(binaryRep.tobytes())
del row
del binaryRep
del fileName
def QueryRelatedData(fc, fldRelatedInfo, relOID):
fldOID = 'OBJECTID'
expression = arcpy.AddFieldDelimiters(fc, fldOID) + " = {0}".format(relOID)
with arcpy.SearchCursor(fc, where_clause=expression) as cursor:
for row in cursor:
return row.getValue(fldRelatedInfo)
break
del row
if __name__ == '__main__':
main()
