Supporting MAC since version 5.0 Supporting OrgUnits Positions Assignments since version 4.0 Supporting 64 bit Office since version 3.0.
The User Management excel sheet allows a simple import of multiple users into ILIAS, change user data, assign roles and positions (OrgUnits) and more.. Please download newest version below.
How to use
Enter user data of multiple users to insert, update or delete user, assign to roles and courses and much more.
Push button to export data as XML file
Import XML file in ILIAS administration
See comments in titles and table "FAQ" for further infos. Use forum for any questions.
CHANGELOG
v.5.0 - 07. March 2025
MAC support, finally! Should be working with Excel on all kind of apples
Configuration for 'toLogin' function. You may now replace any characters in 'login', as you like
New FAQ table added, with some (hopefully) helpfull information
Delete values in ILIAS using underscore (see FAQ for details)
Fixing local role with colon in title "Local:MyRole@[CourseTitle with: colon]"
Minor logo fix ;-)
("Truncating login and email to length of 50" is fixed in ILIAS Mantis #41714 to length of 255.)
v.4.1
Fix "UTF-16LE" Encoding
v.4.0
Support for OrgUnit Positions (new sheets: Positions, Position-Declaration). (Kudos to Halle School of Health Care gGmbH for co-funding)
New Setting: Add time to filename (User-Declaration, Position-Declaration)
New logos and new "Create XX Import" buttons (Kudos to Emil L.)
Refactoring of some old code: minor tweaks, error handling
v. 3.1
Empty cell in 'language' would set language to "DE". With this fix, system language is set, when inserting and no change to language is applied, when updating.
v. 3 (Sylvester Edition)
Added Office 64-bit Support. So now any version should be working just fine.
Refactoring of "Save XML file" Dialog. Only file type ".xml" is available for export (again).
Added new column "Birthday" (see column comment for details)
Added "oidc" value to AuthMode and a dynamic table for further AuthModes. Just add them to the list in "Declaration"-table
v. 2.6.7:
Bugfix Country/CountrySel.
Salutation (no more 'Gender') with added 'n' (=neutral/no salutation) value.
v. 2.6.6:
Enhanced function password(pwLength, nmbrDigits, nmbrCharacters). Only in ILIAS supported characters are possible: ( A-Z a-z 0-9 _.+?#-*@!$%~/:;)
v. 2.6.5:
Enhanced function password(pwLength, nmbrDigits, nmbrCharacters). Now adding special characters is possible.
Abandoned MD5 encryption for passwords, finally. See Blog for details.
Added new column "Country (ISO)" to set selectable country field (in addition to country as plain text).
Small fix in SaveAsDialog: XML extension should be set by default now.
Some small changes to column descriptions.
v. 2.6.4:
Added new column "AuthMode" (s. column comment or forum for more info, be aware of the bug!!).
Added new column "External Account" (s. column comment for details).
v. 2.6.3:
Added new (missing) column "Unlimited Access" (s. column comment for more info)
v. 2.6.2:
Added new column "Skin-ID" where the ILIAS skin could be set/updated for any user (s. column comment)
v. 2.6.1:
Added notification about abondoned MD5 encryption (table "MD5 Declaration")
See this blog for more details on the extended script UserManagement, on the available features, next steps and everything else you might need to know when using the script
