• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Map 3D

    Reply
    Valued Contributor
    Posts: 73
    Registered: ‎06-13-2005

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

    06-12-2012 05:30 AM in reply to: alfred.neswadba

    Now the value is the same, both in the DWG and the sqllite database, but when I connect to the database and use the rotation value it seems that it interprets it as degrees even though I have the correct units etc in the drawing. I'm stumped. I've attached the DWG in question, if you have time it would be great to hear if you get some other result...

     

     

    Please use plain text.
    *Expert Elite*
    Posts: 6,404
    Registered: ‎06-29-2007

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

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

    Hi,

     

    what AutoCAD-Map3D version do you use? Just ot make the tests with the same release and you will then be able to use my data.

     

    - alfred -

    -------------------------------------------------------------------------
    Alfred NESWADBA
    Ingenieur Studio HOLLAUS ... www.hollaus.at
    -------------------------------------------------------------------------
    Please use plain text.
    Valued Contributor
    Posts: 73
    Registered: ‎06-13-2005

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

    06-12-2012 05:39 AM in reply to: alfred.neswadba

    Autocad Map 3D 2011 product version E.208.0.0.

    Please use plain text.
    *Expert Elite*
    Posts: 6,404
    Registered: ‎06-29-2007

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

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

    Hi,

     

    sorry, most of the time I spent was to reduce the video to the max-upload-limit of 1.5MB (I love it :smileysad: ). I hope the quality is enough to recognize what I typed.

    Try to reproduce what I did (within your drawing).

     

    HTH, - alfred -

    -------------------------------------------------------------------------
    Alfred NESWADBA
    Ingenieur Studio HOLLAUS ... www.hollaus.at
    -------------------------------------------------------------------------
    Please use plain text.
    *Expert Elite*
    Posts: 6,404
    Registered: ‎06-29-2007

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

    06-12-2012 07:02 AM in reply to: larsj

    Hi,

     

    and additionally the data I created (just the text-objects, no MTEXT).

    I had save all (DWG and SQLite-file) in C:\TEMP

     

    - alfred -

    -------------------------------------------------------------------------
    Alfred NESWADBA
    Ingenieur Studio HOLLAUS ... www.hollaus.at
    -------------------------------------------------------------------------
    Please use plain text.
    Valued Contributor
    Posts: 73
    Registered: ‎06-13-2005

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

    06-12-2012 07:14 AM in reply to: alfred.neswadba

    You've done a hell of a job, thanks for putting in so much effort!

     

    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 attached a picture of my form.

     

    I'll use this video and/or your export if I can't get it to work myself. Thanks!

    Please use plain text.
    Valued Contributor
    Posts: 73
    Registered: ‎06-13-2005

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

    06-12-2012 07:26 AM in reply to: alfred.neswadba

    And one final thing. Have you tried connecting to the database from a new drawing, adding the texts to the map via a style? I did that with your database and got the same phenomenon - the texts aren't rotated properly... :smileyfrustrated:

     

    I'm starting to think that I'm a dumbass. :smileytongue:

    Please use plain text.
    *Expert Elite*
    Posts: 6,404
    Registered: ‎06-29-2007

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

    06-12-2012 07:45 AM in reply to: larsj

    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 -

    -------------------------------------------------------------------------
    Alfred NESWADBA
    Ingenieur Studio HOLLAUS ... www.hollaus.at
    -------------------------------------------------------------------------
    Please use plain text.
    Valued Contributor
    Posts: 73
    Registered: ‎06-13-2005

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

    06-12-2012 07:49 AM in reply to: alfred.neswadba

    I forgot the formula! Now it works perfectly. I think I exported it correctly, all I was missing was the formula in the style. I've learned alot, thanks!

    Please use plain text.
    *Expert Elite*
    Posts: 6,404
    Registered: ‎06-29-2007

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

    06-12-2012 07:50 AM in reply to: larsj

    You're welcome! - alfred -

    -------------------------------------------------------------------------
    Alfred NESWADBA
    Ingenieur Studio HOLLAUS ... www.hollaus.at
    -------------------------------------------------------------------------
    Please use plain text.