AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Member
tpcc79
Posts: 10
Registered: ‎03-22-2012
Message 1 of 13 (801 Views)

Export Cogo Point Nested Data

801 Views, 12 Replies
04-15-2012 09:48 PM

I'm looking for any ideas on how I can export the nested data of Cogo Points. I need to get them into a spreadsheet.

 

I have tried exporting a .shp file and opening the .dbf file in excel, however, it only seems to export the data field of the table and not the value.

 

Any help will be greatly appreciated.

 

Regards

*Expert Elite*
Alfred.NESWADBA
Posts: 9,070
Registered: ‎06-29-2007
Message 2 of 13 (789 Views)

Re: Export Cogo Point Nested Data

04-16-2012 03:15 AM in reply to: tpcc79

Hi,

 

>> it only seems to export the data field of the table and not the value

The problem is that you can't export Civil-objects with _MAPEXPORT, the next problem is when you convert the Civil-Point objects to Block-objects ... the objectdata-information is lost.

I assume that you have some tools or apps that have assigned these objectdata ot the Civil-points, ask the company for a small tool that does this export to an ascii-file for you. I think that's the fastest way.

 

For the future: yes, you have Map3D-technology built in in Civil3D, but don't mix the functionality like objectdata or topology. Either Civil3D-objects, then no objectdata (except you do development) or plain AutoCAD-geometry and then yes, objectdata, topology ... is allowed. You see e.g. in the function that built blocks from Civil-points that the objectdata is lost .... and that is the same for most of the Civil3D objects.

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Valued Mentor
parkr4st
Posts: 451
Registered: ‎03-24-2004
Message 3 of 13 (787 Views)

Re: Export Cogo Point Nested Data

04-16-2012 03:20 AM in reply to: tpcc79

what software are you using? 

 

I checked your point in Map3d 2013.  you have an autocad proxy entity which does not export.

Valued Contributor
Neil47
Posts: 72
Registered: ‎11-06-2008
Message 4 of 13 (781 Views)

Re: Export Cogo Point Nested Data

04-16-2012 03:35 AM in reply to: tpcc79

Open a new drawing and attach the existing drawing using ADEDRAWINGS, then run a query to create a report file based upon the OD records. The one issue you will have is that your E, N object data has the thousand values separated by a comma which will read through to the csv file.

*Expert Elite*
Alfred.NESWADBA
Posts: 9,070
Registered: ‎06-29-2007
Message 5 of 13 (779 Views)

Re: Export Cogo Point Nested Data

04-16-2012 03:38 AM in reply to: Neil47

Hi,

 

@Neil47

>> Open a new drawing and attach the existing drawing using ADEDRAWINGS,

>> then run a query to create a report file based upon the OD records

You are able to query Civil3D points ???

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Valued Contributor
Neil47
Posts: 72
Registered: ‎11-06-2008
Message 6 of 13 (777 Views)

Re: Export Cogo Point Nested Data

04-16-2012 03:50 AM in reply to: Alfred.NESWADBA

These are Cogo Points but with a normal Object Data tables attached. I've queried for Location, E and N from the OD tables in both Map3D 2012 and Civil 2010 and got the following

 

Woleebee Creek,770,620.708,7,090,612.848



The comma separating the thousand values in the co-ordinates doesn't help

*Expert Elite*
Alfred.NESWADBA
Posts: 9,070
Registered: ‎06-29-2007
Message 7 of 13 (775 Views)

Re: Export Cogo Point Nested Data

04-16-2012 04:18 AM in reply to: Neil47

Hi,

 

Surprising!

 

I tried to query for X1,Y1,Z1 (to get the insertion point) and then some OD-fields and besides of an error message I just get the three BlockReferences exported, but no objectdata and no Civil3D-point.

(If I remove the X1,Y1,Z1 I also don't get the Civil3D-point exported)

Just tried with Civil3D 2012

 

That's my query-report-settings

 

 2012-04-16 13-10-52.png

And that is my result:

124,9045063368394;195,79620874859393;0;;
453448,99888590147;7081922,7257119277;0;;
453448,99888590147;7081922,7257119277;0;;

 

BTW: what is your last value with 612.848, I can't imagine where this come from?

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Valued Contributor
Neil47
Posts: 72
Registered: ‎11-06-2008
Message 8 of 13 (772 Views)

Re: Export Cogo Point Nested Data

04-16-2012 04:55 AM in reply to: Alfred.NESWADBA

I didn't query the insertion point.  My query was based on

 

Location = ALL

Layer = PLI-WUG

 

and the report template settings 

 

Capture.PNG

 

The N value in the OD table is 7,090,612.848 which is where the thousands separator comes in, should be read as 7090612.848

 

*Expert Elite*
Alfred.NESWADBA
Posts: 9,070
Registered: ‎06-29-2007
Message 9 of 13 (768 Views)

Re: Export Cogo Point Nested Data

04-16-2012 05:39 AM in reply to: Neil47

Hi,

 

I really don't know what's going on.

Now I tried Civil3D2013, did not use the insertion corrds, just some objectdata-fields (like you) and the filter to layer you mentioned and the result (in the command line) is:

0 Objects were queried

 

I give it up for the moment (to few time), I'm wondering that you get a result as I never had a chance to query Civil3D-objects. But you can and that lets me think that I'm doing wrong. ;(

Anyway .. thanks for doing that tests with me! :smileywink:

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Active Member
tpcc79
Posts: 10
Registered: ‎03-22-2012
Message 10 of 13 (762 Views)

Re: Export Cogo Point Nested Data

04-16-2012 02:43 PM in reply to: Neil47

This is exactly what I need, however, when I run my query, in the command line it comes up 0 objects queried. I have used the adedrawings function in a new job. Not sure why it isn't working.....

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.