Skip to main content
Solved

transfer AutoCAD mtext-rotation to SQLite

  • December 6, 2012
  • 1 reply
  • 10 views
reservoirdog
Supporter
Forum|alt.badge.img+10
Hello community!

 

 

I tried several times to get mtexts of a dwg into sqlite without success.

 

the mtext-entities are represented as points in sqlite,

 

transferring text-string and text-rotation as attributes of these points.

 

text-string as well as other stuff (height etc.) can be exported without any problems,

 

but with rotations i never had any success.

 

i tried "autocad_text_rotation" as well as "autocad_rotation" as well as

 

"fme_rotation" but always gives a "0" as result in sqlite.

 

datatype of rotations in dwg is always "number, 31,15".

 

I tried using "decimal, 31,15" for the sqlite, but it says in the log,

 

fme can only create "decimal, 29,15" datatype in sqlite.

 

 

What's the problem?

 

Why can't i use the dwg-mtext-rotation?

 

thx for any help,

 

best regards from switzerland.

Best answer by davideagle

Suggest you write all of your 'possible' text rotation values out to an FFS file to begin with to check to see if they actually contain a value other than 0. FFS is FMEs own internal format so it won't destroy datatypes or attribute values as some formats do. Once you have confirmed which attribute you actually need to use, thats usually half the battle.

 

 

As none of the SQLite writers support Text geometry you'll need to either use a TextStroker to create a line or polygon geometry (that looks like the text string) that you can rotate about an anchor point... or store the data as a point or null geom and the rotation value as an attribute that you can use in your client.
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

1 reply

davideagle
Contributor
Forum|alt.badge.img+21
  • davideagleContributor
  • Contributor
  • Best Answer
  • December 14, 2012
Suggest you write all of your 'possible' text rotation values out to an FFS file to begin with to check to see if they actually contain a value other than 0. FFS is FMEs own internal format so it won't destroy datatypes or attribute values as some formats do. Once you have confirmed which attribute you actually need to use, thats usually half the battle.

 

 

As none of the SQLite writers support Text geometry you'll need to either use a TextStroker to create a line or polygon geometry (that looks like the text string) that you can rotate about an anchor point... or store the data as a point or null geom and the rotation value as an attribute that you can use in your client.

Helpful Members This Week

Community Stats

31,322
Posts
118,830
Replies
38,954
Members

Latest FME

Terms & ConditionsCookie settings

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
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.