User Import Script Community

Excel based import of multiple users into ILIAS • Download and community exchange

Tabs

About the Excel User Import Script
Supporting 64 bit Office since version 3.0, see changelog below.
The following excel sheet allows a simple import of multiple users into ILIAS.
  1. Enter user data of multiple users to insert, update or delete user, assign to roles and courses and much more.
  2. Push button to export data in XML file
  3. Import XML file in ILIAS
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")
ToDo's:
  • Adding OrgUnits Import
  • Adding import for assignment of users to OrgUnits Positions
  • Fixing "limited access" time
  • Fixing "SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'import_id' at row 1" (object_data.import_id is limited to 50 characters).
  • Don't ask for Mac Support, unless you have a spare Mac with MSOffice on it. If you do, be my guest. :-)
There is also a LibreOffice Version, kindly provided by a (former) forum user. Use at your own risk.

Content

File

UserManagement_31

by Stanislav Wischniak, Qualitus GmbH (based on the script by Werner Randelshofer / Peter Hofer, HS Luzern)
xlsm   318.39 KB   Version: 7   7. Mar 2023, 19:28  
8   
Blog

Extended User Import Script

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
Forum

Forum: User Import Script

Use this forum for questions and comments on the use, the development or anything else regarding the User Import Script
Articles: 269  
Latest Article: Ich habe gerade eben einen Insert mit... from ILIAS_LM, 14. Jun 2024, 07:43