This feature lets you upload a CSV file and generate properties directly from the file’s columns.

This allows you to seamlessly import all data from the CSV file into COMANAGE, making it easy to assign values to your objects.

Be sure the CSV file meet the following requirements

1. A column containing unique values must be placed on the far left.
2. Every column in the table must have a header.
3. All column headers must be distinct (i.e. no duplicate names).
4. The separator has to be semicolon (';')

Adding properties from a CSV file

1. Go to Configuration.
2. Click Add External Data on the External Data card.
3. Select a CSV file from your PC and save.
4. Now go to the Properties card and click Add Property.
5. Select External Data.
6. Select both Type and Instance if you want the CSV values to be shown on both types and instances in the object table. 
7. In the External Source drop down, select the CSV file that you just added.
8. In the Column drop down, select one of the columns from the CSV file.
9. Click Add (now repeat point 7 and 8 to add more columns from the CSV file).

Adding data from a CSV file to your objects

1. Go to Manage and add your properties to the object table.
2. When editing a cell in one of these columns, a dropdown menu will appear, displaying all the correlated columns derived from the same CSV file.
3. Select a value from the dropdown, and all the correlated cells in the object table will be automatically filled out.

Updating the CSV file

1. Go to Configuration.
2. On the External Data card, edit the row of the External Data you wish to update.
3. Click upload (arrow-up icon) to select a new version of the CSV file.

✅ Only the values in the CSV file have been updated: The updated values will automatically overwrite the existing ones in the object table.

✅ A column in the CSV file has been removed or renamed: You will receive a warning indicating that columns linked to properties have been moved. If an External Data property is based on the removed column, the property will be converted to an Input property.

❌ The column on the far left has been removed or renamed: You will receive a notification stating that the ID column of the file must not be removed or renamed. The updated CSV file cannot be uploaded.

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