Export an Excel file

The command to export the Excel file is located in the Actions menu at the top right of the properties table

image.png

When you click on “Export Excel file,” the dictionary properties are exported to an Excel file (.xlsx).

Excel file structure

There are several tabs:

Properties list tab

This table displays all of the Onfly properties.

Property GUID Property GUID (never modifiable)
Code Property code
Source Name of the Onfly owner (never modifiable)
Default_lang Default language (never modifiable)
Domain List of property classification domains (drop-down menu in English)
Name default language Property name in the default language
Name language 2 to n Property name in other languages
Description default language Property description in the default language (if exists, otherwise empty)
Description language 2 to n Description of the property in other languages
Edit_type Selected input types (drop-down menu in English)
Data_type Selected data types (drop-down menu in English)
Unit Selected unit (drop-down menu in English)
Version Property version (never modifiable)
Revit definition default Name of the Revit definition in the default language
Revit definition 2 to n Name of the Revit definition in other languages
Datatype Revit Selected Revit data types (drop-down menu in English)
Shared param group Name of the group in the shared parameters file export

Import an Excel file

You can update or translate properties from an Excel file, but you can also add new ones. To do this, first download the Excel file from the dictionary and modify or add to it.

Start by downloading the Excel file, which has several sheets. The first sheet contains the list of properties, while the others are input aids. As shown in the screen below, drop-down menus simplify the process of filling in attributes.

image.png

<aside> ⚠️

Any data displayed in red cannot be modified. Any modifications will not be taken into account during upload.

</aside>

Once the file is complete, all you have to do is import it into Onfly. The Actions menu in the list of properties allows you to import an Excel file.

image.png

A pop-up window will then open, allowing you to drop or select the file in the upload area.