Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
tutorial:adm:roles_-_import_data_from_csv [2019/07/17 06:32] doischert |
tutorial:adm:roles_-_import_data_from_csv [2019/07/18 08:49] doischert |
||
---|---|---|---|
Line 13: | Line 13: | ||
cat3" | cat3" | ||
</ | </ | ||
+ | |||
+ | In Excel, it looks like this: | ||
+ | {{ : | ||
As you can see roles column can contain single or multiple values (separated by a line; the separator can be specified in the settings of the LRT). For multivalued roles, values from the same row will be added to every role. The only exception here is role criticality which cannot be multivalued. | As you can see roles column can contain single or multiple values (separated by a line; the separator can be specified in the settings of the LRT). For multivalued roles, values from the same row will be added to every role. The only exception here is role criticality which cannot be multivalued. | ||
Line 41: | Line 44: | ||
- Column with guarantee - name of the column with role guarantee by identity login, can be also used to update guarantee (if your CSV file doesn' | - Column with guarantee - name of the column with role guarantee by identity login, can be also used to update guarantee (if your CSV file doesn' | ||
- Column with guarantee role - name of the column with role guarantee by role code, can be also used to update role guarantee (if your CSV file doesn' | - Column with guarantee role - name of the column with role guarantee by role code, can be also used to update role guarantee (if your CSV file doesn' | ||
- | - Column with catalogue names - name of the column with catalogue names, can be also used to update | + | - Column with catalogue names - name of the column with catalogue names, can be also used to update |
- Form definition code - the code for the definition which will contain the added attributes (you only have to fill this if you are setting attributes) | - Form definition code - the code for the definition which will contain the added attributes (you only have to fill this if you are setting attributes) | ||
- Column separator - separator of columns in csv file (default ; ) | - Column separator - separator of columns in csv file (default ; ) | ||
- Multi value separator - (Char, default: new line) separator of multi valued role names in the csv file, new line separator is default export from excel, but for better clarity of the csv file, it's recommended to use some symbol instead | - Multi value separator - (Char, default: new line) separator of multi valued role names in the csv file, new line separator is default export from excel, but for better clarity of the csv file, it's recommended to use some symbol instead | ||
- | - System name - name of the system to connect with roles; optional | + | - System name - name of the system to connect with roles (if you do not want to connect your roles to any system, leave this line empty) |
- | - MemberOf attribute name - name of multi valued attribute for merge; | + | - MemberOf attribute name - name of multi valued attribute for merge; |
- | - Can be requested - (Boolean) - Roles can be requested, can be also used to update already imported settings; it allows not selecting value when updating (not when creating!) roles which will not change the can be requested property of roles. | + | - Can be requested - (Boolean) - Roles can be requested, can be also used to update already imported settings; it allows not selecting value when updating (not when creating!) roles which will not change the Can be requested property of roles. When creating roles, either Yes or No must be selected. |
<note important> | <note important> |