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/06/10 11:00] hanakp [Fill all attributes] |
tutorial:adm:roles_-_import_data_from_csv [2019/08/05 11:17] doischert |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Roles - Import of data from CSV ====== | ====== Roles - Import of data from CSV ====== | ||
- | ==== Prepare CSV file ==== | + | ==== 1. Prepare |
- | Here is an example of CSV file which can be used for import | + | Here is an example of a CSV file which can be used for importing (or updating) |
< | < | ||
- | roles; | + | roles; |
- | Manager;Some role description | + | Manager-A; |
- | " | + | LAY-SP; |
- | PAY-OP | + | "CORE-CLOSE |
- | PAY-SP | + | AB-role"; |
- | PAY-BLL | + | cat3"; |
- | AMT-BLK | + | |
- | ACC-CLOSE";Some roles description | + | |
</ | </ | ||
- | As you can see roles column can be single or multivalued. For multivalued roles, | + | In Excel, it looks like this: |
+ | {{ : | ||
+ | |||
+ | As you can see roles column can contain | ||
+ | CSV file can have optional number of columns: column names are specified in setup of LRT. | ||
+ | |||
+ | The result of this LRT used with this CSV file should: | ||
+ | * 4 new roles (Manager-A, LAY-SP, CORE-CLOSE, AB-role). | ||
+ | * 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 " | ||
+ | * 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. | ||
==== Create new LongRunningTask ==== | ==== Create new LongRunningTask ==== | ||
- | Now we will create the new LongRunningTask(LRT). As shown in the picture, go to Settings → Task scheduler → Scheduled tasks and hit green " | + | Now we will create the new LongRunningTask (LRT). As shown in the picture, go to Settings → Task scheduler → Scheduled tasks and hit green " |
+ | |||
+ | {{ : | ||
==== Fill all attributes ==== | ==== Fill all attributes ==== | ||
Line 28: | Line 39: | ||
- Task type - **ImportRolesFromCSVExecutor** | - Task type - **ImportRolesFromCSVExecutor** | ||
- 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 | + | - Column with roles - Name of the column with roles in csv file |
- | - Column with description - name of the column with role description | + | - Column with description - name of the column with role description, can be also used to update description (if your CSV file doesn' |
- | - Column separator - separator of columns in csv | + | - Column with role attributes - name of the column with role attributes, can be also used to update attributes (if your CSV file doesn' |
- | - Multi value separator - separator of multi value values | + | - Column with criticality - name of the column with role criticality, |
- | - System name - name of the system to connect with roles | + | - 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' |
- | - MemberOf attribute name - ( default: rights ) - name of multi valued attribute for merge | + | - 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' |
- | - Can be requested - ( Boolean ) - Fills can be requested | + | - 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' | ||
+ | - 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 ; ) | ||
+ | - 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 (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; (if you do not want to do that, leave this line empty) | ||
+ | - 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> | ||
+ | |||
+ | < | ||
+ | |||
+ | {{ : | ||
+ | {{ : | ||
- | {{: | ||
==== Run the task ==== | ==== Run the task ==== | ||
- | Now we just need to hit run | + | Now we need to hit run. |
- | You can check status | + | |
+ | {{: | ||
+ | |||
+ | Now we must go to the "all tasks" panel, select the newly created LRT (check the checkbox), click Operation with selected record and Run selected task. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | You can also check the status | ||
+ | |||
+ | At this point, everything should be set up and when the task ends, roles are imported in IdM with their attributes and other imported values, and placed in the catalogue named by the system name. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ==== Known issues ==== | ||
+ | |||
+ | If you delete or upload new file via dropzone, you should delete old files, created from previous uploads. |