Export

1. Click 'Excel' in top menu and then 'Export'.

 

Exported Excel file

Created Excel file will automatically be downloaded and be where you have said in your browser they should be downloaded.

 

The Excel export will also be available under Reports in Interaxo BIM Data.

Export rules and remarks

Multiline parameters are exported from the Data grid and Parameter group items without tags and formatting.

When importing the exported Excel file with removed tags and formatting, values will be edited in the Data grid and Parameter group items - formatting will be removed. So be very careful when working with Multiline parameters and Excel import as it will remove any formatting including things like lines breaks.

 

Images will not be exported to Excel.

 

Import

With excel import, you can update data on parameters using excel. You can update data that you have the right to handle in the project.

 

1. Click on 'Excel' in top menu and then 'Import'

2. Drag n drop Excel file or click to select file,

3. Then click 'Ok' for import.

 

4. When the import is complete, an excel is created that is downloaded automatically where you can see which data was updated. The updated information is denoted here with a green background color.

 

You can download a Template from where you upload your excel, but a tip is to create a grid and create a Bookmark with the data you want to be able to edit and see in excel. Use this grid to export and later update the data with that formatting.

 

Import rules and remarks

Row four in Excel must have the exact parameter names as in the grid view. Global BIMEYE ID must be in the first column. It is used to identify each instance. The import of values will start from row five.

The data type in Excel must match the parameter setting.

Parameters with lookup values must contain existing and valid values.

Parameters that are part of a parameter group with leading parameter, items cannot be imported this way. Read more about updating items with excel here.

Parameters that are set to be System parameters cannot be imported.

Parameters that are set as Sync to Bimeye cannot be imported.

Parameters that are set to Sync from Bimeye must have bound property in model.

Projection parameters cannot be imported. Projected parameters can be updated from the grid from which they are projected.

Calculation parameters can not be updated in import. Objects and Material data grid, import can not update Quantity and Comments.

Note that importing empty values will not override values that are already filled with some value. Use "-", "N/A" or similar to denote a chosen empty value.

Excel export is support up to 350 parameters/columns and several thousand objects/rows depending on the amount of data in each cell. If the export fails try reducing the amount of parameters or objects and try again. If it fails again contact support for assistance.