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
Veteran
Posts: 1920
Joined: Fri May 16, 2014 1:14 pm
Contact:

Re: BOM (Bill Of Materials) function

Post by saso »

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 112 times
Last edited by saso on Wed Apr 04, 2018 7:10 pm, edited 1 time in total.
User avatar
Kunda1
Veteran
Posts: 13434
Joined: Thu Jan 05, 2017 9:03 pm

Re: BOM (Bill Of Materials) function

Post by Kunda1 »

Screenshot for the people (of @saso's generic proposal)
Image
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
User avatar
silopolis
Posts: 74
Joined: Thu Oct 20, 2016 10:06 pm

Re: BOM (Bill Of Materials) function

Post by silopolis »

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: 18
Joined: Fri Nov 24, 2017 6:30 pm

Re: BOM (Bill Of Materials) function

Post by JoeB »

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 175 times
BMGlobal.csv
(1.03 KiB) Downloaded 109 times
BM.csv
(1.64 KiB) Downloaded 105 times
SAMPLE.pdf
(38.16 KiB) Downloaded 195 times
JoeB
Posts: 18
Joined: Fri Nov 24, 2017 6:30 pm

Re: BOM (Bill Of Materials) function

Post by JoeB »

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
Veteran
Posts: 13434
Joined: Thu Jan 05, 2017 9:03 pm

Re: BOM (Bill Of Materials) function

Post by Kunda1 »

eivindkvedalen wrote:ping
wandererfan wrote:ping
Just wanted to make sure that eivind and wandererfan were involved in the conversation as well.
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
paullee
Veteran
Posts: 5098
Joined: Wed May 04, 2016 3:58 pm

Re: BOM (Bill Of Materials) function

Post by paullee »

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
Veteran
Posts: 1570
Joined: Sat Apr 19, 2014 6:23 am
Contact:

Re: BOM (Bill Of Materials) function

Post by bitacovir »

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)

Canal Youtube Grupo Telegram de FreeCAD Español

My personal web site
My GitHub repository
Mini Airflow Tunnel Project
paullee
Veteran
Posts: 5098
Joined: Wed May 04, 2016 3:58 pm

Re: BOM (Bill Of Materials) function

Post by paullee »

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
Veteran
Posts: 13434
Joined: Thu Jan 05, 2017 9:03 pm

Re: BOM (Bill Of Materials) function

Post by Kunda1 »

Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
Post Reply