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
wow,VERY interesting! I'm also not happy with the arch schedule tool. This indeed is extremely more powerful.
Re: SQL Reporting Workbench for FreeCAD
Another amasing works after the Arch Texture WB!
Can't wait to try unfortunately I have no acess to a PC right now.
Hope there is also some quantity surveyor joining the discussion about Bill of Quantity / Material etc.
Can't wait to try unfortunately I have no acess to a PC right now.
Hope there is also some quantity surveyor joining the discussion about Bill of Quantity / Material etc.
Re: SQL Reporting Workbench for FreeCAD
I'm glad to here that there is some interest in such a tool
I updated the repository with the first Basic implementation of a report. (still no documentation yet)
The tool works a bit like the "Arch schedule" tool.
Open a document and start the "Reporting" workbench.
This will create a Report Object in the document for you. Each Report object has a spreadsheet attached that stores the result of the report.
Double click the Report Object to add some queries to it. For the sample file attached in the initial post i used this statement:
When you click "OK" the report is executed. Now open the Spreadsheet and you should see a result like this You can use multiple Statements per report. And you can skip the Header field if you don't Need one.
Maybe some of you could already test it and give me feedback about the general workflow.
Also intersting to me is: Are there any properties that need special tostring handling (e.g. for quantities i use the UserString property. Everything else is simply converted to a string with pythons "str" method)
Happy reporting
I updated the repository with the first Basic implementation of a report. (still no documentation yet)
The tool works a bit like the "Arch schedule" tool.
Open a document and start the "Reporting" workbench.
This will create a Report Object in the document for you. Each Report object has a spreadsheet attached that stores the result of the report.
Double click the Report Object to add some queries to it. For the sample file attached in the initial post i used this statement:
Code: Select all
Select Label, HorizontalArea
From document
Where IfcRole = 'Column'
When you click "OK" the report is executed. Now open the Spreadsheet and you should see a result like this You can use multiple Statements per report. And you can skip the Header field if you don't Need one.
Maybe some of you could already test it and give me feedback about the general workflow.
Also intersting to me is: Are there any properties that need special tostring handling (e.g. for quantities i use the UserString property. Everything else is simply converted to a string with pythons "str" method)
Happy reporting
Re: SQL Reporting Workbench for FreeCAD
I updated the Readme with a short tutorial and the SQL Reference.
The SQL parser also supports grouping now.
The SQL parser also supports grouping now.
Re: SQL Reporting Workbench for FreeCAD
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
Added some bugfixes and minor improvements. Also started a "How To" section in the Readme where I want to collect some useful SQL Statements that might be of interest for others too
See https://github.com/furti/FreeCAD-Report ... es/tag/0.1 for more Details.
See https://github.com/furti/FreeCAD-Report ... es/tag/0.1 for more Details.
Re: SQL Reporting Workbench for FreeCAD
Added some new Features and redesigned the Report Config UI a bit.
See https://github.com/furti/FreeCAD-Report ... es/tag/0.2 for more Details.
See https://github.com/furti/FreeCAD-Report ... es/tag/0.2 for more Details.
Re: SQL Reporting Workbench for FreeCAD
Added to the addons manager!
I'll need to have a look at integrating it with the BIM WB...
I'll need to have a look at integrating it with the BIM WB...
Re: SQL Reporting Workbench for FreeCAD
Added Export / Import commands to the workbench. This makes it possible to share Reports between different Projects or create a report library with common used Reports.
For a full list of changes see https://github.com/furti/FreeCAD-Report ... es/tag/0.3
For a full list of changes see https://github.com/furti/FreeCAD-Report ... es/tag/0.3