I am attempting to automate a process of exporting photos from a Survey123 geodatabase and give the output a custom filename, modified from the general script for exporting photos provided by Esri. Here is what I have so far. I am trying to join the Feature Layer, image_repeat table and image_repeat__ATTACH table before exporting the photos so that I can use fields that are in the feature class attribute table in the output file names. import arcpy from arcpy import da import os featureTable = arcpy . GetParameterAsText ( 0 ) # the Feature layer repeatTable = arcpy . GetParameterAsText ( 1 ) # the image_repeat table attachTable = arcpy . GetParameterAsText ( 2 ) # the image_repeat__ATTACH table fileLocation = arcpy . GetParameterAsText ( 3 ) # Output folder location for the photos arcpy . AddJoin_management ( repeatTable , "parentglobalid" , featureTable , "globalid" ) arcpy . AddJoin_management ( repeatTable , "Nutrient_Bank_Monitoring.globalid" , attachTable , "REL_GLOBALID" ) with da . SearchCursor ( repeatTable , [ 'DATA' , 'ATT_NAME' , 'ATTACHMENTID' , 'site' , 'plot' ] ) as cursor : for item in cursor : attachment = item [ 0 ] # blob data type site = str ( item [ 3 ] ) plotNum = str ( item [ 4 ] ) filenum = "ATT" + str ( item [ 2 ] ) + "_" # i.e. ATT531_ filename = site + "_Plot" + plotNum + "_" + filenum + str ( item [ 1 ] ) #i.e. miyagi_creek_Plot6_ATT531_plot_image-20200324-143302.jpg open ( fileLocation + os . sep + filename , 'wb' ) . write ( attachment . tobytes ( ) ) del item del filenum del filename del attachment However, I get the following error message - "The value cannot be a table": I have no problem doing the joins manually in ArcMap, so I'm unclear why it won't work in the script. Is it possible to do what I'm trying to do? I am obviously still a python newbie, so many thanks in advance for any help or advice!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem with AddJoin - "The Value Cannot Be A Table"

KClarkDev_GIS

I am attempting to automate a process of exporting photos from a Survey123 geodatabase and give the output a custom filename, modified from the general script for exporting photos provided by Esri. Here is what I have so far. I am trying to join the Feature Layer, image_repeat table and image_repeat__ATTACH table before exporting the photos so that I can use fields that are in the feature class attribute table in the output file names.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> da
<SPAN class="keyword token">import</SPAN> os

