Community
Hi @Anonymous,
The data extraction process is AutoCAD LT relies on blocks with attributes in them. With this said, I modified a couple of your lighting blocks so that they would have an attribute called FIXT.
Next, I created a template file that has the following lines in it:
BL:NAME C015000
CIRC C030000
Now, when I run ATTEXT inside of AutoCAD LT, I have CDF by default for the file format - this means if you rename the resulting text file from .txt to CSV, you should easily be able to open it in Excel.
When I select the Select Objects button I simply type ALL at the command prompt.
Finally, when I click OK the Room_Lighting_Layout.txt file is created.
To get information such as the layer I suggest running this command with only one layer turned on at a time and writing the information to a unique TXT file.
When you import all the data into Excel you will then be able to sort and count. You can then copy and paste your Excel date aback into your drawing.
Please select the Accept as Solution button if my post solves your issue or answers your question.
Thank you John for your effort, I am following your instructions, but it still doesn't work. Same message as usual: "0 records in extract file". I have inserted 10 downlights with attributes into new file (attached), i ma using txt template file with your content, but still no luck so far. cdf neither sdf don't work.
The Attribute tag can be in either upper,lower or even mixed case that makes no difference the attext command is case insensitive, In theory the downlight extraction line should use N for numerical but C also works (it won't work the other way round).
And it is also worth pointing out here that if you have multiple attributes in a block they do have to be unique, Autocad will let you place 2 attributes with DOWNLIGHT as the attribute tag but it won't recognise the second one. You can also create an attribute extraction file that has a long list of attribute tags that are used in many different blocks and it will still work for all the blocks in one go, (it just fills in blanks if it doesn't find an attribute) you don't have to have a seperate extraction file for every different type of block (though a block does have to have a minimum of one attribute from that list before it will work with attext)
Could well be a MAC issue, in windows at least attribute tags are normally automatically changed to caps by the system (at least on my machine, but it could be a setting), but for the extraction, template it doesn't matter. Again it doesn't matter in windows, you could well have found one of the many differences between Windows and MAC hopefully a MAC user will be able to confirm that.
You need to take a look at your template file, 2 examples:
1 - You are telling AutoCAD that SIZE is a number but the attribute contains characters at the end 6'-8" X 7'-7" (50F)
2 - Further down U is a number but the template tells AutoCAD it is just a single digit N001002 with 2 decimal places? should that may be read N010002
If there is a single character in there then it is a string, so even a space would make it a string.
0.28 is made up of at least 4 digits the decimal point counts as a digit so N00200 will still fail and you still need to tell Autocad to use 2 places after the decimal point. You are not telling AutoCAD how big the number is you are telling it how many actual digits are used and how many places after the decimal point to show. So it would need to be at least N004002 (you might not use the zero before the point but AutoCAD does)
If you read your command line after running the 'attext' command it will tell you the errors it is finding, maybe you need to increase the height of your command line window to see the errors.
Forums Links
Can't find what you're looking for? Ask the community or share your knowledge.
Post to forums
