Arch Schedule: Difference between revisions

From FreeCAD Documentation
(For a more complete solution, see the Reporting Workbench in the list of external workbenches.)
No edit summary
(9 intermediate revisions by 3 users not shown)
Line 2: Line 2:
<translate>
<translate>
<!--T:31-->
<!--T:31-->
{{Docnav
{{docnav|[[Arch_MultiMaterial|Multi-Material]]|[[Arch_CutPlane|Cut with plane]]|[[Arch_Module|Arch]]|IconL=Arch_MultiMaterial.png |IconC=Workbench_Arch.svg |IconR=Arch_CutPlane.svg}}
|[[Arch_MultiMaterial|Multi-Material]]
|[[Arch_CutPlane|Cut with plane]]
|[[Arch_Module|Arch]]
|IconL=Arch_MultiMaterial.svg
|IconC=Workbench_Arch.svg
|IconR=Arch_CutPlane.svg
}}


<!--T:1-->
<!--T:1-->
Line 9: Line 16:
|MenuLocation=Arch → Schedule
|MenuLocation=Arch → Schedule
|Workbenches=[[Arch Module|Arch]]
|Workbenches=[[Arch Module|Arch]]
|SeeAlso=[[Arch Equipment]]
|SeeAlso=[[Arch Equipment|Arch Equipment]]
}}
}}


Line 21: Line 28:
{{Emphasis|Note}}: This tool has been rewritten in FreeCAD 0.17 and differs from previous versions.
{{Emphasis|Note}}: This tool has been rewritten in FreeCAD 0.17 and differs from previous versions.


