Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
tutorial:adm:roles_-_import_data_from_csv [2019/07/18 08:49]
doischert 		tutorial:adm:roles_-_import_data_from_csv [2019/08/01 06:52]
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 and for saving them in a created catalogue. To use this CSV file, create a new identity with user name "user_login", and a new role with code "role_code".+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 and for assigning their subordinate role. To use this CSV file, create a new identity with user name "user_login", and a new role with code "role_code".
  
 <code> <code>
-roles;description;attribute;guarantees;guarantee role;criticality;catalogue +roles;description;attribute;guarantees;guarantee role;criticality;catalogue;subroles 
-Manager-A;Leader;;;;; +Manager-A;Leader;;;;;;role_code 
-LAY-SP;Manager;attr1;user-login;role_code;3;cat4+LAY-SP;Manager;attr1;user-login;role_code;3;cat4;
 "CORE-CLOSE "CORE-CLOSE
 AB-role";desc;attr1;;;2;"cat1 AB-role";desc;attr1;;;2;"cat1
-cat3"+cat3";
 </code> </code>
  
Line 22: Line 22:
 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) and a subrole set (role_code).
   * LAY-SP will have a description (Manager), attribute (attr1), criticality (3), guarantee by identity (with user-name "user-login"), and guarantee by role (with role-code "role_code") set. It will be saved in catalogue cat4.   * LAY-SP will have a description (Manager), attribute (attr1), criticality (3), guarantee by identity (with user-name "user-login"), and guarantee by role (with role-code "role_code") set. It will be saved in catalogue cat4.
   * 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 45: Line 45:
 - 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't contain role guarantees, i.e., you are not setting role guarantees for any of your roles, leave this line empty) - 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't contain role guarantees, i.e., you are not setting role guarantees for any of your roles, leave this line empty)
 - Column with catalogue names - name of the column with catalogue names, can be also used to update catalogue names (if your CSV file doesn't contain catalogue names, i.e., you are not setting catalogues for any of your roles, leave this line empty) - Column with catalogue names - name of the column with catalogue names, can be also used to update catalogue names (if your CSV file doesn't contain catalogue names, i.e., you are not setting catalogues for any of your roles, leave this line empty)
 +- 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't contain subordinate roles codes, i.e., you are not setting subordinate roles for any of your roles, leave this line empty)
 - 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 ; )
  • by apeterova