topic Re: Attribute BOM For Excel in AutoCAD Forum

Attribute BOM For Excel

TravAdAutocad — Thu, 01 Aug 2024 12:46:30 GMT

I've been tasked with implementing a material list using attributes to be exported to Excel for my job. I have only worked with attributes to create a title block. I understand how to create attributes on a basic level, but I'm unsure how to make a group of attributes that can be picked and chosen based on what material each project uses. Our material list includes about 300 parts, but each project will only use about 10-20 of those parts. I also have to include quantities.

I'm the only user of Autocad at my job so I am flying solo. Any help will be appreciated.

Re: Attribute BOM For Excel

Washingtonn — Thu, 01 Aug 2024 12:56:24 GMT

Provide a list of the attributes each part will have.

Re: Attribute BOM For Excel

AVCPlugins — Thu, 01 Aug 2024 12:59:10 GMT

You need to add invisible constant attributes to each block-part in the block editor. And if the same block can represent several different parts with different article numbers, then the attributes should be marked as invisible changeable. There are no problems with extracting this data into a table using either the standard DataExtraction command or plugins (for example, DataTable).
Pay attention to the AVCPalette plugin. This property panel allows you to very easily, without the block editor, create new invisible attributes in old blocks. In addition, you can set up "virtual attributes" that will be visible for all blocks, even if the block has no attributes at all. This feature will dramatically reduce your work.

Re: Attribute BOM For Excel

TravAdAutocad — Thu, 01 Aug 2024 13:34:46 GMT

@Washingtonn Part number, description, code, UOM, and class