I have FME reading attachments from AGOL and writing them to a FGDB or SDE GDB. The problem that I'm having now is that FME isn't writing the blobs to the file geodatabase in a way that esri can handle them.
The first screenshot is a directly downloaded database from AGOL. The second screenshot is from the database that I reloaded data with FME. The first screenshot allows you to view attachments, while the second screenshot doesn't allow me to view attachments.
Thoughts @Mark2AtSafe?
I believe your best bet is to use ArcGIS Rest Service to get the attachments. The problem is the related table for hosted feature service is not exposed through rest end point. You can see the related table when you download the hosted feature service to File Geodatabase.
Hello @runneals,
Are you able to clarify your workflow for me, I think if I am understanding correctly.
You are reading in a feature from AGOL that contains attachments, you then want to write this to a Geodatabase(File or SDE) and maintain the attachments with the features. Is that correct?
Hello @runneals,
Are you able to clarify your workflow for me, I think if I am understanding correctly.
You are reading in a feature from AGOL that contains attachments, you then want to write this to a Geodatabase(File or SDE) and maintain the attachments with the features. Is that correct?
I had to delete and recreate the relationship class in the fgdb and recreated it to join the ORIGINAL_GUID and ORIGINAL_RELGUID (both which come from the original AGOL item).
I believe your best bet is to use ArcGIS Rest Service to get the attachments. The problem is the related table for hosted feature service is not exposed through rest end point. You can see the related table when you download the hosted feature service to File Geodatabase.
Hello @runneals
Apologies for the delay in getting back to you.
In order to get the blobs into an ArcSDE or File Geodatabase, you would have to create another table for the blobs and set up a relationship between the original and attachment table. If you would prefer a simpler/easier way of being able to carry out this translation of maintaining the relationship between the features please let me know.
Hello @runneals
Apologies for the delay in getting back to you.
In order to get the blobs into an ArcSDE or File Geodatabase, you would have to create another table for the blobs and set up a relationship between the original and attachment table. If you would prefer a simpler/easier way of being able to carry out this translation of maintaining the relationship between the features please let me know.
Thanks!
agol-attachments-testing-to-fgdb.fmw
I posted this answer also here: IDEA: Simplify AGOL to Geodatabase with attachments
***
I know there is a post somewhere on the knowledge base about this
topic. I could not find it that quickly, but I did find this post: Introduction to Working with Introduction to Working with Geodatabase Relationship Classes
I
have done this several years ago myself and a few steps need to be
taken. First a database needs to be prepared and all the feature classes
/ tables need to be present before writing, including the relationship
class. Next when writing in FME, features have to be written to the
parent, the child class and the relationship class. And attention needs
to be paid to the writing of the ID's otherwise your relationships /
attachments will get messed up!