3 Replies Latest reply on Jan 29, 2016 8:24 AM by wh.grush

    read Conduit System blob field using FME

    Constantinos Constantinides

      Is there a way to read the Conduit System BLOB field using Safe's FME?

      Currently we have in use the following versions: ArcGIS 10.2.1, ArcFM 10.2.1b, FME 2015.

        • Re: read Conduit System blob field using FME

          Hi Constantinos,

          Yes, FME can read BLOB data.  It will appear as an array of bytes in the varialble fme_buffer.

          However, since OOTB FME is unaware of the structure of the byte stream, it is unable to translate it into usable data.  For that you will need detailed information on the internal data structure of the blob and the object(s) that it represents.  (This information is often proprietary to the application that populated the database table.)  With that information you can dust off your C++ programming skills and write a custom transformer to extract the object attribute values from the byte stream.

          Can you be specific about what data you want to extract from the blob?

          Thanks, --Bill

            • Re: read Conduit System blob field using FME
              Constantinos Constantinides

              Hi William,

              Thank you for your answer.

              The actual requirement is to locate all features in ConduitSystem FC that contain Ducts with certain values. Therefore the need is to read the blob of each Feature in conduit System FC, read all values in all fields of all ducts and write them out in a new FC.

               

              Schneider provides an example in C# of how to "Display Conduit Configuration" at the following link %%ItemTitle%%

               

              Based on your reply the easiest way is to write a custom transformer (based on the example available) to extract the attribute values.

               

              However if Schneider provided an alternative approach (that is proven) then it would save me a lot of time.

              Thanks

                • Re: read Conduit System blob field using FME

                  Hi Constantinos,

                  A viable alternative for you would be to modify the example code to operate on all for the features in the feature class (rather than just the selected feature) and write the OBJECTID and duct data to a format that FME can read, such as csv.  Then in FME, you would add a reader for that data file and merge the output with the output from your existing feature class reader.  Or you could write all of the data of interest to the cvs file and replace the feature class reader with a csv reader and use that output to create the new feature class.

                  Let us know if that does the trick for you.

                  Thanks, --Bill