How to modify script to get photos of collector with desire filename

MaryamPanji

I’m trying to export attachments (photos) with area_ID at the begining.

I have a feature class, a table that has _ATTACH in its name, and a relationship class. I use _ATTACH table and http://support.esri.com/technical-article/000011912 to export photos to a local folder. The name of photos look like this:

17_Photo1.jpg

18_Photo2.jpg

19_Photo3.jpg

20_Photo4.jpg

I want to get ride of 17,18,19 and 20 but add a field from the feature class at the beginning of the photos name.

How can I do that?

The field is area_ID and I want the photo names to become like this:

2AFD_Photo1.jpg

2AFD_Photo2.jpg

2AFD _Photo3.jpg

2AFD _Photo4.jpg

The script I use based on http://support.esri.com/technical-article/000011912 

The script:
import arcpy
from arcpy import da
import os
inTable = arcpy.GetParameterAsText(0)
fileLocation = arcpy.GetParameterAsText(1)
with da.SearchCursor(inTable, ['DATA', 'ATT_NAME','ATTACHMENTID']) as cursor:
    for item in cursor:
        attachment = item[0]
        filenum = str(item[2]) + "_"
        filename = filenum + str(item[1])
        open(fileLocation + os.sep + filename, 'wb').write(attachment.tobytes())
        del item
        del filenum
        del filename
        del attachment

 

['DATA', 'ATT_NAME','ATTACHMENTID'] all these fields are in -ATTACH table and I want to add the area_ID instead of 'ATTACHMENTID' which is in the origin feature class.

 

Thanks

dougbrowning

This is the way.  Just do a join then you can grab the other field.  I do it like this.

# to get the names and PrimaryKey
photoForm = "Photos"
# actual attachements table
attachName = "Photos__ATTACH"

outDir = r"C:\tmp\Photos"

# should be standard
fldBLOB = 'DATA'
fldAttName = 'ATT_NAME'

dateLoadedInDb = "2020-09-01"

# vars--------------------

print "Starting"

# join to  form to get the PrimaryKey and state info
# Note the first year they called it PlotKey instead
arcpy.MakeTableView_management(inDB + "\\" + attachName, "attachView")
arcpy.AddJoin_management("attachView", "REL_GLOBALID", inDB + "\\" + photoForm, "globalid")
# funky due to the join
fieldList = [attachName + "." + fldBLOB, attachName + "." + fldAttName, photoForm + ".PlotKey", photoForm + ".Office", photoForm + ".filename_T1", photoForm + ".filename_T2", photoForm + ".filename_T3" \
            ,photoForm + ".filename_Soil", photoForm + ".MiscPhoto1filename", photoForm + ".MiscPhoto2filename", photoForm + ".MiscPhoto3filename", photoForm + ".MiscPhoto4filename", photoForm + ".MiscPhoto5filename"]
with arcpy.da.SearchCursor("attachView", fieldList) as cursor:
   for row in cursor:
      binaryRep = row[0]
     # full access to fields here