Skip to main content
I am using FME 2012 SP4 to exposed a number of GeoMedia Format attributes on our text features coming from an Oracle DB i.e. geomedia_text_string, When I run the WB the attribute name changes to oracle_element{0}.geomedia_text_string which looks like a list to me. I have tried to use list manipulators to get to the text string but a list is not exposed.

 

 

Any thoughts on how to get to these format attributes so that I can export them?

 

 

Cheers
Hi,

 

Have tried exposing the attributes in the reader or via the attribute exposer ? 
Yes I have, but somewhere the exposed attribute name gets modified.

 

Original exposed Format attribute name = geomedia_text_string

 

becomes

 

oracle_element{0}.geomedia_text_string

 

when I look at it in the visualizer
Have you tried to make use if the fme_text_string instead ?
Yes, but  I do not see it in the attribute in the visualizer

 


Can you copy the oracle element list into a new attribute?
None of the List transformers see the list oracle_element so I can't copy that attribute.
You can try to copy the list element attribute name and paste it into the attribute copier or creator.

 


Solution:

 

1 add all the oracle_element_* attributes in an attribute creator

 

2 connect the attribute copier  to the attribute creator  to copying the attributes.

 

3 disable the attribute creator

 

 


Hi,

 

 

With FME 2013 you can replace your solution with a single attribute creator ( it does stay red) but the new attribute is created with the oracle list values.

 

 


GeoCookie ,

 

 

I having the same issue.  How do you 

 

 

1 add all the oracle_element_* attributes in an attribute creator

 

 

How do you specife the value for oracle_element{0}.geomedia_text_string>

 

 

Any help is much appreciated.  Tim.

Reply