Import file structure of a complex relation
You can define multiple relations with the same role.
The different assets to relate to are formatted as a comma-separated list in a single cell.
This means that:
- For every role in the complex relation type, you have to specify the Asset column. Fill in a comma-separated list of the asset names to connect to the complex relation with that role. If there is an asset in the import file that does not exist, it is created automatically.
- If an asset name contains a comma, you can use double quotes around the asset names to ignore the comma as a separator.
For example, to refer to an asset named last name, first name, the name has to be written as "last name, first name". - If your asset names have commas as well as double quotes, you can change the standard behavior of the double quote by using a backslash (\).
For example, to refer to an asset called last name "," first name, the name has to be written as "last name \",\" first name". - If you specify the domain names for mapped assets, you also have to use a comma-separated list in the Domain column, even if the domain is the same for all the assets.
- If you have to specify the domain and community for the relation assets as well, it is important that the size and order of the comma-separated lists for all three aspects (asset name, domain, community) is the same.
- If the referred assets are not all in the current domain, you can specify one or more domains to search in, by mapping the Domain characteristic to a column containing a comma-separated list of domain names. If there is a domain in the import file that does not exist, it is created automatically.
-
If the referred domains are not all in the current community, you can specify one or more communities to search in, by mapping the Community characteristic to a column containing a comma-separated list of community names.