Jump to content

How to convert attribute to excell in autocad 2014 lt


Recommended Posts

First you will have to create an attribute extract template file (use an ASCII text editor like Notepad to create). You can extract to CDF, SDF or DXF file format. To bring the attributes into Excel I suggest using the CDF file format.

 

You might want to give this a read.

 

http://exchange.autodesk.com/autocadlt/enu/online-help/ACDLT/2012/enu/pages/WS1a9193826455f5ffa23ce210c4a30acaf-6be7.htm

Link to comment
Share on other sites

Do you have blocks that contain attributes already? if so then you need to create a text file so that Autocad knows what you want to extract, use windows notepad, it is nothing special just a simple text file. You need to enter the TAGS from the attributes you want to use and then tell Autocad whether the value is text or numerical and how long it likely will be, for example an attribute that has the tag ArEa

Tag.GIF

You would enter

AREA N003002

the text is not case sensitive and it's normal to use uppercase, this is followed by a space then either the letters "C" to show the value will be a character or "N" if it will be numerical, the 6 numbers following tell Autocad how much information is going to be in the value, the first 3 is just a straight count so "003" tells Autocad the value will be a 3 letter word or number up to 999, you don't need to be exact I usually use "030" unless I know it will be a long text string. The second 3 numbers are only used for numbers to show how many decimal places should be included so "003002" would give anything up to 999.99. If the value is text the last 3 should be zero "003000".

The next attribute is just text

Tag2.GIF

so notepad now looks like this

AREA N003002
MANUFACTURER C030000

add as many tags as you like, you can also get information from the block like it's name or position (take a look at the help files for how to get that) for example will export the blocks name.

BL:NAME C030000

The text file can contain tag names from various blocks they don't all have to be in every block, when Autocad is collecting the details if there is no tag that matches the name in the text file it will just ignore it (so if you spell it wrong it won't be extracted). PS All your tags should have unique names, although you can have 2 attributes in a block with the same name Autocad will only read one of them. Having the same tag name in different blocks is OK but it is logical that they should contain similar values.

Make sure you press enter after the last line in the text file and then save the file, this is now your Attribute Extraction Template, put it in a folder so you can tell the ATTEXT command where to find it. That's it. Run ATTEXT and the dialogue will ask you to select the objects to Extract attributes from (either pick the blocks or just type "all" and press enter) click on the template file button and tell Autocad where the text file is, and then click on the output file button an tell Autocad where you want it to extract the data too (again this is just a plain text file so type a name). You need to select how you want the data stored so choose 'CDF' ,'SDF' or 'DXX', for excel CDF is fine. Click ok and Autocad should tell you it has output 'XX'-records in extract file.

Link to comment
Share on other sites

Open excel goto the data tab and select get external data from text file, where it is depends on which version you have, this opens a dialogue box with 3 steps

step 1 select delimited data

Excel1.GIF

step 2 change the delimeters to 'comma'

tick the box 'treat consecutive delimeters as one'.

change the text qualifier to a single quote (I have to - there is a preview box at the bottom and it should show what is in the text file, when you pick the correct value the symbols disapear in the preview - try it you'll see)

Excel2.GIF

step 3 I've never changed anything here, except clicking on the Advanced button (just because in Belgium they use a comma as a decimal point)

Excel3.GIF

so click finish and excel will ask you if you want to import the data into the current sheet starting at the active cell (usually A1)

Excel4.GIF

Your situation maybe different but hopefully this will get you started.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...