<!--T:35-->
For a more general solution, see the [https://github.com/furti/FreeCAD-Reporting/tree/master Reporting Workbench] in the list of [[external workbenches|external workbenches]]. This workbench uses SQL syntax to extract information from the document.
For a more general solution, see the [https://github.com/furti/FreeCAD-Reporting/tree/master Reporting Workbench] in the list of [[external workbenches|external workbenches]]. This workbench uses SQL syntax to extract information from the document.


==How to use== <!--T:4-->
==Usage== <!--T:4-->


<!--T:8-->
<!--T:8-->
Line 40: Line 48:


<!--T:15-->
<!--T:15-->
Then you press the Arch Schedule button. You get a task panel like this. It is pretty wide, so you'll need to widen the task panel to be comfortable.
Then you press the {{Button|[[Image:Arch Schedule.svg|16px]] [[Arch Schedule|Arch Schedule]]}} button. You get a task panel like this. It is pretty wide, so you'll need to widen the task panel to be comfortable.


<!--T:16-->
<!--T:16-->
Line 46: Line 54:


<!--T:17-->
<!--T:17-->
Then you can fill line by line. Each line is a "query" and will render one line in the spreadsheet. Press the '''Add''' button to add a new line, and double-click each cell from that line to fill in the values. The '''Del''' button will delete the line which contains a currently selected cell, and '''Clear''' will delete all the lines. Possible values to put in columns are:
Then you can fill line by line. Each line is a "query" and will render one line in the spreadsheet. Press the {{Button|Add}} button to add a new line, and double-click each cell from that line to fill in the values. The {{Button|Del}} button will delete the line which contains a currently selected cell, and {{Button|Clear}} will delete all the lines. Possible values to put in columns are:


<!--T:18-->
<!--T:18-->
* '''Description''': A description for this query. The Description column will be the first column of the resulting spreadsheet. The description is mandatory to have a query performed. If you leave the description cell empty, the whole line will be skipped and left blank in the spreadsheet. This allows you to add "separator" lines.
* '''Description''': A description for this query. The Description column will be the first column of the resulting spreadsheet. The description is mandatory to have a query performed. If you leave the description cell empty, the whole line will be skipped and left blank in the spreadsheet. This allows you to add "separator" lines.
* '''Value''': This is the real query that you want to perform on all the objects selected by this query. It can be two kinds of things: either the word '''count''' (or Count or COUNT, it's case-insensitive), which will simply count objects, or retrieve ans sum a property, for example '''object.Shape.Volume''' or '''object.Length''' or even '''object.Label'''. The name you use before the first dot (object) can be anything, you could also write x.Shape.Volume. The rule is: what comes after the first dot will be retrieved from each object selected by this query, if possible (object that don't have the required property will be skipped), and the result will be added together. For example, if you use object.Shape.Volume, you will get the sum of all volumes of all objects selected by this query.
* '''Value''': This is the real query that you want to perform on all the objects selected by this query. It can be two kinds of things: either the word '''count''' (or Count or COUNT, it's case-insensitive), which will simply count objects, or retrieve ans sum a property, for example {{incode|object.Shape.Volume}} or {{incode|object.Length}} or even {{incode|object.Label}}. The name you use before the first dot (object) can be anything, you could also write {{incode|x.Shape.Volume}}. The rule is: what comes after the first dot will be retrieved from each object selected by this query, if possible (object that don't have the required property will be skipped), and the result will be added together. For example, if you use {{incode|object.Shape.Volume}}, you will get the sum of all volumes of all objects selected by this query.
* '''Unit''': An optional unit to express the results in. It's up to you to give a unit that matches the query you are doing, for example, if you are retrieving volumes, you should use a volume unit, such as m^3. If you use a wrong unit, for ex. cm, you'll get wrong results.
* '''Unit''': An optional unit to express the results in. It's up to you to give a unit that matches the query you are doing, for example, if you are retrieving volumes, you should use a volume unit, such as {{incode|m^3}}. If you use a wrong unit, for ex. cm, you'll get wrong results.
* '''Objects''': You can leave this empty, then all the objects of the document will be considered by this query, or give a semicolon (;)-separated list of object names (not labels). If any of the objects in this list is a group, its children will be selected as well. So the easiest way to use this feature is to group your objects meaningfully in the document, and just give a group name here. You can also use the '''Selection''' button to add objects currently selected in the document.
* '''Objects''': You can leave this empty, then all the objects of the document will be considered by this query, or give a semicolon (;)-separated list of object names (not labels). If any of the objects in this list is a group, its children will be selected as well. So the easiest way to use this feature is to group your objects meaningfully in the document, and just give a group name here. You can also use the {{Button|Selection}} button to add objects currently selected in the document.
* '''Filter''': Here you can add a semicolon(;)-separated list of filters. Each filter is written in the form: filter:value, where filter can be (it's case-insensitive too): Name, Label, Type, or Role (see full list below). For example: name:door;type:window will filter the objects we got from the step above, and retain only those whose name contains "door" AND the type (returned by Draft.getType) is "wall". Everything is case-insensitive. Filters that begins with ! are inverted. For example, !name:wall will retain only objects that DON'T have "wall" in their name. "Role" is a property that all Arch objects have.
* '''Filter''': Here you can add a semicolon(;)-separated list of filters. Each filter is written in the form: filter:value, where filter can be (it's case-insensitive too): Name, Label, Type, or Role (see full list below). For example: name:door;type:window will filter the objects we got from the step above, and retain only those whose name contains "door" AND the type (returned by Draft.getType) is "wall". Everything is case-insensitive. Filters that begins with ! are inverted. For example, !name:wall will retain only objects that DON'T have "wall" in their name. "Role" is a property that all Arch objects have.


<!--T:19-->
<!--T:19-->
The '''Import''' button allows you to build this list in another spreadsheet application, and import that as a csv file here.
The {{Button|Import}} button allows you to build this list in another spreadsheet application, and import that as a csv file here.


<!--T:20-->
<!--T:20-->
Line 65: Line 73:


<!--T:22-->
<!--T:22-->
After that, press OK and a new Schedule object is added to the document, which contains a result spreadsheet:
After that, press {{Button|OK}} and a new Schedule object is added to the document, which contains a result spreadsheet:


<!--T:23-->
<!--T:23-->
Line 85: Line 93:


<!--T:29-->
<!--T:29-->
* '''name:something''': Will retain only objects that have "something" in their name (case-insensitive)
: {{incode|name:something}}: Will retain only objects that have "something" in their name (case-insensitive)
* '''!name:something''': Will retain only objects that don't have "something" in their name
: {{incode|!name:something}}: Will retain only objects that don't have "something" in their name
* '''label:something''': Will retain only objects that have "something" in their label (case-insensitive)
: {{incode|label:something}}: Will retain only objects that have "something" in their label (case-insensitive)
* '''!label:something''': Will retain only objects that don't have "something" in their label
: {{incode|!label:something}}: Will retain only objects that don't have "something" in their label
* '''type:something''': Will retain only objects where the Draft.getType() function returns "something"
: {{incode|type:something}}: Will retain only objects where the {{incode|Draft.getType()}} function returns "something"
* '''!type:something''': Will retain only objects where the Draft.getType() function does not return "something"
: {{incode|!type:something}}: Will retain only objects where the {{incode|Draft.getType()}} function does not return "something"
* '''role:something''': Will retain only objects that have a Role property set to "something"
: {{incode|role:something}}: Will retain only objects that have a Role property set to "something"
* '''!role:something''': Will retain only objects that don't have a Role property, or where the Role property is not set to "something"
: {{incode|!role:something}}: Will retain only objects that don't have a Role property, or where the Role property is not set to "something"




<!--T:32-->
<!--T:32-->
{{Docnav
{{docnav|[[Arch_MultiMaterial|Multi-Material]]|[[Arch_CutPlane|Cut with plane]]|[[Arch_Module|Arch]]|IconL=Arch_MultiMaterial.png |IconC=Workbench_Arch.svg |IconR=Arch_CutPlane.svg}}
|[[Arch_MultiMaterial|Multi-Material]]
|[[Arch_CutPlane|Cut with plane]]
|[[Arch_Module|Arch]]
|IconL=Arch_MultiMaterial.svg
|IconC=Workbench_Arch.svg
|IconR=Arch_CutPlane.svg
}}


<!--T:33-->
{{Arch Tools navi}}

<!--T:34-->
{{Userdocnavi}}
</translate>
</translate>
{{Arch Tools navi{{#translation:}}}}

{{Userdocnavi{{#translation:}}}}

Revision as of 20:45, 20 February 2020

Arch Schedule

Menu location
Arch → Schedule
Workbenches
Arch
Default shortcut
None
Introduced in version
-
See also
Arch Equipment


Description

The Schedule tool allows you to create and automatically populate a spreadsheet with contents gathered from the model.

Note: This tool has been rewritten in FreeCAD 0.17 and differs from previous versions.

For a more general solution, see the Reporting Workbench in the list of external workbenches. This workbench uses SQL syntax to extract information from the document.

Usage

  1. Open or create a FreeCAD document which contains some objects.
  2. Press the Schedule button.
  3. Adjust the desired options.
  4. Press OK.

Workflow

First you need to have a model. For example, here is a document with a couple of objects. I did Arch stuff here, but it doesn't need to be Arch, it can be anything.

Then you press the Arch Schedule button. You get a task panel like this. It is pretty wide, so you'll need to widen the task panel to be comfortable.

Then you can fill line by line. Each line is a "query" and will render one line in the spreadsheet. Press the Add button to add a new line, and double-click each cell from that line to fill in the values. The Del button will delete the line which contains a currently selected cell, and Clear will delete all the lines. Possible values to put in columns are:

  • Description: A description for this query. The Description column will be the first column of the resulting spreadsheet. The description is mandatory to have a query performed. If you leave the description cell empty, the whole line will be skipped and left blank in the spreadsheet. This allows you to add "separator" lines.
  • Value: This is the real query that you want to perform on all the objects selected by this query. It can be two kinds of things: either the word count (or Count or COUNT, it's case-insensitive), which will simply count objects, or retrieve ans sum a property, for example object.Shape.Volume or object.Length or even object.Label. The name you use before the first dot (object) can be anything, you could also write x.Shape.Volume. The rule is: what comes after the first dot will be retrieved from each object selected by this query, if possible (object that don't have the required property will be skipped), and the result will be added together. For example, if you use object.Shape.Volume, you will get the sum of all volumes of all objects selected by this query.
  • Unit: An optional unit to express the results in. It's up to you to give a unit that matches the query you are doing, for example, if you are retrieving volumes, you should use a volume unit, such as m^3. If you use a wrong unit, for ex. cm, you'll get wrong results.
  • Objects: You can leave this empty, then all the objects of the document will be considered by this query, or give a semicolon (;)-separated list of object names (not labels). If any of the objects in this list is a group, its children will be selected as well. So the easiest way to use this feature is to group your objects meaningfully in the document, and just give a group name here. You can also use the Selection button to add objects currently selected in the document.
  • Filter: Here you can add a semicolon(;)-separated list of filters. Each filter is written in the form: filter:value, where filter can be (it's case-insensitive too): Name, Label, Type, or Role (see full list below). For example: name:door;type:window will filter the objects we got from the step above, and retain only those whose name contains "door" AND the type (returned by Draft.getType) is "wall". Everything is case-insensitive. Filters that begins with ! are inverted. For example, !name:wall will retain only objects that DON'T have "wall" in their name. "Role" is a property that all Arch objects have.

The Import button allows you to build this list in another spreadsheet application, and import that as a csv file here.

So we can build a list of queries like this:

After that, press OK and a new Schedule object is added to the document, which contains a result spreadsheet:

By double-clicking the Schedule object, you get back to the task panel and change the values. By double-clicking the spreadsheet itself, you get the results in 3 columns: description, value, unit (if applicable):

The spreadsheet can then be exported to csv normally, from the Spreadsheet workbench.

Filters

Currently available filters:

name:something: Will retain only objects that have "something" in their name (case-insensitive)
!name:something: Will retain only objects that don't have "something" in their name
label:something: Will retain only objects that have "something" in their label (case-insensitive)
!label:something: Will retain only objects that don't have "something" in their label
type:something: Will retain only objects where the Draft.getType() function returns "something"
!type:something: Will retain only objects where the Draft.getType() function does not return "something"
role:something: Will retain only objects that have a Role property set to "something"
!role:something: Will retain only objects that don't have a Role property, or where the Role property is not set to "something"