topic Betreff: Convert ACAD Point To COGO Point with Object Data in Civil 3D Forum

Convert ACAD Point To COGO Point with Object Data

lmorse — Wed, 04 Nov 2020 23:23:21 GMT

HI,

Can anyone advise me how to convert ACAD Points containing Object Data into COGO Points and retain the object data? I have 2400+ points that I have been asked to convert.

Thanks in advance

Lee

Betreff: Convert ACAD Point To COGO Point with Object Data

Udo_Huebner — Wed, 04 Nov 2020 23:31:18 GMT

My first idea:

1. Use MAPEXPORT to export a Pointshape containing X,Y,Z, and the desired objectdata.

2. Save DBF as TXT.

3. Import Textfile using IMPORTPOINTS

Betreff: Convert ACAD Point To COGO Point with Object Data

lmorse — Wed, 04 Nov 2020 23:42:51 GMT

Hi,

I have a shape file, I have copied the DBF and given it the TXT extension. However, I am stuck on the IMPORTPOINTS step. Only the CFG file has a matching Point FIle Format, and it only pulls in one COGO point without any object data. Are there any more detailed instructions you can point me towards?

Betreff: Convert ACAD Point To COGO Point with Object Data

samir_rezk — Thu, 05 Nov 2020 00:59:40 GMT

Hi @lmorse

If you're using Civil 3D 2016 or 2020 - 2021, there is handy add-on/extension for working with SHP files; you can download and install the Autodesk SHP Import/Export Utility from your Autodesk account or the Desktop App

Like @Udo_Huebner noted, use the MAPEXPORT Command to create a SHP file, then use the add-on to import the SHP file in to Cogo Points with Property Set data containing the Object Data attribute values.

Hope this helps,

Betreff: Convert ACAD Point To COGO Point with Object Data

lmorse — Thu, 05 Nov 2020 01:01:47 GMT

☹️We have C3D 2018

Betreff: Convert ACAD Point To COGO Point with Object Data

samir_rezk — Thu, 05 Nov 2020 02:03:22 GMT

Hi @lmorse ,

Try the below steps to export to txt the re-import again as Cogo:

In a blank new drawing, using AutoCAD Map Taskpane, Attach the drawing then run a Report Query to extract out AutoCAD properties and Object Table properties into a Text file.
Open the file in Notepad and save as a new file with ANSI Encoding
In Civil 3D, create User Defined Properties to match the properties and attribute value types you have in the export
create a comma delimited point file format to match the the Point export with all the user defined properties culminated in the same sequence as the point export txt
finally execute the Point from File command to import the point file as Cogo Points

