Introduction
As a user with the sysadmin role you can bulk import groups and subgroups using an Excel spreadsheet.
 | Available from 2.0.5
This functionality is only available in LAMS 2 from version 2.0.5 onwards. |
Creating Groups and Subgroups
To do this, use the groups template spreadsheet (lams_groups_template.xls). You can also download it from LAMS' Import Groups screen. It contains 7 columns, only 1 of which is mandatory (the name of the group/subgroup).
In the example in the screenshot, a group called 'Computing Department' will be created, which has 2 subgroups, 'Intro to Computing' and 'Database Systems'. A second group 'Maths Faculty' will also be created with 1 subgroup, 'Discrete Mathematics'.
 | Important!
When intending to create a new group, make sure the row above doesn't contain another entry - otherwise it will be created as a subgroup. |
Here is a description of each of the columns:
| Column |
Description |
| name (250) |
Mandatory. The name of the group/subgroup. Limited to 255 characters. |
| code (20) |
Code name of the group of course, e.g. COMP1011 |
| description |
Description of the group or subgroup. |
| locale_id |
The identifier number of the locale for this group. Comes from lams_supported_locale table. Defaults to system default locale. |
| admin_add_new_users |
Boolean value, use '1' or 'true'. Defaults to false. |
| admin_browse_all_users |
Boolean value, use '1' or 'true'. Defaults to false. |
| admin_change_status |
Boolean value, use '1' or 'true'. Defaults to false. |
