import 3D datapoints

Hi everyone,

I'm looking for a way to import 3D points to autocad. These datapoints are in a text (or Excel) file under the form (x,y,z). For 2D points I'm using the script command but it doesn't work for 3D. Is there an equivalent way to do it?

Many thanks for your help.

Nick

Michael's Corner > The Odd Spot > Coordinates from Excel into AutoCAD. Read it and weep for joy.

http://www.cadtutor.net/corner/2009/may.php

Thanks for the link, I didn't see it.

You're entirely welcomed. Michael's Corner is always worth checking out. You never know what nuggets of information you may find. Kind of like discovering treasure.

You don't have to use a script file for points into AutoCAD. From Excel, make a copy of the file before editting it, then delete all other columns except x, y, z and then Save-as a CSV file.

5305.031,4628.081,34.751

5556.799,4418.184,16.594

5091.768,4161.226,50.839

5129.994,4160,54.39

5275.077,4626.125,37.654

5060.099,4154.383,53.658

5085.171,4189.658,47.559

Open this file in Notepad, select all and Copy (Cntrl C). In AutoCAD, type Multiple at the Command Line, then type the name of the command to be repeated - Point. Now paste (Cntrl V), and all the points will be drawn in 3D.

I found something really great for this at this link:

http://www.jefferypsanders.com/autolisp_IMPORTXYZ.html

This AutoLISP routine will import points from a file. I find it very useful.

Thanks Eldon! Looks like it works!!

I will read Michael's Corner anyway (will surely learn something )

I found something really great for this at this link:

 

This AutoLISP routine will import points from a file. I find it very useful.

Hi Bill, I don't know what an AutoLISP routine is or how it works but I'll have a look at it. Thanks!!

Re: Using AutoLISP.

Go to top of this page. Click on AutoCAD FAQ. At the next page click on Customization. Find the "how to" article entitled How do I use an AutoLISP routine" and read it.

Re: Using AutoLISP.

 

Go to top of this page. Click on AutoCAD FAQ. At the next page click on Customization. Find the "how to" article entitled How do I use an AutoLISP routine" and read it.

That's efficient!! Thanks again for the tip Mark!

You're welcomed once again. There's a lot more to CADTutor than meets the eye. Poke around. We encourage exploring.

Will do! I'm just a bit lost at the moment

You were lost but now you are found. Welcome to CADTutor grasshopper.

I'm not sure you won't regret one day to have found me

I found something really great for this at this link:

 

This AutoLISP routine will import points from a file. I find it very useful.

Hi Bill,

I'm trying to use the routine you told me and I have a problem: I've loaded it without problem but when I try to execute it (i.e. type IMPORTXYZ in the command line) it tells me that the IMPORTXYZ.dcl file cannot be found. The problem is that the file is in the ame folder as IMPORTXYZ.lsp...

Any idea on what I'm doing wrong?