AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Valued Contributor
larsj
Posts: 73
Registered: ‎06-13-2005
Message 1 of 20 (237 Views)
Accepted Solution

Texts aren't rotated after Map Export DWG to SQLLite

237 Views, 19 Replies
06-12-2012 03:36 AM

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

Hi,

 

>> I noticed that you where able to choose text on the map export form but I don't have those options on top

I have modified the MAPEXPORT.INI file in th section of SQLite (in orange the changed part), so you get the object-types also available to chose.

 

   [FDO_SQLITE]
   File=True
   Rootname=False
   EntTypes=Types
   FeatureClass=Single
   CreateClassBy=None
   SupportsAppend=False

 

Search through your workstation through all folder (also through hidden ones) for a file called MAPEXPORT.INI and modify that option. Restart Map3D then.

 

>> Have you tried connecting to the database from a new drawing, adding the texts to the map via a style?

May be I don't understand you correctly ... have you modified the style also in the new drawing with the formula for rotation

TXT_ANGLE / 3.14159 * 180

???

If you opened my drawing (drawing and db-file placed in C:\TEMP) do you see the rotation then or not?

 

- alfred -

*Expert Elite*
Alfred.NESWADBA
Posts: 9,398
Registered: ‎06-29-2007
Message 2 of 20 (235 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 03:40 AM in reply to: larsj

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
-------------------------------------------------------------------------
Valued Contributor
larsj
Posts: 73
Registered: ‎06-13-2005
Message 3 of 20 (231 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 03:58 AM in reply to: larsj

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?

*Expert Elite*
Alfred.NESWADBA
Posts: 9,398
Registered: ‎06-29-2007
Message 4 of 20 (227 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 04:23 AM in reply to: larsj

Hi,

 

>> If so, do you know why it converts the value?

The strongly correct answer is: because Autodesk did it this way :smileywink:

 

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
-------------------------------------------------------------------------
Valued Contributor
larsj
Posts: 73
Registered: ‎06-13-2005
Message 5 of 20 (226 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 04:30 AM in reply to: Alfred.NESWADBA

Ok, but I don't really understand how 192.0233g can be converted to the value 4.8376865658545531. Any idea?

*Expert Elite*
Alfred.NESWADBA
Posts: 9,398
Registered: ‎06-29-2007
Message 6 of 20 (224 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 04:38 AM in reply to: larsj

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
-------------------------------------------------------------------------
Valued Contributor
larsj
Posts: 73
Registered: ‎06-13-2005
Message 7 of 20 (221 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 04:49 AM in reply to: Alfred.NESWADBA

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.

*Expert Elite*
Alfred.NESWADBA
Posts: 9,398
Registered: ‎06-29-2007
Message 8 of 20 (218 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 04:56 AM in reply to: Alfred.NESWADBA

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
-------------------------------------------------------------------------
Valued Contributor
larsj
Posts: 73
Registered: ‎06-13-2005
Message 9 of 20 (214 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 05:09 AM in reply to: Alfred.NESWADBA

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

*Expert Elite*
Alfred.NESWADBA
Posts: 9,398
Registered: ‎06-29-2007
Message 10 of 20 (212 Views)

Re: Texts aren't rotated after Map Export DWG to SQLLite

06-12-2012 05:12 AM in reply to: larsj

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
-------------------------------------------------------------------------
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!