Edit Smart Properties as CSV files

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.
Smart Properties are currently only available in the Windows version of BIMcollab ZOOM.

Export the Smart Property

  1. Create a new Smart Property
  2. If necessary, already add a couple of lines as a guideline for the rest of the script
  3. In the edit window, click the  button
  4. 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:
  1. The values are separated by commas
  2. The first line contains version information
  3. The second line contains the headers of the input fields: Element Type, Property, Operator, Value, Action and Output
  4. The following lines contain the rules which were present in the exported Smart Property
  5. 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 helpcenter 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:
  1. Element Type
    The element type can be found within the currently loaded IFC-files

  2. Property
    The set and property can be found within the currently loaded IFC-files, or is part of the basic Summary and Location properties

  3. Operator
    The operator is part of the operator options, and is valid based on the chosen Property: 

    1. For text based properties the options are: Is, IsNot, Contains, DoesNotContain, StartsWith, EndsWith, Or (One of), Nor (None of), IsDefined, IsNotDefined

    2. For quantity based properties the options are: Equals (=), NotEquals (≠), Less (<), Greater (>), GreaterEqual (>=), LessEqual (<=), IsDefined, IsNotDefined

  4. Value
    The value which the property should have

  5. Action
    The action must be SetValue, MapValue or And

  6. Output

    1. When the Action is 'And', this field should be empty.

    2. 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.

    3. 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.

  7. 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

  1. In BIMcollab ZOOM, open the models for which you want to add the Smart Property

  2. Open the Smart Property you created earlier again, or create a new Smart Property

  3. In the edit window, click the  button

  4. Navigate to the file you want to import, and click 'Open'
  5. 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.
  6. 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

  1. 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).
  2. 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).
  3. 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).
  4. 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.
  5. Too many columns in line “{LineNumber}” in file "{FileName}"
    There are too many columns in a particular line of the script.
  6. 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

  1. Could not parse "{Action}” to an action. Must be 'SetValue', 'MapValue' or 'And'
    The action must be 'SetValue', 'MapValue' or 'And'.
  2. 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.
  3. 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

    • 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 ...
    • 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. Smart ...
    • 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 ...
    • New release: Smart Properties | 09-06-2022

      With the new version of BIMcollab ZOOM being released on June 9th 2022, Smart Properties are ready to use! With Smart Properties you can easily re-organize and structure BIM data to your needs for consistent model validation. We believe this feature ...
    • 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 ...