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:36] doischert |
tutorial:adm:roles_-_import_data_from_csv [2019/08/05 11:17] doischert |
||
---|---|---|---|
Line 3: | Line 3: | ||
==== 1. Prepare the CSV file ==== | ==== 1. Prepare the CSV file ==== | ||
- | Here is an example of a CSV file which can be used for importing (or updating) roles, setting their role attributes, guarantees (by user, or by role) and criticality | + | Here is an example of a CSV file which can be used for importing (or updating) roles, setting their role attributes, guarantees (by user, or by role) and criticality, for saving them in a created catalogue |
< | < | ||
- | roles; | + | roles; |
- | Manager-A; | + | Manager-A; |
- | LAY-SP; | + | LAY-SP; |
" | " | ||
AB-role"; | AB-role"; | ||
- | 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 18: | Line 21: | ||
The result of this LRT used with this CSV file should: | The result of this LRT used with this CSV file should: | ||
- | * 4 new roles (Manager-A, LAY-SP, CORE-CLOSE, AB-role) | + | * 4 new roles (Manager-A, LAY-SP, CORE-CLOSE, AB-role). |
- | * Manager-A will only have a description set (Leader) | + | * Manager-A will have a description set (Leader) |
+ | * | ||
* LAY-SP will have a description (Manager), attribute (attr1), criticality (3), guarantee by identity (with user-name " | * LAY-SP will have a description (Manager), attribute (attr1), criticality (3), guarantee by identity (with user-name " | ||
* 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. | ||
Line 41: | Line 45: | ||
- 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 |
+ | - 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' | ||
- 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 ; ) |