Bug 56856 – Cannot modify user in School Users module after import, if class is in upper case

Bug 56856 - Cannot modify user in School Users module after import, if class is in upper case


Summary:	Cannot modify user in School Users module after import, if class is in upper ...

Status:	NEW

Product:	UCS@school
Classification:	Unclassified
Component:	Import scripts
Version:	unspecified
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	---
Assigned To:	UCS@school maintainers
QA Contact:

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2023-11-21 16:24 CET by Robert Heyer
Modified:	2023-12-11 15:09 CET (History)
CC List:	4 users (show)

See Also:
What kind of report is it?:	Bug Report
What type of bug is this?:	2: Improvement: Would be a product improvement
Who will be affected by this bug?:	2: Will only affect a few installed domains
How will those affected feel about the bug?:	3: A User would likely not purchase the product
User Pain:	0.069
Enterprise Customer affected?:
School Customer affected?:	Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:

Attachments
screenshot1 (29.84 KB, image/png) 2023-11-21 16:24 CET, Robert Heyer	Details
screenshot2 (39.33 KB, image/png) 2023-11-21 16:25 CET, Robert Heyer	Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Robert Heyer

2023-11-21 16:24:34 CET

Importfile with class in upper case

```
Nachname,Vorname,Klasse,record_uid
Musterfrau,Michelle,5D,9878623
```

* Import via UMC
* Result UDM

```
root@pucsxtx001:/usr/share/ucs-school-import/scripts# udm users/user list --filter uid=mmusterfr* | grep groups
  groups: cn=Domain Users rhschule1,cn=groups,ou=rhschule1,dc=qs,dc=schule-sh,dc=de
  groups: cn=schueler-rhschule1,cn=groups,ou=rhschule1,dc=qs,dc=schule-sh,dc=de
  groups: cn=rhschule1-5D,cn=klassen,cn=schueler,cn=groups,ou=rhschule1,dc=qs,dc=schule-sh,dc=de
  primaryGroup: cn=Domain Users rhschule1,cn=groups,ou=rhschule1,dc=qs,dc=schule-sh,dc=de
```

* UDM group property from user in class is in upper case. user object is related to class in lower case.
* In the UMC user school grid you see the mapped upper case class (screenshot1.png), in user details you get a hint that's there is a problem with the class (screenshot2.png).

Comment 1 Robert Heyer

2023-11-21 16:24:56 CET

Created attachment 11148 [details]
screenshot1

Comment 2 Robert Heyer

2023-11-21 16:25:15 CET

Created attachment 11149 [details]
screenshot2

Comment 3 J Leadbetter

2023-11-23 08:30:58 CET

To add more context to the issue:

This problem was found while doing a graphical import via the UMC; however it affects the CLI imports as well (both SiSoPi and regular).

The issue affecting the customer that we have to fix is, after importing the user, is isn't possible to save/modify the user from the School Users module, because the class that is assigned to user doesn't match the available classes in the drop-down due to case sensitivity in the frontend.