Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Attribute Data Transfer

Anonymous

Attribute Data Transfer

Anonymous
Not applicable

I have imported points from an Autocad Shape Source file, with thier attribute data, and have converted these points into COGO ponits.  I was able to transfer most other attributes automatically but the "FeatureCod" attribute data from the Autocad Shape Source file points. Does anyone know how transfer this attribute so that it displays in the COGO Point Lable Style Raw Descrtiption?

0 Likes
Reply
989 Views
13 Replies
Replies (13)

Pointdump
Mentor
Mentor

Jose,

 

Welcome to the Forum.

 

Please post your Shapefile. Probably the easiest workflow would be to Attach and Query the drawing you have the Shapefile in. Use Report >> Options >> Expression to generate a CSV file with which you can add the "FeatureCod" to a Point File Format.

 

DataCSV1.png

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

Anonymous
Not applicable

I'll try that out. Thanks for the welcom and the response Dave.

0 Likes

tcorey
Mentor
Mentor

I was going to take a look, but you forgot to attached the .shx and .dbf files that go along with the .shp. Without those files (or the .dbf, at least) we cannot view the attribute data, only the point locations.

 

 



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Gold Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
0 Likes

Pointdump
Mentor
Mentor

Jose,

 

Tim is right. There's not much data in that Shapefile. Please zip together the 4 minimum files that a Shapefile needs:

 

  • DBF
  • PRJ
  • SHP
  • SHX

 

DataCSV2.png

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

Anonymous
Not applicable

tcorey,

 

I have attached the missing files, sorry about that. Thanks for your help.

 

-Joe

0 Likes

Pointdump
Mentor
Mentor

Jose,

 

With the full data you can now use Report >> Options >> Expression to generate a CSV file:

 

JosePoints.png

 

JosePoints1.png

 

CSV and drawing files attached.

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024

Pointdump
Mentor
Mentor

Joe,

 

There was no PRJ file with your zipped Shapefile. What Coordinate System are you using? Turning on Bing Live Maps is always a good check to see if your points are in the ballpark.

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

Anonymous
Not applicable

Thats exactly what I'm looking for Dave. I'm using Autocad Civil 3D 2015, I don't know if that makes a difference, I can't seem to figure out how to get to those dialog boxes you show. This is my first attempt at converting Autocad points to COGO points. I opened Tool Space from the home tab, clicked the Toolbox tab, expaned "Points," clicked "Points_In_CSV." It opens an Excel file with with the field and information. I then saved the CSV file. When Im going to open the CSV report (the CSV file I just created from Autocad) it won't work. Am I missing somehting?

0 Likes

tcorey
Mentor
Mentor

Yes, you're missing where Dave is accessing the command he is using. He is using AutoCAD Map, available through the Planning and Analysis workspace, or type the commands I show below.

 

Import the points, then save the drawing; I will refer to this as DrawingA. Save and close. Create a new drawing, DrawingB.

 

With DrawingB open and DrawingA closed, use ADEDRAWINGS command and press the Attach button to attachDrawingA to DrawingB. If your data are on a drive other than c:, you might have to create a new Alias. Two buttons right of where it shows Look in...

 

After attaching, type ADEQUERY to call up the QUERY dialog. Set your Location to All, then set the Query mode to Reports. Press the Options button, then follow what Dave shows in his screenshots. This will create a CSV file of your selected point attributes. This CSV can be imported into Civil 3D as COGO points.

 

 



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Gold Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut

Pointdump
Mentor
Mentor

Joe,

 

I always like to see what I've got in a Shapefile before working with it. Drag-n-Drop your Shapefile into a blank drawing in the "Planning and Analysis" (Map) Workspace and look at the Table to see what data is there:

 

Drag-n-Drop.png

 

Here's a Screencast:

 

 

 

 

To pull data from a Shapefile, here's the workflow:

 

1. MAPIMPORT your Shapefile into a blank, new drawing. Save and close.
2. Open new drawing and Attach and Query first drawing. Using Report in Query will allow you to save a CSV file.
3. Import the CSV file in the Create Points Dialogue Box. Select a Point Label Style to suit.

 

You'll need to spend some time in the Help Section to nail down these concepts. Here's an excellent 34-minute, cut-to-the-chase video from Jason Porter that will get you started:
https://www.youtube.com/watch?v=g7HW6apnh3g

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

Anonymous
Not applicable

Oooook. So after after figuring out why I didn't get those dialog boxes you guys were showing me, I was finally able to go through the process. In the "Output Report Options" dialog box I'm not given the option to output the file as a .csv file, just as a .txt. I have imported points form a .txt file before but for whatever reason when I import these points I get an error message that says "No Point File Format Match Found." Attached is the out file generated.

0 Likes

Pointdump
Mentor
Mentor

Joe,

 

"...not given the option to output the file as a .csv file, just as a .txt"

 

"No Point File Format Match Found."

 

Yes, it outputs as a TXT. Forgot to mention that. I also got the same "no match" when I first tried to import the points. It needs work in either Notepad or Excel. When you fix it and re-save, either a CSV or TXT file will work. I fixed things up in Excel, so I saved as a CSV. Anyway, what you're looking for is:

 

P,N,E,Z,D
P,N,E,Z,D
P,N,E,Z,D
P,N,E,Z,D
P,N,E,Z,D

 

And make sure that in the "P" column you have an integer, no alpha or decimal or fraction.

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

Anonymous
Not applicable

I got it working now. Thank you Dave for all your help. I really appreciate your patience, I was losing patience with myself ha ha ha, and the time you took out of you day to help me out. Thank you too Tom!

0 Likes