Material List Pro

AutoCAD® Data Extraction Software

database 100 100Part Database

Actions go next icon 64Part Bubbles

autocad 100 100AutoCAD®

Actions go next icon 64Material List

excel 100 100Excel®

AutoCAD Material List (BOM)

 

You can download the demo and create material lists with one click!AutoCAD material list

The SQL database supports Excel exports and imports!

Manual part number entry is history.  Revitalize your productivity and increase teamwork with automation.

Material List Pro automates the material list process, from creating attribute blocks, to attribute data extraction, to drawing material lists. With one click, MLP creates matching drawing and Excel material lists.

By controlling SQL databases, AutoCAD drawings, and Excel worksheets, Material List Pro uses attribute blocks and data extraction to make your data flow smoothly between these applications, resulting in a stable, highly-automated design and procurement process than increases the consistency and accuracy of your drawings.

Material List Pro saves time and enhances accuracy as you create estimates, attribute block part bubbles, drawing material lists, Excel reports, and Excel purchase orders.  Custom reports format material lists for import into your ERP system.

Departments using Material List Pro share an SQL database resulting in consistent material descriptions.  The use of attribute blocks and data extraction means that important design data stays in the drawing where it belongs.

Material List Pro is designed primarily for companies that build "Engineered to Order" or ETO products. If each item that leaves your facility has a unique combination of materials and drawings, then AutoCAD attribute blocks and the AutoCAD data extraction process automated by Material List Pro save time and money during the design phase of each project.

autocad attribute block

Material List Pro creates part bubbles using AutoCAD block attributes containing values from an SQL database.  A typical part bubble includes attribute constants such as part number and description.  Variable attributes, such as item number and quantity are also included.  Part bubbles are created automatically and dynamically based upon user-defined settings.

The AutoCAD block definition used for the part bubbles can be customized.  Custom calculations based upon the attribute values can also be performed.  When a part bubble is inserted into a drawing, the user is prompted for the part bubble location and points that define the middle and end points of a leader line.

 

autocad data extraction

Material List Pro extracts data from AutoCAD attribute block part bubbles using a customized AutoCAD data extraction template. The extracted data is processed and used for material lists in the drawing and a matching Excel workbook. This process is executed with a single click.

autocad excel

video

 

autocad data extraction

Embedding AutoCAD attribute block part bubbles in blocks from a part library carries the automation process one step further.  The AutoCAD block from the part library is listed in the part database.  Inserting an AutoCAD block takes only three clicks.  Using a part library with embedded AutoCAD attribute block part bubbles combines two steps of the drafting process into one and ensures consistency. video

NEWS

New Features!

 Corner Markers Associate Part Bubbles In Model Space With a Layout

Material from part bubbles within the range of the corner markers will only appear in the material lists of the layouts associated with the corner markers.  This feature makes it very easy to have multiple layouts with a material list on each layout.  Item numbers within the model are updated automatically based upon which layout the part bubbles are associated with.

Update XREF Part Bubble Item Numbers

If an XREF is used in model space, the XREF will be opened and the item numbers updated automatically.

Attribute Block Material Lists

Material list data can now be placed in user defined attribute blocks.  This works great if your title blocks or other blocks are used to display material lists.

Company ID

A Company ID setting is used so that custom code can be written for your specific application.  This is useful for such things as calculating total weights or other values when editing quantities in part bubbles.  Contact us to discuss your specific needs.

Global and Local Configuration Files

The program now supports the use of global and local configuration files. Local configuration files are local to a drawing directory and can be used to override the settings of the global configuration file.  This allows program settings to be different from drawing directory to drawing directory as required.

SQL Database search fields are now ComboBoxes with user defined drop down lists.

AutoCAD Attribute Commands

Material List Pro automates the use of many AutoCAD attribute block commands including:

ATTDEF - Creates an attribute definition for storing data in a block.

ATTEXT - Extracts attribute data, informational text associated with a block, into a file.

ATTREDEF - Redefines an attribute block and updates associated attributes.

ATTSYNC - Applies attribute changes in a block definition to all block references.

EATTEXT - Exports block attribute information to a table or to an external file.

MLP handles all the details of executing these commands and processing the extracted data.