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.
>> 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 -
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.
>> 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 -
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
The comma separating the thousand values in the co-ordinates doesn't help
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
And that is my result:
BTW: what is your last value with 612.848, I can't imagine where this come from?
- alfred -
I didn't query the insertion point. My query was based on
Location = ALL
Layer = PLI-WUG
and the report template settings
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
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!
- alfred -
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.....