Skip to main content
Question

GeoMedia/Oracle Format Attributes

  • Oct 9, 2013 3:54 PM UTC
  • 10 replies
  • 62 views

fmelizard
Safer
Forum|alt.badge.img+22
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+22
  • Author
  • Safer
  • Oct 9, 2013 7:12 PM UTC
Hi,

 

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

fmelizard
Safer
Forum|alt.badge.img+22
  • Author
  • Safer
  • Oct 9, 2013 7:24 PM UTC
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+22
  • Author
  • Safer
  • Oct 9, 2013 7:43 PM UTC
Have you tried to make use if the fme_text_string instead ?

fmelizard
Safer
Forum|alt.badge.img+22
  • Author
  • Safer
  • Oct 9, 2013 7:55 PM UTC
Yes, but  I do not see it in the attribute in the visualizer

 


fmelizard
Safer
Forum|alt.badge.img+22
  • Author
  • Safer
  • Oct 9, 2013 8:07 PM UTC
Can you copy the oracle element list into a new attribute?

fmelizard
Safer
Forum|alt.badge.img+22
  • Author
  • Safer
  • Oct 9, 2013 8:23 PM UTC
None of the List transformers see the list oracle_element so I can't copy that attribute.

fmelizard
Safer
Forum|alt.badge.img+22
  • Author
  • Safer
  • Oct 9, 2013 8:30 PM UTC
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+22
  • Author
  • Safer
  • Oct 9, 2013 8:40 PM UTC
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+22
  • Author
  • Safer
  • Oct 10, 2013 6:16 AM UTC
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.

 

 


  • Nov 20, 2013 4:03 PM UTC
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.