Mapping data is the process of linking synchronized objects with a corresponding column in an uploaded csv/excel file. 

This connection enables COMANAGE to automatically match objects in the model with additional information from the file, making it easy to enrich your objects with all data from the file.

💡Practical example

1. In Revit, you have already assigned classification codes to your types.
2. Synchronize your Revit model with COMANAGE.
3. Add a Model Data property and select the 'Classification code' parameter.
4. Upload a file containing your classification data.

5. Map the Model Data property (from step 3) to the corresponding column (from step 4).

   → The system will automatically match identical classification codes.

   → You can now display all additional values from the file on your objects by adding them as External Data properties.

How to map

1. Go to the Configuration section.
2. Locate the uploaded csv/excel file and click the context menu (three-dot icon).
3. Click Map Data and the dialog shown above will open.
4. Select the column that contains the classification codes.
5. Select the Model Data property that contains the same classification codes. (⚠️ The value types length, area and volume are not supported for mapping)
6. Check Value Matches to see how many objects have a classification code that matches a classification code in the file.
7. Click Save and Close.
8. Add other columns (IFC Type, Description, Status etc.) as External Data properties.
9. Go to the object table in the Manage section and enable the External Data properties, and the corresponding values from the file will appear on your objects.

Mapped data is not editable

Once the mapping is executed, values originating from the file cannot be edited on the objects. They are read-only. You need to clear the mapping to make the objects editable again.
 

Clear mapping

If you want to remove the mapping you can manually clear it.

1. Go to the Configuration section.
2. Locate the uploaded csv/excel file and click the context menu (three-dot icon).
3. Click Clear Mapping and a the dialog will tell you that 'Clearing will disable automatic application of external data. Current object data will remain unchanged'.
4. Now you can edit the external data on the objects again.

Updating the file used for mapping

You can upload an updated version of the file without removing the existing mapping. The objects in the Manage section will be updated automatically.

⚠️ If the column used for mapping has been renamed or deleted, a warning will inform you that the mapping will be cleared.

Where: HOME / <project name> / OBJECTS / Configuration
Where: HOME / <project name> / OBJECTS / Manage