Here is demo video to clarify the steps (sorry it's a little long). hope this helps,

Betreff: Convert ACAD Point To COGO Point with Object Data

samir_rezk — Thu, 05 Nov 2020 02:08:33 GMT

Hi @lmorse ,

Try the below steps to export to txt the re-import again as Cogo:

In a blank new drawing, using AutoCAD Map Taskpane, Attach the drawing then run a Report Query to extract out AutoCAD properties and Object Table properties into a Text file.
Open the file in Notepad and save as a new file with ANSI Encoding
In Civil 3D, create User Defined Properties to match the properties and attribute value type you have in the export
Create a comma delimited point file format to match the the Point export with all the user defined properties culminated in the same sequence as the point export txt
Finally execute the Point from File command to import the point file as Cogo Points

Here is a Screencast video to clarify the steps (sorry it's a little long!)

Hope this helps,

Betreff: Convert ACAD Point To COGO Point with Object Data

lmorse — Thu, 05 Nov 2020 04:13:02 GMT

Thanks this is useful, however, it appears that it doesn't retain the Object Data as Object Data?

I know it is possible to attach Object Data to a COGO point. Once a year we have to re-export all of the information as a Shape File with Object data for submission to the powers that be.

Betreff: Convert ACAD Point To COGO Point with Object Data

Udo_Huebner — Thu, 05 Nov 2020 07:41:32 GMT

@lmorse
I didn't realize that the object data would then have to be appended to the CogoPoints as object data again.
Because attaching it as a description or user-defined properties is a simple task.

To get the object data (OD) from ACAD-Points to CogoPoints, I would use a macro.
I have already created both single tasks as Lisp macros.

Step 1 - Create CogoPoints from blocks or points
Step 2 - Copy the object data from the source object to the target object.

If you upload a sample file with a few Points and the attached object data, I will check if my code already works with your data. If it is a simple task to combine both code snippets, I will post the result here.

Betreff: Convert ACAD Point To COGO Point with Object Data

lmorse — Thu, 05 Nov 2020 10:01:19 GMT

Hi,

I have left work now and will return on Monday. I’ll send a sample then.

Betreff: Convert ACAD Point To COGO Point with Object Data

АлексЮстасу — Thu, 05 Nov 2020 17:09:30 GMT

Hi,

Do you necessarily need COGOPoints?
If you need to store coordinates, elevations, etc, you can do this in Object Data.

Betreff: Convert ACAD Point To COGO Point with Object Data

lee.morse — Mon, 09 Nov 2020 01:46:25 GMT

Example DWG attached. Thank you 😊

Betreff: Convert ACAD Point To COGO Point with Object Data

Udo_Huebner — Mon, 09 Nov 2020 08:09:26 GMT

With a minor modification, my existing code snippets work as expected.

Load UHODCOPY.vlx first (contains code to copy Objectdata between objects), then load UHBLOCK2CivilPoint.lsp and execute UHBlock2CivilPoint.

This Lisp Code should draw Civil Points on your block references and copies existing Objectdata to the CogoPoints.

Lisp Macros are attached.

Betreff: Convert ACAD Point To COGO Point with Object Data

АлексЮстасу — Mon, 09 Nov 2020 15:12:37 GMT

Hi, Udo,

Perhaps, instead of creating UHODCOPY. VLX, you could use the old lisp from Autodesk to OD copy from object to objects - COPY_OD.lsp.
But you're the author, you better know. 🙂

Good solution!

I will immediately assume that lee.morse will also need a reverse process - replacing COGOPoints with blocks with OD creation and copying OD or PropertySets values.

Betreff: Convert ACAD Point To COGO Point with Object Data

lee.morse — Mon, 09 Nov 2020 19:50:25 GMT

Udo,

Thank you. This works well. There is one thing that I have noticed on the full data set:

Most layers have come through with their own point groups with the label set to the borehole name, however a couple of layers do not have their own point groups. These layers show the following info in the point label: point number, RL, layer name.

I have attached another sample so that you can see:

Betreff: Convert ACAD Point To COGO Point with Object Data

lee.morse — Mon, 09 Nov 2020 19:51:22 GMT

I have no immediate need for Cogo - > Block, but it doesn't sound like a bad idea

😉

Betreff: Convert ACAD Point To COGO Point with Object Data

АлексЮстасу — Tue, 10 Nov 2020 02:34:10 GMT

... for general reasons, firstly, it only now seems that it is not necessary.

Secondly, it would be better now, right away - sometime later there will be no time.

Thirdly, it's easier right now, because the first part has just been made. 🙂

(I do not use COGO at all, and I have no similar tasks. But it can be useful).

Re: Convert ACAD Point To COGO Point with Object Data

ChicagoLooper — Tue, 10 Nov 2020 06:12:37 GMT

@lmorse wrote

<<......to convert ACAD Points......>>

What does this mean? Do you mean you have points physically sitting in modelspace? And those points have Object Data (OD) attached? If you do, then it can be done but you’ll need to disclose the OD. The number of points is not relevant. Whether 240,000 points, 2,400 points or just 24 points, it doesn’t matter. What does matter is the number of OD fields and the individual field names.

To effectively evaluate your specific situation, it’s best if you could provide the actual ‘data fields’ of your OD. Better yet, upload a sample, e.g. 20 points, of the ACAD points.