Edit Smart Properties as CSV files
When creating a Smart Property to structure the data in IFC files, a lot of input might be required to define the property completely. In order to make this process easier, Smart Properties can also be imported, exported and edited as CSV files.
To be able to create and use Smart Properties in BIMcollab Zoom, you need an active Zoom license.
Export the Smart Property
- Create a new Smart Property
- If necessary, already add a couple of lines as a guideline for the rest of the script
- In the edit window, click the button
- Navigate to the location you want to save the file to, and click 'Save'
Edit the CSV file
Once the file has been exported, it can be opened in the spreadsheet software or CSV editor of your choice.
The CSV file is structured as follows:
- The values are separated by commas
- The first line contains version information
- The second line contains the headers of the input fields: Element Type, Property, Operator, Value, Action and Output
- The following lines contain the rules which were present in the exported Smart Property
- In the Property column, both the Property set and Property are present, separated by '/'
When opening the CSV file in a spreadsheet software like excel, it might occur that the text has not been separated into columns yet. To easily work with the data in
excel, follow the workflow as described on the Microsoft Help Center to separate the data into columns
.
Edit the CSV file as desired. Copy and add lines to create a full Smart Property script.
The resulting script must meet the following criteria:
Element Type
The element type can be found within the currently loaded IFC-files
Property
The set and property can be found within the currently loaded IFC-files, or is part of the basic Summary and Location properties
Operator
The operator is part of the operator options, and is valid based on the chosen Property:
For text based properties the options are: Is, IsNot, Contains, DoesNotContain, StartsWith, EndsWith, Or (One of), Nor (None of), IsDefined, IsNotDefined
For quantity based properties the options are: Equals (=), NotEquals (≠), Less (<), Greater (>), GreaterEqual (>=), LessEqual (<=), IsDefined, IsNotDefined
For boolean based properties the options are: IsTrue, IsFalse, IsDefined, IsNotDefined
Value
The value which the property should have
Action
The action must be SetValue, MapValue or And
Output
When the Action is 'And', this field should be empty.
When the Action is 'MapValue', this field should contain a property which is also part of the sequence the rule is part of. This field cannot be empty.
When the Action is 'SetValue', this field should contain a text input for the value of the new property. This field will always be valid, even if it is empty.
All six of the above columns need to be present in the file
Save the file again as a CSV file (comma separated values).
Import the CSV file
In BIMcollab Zoom, open the models for which you want to add the Smart Property
Open the Smart Property you created earlier again, or create a new Smart Property
In the edit window, click the button
- Navigate to the file you want to import, and click 'Open'
The Smart Property script will be imported into the edit window.
Any lines already present in the Smart Property will be overwritten by the import. If the lines present in the Smart Property should remain part of the script, make sure they are also present in the CSV file. To restore the original lines of the Smart Property, click 'Cancel' to discard the imported script.
- Save the Smart Property
Possible error messages
When importing a CSV file as a Smart Property, you will get an error message when the file does not meet the requirements listed above.
File errors
- Header missing in file "{FileName}"
The second line of the script must contain the headers of the input fields: Element Type, Property, Operator, Value, Action and Output (in English). - Missing column "{ColumnName}" in header of file "{FileName}"
One of the columns is missing. The CSV file must contain 6 columns at all times with the headers: Element Type, Property, Operator, Value, Action and Output (in English). - Duplicated column "{ColumnName}" in header of file "{FileName}"
One of the columns is duplicated. The CSV file must contain 6 columns at all times with the headers: Element Type, Property, Operator, Value, Action and Output (in English). - Too few columns in line “{LineNumber}” in file "{FileName}"
One of the columns is missing or not filled in in a particular line of the script. - Too many columns in line “{LineNumber}” in file "{FileName}"
There are too many columns in a particular line of the script. - Escaped string was not closed in line “{LineNumber}” in file "{FileName}"
There is no closing quotation mark present in the value field. Quotation marks are only necessary when you want to use a comma or semicolon as part of the value.
Translation errors
- Could not parse "{Action}” to an action. Must be 'SetValue', 'MapValue' or 'And'
The action must be 'SetValue', 'MapValue' or 'And'. - Could not find property “{PropertyName}” and/or set "{SetName }"
The property and/or property set are not part of the loaded models or contain a typo. - Could not parse "{Operator}” to a condition operator
The chosen operator is not part of the operator options, or is not valid for the chosen property.
Related Articles
Create Smart Properties
Smart Properties in BIMcollab Zoom are user-defined properties, based on existing object attributes. They help you to reorganize and structure BIM data. When working with IFC files delivered by multiple authors, it is inevitable that they contain ...
Share Smart properties with my team members
Smart Properties can be easily shared with team members within a project by following these steps: Start BIMcollab Zoom Connect to the correct space and project Go to Validate > Smart Properties Drag and drop the Smart Properties you wish to share ...
The different types of actions for Smart Properties
With Smart Properties, you can either map existing properties to a new property, or define a new property value for an element based on certain criteria. To be able to create Smart Properties in BIMcollab Zoom, you need an active Zoom license. Do you ...
Create a value dictionary to simplify IFC data with Smart Properties
When adding data to a BIM model, different languages, abbreviations and typos are inevitable. In order to smooth out these differences, Smart Properties help to get a predictable outcome for consistent model validation. To be able to create and use ...
Where can Smart Properties be used?
Smart Properties are available in BIMcollab Zoom as if they are native properties. They are usable in all other functions of BIMcollab Zoom, like Smart views, Clash rules, Lists and any other place where IFC properties can be found. To be able to ...