Skip to main content
Question

GeoMedia/Oracle Format Attributes


fmelizard
Safer
Forum|alt.badge.img+18
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

10 replies

fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 9, 2013
Hi,

 

Have tried exposing the attributes in the reader or via the attribute exposer ? 

fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 9, 2013
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

fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 9, 2013
Have you tried to make use if the fme_text_string instead ?

fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 9, 2013
Yes, but  I do not see it in the attribute in the visualizer

 


fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 9, 2013
Can you copy the oracle element list into a new attribute?

fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 9, 2013
None of the List transformers see the list oracle_element so I can't copy that attribute.

fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 9, 2013
You can try to copy the list element attribute name and paste it into the attribute copier or creator.

 


fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 9, 2013
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

 

 


fmelizard
Safer
Forum|alt.badge.img+18
  • Author
  • Safer
  • October 10, 2013
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.

 

 


  • November 20, 2013
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.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings