o365-moodle icon indicating copy to clipboard operation
o365-moodle copied to clipboard

Published 20 hours ago • verified publisher icon microsoft

Syncing Microsoft 365 Emails With Uppercase Letters - Bulk Update Issues

Open aboarken opened this issue 4 years ago • 4 comments

Hello Everyone,

Please is it possible for O365-Moodle Plugin to change the syncing of Microsoft 365 emails which have uppercase letter to be changed to lowercase since it causing issues while bulk updating Moodle Users using a csv file. I had to update mdl_user table and make all uppercase letters lowercase in order to bulk update users.

Thanks in advance. Below a list of links about same issue:

https://moodle.org/mod/forum/discuss.php?d=363024 https://moodle.org/mod/forum/discuss.php?d=256116 https://moodle.org/mod/forum/discuss.php?d=271717

aboarken avatar Oct 10 '21 14:10 aboarken

Thanks @nenorojas

aboarken avatar Oct 17 '21 11:10 aboarken

+1

It also causes duplicate accounts to be created with the same email but a different casing.

sam-suresh avatar Feb 15 '22 05:02 sam-suresh

Is there any progress on this issue?

gushagelberg2 avatar Feb 22 '22 14:02 gushagelberg2

Hi @aboarken and @sam-suresh,

Could you clarify what the problem here and how duplicate accounts can be created please.

@aboarken, the original reporting of the issue mentions both "CSV user upload" feature in Moodle core and the user sync feature in the Microsoft plugins. Could you please clarify:

  • the nature of your Azure AD users (e.g. their UPN and email letter cases),
  • the nature of your Moodle users (e.g. their username and email, along with letter cases),
  • how the Moodle accounts are created, and
  • how is CSV user upload feature in Moodle core is relevant.

@sam-suresh, could you clarify:

  • How can I reproduce the issue in which duplicate accounts are created.

Thank you. Lai

weilai-irl avatar Feb 23 '22 14:02 weilai-irl