Bug 37813 - CSV export of password reset job
CSV export of password reset job
Status: RESOLVED WONTFIX
Product: UCS@school
Classification: Unclassified
Component: UMC - Password reset
UCS@school 3.2 R2
Other Linux
: P5 enhancement (vote)
: ---
Assigned To: UCS@school maintainers
:
Depends on:
Blocks: 49670
  Show dependency treegraph
 
Reported: 2015-02-16 15:51 CET by Jan Christoph Ebersbach
Modified: 2019-06-18 09:51 CEST (History)
5 users (show)

See Also:
What kind of report is it?: Feature Request
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?: Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional): Roadmap discussion
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Christoph Ebersbach univentionstaff 2015-02-16 15:51:21 CET
A customer requested the functionality to print usernames and passwords from the password reset dialogue.
Comment 1 Florian Best univentionstaff 2015-02-16 16:15:03 CET
What exactly do you mean?
To not show them as '****' ?
Comment 2 Jan Christoph Ebersbach univentionstaff 2015-02-16 16:16:51 CET
The request is to print the password as well.  This makes even more sense when random passwords could be assigned.
Comment 3 Florian Best univentionstaff 2016-09-21 16:25:19 CEST
I still don't get what this bug entry is about.
Where do you want to print the passwords?
In the "Reset Password (students)" UMC module (which is the tagged component) the passwords are already shown in plaintext.

What do you mean with "print"? Like with a real printer (hardware) or showing them somewhere?
Comment 4 Jan Christoph Ebersbach univentionstaff 2016-09-21 17:06:59 CEST
Yes, a real printer is involved.  The question is: how do students get hold of their credentials?  Currently, the most likely was is that either the teacher prints the UMC page or looks up each individual username.  Even if the teacher sets the password to a common value like "univention", students don't know their username in the first place.

It's about printing the list of accounts with their passwords in order to distribute it to the students so that they can find their credentials and log in.
Comment 5 Sönke Schwardt-Krummrich univentionstaff 2016-11-01 10:33:05 CET
2 other customers also requested a feature like this.

Depending on the use case, the customers want to hand out paper lists to teachers with usernames, first names and last names. Sometimes with, sometimes without passwords.
Possible use cases:
a) create a handout for the teacher of a class (one sheet of paper with all information)
b) create a handout for students (one sheet or part of one sheet for each student with all neccessary information of his/her new account; mainly used for new classes)
Comment 6 Jan Christoph Ebersbach univentionstaff 2016-12-08 11:38:17 CET
Requested by another customer.
Comment 7 Sönke Schwardt-Krummrich univentionstaff 2016-12-09 09:28:40 CET
(In reply to Jan Christoph Ebersbach from comment #6)
> Requested by another customer.
Correction: this was a second school of the same school district customer.
Comment 8 Michel Smidt 2017-01-20 10:13:13 CET
As discussed with Jan Christoph I add the request to this bug as it is strongly related.

Requested by the sales team of a partner.
They are sure this will support their attempts to argue pro paedML Linux.
The competitive product paedML Windows has a simple possibility to somehow generate tables for teachers from the directory.

Use case for teachers.
1. They need class overviews all the time during the lesson. E.g. to check that pupils all have made his homework or to group pupils for tasks during the lesson.
2. This overview must be a UMC module and should have the possibility to (de-)select classes and (de-)select attributes (e.g. Firstname, Lastname, Username, Class). The set of possible attributes could be configurable by the schooladmin.
3. It is perfectly fine for the teachers to copy+paste this grid to a excel sheet and rearrange, modify or print the data.

So, it would be perfectly fine for the the teachers to extend the grid of the "password reset" module for the use case.
Comment 9 Daniel Tröder univentionstaff 2018-08-07 11:42:48 CEST
(In reply to Michel Smidt from comment #8)
> As discussed with Jan Christoph I add the request to this bug as it is
> strongly related.
> 
> Requested by the sales team of a partner.
> They are sure this will support their attempts to argue pro paedML Linux.
> The competitive product paedML Windows has a simple possibility to somehow
> generate tables for teachers from the directory.
> 
> Use case for teachers.
> 1. They need class overviews all the time during the lesson. E.g. to check
> that pupils all have made his homework or to group pupils for tasks during
> the lesson.
> 2. This overview must be a UMC module and should have the possibility to
> (de-)select classes and (de-)select attributes (e.g. Firstname, Lastname,
> Username, Class). The set of possible attributes could be configurable by
> the schooladmin.
> 3. It is perfectly fine for the teachers to copy+paste this grid to a excel
> sheet and rearrange, modify or print the data.
> 
> So, it would be perfectly fine for the the teachers to extend the grid of
> the "password reset" module for the use case.
This has been implemented in Bug #47017.
Comment 10 Daniel Tröder univentionstaff 2018-08-07 11:47:34 CEST
Add a button to the password reset module that allows to reset the selected users passwords (like the existing one) and afterwards export a CSV file containing the list of users with the freshly set passwords.
Ask ProfS what user attributes the CSV file should contain, besides username and password. I propose: [firstname, lastname, username, password, school_classes (with school names if more than 1)].
Comment 11 Sönke Schwardt-Krummrich univentionstaff 2019-02-05 21:49:56 CET
This issue has been filled against UCS@school 3. The maintenance with
bug and security fixes for the last UCS@school version for UCS 3.x 
(→ UCS@school 3.2) has ended on Dec 31, 2016.

Customers still on UCS 3.x are encouraged to update to UCS 4.3 (or later). 
Please contact your partner or Univention for any questions.

If this issue still occurs in newer UCS versions, please use "Clone this bug"
or simply reopen the issue. In this case please provide detailed information on
how this issue is affecting you.