Create & export parts list

[Roland]

I found a Parts List inside the Assembly 2 WB. (I assume that is the only functional Assembly WB so far).

The Parts List tool of the Assembly 2 WB projects such a list on a drawing.
Now I need to export that list to a spreadsheet for further elaborations.

I accessed the XML codes by unzipping the FStd files, but unfortunately could not find the Parts List as a coherent block of text.

Could somebody advise me an effective procedure for this task?

Thanks

Roland
OS: Windows 7
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.15.4671 (Git)
Branch: releases/FreeCAD-0-15
Hash: 244b3aef360841646cbfe80a1b225c8b39c8380c
Python version: 2.7.8
Qt version: 4.8.6
Coin version: 4.0.0a
OCC version: 6.8.0.oce-0.17

[triplus]

I found a Parts List inside the Assembly 2 WB. (I assume that is the only functional Assembly WB so far).

The Parts List tool of the Assembly 2 WB projects such a list on a drawing.
Now I need to export that list to a spreadsheet for further elaborations.

I accessed the XML codes by unzipping the FStd files, but unfortunately could not find the Parts List as a coherent block of text.

Could somebody advise me an effective procedure for this task?

Thanks

Roland
OS: Windows 7
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.15.4671 (Git)
Branch: releases/FreeCAD-0-15
Hash: 244b3aef360841646cbfe80a1b225c8b39c8380c
Python version: 2.7.8
Qt version: 4.8.6
Coin version: 4.0.0a
OCC version: 6.8.0.oce-0.17

You will find the information stored in SVG files. Therefore you would need to code SVG parser/extractor of the data you are after or you could make feature request on Assembly2 module issue tracker to provide CSV BOM export capabilities.

For fun i made macro that reads labels of selected objects and puts them in the spreadsheet. Spreadsheet WB has CSV export capabilities.

Code: Select all

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()

[Roland]

Dear Triplus.

Thanks for advice. Yr macro works also at my system. It could be a start, because from there I can make spreadsheet count parts and create a list.

Stupid question perhaps: You wrote: "BOM export capabilities". What is BOM? I also tried your macro using BAM in stead of BOM, and works perfect

[mario52]

hi
try this macro Macro_FCInfo
Save alls info of object selected in a file in CSV format
mario

[J.Martinsson]

BOM, in this case means Bill Of Materials.

[triplus]

Dear Triplus.

Thanks for advice. Yr macro works also at my system. It could be a start, because from there I can make spreadsheet count parts and create a list.

Stupid question perhaps: You wrote: "BOM export capabilities". What is BOM? I also tried your macro using BAM in stead of BOM, and works perfect

Yes as @J.Martinsson explained but you can give the spreadsheet any name.

hi
try this macro Macro_FCInfo
Save alls info of object selected in a file in CSV format
mario

Nice macro.

[mario52]

hi

Nice macro.

thanks if I have time I will extend PDF
mario

[Roland]

Nice macro, Mario,
Not making a parts list of an assembly though.
Never mi
Greetz

[mario52]

hi
no this macro works with one selected object
but you can create a Compound save the data file and delete the Compound to return to normal
mario

[mdk]

Working with wood I had to export a part list (to later build a cut list), so I needed label, width, length, height, this is doable in the Python console using:

Code: Select all

print("\n".join("{}: {} × {} × {}".format(o.Label, o.Height, o.Length, o.Width) for o in App.ActiveDocument.Objects if all([hasattr(o, attr) for attr in ("Height", "Width", "Length", "Label")])))