SQL Reporting Workbench for FreeCAD

Info about new community or project announcements, implemented features, classes, modules or APIs. Might get technical!
PLEASE DO NOT POST HELP REQUESTS OR OTHER DISCUSSIONS HERE!
Forum rules
Be nice to others! Respect the FreeCAD code of conduct!
chrisb
Veteran
Posts: 53930
Joined: Tue Mar 17, 2015 9:14 am

Re: SQL Reporting Workbench for FreeCAD

Post by chrisb »

wandererfan wrote: Fri Feb 22, 2019 9:44 pm Reports go onto TechDraw pages easily!
Very interesting application.
A Sketcher Lecture with in-depth information is available in English, auf Deutsch, en français, en español.
User avatar
roerich_64
Veteran
Posts: 1465
Joined: Thu May 21, 2015 7:00 pm
Location: Ostfriesland

Re: SQL Reporting Workbench for FreeCAD

Post by roerich_64 »

chrisb wrote: Mon Feb 25, 2019 12:12 am Very interesting application.
Realy!

I will give the Reporting WB a try at the house_B ;)
Haus_B.jpg
Haus_B.jpg (122.23 KiB) Viewed 3505 times
But it needs a little time to do that ;)

BR
Walter
Die Liebe wird siegen, denn sie ist unzerstörbar :) ;)
romabalti1900
Posts: 2
Joined: Fri Jan 05, 2018 6:20 pm

Re: SQL Reporting Workbench for FreeCAD

Post by romabalti1900 »

VERY COOL Workbench !
HolgerL
Posts: 4
Joined: Thu Nov 28, 2019 3:30 pm

Re: SQL Reporting Workbench for FreeCAD

Post by HolgerL »

Hi furti,

thank you very much for your great tool!
You solved my problem with gernerating a BOM including size of all components.
Great work!

Holger
User avatar
Kunda1
Veteran
Posts: 13434
Joined: Thu Jan 05, 2017 9:03 pm

Re: SQL Reporting Workbench for FreeCAD

Post by Kunda1 »

HolgerL wrote: Thu Dec 05, 2019 2:51 pm You solved my problem with gernerating a BOM including size of all components.
Can you post your own success story with this WB in this forum for other to see ?
How did you generate the BOM ?
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
HolgerL
Posts: 4
Joined: Thu Nov 28, 2019 3:30 pm

Re: SQL Reporting Workbench for FreeCAD

Post by HolgerL »

Hi,

yes sure I can do that. But it is pretty simple and straight forward.

I have build the complete construction of the planning for a camper into freecad. So this is an assemby of "boxes", which are all the plates of the planned furniture. Then I looked for a solution to collect all these pieces with their length, width and heights to calculate the total amount of wood I need and so get the total weight of the interior construction.

So I found this reporting workbench and put the reporting statement:

Code: Select all

SELECT  Label, Length, Width, Height
FROM document
WHERE Length IS NOT NULL
This gives a result table like:

Code: Select all

=Label	Length	Width	Height
Boden	=3600mm	=2040mm	=52mm
Seite links	=3600mm	=40mm	=2192mm
Seite rechts	=3600mm	=40mm	=2192mm
Seite hinten	=40mm	=2040mm	=1960mm
Seite vorne	=40mm	=2040mm	=1500mm
Seite Alkoven Top	=40mm	=2040mm	=670mm
Sitz_Wand001	=16mm	=650mm	=634mm
Sitz_Wand002	=16mm	=650mm	=634mm
Bodenplatte Sitz	=800mm	=660mm	=16mm
Sitz_Wand_L	=800mm	=16mm	=634mm
Sitz_Wand_R	=800mm	=16mm	=634mm
Sitz_Trennwand	=16mm	=1960mm	=634mm
This I then took to Excel and made some calculations.
- removed the mm and make the fields number
- filtered Length,Width,Height for 16mm entries, because these are the furniture plates. (40mm are the sidewalls..) and gave them a 4. filter attribute
- for all these furniture entries I simply calculated the volume and devided by 16 to get the total plate area. done

Sure this could be some more automated, but since this is more a singel event caculation it is ok for me to get the result.
stanicke
Posts: 6
Joined: Sun Dec 01, 2019 8:58 pm

Re: SQL Reporting Workbench for FreeCAD

Post by stanicke »

Hello, I needed an export to a .xlsx file, so I implemented it, can be useful to somebody :). See https://github.com/furti/FreeCAD-Reporting/pull/26

One idea for improvement: the xlsx file is able to handle units as a cell format, but I am not sure how to get proper units from FreeCad :(
Joyas
Posts: 532
Joined: Sat Jul 12, 2014 8:39 pm

Re: SQL Reporting Workbench for FreeCAD

Post by Joyas »

This workbench is interesting.
What happens if accidentally I write "DELETE FROM document" without specifying anything (WHERE)?
Does it clean the entire FreeCAD document?
:P
Estudié ingeniería técnica industrial en España y sólo me ha servido para estar en el paro, no me contratan porque no tengo experiencia, y no tengo experiencia porque no me contratan. No debí estudiar esa carrera.
chrisb
Veteran
Posts: 53930
Joined: Tue Mar 17, 2015 9:14 am

Re: SQL Reporting Workbench for FreeCAD

Post by chrisb »

There are several possibilities to find out:
- You can read the documentation and find out that it is not implemented: https://github.com/furti/FreeCAD-Reporting
- You can look at the source code: https://github.com/furti/FreeCAD-Reporting
- You can even try it, of course on a copy if the document is important..
A Sketcher Lecture with in-depth information is available in English, auf Deutsch, en français, en español.
stanicke
Posts: 6
Joined: Sun Dec 01, 2019 8:58 pm

Re: SQL Reporting Workbench for FreeCAD

Post by stanicke »

Ok, I also added proper cell formatting, so cell values can be now used directly for further computations in Excel (see https://github.com/furti/FreeCAD-Reporting/pull/26)
Post Reply