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

    AutoCAD Civil 3D

    Reply
    Active Member
    Edoc13
    Posts: 9
    Registered: ‎09-22-2010
    Accepted Solution

    Survey Database Point Description Length

    245 Views, 8 Replies
    12-06-2012 01:34 PM

    Civil 3D 2013 SP1 (64bit)

     

    When importing an event, my point descriptions are cutoff at 16 characters.

     

    Is there any setting to increase this?

     

    If I have Microsoft Access installed on my computer, can one easily modify the table?

    If you can modify the table using Access, can you define a default DB or would I have to redefine the string length within a table everytime I create a DB thru Civil 3D GUI?

     

    Please use plain text.
    Valued Mentor
    Posts: 470
    Registered: ‎09-29-2008

    Re: Survey Database Point Description Length

    12-06-2012 04:39 PM in reply to: Edoc13
    Not sure what you mean as I don't use survey really. Is this controlled by description key sets if so you only need a few characters I the DB, then define the text string for each key in civil 3d under key sets.
    Please use plain text.
    Active Member
    Edoc13
    Posts: 9
    Registered: ‎09-22-2010

    Re: Survey Database Point Description Length

    12-06-2012 05:26 PM in reply to: mikeevans

    I'm not really talking about DescKeys but surveyors would need more than 16 chars in the point description when using DescKeys anyway. Ex: "BLDG B  RPN1000 /#123 EXAMPLE ROAD"

     

    I'm speaking of the actual point description.

     

    I just visit another user (Civil 3D 2012 on Win7) and they can have at least 40 chars.

     

    I beginning to believe it may have something to do with Win7 (true 64bit).

     

    I also just remembered that when I start C3D, i see the following message on the command line:

     

    No MS Jet provider found...

     

    Or something like that. I'll post the actual message when I'm back at the office.

     

    Please use plain text.
    *Expert Elite*
    BrianHailey
    Posts: 2,384
    Registered: ‎04-27-2005

    Re: Survey Database Point Description Length

    12-06-2012 06:50 PM in reply to: Edoc13
    Please use plain text.
    *Expert Elite*
    Murph
    Posts: 1,584
    Registered: ‎11-13-2006

    Re: Survey Database Point Description Length

    12-07-2012 04:36 AM in reply to: Edoc13

    Edoc13 wrote:

     I also just remembered that when I start C3D, i see the following message on the command line:

     No MS Jet provider found...

     Or something like that. I'll post the actual message when I'm back at the office.

     


    To fix that issue use the "MAPOPTIONS" and on the Data Source tab of the dialog there is a place to change the default provider for MS Acess databases, select one that's on your workstation.

    Murph
    Supportting the troops daily.
    Please use plain text.
    *Expert Elite*
    Posts: 3,040
    Registered: ‎07-22-2003

    Re: Survey Database Point Description Length

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

    Edoc13 wrote:

    I'm not really talking about DescKeys but surveyors would need more than 16 chars in the point description when using DescKeys anyway. Ex: "BLDG B  RPN1000 /#123 EXAMPLE ROAD"

     


    I'm not finding. in the 2013 help. where it lists valid characters to use in your input file, nor do you mention what kind of file you are importing (fieldbook, point file, etc.). But I think your issue comes from the # character in the description....most, if not all, of the stock PointFileFormat styles use the # character as a comment tag, so anything following it is ignored.

     

    12-7-2012 6-44-13 AM.png

    Jeff_M, also a frequent Swamper
    Please use plain text.
    Mentor
    IanMcClain
    Posts: 256
    Registered: ‎09-29-2008

    Re: Survey Database Point Description Length

    12-07-2012 11:09 AM in reply to: Edoc13

    Can you post a sample file of what you are importing?

     

    I haven't had an issue with the survey database limiting my descriptions to 16 characters, but my data collector software limits me to 16 characters. In fact I regularly store long descriptions as * with the description as raw data note, then copy and past them in place of the * in the file I import into C3D.

    -Ian McClain
    (running C3D 2012 sp3, Win7 64bit)
    Please use plain text.
    Active Member
    Edoc13
    Posts: 9
    Registered: ‎09-22-2010

    Re: Survey Database Point Description Length

    12-07-2012 04:25 PM in reply to: IanMcClain

    I was importing a FBK.

    When speaking with IT, I imported a ASCII file and all the characters were there!

     

    It turns out the Survey Data Collection Link (found on the Home tab under Create Ground Data) was reducing the characters when converted from TDS .RAW to FBK.

     

    Thanks for the help everyone!

     

    @Jeff_M: Thanks for pointing out that I need to remove/change the comment tag for ASCII import.

    Please use plain text.
    *Expert Elite*
    BrianHailey
    Posts: 2,384
    Registered: ‎04-27-2005

    Re: Survey Database Point Description Length

    12-07-2012 06:00 PM in reply to: Edoc13

    Thanks for posting up the answer you came across. It helps when others are searching for an answer.

    Please use plain text.