AutoLisp Home

Home

I

m

p

o

r

t

X

Y

Z

I

m

p

o

r

t

X

Y

Z

I

m

p

o

r

t

X

Y

Z

I

m

p

o

r

t

X

Y

Z

ImportXYZ   Updated! (See Below)

Import xyz coords from practically any type of file.

Excel, CSV, and any ascii file delimited with a space, comma, tab, enter (new line character) or any ascii file seperated by number of characters.

• Draw a node on every point.
• Draw a circle on every point (input the diameter)
• Draw lines from point to point to point.
• Insert a block on every point.
• Insert a block and update the x y and/or z attributes on every point.

  Need something else?  Let me know here ---> <click>

Update:

  The update added the ability to: 

    INSERT AN EXCEL NOTE :
      This function will write the data from the first column in excel on each coordinate with a leader. ( If each row contains four items, the program assumes the first column of data is a note. ) The program will use the default text style and height.  I have not rebuilt the screen shots below to show this update!

Instructions and screen shots:

  Download the program (ZIP file) and extract all files into a directory located somewhere inside your autocad search path.  To load the program type (load "importxyz") on the command line and press enter.  To run the program type IMPORTXYZ on the command line and press enter.

  You should see something like this:

  Select the browse for file button and locate the file you want to import.

When you have located the correct file, press the Open button.  Select the decimal places you want to display and press the Get XYZ Coords button.  The XYZ coords will show up in the list.  The first 50 anyway.

You can change the decimal places at any time.  The list box is for display purposes only and does not effect the accuracy of the points.  The list box is there to let you know the data was imported correctly. 

If the program could not determine which delimiter to use, it would have displayed a dialog box that looks like this:

  Select the proper delimiter.  If your file is character width delimited, select the number of characters that seperate the x y and z coords from each other.  Then press Okay.  The coords will now show up in the list as shown above.

  If you had selected an EXCEL file, the following dialog box would have appeared:

  Select the Excel sheet name and press Okay.  Now the xyz coords will show up in the list box as shown above.

  Next, select the type of operation you want.  In this example, select the "Edit Attribute" option.  The Block Name and XYZ TAG edit boxes will enable afterwards.  Select the block name from the list of existing blocks or press the Browse button and select it from a directory.  Type in the tag names for the attributes you want to replace.  The dialog box should look something like below:

   Press the Okay button and the program will go to work.   I've included the block used in this example inside the ZIP file to download.   The name of the block is IMPORTXYZATT.dwg.  

  After the program inserted the blocks and replaced the attributes, I did a getpoint function on the center of the circle to display the actual coordinates.  Notice they match the attributes in the the IMPORTXYZATT block.

To Download the program click   <here>.

If you have any questions about the program click here.

AutoLisp Home

Home

All questions/complaints/suggestions should be sent to /

Last Updated April 1st, 2013

Copyright 2002-2013 /.  All rights reserved.