Skip to main content
  • EN
I try to convert an Oracle Spatial table to MapInfo .TAB.

 

There is an MI_STYLE column. The spatial table looks all right in a MapInfo linked table.

 

 

In the workbench I ticked ' Apply MapInfo Symbology' and set the Style Column to MI_STYLE and Index Column to MI_PRINX (as they are in the database) n the Oracle Spatial Object Parameters panel.

 

 

However I get this eror message for all the objects and the style of all the objects in the output MapInfo table are the same (default):

 

ORACLE Reader: Failed to parse MapInfo Symbology string.  String was `Pen( 2, 2, 32768 )  '

 

 

All the objects are lines and polylines.

 

 

Does anyone have an idea why FME cannot parse the symbols?
I'd recommend that you take a look at the contents of the MI_STYLE column in a bit more detail to make sure there are no corrupt values in there, no blanks etc. Presumably when you view the data in MapInfo you see all the appropriate styles as read from the MI_STYLE column?

 

 

There's not much on FMEPedia about this because its relatively new, in the old days you had to manually parse the MI_STYLE attribute with a set of transformers. 

 

 

http://fmepedia.safe.com/articles/Error_Unexpected_Behavior/Oracle-reader-error-ora-00904-invalid-identifier

 

 

I'd also make sure that you are using the official MFAL Writer, rather than MITAB, though the error does point to the Reader as the issue.

 

 

http://fmepedia.safe.com/articles/FAQ/What-is-the-difference-between-the-MFAL-and-MITAB-Readers-and-Writers

 

Oh, those evil spaces!

 

 

`Pen( 2, 2, 32768 )  '  fails,

 

`Pen (2, 2, 32768) ' is working.

 

 

Thanks a lot for the tips, Dave.

 

You saved me the time to create a custom transformer that processes the MI_STYLE values :)

 

It had to be the spaces, it always is! Check out my first post to this forum... spaces are always tripping me up, so I always look there first... except in this case of course!

 

 

https://safe.secure.force.com/AnswersQuestionDetail?id=906a0000000cZy5AAE

 

ORACLE Reader: Failed to parse MapInfo Symbology string.  String was `Pen(12,2,13421772) Brush(2,16764057)'

 

... Last line repeated 2499 times ...

 

 

I think I change back to the old day method

Reply


Community Stats

30,159
Posts
114,480
Replies
37,805
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.