AutoCAD Map 3D
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hello,
I wan't to export a DWG-file with texts to a sqllite database to be used i MapGuide. The export is successfull but I can't get the rotation of texts to work properly - all the texts are horizontally aligned and not rotated. For example, the ROTATION field of a text in the sqllite database has the value 4.8376865658545531 - in the DWG the rotation property is 192.0233g - but when using the ROTATION field as the value for Rotation in the style label it isn't being rotated. Am I doing something wrong?
Regards
Lars Jensen
Solved! Go to Solution.
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hi,
IMHO the ROTATION-value is measured in radiant (based on PI) and not degrees.
So you can make a function like
ROT_DEGREE = ROT_RADIANT / PI * 180
HTH, - alfred -
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
So when I export from a DWG to sqllite it converts radiants to degrees and that I need to convert the value in the sqllite database? If so, do you know why it converts the value?
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hi,
>> If so, do you know why it converts the value?
The strongly correct answer is: because Autodesk did it this way ![]()
The answer (I think) is that it has to be one default or there must be any config-files parallel to the SQLite-export that gives the information of what angle-units you are using, what angle is the north-direction and so on.
So it's done easy, no config-files and just one default.
- alfred -
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Ok, but I don't really understand how 192.0233g can be converted to the value 4.8376865658545531. Any idea?
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hi,
4 question, then I start to think about what your settings may be:
- what is your UNITS-setting in your DWG?
- how is your north-direction set in the DWG?
- what is your position angle-direction? Clockwise or counterclockwise?
- are you sure that you measured your object while WCS was active (and not any UCS/UserCoordianteSystem)
Or use this alternative: copy the drawing erase all but this one text-object and upload this new drawing.
- alfred -
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Units = Meters
Northdirection = 100.0000g
Angle = Grads (type) and clockwise
I'm not sure what you mean. I haven't measured any objects but there is a coordinate system specified in the drawing. Could that have something to do with it? The drawing was sent to me, I haven't produced it myself.
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hi,
you are working 100° based (don't know how it's called in english, in German it's "Neugrad")
and you have your system rotated to another 0-direction then the export does
and you have another positive angle direction.
Look to this sketch:
HTH, - alfred -
[EDIT] Sorry answers crossed, I have not seen that you already answered before [/EDIT]
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
I think I understand the problem, but I don't know how to fix it. I tried changing the northdirection to 0 and changing units (in format-> units) from Grads to Decimal Degrees but I still get the same result in the sqllite database. That makes me believe that perhaps I don't understand the problem as I thought... ![]()
Re: Texts aren't rotated after Map Export DWG to SQLLite
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hi,
You have to:
- change your angular untis to "RADIANT"
- your 0-direction has to point to east
- your angular direction has to be counter-clockwise
....that brings you to the same settings in AutoCAD like the exporter does (hope so, have not tried it at the moment).
Hope now that makes it more clear!
- alfred -
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------



