Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Anonymous
1232 Vistas, 8 Respuestas

Import and display X,Y,Z points from Excel file

Hello  everybody,

I have some troubles to find the way to import points in AutoCAD 3D projects. I have 1400 points in Excel file with columns ID, X, Y, Z,. I would like to display them with 2 labels (ID and Z).

I know there is scripts showed on web but it doesn't work for me.

Herewith my Excel file.

Thank you for your help

Anonymous
en respuesta a: Anonymous

Hi @Anonymous 

Normally points import  fails with number formats: decimal point or comma refer to an dot or comma respectively. Check "Number format" in your Windows, which decimal separator use:

click-reset.png

tcorey
en respuesta a: Anonymous

Do you not use Civil 3D?



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

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
Anonymous
en respuesta a: tcorey

Thank you

Yes I have checked that AutoCAD need . as decimal separator.

Yes I just found Civil 3D as option. I am gonna try that. Is this soft provide .DWG as output file ?

АлексЮстасу
en respuesta a: Anonymous

To display points, you can make a block with the necessary attributes, and load your data with the necessary labels using Lee Mac's PointManager, PTM - http://www.lee-mac.com/ptmanager.html.


You can also download using Civil - as written by .
You can import and Map (/ Civil) 3D - MAPIMPORT.

 


-- Alexander, private person, pacifist, english only with translator :cara_con_una_leve_sonrisa: --

Object-modeling _ odclass-odedit.com _ Help

tcorey
en respuesta a: Anonymous

Yes, Civil 3D uses .dwg, the same as plain AutoCAD.



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

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
Anonymous
en respuesta a: tcorey

OK thanks, I got Cicil 3D.

I have lot of trouble to import my set of topographic data. 

It should be easy but it's not, for me

My Excel file is :

first column : description of the point (sometime empty) alphanumeric

column 2 : X numeric

column 3 : Y  numeric

column 4 : Z  numeric

column 5 ID   string

what kinf of format shoul I use ? I tried but I always have error messages about my input file.

 

Thanks a lot for your help

Anonymous
en respuesta a: Anonymous

Here is my import windows

tcorey
en respuesta a: Anonymous

Instead of the column for Point Number, use Point Name. Point Number does not allow alpha-numeric, but Point Name does.



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

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