txdot2012@gmail.com

Mass creation of Attachments from an oracle "BLOB" table

Discussion created by txdot2012@gmail.com on Feb 13, 2013
Latest reply on Sep 13, 2013 by mvolz47
Hi,

Please forgive me with my newbie question. I am still learning my way around ArcGIS 10.1 and python

Is this possible to write a python script to perform batch loading attachments from a blob column of an oracle table ? In this case, I have a featureclass with MATCHID field (say PIC_ID). I also have a "detail" oracle table that has coresponding PIC_ID column and the image is stored in a blob column.

I went through the add attachments example of ArcGIS 10.1 using matching table to generate attachment by loading image from file folders using "arcpy":

http://resources.arcgis.com/en/help/...0000014v000000

The above example loads images from an o/s folder.  Is this feasible to use a similar python script with arcpy & cx_oracle to add attachment using data from a blob column in an oracle table ? or is there other tool in Arcgis to perform this task in batch ?

Thank you in advance for any pointers.

Michael

Outcomes