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

This connection enables COMANAGE to automatically match objects in the model with additional information from the CSV file, making it easy to enrich your objects with all data from the CSV 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 CSV file containing your classification data.

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

   → The system will automatically match identical classification codes.

   → You can now display all additional values from the CSV 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 file and click the context menu (three-dot icon).
3. Click Map Data and the dialog shown above will open.
4. Select the CSV 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 CSV file.
7. Click Save and Close.
8. Add other CSV 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 CSV file will appear on your objects.

Mapped data is not editable

Once the mapping is executed, values originating from the CSV 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 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 CSV file used for mapping

You can upload an updated version of the CSV 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