Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
tutorial:adm:virtual_system_-_adding_or_deleting_managed_extended_attributes [2019/06/19 13:18] doischert [Step 3: modify scheme and mapping] |
tutorial:adm:virtual_system_-_adding_or_deleting_managed_extended_attributes [2020/03/03 13:14] poulm minor typos |
||
---|---|---|---|
Line 16: | Line 16: | ||
{{ : | {{ : | ||
- | ===== Step 2: add the attribute to configuration ===== | + | ===== Step 2: add the attribute to VS configuration ===== |
Click Virtual systems in the left panel and select List. Open you virtual system and select Configuration. Add your attribute (building) to the list of attributes and click on save. | Click Virtual systems in the left panel and select List. Open you virtual system and select Configuration. Add your attribute (building) to the list of attributes and click on save. | ||
Line 57: | Line 57: | ||
If you want to stop provisioning an attribute which is present in other systems you have to do even fewer changes. This can be relevant in the above mentioned phone number case. In this case, undo only steps 2 and 3. | If you want to stop provisioning an attribute which is present in other systems you have to do even fewer changes. This can be relevant in the above mentioned phone number case. In this case, undo only steps 2 and 3. | ||
+ | |||
+ | <note tip> | ||
+ | If you want to remove an attribute from a virtual system which was already used, so it has existing virtual accounts with this attribute filled, you have to remove the values of the accounts' | ||
+ | </ | ||
First, remove the mapping of the attribute. Click Virtual systems, List, Mapping, and Provisioning. Check the checkbox next to the attribute you want to remove. Above the list, a new dialog should appear, Operation with selected record. Click and choose Remove. Click Yes. | First, remove the mapping of the attribute. Click Virtual systems, List, Mapping, and Provisioning. Check the checkbox next to the attribute you want to remove. Above the list, a new dialog should appear, Operation with selected record. Click and choose Remove. Click Yes. | ||
Line 77: | Line 81: | ||
{{ : | {{ : | ||
+ | |||
+ | If this operation fails with the message that there are already some values, you must go to the IdM database and delete those values by SQL. It's strongly recommended to make a backup of the database prior to this action. | ||
+ | |||
+ | <code sql> | ||
+ | -- Check the values you are about to delete - change the code of your attribute and your system name -- | ||
+ | SELECT * FROM vs_account_form_value WHERE attribute_id IN (SELECT id FROM idm_form_attribute WHERE code=' | ||
+ | |||
+ | -- Delete the values | ||
+ | DELETE FROM vs_account_form_value WHERE attribute_id IN (SELECT id FROM idm_form_attribute WHERE code=' | ||
+ | </ | ||
+ | |||
+ | Then you can remove the attribute from the Form Attributes as written above. | ||
The attribute is still present in the detail of the user; however, it is no longer connected to the virtual system and the implementer will not be notified when the attribute' | The attribute is still present in the detail of the user; however, it is no longer connected to the virtual system and the implementer will not be notified when the attribute' |