Very interesting application.
SQL Reporting Workbench for FreeCAD
Forum rules
Be nice to others! Respect the FreeCAD code of conduct!
Be nice to others! Respect the FreeCAD code of conduct!
Re: SQL Reporting Workbench for FreeCAD
A Sketcher Lecture with in-depth information is available in English, auf Deutsch, en français, en español.
- roerich_64
- Veteran
- Posts: 1465
- Joined: Thu May 21, 2015 7:00 pm
- Location: Ostfriesland
Re: SQL Reporting Workbench for FreeCAD
Realy!
I will give the Reporting WB a try at the house_B But it needs a little time to do that
BR
Walter
Die Liebe wird siegen, denn sie ist unzerstörbar
-
- Posts: 2
- Joined: Fri Jan 05, 2018 6:20 pm
Re: SQL Reporting Workbench for FreeCAD
VERY COOL Workbench !
Re: SQL Reporting Workbench for FreeCAD
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
thank you very much for your great tool!
You solved my problem with gernerating a BOM including size of all components.
Great work!
Holger
Re: SQL Reporting Workbench for FreeCAD
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
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
Re: SQL Reporting Workbench for FreeCAD
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:
This gives a result table like:
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.
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
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
- 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.
Re: SQL Reporting Workbench for FreeCAD
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
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
Re: SQL Reporting Workbench for FreeCAD
This workbench is interesting.
What happens if accidentally I write "DELETE FROM document" without specifying anything (WHERE)?
Does it clean the entire FreeCAD document?
What happens if accidentally I write "DELETE FROM document" without specifying anything (WHERE)?
Does it clean the entire FreeCAD document?
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.
Re: SQL Reporting Workbench for FreeCAD
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..
- 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.
Re: SQL Reporting Workbench for FreeCAD
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)