Spreadsheet Template
A template spreadsheet is available at:
<apriori_install>\ext\group-loader-plugin\templates\
groupCreationTemplate.xls
The template has four sheets:
• groups
• attributes
• permissions
• sheetIndex
Groups sheet
The groups sheet has the following columns:
• action – contains one of three values (must be in upper-case):
o ADD
o MODIFY
o REMOVE
• groupPath – contains the path where the group being modified or deleted can be found. In case of new group creation - this will be the path of the new added group. If group already exist - then import will do nothing (i.e. there will be no duplicates after import).
• newGroupName – contains new group name in case of group modification (applicable only for MODIFY action). If value in this column is not set, then group name will not be changed.
• groupType – contains one of three values (in upper case):
o NONE
o MANUAL
o AUTOMATED
The types will be applied as follows:
o If action=ADD, this value will be the group membership type of the newly created group.
o If action=MODIFY, this value will be the new group membership type (if desired). If this value is not set, the membership type of the group will not be changed.
o If action=REMOVE, this value is not needed: the group to be removed is searched only by its path.
Example:
Attributes Sheet
The attributes sheet has the following columns:
• action – contains one of three values (must be in upper-case):
o ADD – create a new attribute
o MODIFY – edit an existing attribute
o REMOVE – delete an existing attribute
• groupPath – contains the path of the group to which the attribute belongs.
• attributeName – contains the name of the attribute which should be modified or removed. If action=ADD, this value will be the name of the newly created attribute. If the attribute already exists, import will do nothing (i.e., duplicates will not be created).
• attributeType – contains one of three values:
o Boolean
o String
o List
o Double
If action=ADD, this value will be the type of newly created attribute.
If action=MODIFY, this value should contain the exact type of attribute to be found and modified. Note: The attribute type itself cannot be modified.
If action=REMOVE, this value it not needed; the attribute to be removed will be searched by group path and name.
• attributeValue – contains the value of the newly created attribute (when action= ADD), or the new value of the modified attribute (when action=MODIFY).
Double values should contain decimal points. List values should be separated with semicolons.
Example:
Permissions Sheet
The permissions sheet has the following columns:
• action – contains one of two values (must be in upper-case):
o ADD – create a new group permission.
o REMOVE – delete a group permission.
• groupPath – contains the path of the group to which the permission belongs.
• permissionName – contains the name of the permission.
If action=ADD, this value will be the name of the newly added permission. If the permission has been added already, import will do nothing (i.e. duplicates will not be created).
If action=REMOVE, this value is the name of the permission to be removed.
Example:
SheetIndex Sheet
An Excel index sheet for navigating to other sheets. DO NOT EDIT.