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/09/17 12:43] doischert |
tutorial:adm:roles_-_import_data_from_csv [2020/05/26 08:53] sourek |
||
---|---|---|---|
Line 6: | Line 6: | ||
< | < | ||
- | roles; | + | roles; |
- | Manager-A; | + | Manager-A; |
- | LAY-SP; | + | LAY-SP; |
" | " | ||
- | AB-role"; | + | AB-role"; |
cat3"; | cat3"; | ||
</ | </ | ||
In Excel, it looks like this: | 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 23: | Line 23: | ||
* 4 new roles < | * 4 new roles < | ||
* < | * < | ||
- | * < | + | * < |
* Roles CORE-CLOSE and AB-role will have a description (desc), an attribute (attr1), and criticality (2) set. They will be in catalogues cat1 and cat3. | * Roles CORE-CLOSE and AB-role will have a description (desc), an attribute (attr1), and criticality (2) set. They will be in catalogues cat1 and cat3. | ||
+ | |||
+ | <note important> | ||
==== Create new LongRunningTask ==== | ==== Create new LongRunningTask ==== | ||
Line 39: | Line 41: | ||
- Import csv file - dropzone to select or drop csv file | - Import csv file - dropzone to select or drop csv file | ||
- Column with roles - name of the column with roles in csv file | - Column with roles - name of the column with roles in csv file | ||
- | - Column with role codes - name of the column with role codes in csv file; if left empty, the role code is based on the role name, only spaces | + | - Column with role codes - name of the column with role codes in csv file; if left empty, the role code is based on the role name, only spaces are replaced by underscores |
- Column with description - name of the column with role description, | - Column with description - name of the column with role description, | ||
- Column with role attributes - name of the column with role attributes, can be also used to update attributes (if your CSV file doesn' | - Column with role attributes - name of the column with role attributes, can be also used to update attributes (if your CSV file doesn' | ||
- Column with criticality - name of the column with role criticality, | - Column with criticality - name of the column with role criticality, | ||
- 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 types - name of the column with role guarantee by identity [[tutorial: | ||
+ | - Update guarantee types - check if you want to add new guarantee type to an existing guarantee (this will create a new guarantee with the selected type, the original one will still exist) (since Extras 2.2.0) | ||
- 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 guarantee role types - name of the column with role guarantee by role [[tutorial: | ||
+ | - Update guarantee role types - check if you want to add new guarantee type to an existing guarantee role (this will create a new guarantee with the selected type, the original one will still exist) (since Extras 2.2.0) | ||
- Column with catalogue names - name of the column with catalogue names, can be also used to update catalogue names (if your CSV file doesn' | - Column with catalogue names - name of the column with catalogue names, can be also used to update catalogue names (if your CSV file doesn' | ||
- Column with subroles to be assigned - name of the column with subordinate roles codes, can be also used to update subordinate roles (if your CSV file doesn' | - Column with subroles to be assigned - name of the column with subordinate roles codes, can be also used to update subordinate roles (if your CSV file doesn' | ||
Line 61: | Line 67: | ||
{{ : | {{ : | ||
{{ : | {{ : | ||
+ | {{ : | ||
==== Run the task ==== | ==== Run the task ==== |