Univention Bugzilla – Bug 36450
The string length of Windows and CSV import are not compatible.
Last modified: 2015-02-27 15:18:36 CET
The string length of Windows (max. 20) and CSV import (unlimited) are not compatible. The user name is not truncated after 20 characters . A suggestion would be that a warning message is displayed with the following content. 'The user name contains more than 20 characters.'
This issue has been reported by another customer. The generated username is too long for Samba which silently leads to problems in the S4 connector. An even better solution would be if the import would try to suggest different usernames that don't exceed 20 characters.
Considering the exam mode, usernames shouldn't be longer than 20 - len(ucr get ucsschool/ldap/default/userprefix/exam) → 15 characters by default!
Created attachment 6467 [details] Manual
Created attachment 6468 [details] Data import "Business"
Created attachment 6469 [details] Data import "School"
LMZ created a sophisticated workaround for this and other issues with the CSV import. See attached files.
A check should be added that usernames cannot be longer than (20 - len(ucr get ucsschool/ldap/default/userprefix/exam)) characters. The CSV import should show an error (red cell) if a username is longer. Please also add a changelog entry to ucs-school-3.2r2/doc/changelog/release-notes-ucsschool-3.2R2v4-de.xml (maybe this file does not exist yet).
The CSV import module and the users wizard now check the length of usernames. The username may not be longer than (20 - len(ucr get ucsschool/ldap/default/userprefix/exam)) characters. Otherwise the CSV import module marks the cell in red. The users wizard shows an exclamation mark and a corresponding tooltip message. The error messages also mention the maximum allowed username length, that is calculated depending on the UCR variable ucsschool/ldap/default/userprefix/exam. By default, the UCR variable is empty and the prefix "exam-" is used. ucs-school-umc-wizards (4.0.32-1) unstable; urgency=low r58009 | Bug #36450: limit length of usernames to prevent windows logon errors Changelog entry has been made. Package has been rebuilt.
As discussed with Stefan, the "error" message (red) should be rather a "warning" (yellow).
The username length is now enforced within the "Students (Schools)" wizards. By setting ucsschool/ldap/check/username/lengthlimit=false the limitation can be disabled. r58328 | Bug #36450: added UCR variable to disable length limit of usernames: ucsschool/ldap/check/username/lengthlimit r58327 | Bug #36450: show warning if max length of usernames is exceeded to prevent problems with windows logons r58009 | Bug #36450: limit length of usernames to prevent windows logon errors ucs-school-umc-csv-import (1.0.27-1) unstable; urgency=medium ucs-school-umc-wizards (4.0.33-1) unstable; urgency=low Please test both UMC modules. And also the 3 states of the new UCR variable (undefined, true, false).
Fix: OK (In reply to Sönke Schwardt-Krummrich from comment #7) > Please also add a changelog entry to > ucs-school-3.2r2/doc/changelog/release-notes-ucsschool-3.2R2v4-de.xml > (maybe this file does not exist yet). REOPEN: "will be highlighted with a »red« cell background" REOPEN: "the CSV import module restricts" → is restrict the right word as this is now optional.
(In reply to Florian Best from comment #11) > Fix: OK > > (In reply to Sönke Schwardt-Krummrich from comment #7) > > Please also add a changelog entry to > > ucs-school-3.2r2/doc/changelog/release-notes-ucsschool-3.2R2v4-de.xml > > (maybe this file does not exist yet). > REOPEN: "will be highlighted with a »red« cell background" > REOPEN: "the CSV import module restricts" → is restrict the right word as > this is now optional. fixed XML changelog
Fix: OK Changlog: OK (fix typo svn r58380)
UCS@school 3.2 R2 v3 has been released: http://docs.univention.de/release-notes-ucsschool-3.2R2v3-de.html If this error occurs again, please use "Clone This Bug".