Question

Writing Portal for ArcGIS (or AGOL) image attachments to SDE - relationship class ok but image is not valid

Forum|Forum|6 years ago
March 28, 2019
7 replies
209 views

+11

annette2
Contributor
96 replies

Hi,

I am copying a Portal hosted feature service to our internal Oracle SDE database.

The relationship class is written ok and I can see that the correct attachment is associated with the parent table. However the image is not valid when I try to open it via ArcGIS Pro or ArcMap.

I've read a lot of forum posts including this one but I still haven't got it working. Does anyone have an example with the last steps on how to get the downloaded attachment (binary data) into a SDE jpeg attachment that I could take a look at?

Or outline the order of the transformers Binarydecoder, rasterreplacer (I see the raster in inspector, only if I use the decoder first), AttributeFileWriter (you write the file to a disk but not the database - do you use the AttributeFileReader to read it again and write to an attribute in the attachment table?)

Any ideas would be appreciated.

Thanks in advance,

Annette

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+11

annette2
Author
Contributor
96 replies
Forum|Forum|6 years ago
March 28, 2019

Got it working. I will post the workspace later so that others can reference it.

We want to take a copy of Survey123 records and attachments to our internal SDE schema (and to be able to see the photos because the Inbox doesn't support attachments).

BinaryDecoder > RasterReplacer> AttributeFileWriter > AttributeFileReader was the sequence I used. Perhaps there is a more elegant solution but this worked.

This screenshot is the part used to write the photo to the database.

+19

bruceharold
Supporter
344 replies
Forum|Forum|6 years ago
March 28, 2019

Got it working. I will post the workspace later so that others can reference it.

We want to take a copy of Survey123 records and attachments to our internal SDE schema (and to be able to see the photos because the Inbox doesn't support attachments).

BinaryDecoder > RasterReplacer> AttributeFileWriter > AttributeFileReader was the sequence I used. Perhaps there is a more elegant solution but this worked.

This screenshot is the part used to write the photo to the database.

Good example, on a related topic I avoided writing directly to attachments like this:

https://community.esri.com/community/open-platform-standards-and-interoperability/blog/2019/03/21/using-arcgis-pros-python-environment-in-etl-tools

psr14789
1 reply
Forum|Forum|6 years ago
July 2, 2019

Got it working. I will post the workspace later so that others can reference it.

We want to take a copy of Survey123 records and attachments to our internal SDE schema (and to be able to see the photos because the Inbox doesn't support attachments).

BinaryDecoder > RasterReplacer> AttributeFileWriter > AttributeFileReader was the sequence I used. Perhaps there is a more elegant solution but this worked.

This screenshot is the part used to write the photo to the database.