AutoCAD Civil 3D General Discussion

AutoCAD Civil 3D General Discussion

Reply
Contributor
Edoc13
Posts: 22
Registered: ‎09-22-2010
Message 1 of 9 (455 Views)
Accepted Solution

Survey Database Point Description Length

455 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?

 

*Expert Elite*
mikeevans
Posts: 764
Registered: ‎09-29-2008
Message 2 of 9 (437 Views)

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

Civil3D 2013 / 2014 British UK
Windows 7 Professional 64-bit
Intel(R) Core(TM) i7-3820 CPU @ 3.60GHz (8 CPUs), ~4.0GHz With 32768MB RAM, AMD FirePro V4900, Dedicated Memory: 984 MB, Shared Memory: 814 MB

Contributor
Edoc13
Posts: 22
Registered: ‎09-22-2010
Message 3 of 9 (430 Views)

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.

 

*Expert Elite*
BrianHailey
Posts: 2,791
Registered: ‎04-27-2005
Message 4 of 9 (421 Views)

Re: Survey Database Point Description Length

12-06-2012 06:50 PM in reply to: Edoc13

Seems to work fine for me: 

 

http://screencast.com/t/idRxdQbPqNki 

Brian Hailey
CAD-1.com
My Blog
*Expert Elite*
Murph
Posts: 1,959
Registered: ‎11-13-2006
Message 5 of 9 (407 Views)

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.
*Expert Elite*
Jeff_M
Posts: 4,316
Registered: ‎07-22-2003
Message 6 of 9 (399 Views)

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
Valued Mentor
IanMcClain
Posts: 447
Registered: ‎09-29-2008
Message 7 of 9 (386 Views)

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 sp4, Win7 64bit, 8GB)
Contributor
Edoc13
Posts: 22
Registered: ‎09-22-2010
Message 8 of 9 (376 Views)

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.

*Expert Elite*
BrianHailey
Posts: 2,791
Registered: ‎04-27-2005
Message 9 of 9 (369 Views)

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.

Brian Hailey
CAD-1.com
My Blog
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.