FreeCAD BOM Generator: Difference between revisions
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=Tools That Can Be Used For Generating Bills of Materials by Counting= | =Tools That Can Be Used For Generating Bills of Materials by Counting= | ||
==Structured Way== | ==Structured Way== | ||
*The simplest method of obtaining a complete [[BOM]], line by line, is to export parts in a FreeCAD document, and simply count them. You can count phrases by using an online phrase counter - [https://www.browserling.com/tools/phrase-frequency] | *The simplest method of obtaining a complete [[BOM]], line by line, is to export parts spreadsheet in a FreeCAD document, and simply count them. You can count phrases by using an online phrase counter - [https://www.browserling.com/tools/phrase-frequency]. '''That is your BOM Generator MVP1.0.''' | ||
*For this to work, the part names must be structured in an understandable way, such as "8 mm Screw #" such that every time it is copied, it appears as: "8 mm Screw #0", | *For this to work, the part names must be structured in an understandable way, such as "8 mm Screw #" such that every time it is copied, it appears as: "8 mm Screw #0", | ||
*Check out what happens when you copy a part, if its name allows for easy counting by examinging part name: | *Check out what happens when you copy a part, if its name allows for easy counting by examinging part name: | ||
Revision as of 13:14, 18 September 2020
Tools That Can Be Used For Generating Bills of Materials by Counting
Structured Way
- The simplest method of obtaining a complete BOM, line by line, is to export parts spreadsheet in a FreeCAD document, and simply count them. You can count phrases by using an online phrase counter - [1]. That is your BOM Generator MVP1.0.
- For this to work, the part names must be structured in an understandable way, such as "8 mm Screw #" such that every time it is copied, it appears as: "8 mm Screw #0",
- Check out what happens when you copy a part, if its name allows for easy counting by examinging part name:
- The count appears readily by observing the last number.
- Out of the box - you can even include a BOM link to that part with URL or shortcut, so that the exported BOM can include links out of the box:
- FreeCAD allows CSV export of part spreadsheets - so further processing into finished BOMs can happen readily.
Extracting Parts Spreadsheet in FreeCAD
There is a macro from FreeCAD forum [2]:
obj = FreeCADGui.Selection.getSelection()
bom = App.activeDocument().addObject('Spreadsheet::Sheet','BOM') cell = 0 for x in obj:
cell = cell + 1
bom.set("A" + str(cell), x.Label)
App.ActiveDocument.recompute()
You can execute this macro in Macros or in the Python console. Select the parts in the tree view, and you will generate a spreadsheet with all the parts.Then these parts can be counted.
- This generates a spreadsheet, from selected parts in part tree
- Export this to CSV for other spreadsheet apps.
- Spreadsheet workbench allows import of CSV as well.
FreeCAD Evolution
2018 Progress
- Note comment: part organization is what makes for proper assemblies - not constraints! Exactly. [3]