topic Re: Feature service attachments- how to access them & use? in ArcGIS Online Questions

Feature service attachments- how to access them & use?

C_EHoward — Thu, 26 Mar 2015 16:42:37 GMT

I have a web app that allows users to upload an attachment with the map note they draw on the map. That seems to work as expected. but once I have attachments, I do not see logically where they should be accessed & how they can be related to the GDB that contains the feature classes to which the attachments belong.

My uploaded attachments are visible at the REST endpoint, such as

//myserver/arcgis/rest/services/Folder/ServiceName/FeatureServer/1/26/attachments

I also see that the attachments are in the following folder on my AGS machine:

\\arcgisserver\directories\arcgissystem\arcgisuploads\scratch- all attachments are seen here

My question now is how to make the connection between the scratch folder contents (with long numeric file names) and my attachments? I can click on the REST endpoint to get them. They are also listed in the ATTACH table in my SQL GDB that is the managed database for my data. But I do not see the connection between the two.

I also see some non-image attachments here:

\\arcgisserver\directories\arcgisoutput\Folder\ServiceName_MapServer

I would like to be able to have some way to more easily find the attachments on my server after users upload content. Right now there does not seem to be a way to relate the files by name or other field.

Please help me untangle the web.....thanks

Re: Feature service attachments- how to access them & use?

JakeSkinner — Thu, 26 Mar 2015 21:00:25 GMT

Hi C E,

Take a look at the relationship class properties (right-click > Properties) between the feature class an attachment table. It will tell you the fields used for the relationship. Ex:

Re: Feature service attachments- how to access them & use?

C_EHoward — Fri, 27 Mar 2015 12:58:23 GMT

Thanks for the response. This is not what I am asking exactly. I am trying to figure out how to actually use the attachments that are uploaded by users when editing. The files are accessible at the REST endpoint by the name that the user gives. However, the only place I have been able to physically find the files (as in storage location other than a URL) is in the scratch folder I mention above. The only thing in the attach table is the REL_OBJECTID like you mention, that relates to the position in REST where the attachment resides. But there is nothing in the files themselves anywhere that I can easily download and assign a particular file to a record since the scratch files do not have the REL_OBJECTID.

Do these attachments with useful names/IDs live anywhere other than REST? If not, how can I collect these attachments besides manually? thanks

Re: Feature service attachments- how to access them & use?

JakeSkinner — Sun, 12 Dec 2021 01:29:24 GMT

You can use the following script to download all of the attachments. The attachment name will match the name of the ATT_NAME field in attachments table:

import os, arcpy
tbl = r"C:\Projects\SQLServer.sde\VECTOR.VECTOR.Graffiti__ATTACH"
fldBLOB = 'DATA'
fldAttName = 'ATT_NAME'
outFolder = r"C:\Temp\Attachments"

with arcpy.da.SearchCursor(tbl,[fldBLOB,fldAttName]) as cursor:
  for row in cursor:
      binaryRep = row[0]
      fileName = row[1]
      # save to disk
      open(outFolder + os.sep + fileName, 'wb').write(binaryRep.tobytes())

print 'Finished'

Re: Feature service attachments- how to access them & use?

C_EHoward — Tue, 31 Mar 2015 13:21:58 GMT

Thanks for the script. I tried running it and got a syntax error on the 2nd line....think it was because the data owner name was in quotes. So I changed it to this (was "COGMASTER\AGS" before)

... tbl = r"C:\Users\choward\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\Connection to TPBData.sde\TPBData.COGMASTER\AGS.BikeBeltway_inner__ATTACH"

After that, nothing seems to happen. I do not use python much so maybe I am just missing a simple thing. I copied the code into the python window in Catalog, maybe I should save as a file and run somewhere/how?

thanks

Re: Feature service attachments- how to access them & use?

JakeSkinner — Wed, 01 Apr 2015 11:32:03 GMT

Do you have the 'outFolder' path created on your server? In the example, the attachments are being written to 'C:\Temp\Attachments'. Make sure this folder exists.

Re: Feature service attachments- how to access them & use?

C_EHoward — Wed, 01 Apr 2015 12:39:14 GMT

yes, I have that folder already created. I am thinking its something with my SDE connection string, but this is the location for it....only difference is the quotes as mentioned above. I am going to copy the string again and try one more time.....stay tuned

Should I log this as an official support case? only hesitation there is it usually takes longer to get a response. But I need to figure out how to use the attachments people will be providing (any day now, my app goes live next week)

Re: Feature service attachments- how to access them & use?

C_EHoward — Wed, 01 Apr 2015 12:48:52 GMT

This time I get this

Runtime error

Traceback (most recent call last):

File "<string>", line 7, in <module>

RuntimeError: cannot open 'C:\Users\choward\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\Connection to TPBData.sde\TPBData.COGMASTER\AGS.BikeBeltway_inner__ATTACH'

I should mention that the C drive in this line is my workstation, and the C:\temp is on my server machine

Re: Feature service attachments- how to access them & use?

JakeSkinner — Wed, 01 Apr 2015 13:23:22 GMT

Can you send a screen shot of how the attachment appears in your catalog window?

Re: Feature service attachments- how to access them & use?

C_EHoward — Wed, 01 Apr 2015 13:47:16 GMT

Thanks for the response....here is the attachment table. I only see the attachments via the REST endpoint or in the scratch folder

Re: Feature service attachments- how to access them & use?

JakeSkinner — Wed, 01 Apr 2015 13:54:29 GMT

Try the following for the tbl variable:

tbl = r'Database Connections\Connection to TPBData.sde\TPBData."COGMASTER\AGS".BikeBeltway_inner__ATTACH'

Also, create the 'C:\Temp\Attachments' directory on your machine.

Re: Feature service attachments- how to access them & use?

C_EHoward — Mon, 06 Apr 2015 13:22:59 GMT

Thanks for the reply and suggestion. I used this syntax and added the table name and it worked. I have my attachments from each table in the temp folder now. Now that they are there I can at least assign the correct attachment to the correct feature and eventually join the attach table to the feature class to get the attachments to appear in a web map (when its ready).

I appreciate the script, it will no doubt come in handy. Thanks for all the help!

Re: Feature service attachments- how to access them & use?

C_EHoward — Tue, 25 Jul 2017 15:11:54 GMT

Is there a way I can make my input database connection and the output folder a parameter in a model? So far, I tried modifying the script to have tbl = arcpy.GetParameter(0) and then define my parameter in a model, but ArcMap keeps crashing....so I do not think I am modifying the script correctly or choosing the right kind of parameter (its an SDE table). The script I am using is the same as was provided previously. I would like to share this model with folks using our Collector app so they can download the photos taken out in the field. and it would be easier to give a model than modify the script each time. thanks-