Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
tutorial:adm:roles_-_import_data_from_csv [2019/06/12 14:15] hanakp |
tutorial:adm:roles_-_import_data_from_csv [2019/07/09 06:44] doischert |
||
---|---|---|---|
Line 7: | Line 7: | ||
==== 1b. Prepare CSV file ==== | ==== 1b. Prepare CSV file ==== | ||
- | Here is an example of CSV file which can be used for import | + | Here is an example of CSV file which can be used for importing (or updating) |
< | < | ||
- | roles; | + | roles; |
- | Manager;Some role description | + | Manager-A;Leader; |
- | " | + | LAY-SP; |
- | PAY-OP | + | "CORE-CLOSE |
- | PAY-SP | + | AB-role";desc;attr1 |
- | PAY-BLL | + | |
- | AMT-BLK | + | |
- | ACC-CLOSE";Some roles description | + | |
</ | </ | ||
- | As you can see roles column can be single or multivalued. For multivalued roles, description from the same row will be added to every role. | + | As you can see roles column can contain |
- | CSV file can have optional number of columns, role and description columns are specified in setup of LRT. | + | CSV file can have optional number of columns, role, description, and attribute |
==== 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 35: | Line 32: | ||
- 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 description - name of the column with role description, | - Column with description - name of the column with role description, | ||
- | - Column separator - separator of columns in csv file | + | - Column with attributes - name of the column with role attributes, can be also used to update attributes |
- | - Multi value separator - ( Char, default: new line ) separator of multi valued role names in csv file, new line separator is default export from excel, but for better clarity of csv file, it's recommended to use some symbol instead | + | - Form definition code - the code for the definition which will contain the added 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 csv file, it's recommended to use some symbol instead | ||
- System name - name of the system to connect with roles | - System name - name of the system to connect with roles | ||
- MemberOf attribute name - ( default: rights ) - name of multi valued attribute for merge, attribute named " | - MemberOf attribute name - ( default: rights ) - name of multi valued attribute for merge, attribute named " | ||
- Can be requested - ( Boolean ) - Fills can be requested, can be also used to update already imported settings | - Can be requested - ( Boolean ) - Fills can be requested, can be also used to update already imported settings | ||
+ | |||
+ | <note important> | ||
{{: | {{: | ||
Line 48: | Line 49: | ||
{{: | {{: | ||
- | And we also need to process it in all tasks. | ||
{{: | {{: | ||
- | You can check status | + | You can check the status |
- | Everything | + | At this point, everything |
==== Known issues ==== | ==== Known issues ==== |