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
Added "CONCAT" function and fixed a bug with unhashable types in Statements with a "GROUP BY" clause.
Full list of changes is here https://github.com/furti/FreeCAD-Report ... es/tag/0.4
Full list of changes is here https://github.com/furti/FreeCAD-Report ... es/tag/0.4
Re: SQL Reporting Workbench for FreeCAD
this is amazing! thank you so much. i can't play with it right this second, but i've been hurting for a basic database, and having it inside FreeCAD will be perfect for me.
have you given any thought to creating basic "TABLE", "VIEW", and "REPORT" python object types? obviously i can add whatever i want to my own python object. i need to go read your docs before i ask too many questions.
my main message here is thank you
have you given any thought to creating basic "TABLE", "VIEW", and "REPORT" python object types? obviously i can add whatever i want to my own python object. i need to go read your docs before i ask too many questions.
my main message here is thank you
Re: SQL Reporting Workbench for FreeCAD
There is a report object available in the workbench. You can add multiple queries to it an it will fill a spreadsheet with the resulting data.
If you need more specialised objects feel free to make a issue (or even a pull request ) in the github repo. Or post your wishes here.
Currently I'm thinking of a "visibility" object. You configure it with a "Where" clause and it will display or hide all objects matching. I often need this in my current arch project when displaying only a single building part or the whole building.
If you need more specialised objects feel free to make a issue (or even a pull request ) in the github repo. Or post your wishes here.
Currently I'm thinking of a "visibility" object. You configure it with a "Where" clause and it will display or hide all objects matching. I often need this in my current arch project when displaying only a single building part or the whole building.
Re: SQL Reporting Workbench for FreeCAD
i'm with you on the visibilty filter.
i need to assign master / derived / construction / final statuses to points, curves and segments of curves, and surfaces and their segments.
right now i do it by choosing a principal charateristic, and sticking the elements in folders. whenever the principal charateristic doesn't map to a specific task, i do a lot of dancing around from folder to folder.
so i want to 'select' all master elements, make then visible / invisible for editing. at the very end, i want to 'select' all final surface segments, and stitch a shell and make it a solid.
by analogy to Solidworks and Autodesk Inventor, i want one autopopulated folder that shows all solids, one for surfaces, one for curves, one for points, etc.
the relational database model is exactly what is needed!
i need to assign master / derived / construction / final statuses to points, curves and segments of curves, and surfaces and their segments.
right now i do it by choosing a principal charateristic, and sticking the elements in folders. whenever the principal charateristic doesn't map to a specific task, i do a lot of dancing around from folder to folder.
so i want to 'select' all master elements, make then visible / invisible for editing. at the very end, i want to 'select' all final surface segments, and stitch a shell and make it a solid.
by analogy to Solidworks and Autodesk Inventor, i want one autopopulated folder that shows all solids, one for surfaces, one for curves, one for points, etc.
the relational database model is exactly what is needed!
Re: SQL Reporting Workbench for FreeCAD
Added Arithmetics and Named columns to the SQL parser
Full list of changes can be found here: https://github.com/furti/FreeCAD-Report ... es/tag/0.5
Full list of changes can be found here: https://github.com/furti/FreeCAD-Report ... es/tag/0.5
Re: SQL Reporting Workbench for FreeCAD
Hi I install in AddManager
Start FC and find below message, can't find Reporting WB in the drop-down menu.
Any idea?
FreeCAD_0.18.15860.glibc2.17-x86_64.AppImage
on
Fedora 29
Start FC and find below message, can't find Reporting WB in the drop-down menu.
Any idea?
Code: Select all
During initialization the error No module named report_utils.resource_utils occurred in /home/paullee/.FreeCAD/Mod/Reporting/InitGui.py
on
Fedora 29
Re: SQL Reporting Workbench for FreeCAD
Is this a python 3 build? If not, can you give it a try with a python 3 build?
I only use python 3 so this is not tested with python 2
Hopefully we can drop python 2 support soon
I only use python 3 so this is not tested with python 2
Hopefully we can drop python 2 support soon
Re: SQL Reporting Workbench for FreeCAD
I see
Downloaded
FreeCAD_0.18.15823_Conda_Py3Qt5_glibc2.12-x86_64.AppImage
and Reporting WB is there, thanks!
Downloaded
FreeCAD_0.18.15823_Conda_Py3Qt5_glibc2.12-x86_64.AppImage
and Reporting WB is there, thanks!
- wandererfan
- Veteran
- Posts: 6270
- Joined: Tue Nov 06, 2012 5:42 pm
- Contact:
Re: SQL Reporting Workbench for FreeCAD
Just fooling around a bit so far. Reports go onto TechDraw pages easily! Well done @furti!
- Attachments
-
- ReportOnTDPage.png (202.13 KiB) Viewed 2686 times
Re: SQL Reporting Workbench for FreeCAD
Nice to see that. So it schould be pretty easy to export and print them next to the model