Import Conflict Management

The following conflict management strategies are applied when importing objects:

• Attributes that are not defined in the Excel file respectively not defined in the XML file are not changed by the Excel import.

• Simple attribute values will be overwritten with the values from the Excel file (even if the Excel file contains empty values).

• The values of date attributes will be overwritten if the Excel file contains valid data. The values will be removed if the date cell in the Excel file is empty.

• If the parameter strategy is set to overwrite, relations will be overwritten with the values from the Excel file:

  • New relations will be created.

  • Relations which are not present in the Excel file will be removed.

  • If the relation cell is empty, then all the relations of the configured type will be removed from the object.

  If the parameter strategy is set to add, existing relations will not be removed. New relations will be created.

• Handling of referenced objects when creating relations:

  • If the referenced object exists in the repository, the relation will be created.

  • If the referenced object exists in the Excel file, the referenced object and the relation will be created

  • If the referenced object neither exists in the Excel file nor in the repository, the relation will not be created.

  • If the referenced object exists in the Excel file, but could not be created, the relation will not be created.

  • If it is unclear which object should be referenced because there are multiple potential targets, the relation will not be created.