Converting jpg images to BLOB

[JayanthiRajagopalan]

I have a field in a feature class that contains the names of the .jpg files. The actual images are stored in the hard drive. I need to convert these images and save them to another field in the same feature class as a BLOB object. Is there a way to do this in ArcGIS PRO?

[AlfredBaldenweck]

Could you just add them as attachments in an attachment table? They'll be stored as BLOB in the attachment table.

Add Attachments (Data Management)—ArcGIS Pro | Documentation

Generate Attachment Match Table (Data Management)—ArcGIS Pro | Documentation

[JayanthiRajagopalan]

That option may not be acceptable, as the customer wants the images to be written in the BLOB format in one of the fields of the output feature class. 

[RhettZufelt]

It appears you can use arcpy updatecursor to do this.

However, I don't see any ESRI product/tool that can access it, so, not sure the benefit.

R_

[JayanthiRajagopalan]

Ok, let me try this. Thanks

[RenatoSalvaleon3]

If you prefer no code, ArcGIS Data Interoperability extension for Pro can do this but you need to install the product and license it.

Here's a sample article with a solution from Safe software on how to do it using Data Interoperability/FME Form.
https://community.safe.com/s/article/how-to-read-the-contents-of-a-file-into-a-database

Here's a couple of use cases whose solutions can be reauthored to solve your problem and can do exactly what you want to do, di-survey123-tools-no-code-required.

[AlfredBaldenweck]

I suppose maybe you could just do a join between the origin and attachment tables, then export them together?

[JayanthiRajagopalan]

I have tried to do this. However, the Data field (where the BLOB files are stored) is not one of the fields that can be transferred to the input table. It does not appear in the Transfer field option. Maybe there is another way, which I am not aware of yet.

[AlfredBaldenweck]

Did you give this a look? Adding raster datasets as attributes in a feature class—ArcGIS Pro | Documentation