Skip to main content
Question

GeoMedia/Oracle Format Attributes

  • October 9, 2013
  • 10 replies
  • 16 views

fmelizard
Safer
Forum|alt.badge.img+21
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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

10 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • 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+21
  • 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+21
  • Author
  • Safer
  • October 9, 2013
Have you tried to make use if the fme_text_string instead ?

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

 


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

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