featureTable <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># the Feature layer</SPAN>
repeatTable <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># the image_repeat table</SPAN>
attachTable <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># the image_repeat__ATTACH table</SPAN>
fileLocation <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># Output folder location for the photos</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddJoin_management<SPAN class="punctuation token">(</SPAN>repeatTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"parentglobalid"</SPAN><SPAN class="punctuation token">,</SPAN> featureTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"globalid"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddJoin_management<SPAN class="punctuation token">(</SPAN>repeatTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Nutrient_Bank_Monitoring.globalid"</SPAN><SPAN class="punctuation token">,</SPAN> attachTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"REL_GLOBALID"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>repeatTable<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'DATA'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ATT_NAME'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ATTACHMENTID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'site'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'plot'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        attachment <SPAN class="operator token">=</SPAN> item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># blob data type</SPAN>
        site <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        plotNum <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        filenum <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ATT"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="comment token"># i.e. ATT531_</SPAN>
        filename <SPAN class="operator token">=</SPAN> site <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_Plot"</SPAN> <SPAN class="operator token">+</SPAN> plotNum <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> filenum <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#i.e. miyagi_creek_Plot6_ATT531_plot_image-20200324-143302.jpg</SPAN>
        open<SPAN class="punctuation token">(</SPAN>fileLocation <SPAN class="operator token">+</SPAN> os<SPAN class="punctuation token">.</SPAN>sep <SPAN class="operator token">+</SPAN> filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'wb'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>attachment<SPAN class="punctuation token">.</SPAN>tobytes<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">del</SPAN> item
        <SPAN class="keyword token">del</SPAN> filenum
        <SPAN class="keyword token">del</SPAN> filename
        <SPAN class="keyword token">del</SPAN> attachment<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

However, I get the following error message - "The value cannot be a table":

I have no problem doing the joins manually in ArcMap, so I'm unclear why it won't work in the script. Is it possible to do what I'm trying to do?

I am obviously still a python newbie, so many thanks in advance for any help or advice!

Vind meer berichten getagd met

Accepted answers

DavidPike

Hi, the problem is you cant apply a join to a dataset, it must be a layer.

arcpy.MakeFeatureLayer(in_features, out_layer)

arcpy.MakeFeatureLayer(repeatTable, "repeatTable_lyr")

then swap out your join repeatable for the layer, "repeatTable_lyr" will exist in the memory workspace or a workspace you specify, you can also of course assign it to a variable.

https://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-feature-layer.htm

All comments

DavidPike

You can reference the data via a cursor through the dataset path itself, not even sure if it works on a layer. Also save the layer after the join then use that path in the cursor.

for fields input into the cursor you can pass in a list of field names as strings:

cursor_fields = ["Field1", "Field2", "Field3"]

with arcpy.da.cursor(path, cursor_fields) as cursor...

throw some print statements into the variables you're creating in the cursor, my guess is your final path is ending up a bit funky after concatenation, i'd use os.path.join instead.

KClarkDev_GIS

You're right, I used an IF statement and confirmed that all of the attributes for the DATA column are None type. The script runs successfully with this IF statement but just returns "No Attachment data" for all rows.

<SPAN class="keyword token">with</SPAN> da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>repeatLayer<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'plot_image_repeat__ATTACH.DATA'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'plot_image_repeat__ATTACH.ATT_NAME'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'plot_image_repeat__ATTACH.ATTACHMENTID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Nutrient_Bank_Monitoring.site'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Nutrient_Bank_Monitoring.plot'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        attachment <SPAN class="operator token">=</SPAN> item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># blob data type</SPAN>
        site <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        plotNum <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        filenum <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ATT"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="comment token"># i.e. ATT531_</SPAN>
        filename <SPAN class="operator token">=</SPAN> site <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_Plot"</SPAN> <SPAN class="operator token">+</SPAN> plotNum <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> filenum <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#i.e. miyagi_creek_Plot6_ATT531_plot_image-20200324-143302.jpg</SPAN>
        <SPAN class="keyword token">if</SPAN> attachment <SPAN class="operator token">!=</SPAN> None<SPAN class="punctuation token">:</SPAN>
            open<SPAN class="punctuation token">(</SPAN>fileLocation <SPAN class="operator token">+</SPAN> os<SPAN class="punctuation token">.</SPAN>sep <SPAN class="operator token">+</SPAN> filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'wb'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>attachment<SPAN class="punctuation token">.</SPAN>tobytes<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'No Attachment data'</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">del</SPAN> item
        <SPAN class="keyword token">del</SPAN> filenum
        <SPAN class="keyword token">del</SPAN> filename
        <SPAN class="keyword token">del</SPAN> attachment<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

So, something must be going wrong with the join. (again, this issue does not occur when I do the joins manually). Any ideas?

Thanks again for the help!

DavidPike

A few print statements will give you a better idea. has that DATA column got any missing values or nulls? that would throw an exception. If so use a bit of logic such as if type(attachment)… do this or a try Except block with a continue.

KClarkDev_GIS

Hi David, thanks for your response.

I had to use the makeTableView function because I am working with a table rather than a layer:

repeatLayer <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>repeatTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"repeatTable_lyr"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

However, then I run into this error, 'NoneType' object has no attribute 'tobytes'

So I guess you can't use that function on a table view? If so, how can I access that information to be able to export the photo and assign it a custom file name?

DavidPike

Hi, the problem is you cant apply a join to a dataset, it must be a layer.

arcpy.MakeFeatureLayer(in_features, out_layer)

arcpy.MakeFeatureLayer(repeatTable, "repeatTable_lyr")

then swap out your join repeatable for the layer, "repeatTable_lyr" will exist in the memory workspace or a workspace you specify, you can also of course assign it to a variable.

https://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-feature-layer.htm

DanPatterson_Retired

Throw in a print statement to check the datatype or use

Describe object properties—ArcPy Functions | Documentation

or use the describe object's dataType to limit the objects that you process

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.