topic Re: Naming Batch Exports From FGDB in Python Questions

Naming Batch Exports From FGDB

PaulGardiner — Tue, 28 Sep 2021 11:51:43 GMT

I am batch exporting photo attachments from a FGDB using the ExportAttachment script (as attached). The FGDB consists of points which have a field called MapID (which contains a unique identified for each point).

Is there script I can add to this so that the exported photo is named as 'FieldValue_PhotoNo'?

I have also used the Export Attachments tool by @UriGilad_EsriAu but would rather not have to group the photos by field value if possible (so the output consists of a single folder containing all photos rather than multiple folders).

Re: Naming Batch Exports From FGDB

DavidPike — Tue, 28 Sep 2021 12:29:27 GMT

Have you modified the cursor to take your fields? The name will be derived from a concatenation of row[0] and row[1].

Re: Naming Batch Exports From FGDB

PaulGardiner — Tue, 28 Sep 2021 14:11:20 GMT

Apologies, Python scripting is not a forte of mine. Would appreciate it if you could expand a little bit on the above. Thanks.

Re: Naming Batch Exports From FGDB

DavidPike — Tue, 28 Sep 2021 14:36:55 GMT

I think it may just be an easy change of the fields specified in the cursor (part of the script), but I'm not completely sure of your field names and the output name, is it based on MapID or fieldValue_photoNumber?

import arcpy from arcpy import da import os inTable = arcpy.GetParameterAsText(0) fileLocation = arcpy.GetParameterAsText(1) #data, attname and attachmentid will need to be changed to your relevant fields with da.SearchCursor(inTable, ['DATA', 'ATT_NAME', 'ATTACHMENTID']) as cursor: for item in cursor: attachment = item[0] filenum = "ATT" + 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

Re: Naming Batch Exports From FGDB

BlakeTerhune — Tue, 28 Sep 2021 21:34:21 GMT

Export Attachments Toolbox - Esri Community

I don't see where it would be making multiple folders. There should only be the one fileLocation folder with all the attachments. I altered the code slightly for ArcGIS Pro to make it easier for you to change the file name. Could you give a specific example of how you want the output files to be named and organized?

import arcpy import os in_table = arcpy.GetParameterAsText(0) out_dir = arcpy.GetParameterAsText(1) with arcpy.da.SearchCursor(in_table, ['DATA', 'ATT_NAME', 'ATTACHMENTID']) as cursor: for data, att_name, attachmentid in cursor: file_name = f"ATT{attachmentid}_{att_name}" file_path = os.path.join(out_dir, file_name) open(file_path, 'wb').write(data.tobytes())

Re: Naming Batch Exports From FGDB

DonMorrison1 — Tue, 28 Sep 2021 17:52:26 GMT

I do something similar to this. Since I have a relationship defined between the attachment table and the feature class, there is a field in the attachment table that holds the GUID of the associated feature. So my script reads this field in (along with 'DATA', 'ATT_NAME', 'ATTACHMENTID') then looks up the feature to get the desired value ('MapID') in your case.

Re: Naming Batch Exports From FGDB

UriGilad_EsriAu — Wed, 29 Sep 2021 00:35:12 GMT

Hi @PaulGardiner,

You can achieve this doing the following workflow:

1. Use the Export Attachments toolbox to export the photos to different folders by field value.

2. In windows explorer, search for the photos (e.g., "ext: jpg") in the folder containing all the exported folders. You will get a list of all the photos from all the folders.

3. Select all the photos, cut and paste into one folder

4. Delete all the empty folders

The other replies to your post are using the base script provided by Esri (which is also found in my toolbox as Export Attachments From Table). That script doesn't and can't access the field value because that value is not stored in the photo attachment table, but only in the parent Feature Class. To access this value the script needs to match each photo's REL_GLOBALID to the parent's feature class GLOBALID, which is what the Export Attachments toolbox does.

Hope this helps,

Uri

If this answer solved your question or if you found it helpful please mark it accordingly to help others who have the same question.

Re: Naming Batch Exports From FGDB

PaulGardiner — Wed, 29 Sep 2021 08:13:39 GMT

Thanks @UriGilad_EsriAu , yes that does work but had wanted to automate the entire process from within GIS.

Intention was to join the attribute field I wanted to name the files with to the attachment table using GLOBALID/REL_GLOBALID as the join field.

Re: Naming Batch Exports From FGDB

UriGilad_EsriAu — Thu, 30 Sep 2021 05:46:35 GMT

Hi @PaulGardiner,

If it's any help, here's a little ArcGIS toolbox that grabs all the photos from the folders, moves them up a level and deletes the folders. The tool input should be the folder where you exported all your photos to.

It'll work only on jpg and png file types. To add more types open the script and add types extension type in 'file_type' parameter. Any folder that had photos in it and remained empty after the export will be deleted.

Cheers,

Uri

If this answer solved your question or if you found it helpful please mark it accordingly to help others who have the same question.

Re: Naming Batch Exports From FGDB

PaulGardiner — Thu, 30 Sep 2021 16:27:36 GMT

Thanks all, hoping to get a chance over the coming days to work through your suggestions and will update. Your help, as always, is much appreciated.

Re: Naming Batch Exports From FGDB

PaulGardiner — Thu, 30 Sep 2021 16:28:13 GMT

Thanks for that, really appreciated. Will try and put together a workflow with both scripts.

Re: Naming Batch Exports From FGDB

DominicRobergeIADOT — Thu, 14 Oct 2021 21:42:04 GMT

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)