BOM (Bill Of Materials) function

Have some feature requests, feedback, cool stuff to share, or want to know where FreeCAD is going? This is the place.
Forum rules
Be nice to others! Read the FreeCAD code of conduct!
User avatar
saso
Posts: 1336
Joined: Fri May 16, 2014 1:14 pm
Contact:

Re: BOM (Bill Of Materials) function

Postby saso » Fri Mar 16, 2018 6:15 pm

Here is an old brainstorming idea from me on this topic... Columns A to G are the output (the results the user would get), column I and K show a possible syntax for an generic input. It is in general based on the existing schedule tool from the Arch WB but the idea here was that it should be extremely generic, so to say, it should be possible to get any imaginable data out of the FreeCAD model with it. The examples are more specific to architecture, but with the right input it should work for anyone (since different FreeCAD users can have very different needs here).
Attachments
schedule idea.ods
(25.11 KiB) Downloaded 36 times
Last edited by saso on Wed Apr 04, 2018 7:10 pm, edited 1 time in total.
User avatar
Kunda1
Posts: 5913
Joined: Thu Jan 05, 2017 9:03 pm

Re: BOM (Bill Of Materials) function

Postby Kunda1 » Fri Mar 16, 2018 6:20 pm

Screenshot for the people (of @saso's generic proposal)
Image
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
silopolis
Posts: 59
Joined: Thu Oct 20, 2016 10:06 pm

Re: BOM (Bill Of Materials) function

Postby silopolis » Sun Mar 25, 2018 7:50 am

G'evening

I totally second pushing the BoM feature to the front !

BTW, something I'm wondering, wouldn't it benefit from a a feature packed spreadsheet app ? If so, shouldn't this effort be joined with those aiming to connect FreeCAD and LibreOffice ?

See here:
* https://forum.freecadweb.org/viewtopic.php?f=8&t=23863
* https://forum.freecadweb.org/viewtopic.php?f=4&t=25691

Anyway, I'll gratefully welcome any progress on this matter :)

Bests
JoeB
Posts: 16
Joined: Fri Nov 24, 2017 6:30 pm

Re: BOM (Bill Of Materials) function

Postby JoeB » Wed Apr 04, 2018 6:52 pm

Attached is my take on the bill of materials.
The assumptions are:
1) Every object is in a group
2) Every Object has a description field (either generated by the input parameters, or assigned to "Black Boxed" objects
See showcase> "pressure vessel with piping" for an overall view.
Attached sample.pdf is how I want to details to look and I think I can make it work in techdraw, which would allow for an internal table.
Attachments
bill of materials.txt
(1.04 KiB) Downloaded 69 times
BMGlobal.csv
(1.03 KiB) Downloaded 41 times
BM.csv
(1.64 KiB) Downloaded 40 times
SAMPLE.pdf
(38.16 KiB) Downloaded 73 times
JoeB
Posts: 16
Joined: Fri Nov 24, 2017 6:30 pm

Re: BOM (Bill Of Materials) function

Postby JoeB » Wed Apr 04, 2018 9:07 pm

I forgot to mention, you do want an external data base be it csv, sql or whatever. Parts need to be ordered, checked in when received, checked for quality and so on. FC has enough power to generate all the lists very easily, but everybody does it differently.
User avatar
Kunda1
Posts: 5913
Joined: Thu Jan 05, 2017 9:03 pm

Re: BOM (Bill Of Materials) function

Postby Kunda1 » Wed Aug 08, 2018 8:39 pm

eivindkvedalen wrote:ping
wandererfan wrote:ping
Just wanted to make sure that eivind and wandererfan were involved in the conversation as well.
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
paullee
Posts: 1826
Joined: Wed May 04, 2016 3:58 pm

Re: BOM (Bill Of Materials) function

Postby paullee » Thu Aug 09, 2018 11:59 pm

Hi, I attempt some FC spreadsheet earlier.

But I find in architectural practice, there is discussion about 'standard modelling'.

I.E.
Architect/ Structural Engineer / M&E or building services engineer do BIM model 'standard' way.

Quantity Surveyor (British tradition only?) then take measurement opening up the model rather than 2d drawings.
User avatar
bitacovir
Posts: 724
Joined: Sat Apr 19, 2014 6:23 am
Contact:

Re: BOM (Bill Of Materials) function

Postby bitacovir » Tue Aug 14, 2018 12:19 pm

paullee wrote:
Thu Aug 09, 2018 11:59 pm
Quantity Surveyor (British tradition only?) ...
Also in Australia...
::bitacovir::
===================================
One must be absolutely modern.
Arthur Rimbaud (A Season in Hell -1873)

My Blog
Mini Airflow Tunnel Project
paullee
Posts: 1826
Joined: Wed May 04, 2016 3:58 pm

Re: BOM (Bill Of Materials) function

Postby paullee » Tue Aug 14, 2018 1:05 pm

bitacovir wrote:
Tue Aug 14, 2018 12:19 pm
Also in Australia...
Good... :)

I haven't dig into documents about the so-called 'standard' way of modelling.

Anyone has any idea?

BTW, happens to be any Quantity Surveyor here?
User avatar
Kunda1
Posts: 5913
Joined: Thu Jan 05, 2017 9:03 pm

Re: BOM (Bill Of Materials) function

Postby Kunda1 » Thu Sep 06, 2018 1:38 pm

Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features