Attribute Data Transfer

[Anonymous]

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?

[Pointdump]

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.

Dave

[Anonymous]

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

[tcorey]

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.

[Pointdump]

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

Dave

[Anonymous]

tcorey,

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

-Joe

[Pointdump]

Jose,

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

CSV and drawing files attached.

Dave

[Pointdump]

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

[Anonymous]

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?

[tcorey]

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.

[Pointdump]

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:

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

[Anonymous]

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.

[Pointdump]

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

[Anonymous]

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!