AutoCAD Civil 3D General Discussion

AutoCAD Civil 3D General Discussion

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

Survey Database Point Description Length

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

 

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*
mikeevans
Posts: 810
Registered: ‎09-29-2008
Message 2 of 9 (474 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 (467 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,850
Registered: ‎04-27-2005
Message 4 of 9 (458 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: 2,064
Registered: ‎11-13-2006
Message 5 of 9 (444 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,483
Registered: ‎07-22-2003
Message 6 of 9 (436 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: 461
Registered: ‎09-29-2008
Message 7 of 9 (423 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 (413 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,850
Registered: ‎04-27-2005
Message 9 of 9 (406 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
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!