search

microsoft / o365-moodle

Office 365 and Azure Active Directory plugins for Moodle
GNU General Public License v3.0
184 stars 138 forks source link

Recreating 365Group\Teams site after 30 days hard delete - but teams course record still in [mdl_local_o365_objects] table #2019

Closed geobuc1 closed 2 years ago

geobuc1 commented 2 years ago

Not sure where to ask this question (of if even appropriate on Github), as not strictly an issue more of an unknown. Forgive me as I have just been asked to look into this as previous developer\admin has left suddenly. $plugin->release = '3.9.0';$plugin->version = 2020071500; Moodle version 3.9. Situation where a Teams site that was created via Moodle To teams integration but has been hard deleted (over 30 days ago) before teachers flagged so cannot restore via 365 admin .

However, within the [mdl_local_o365_objects] tbl where (type = 'group') the course team record still exists (subtype= course; courseteam) but no 365 group or Teams site. I am unsure of how to recreate i.e. recreate the linked site this if already exists in [dbo].[mdl_local_o365_objects] table? I going to hazard a guess than absolutely not as straightforward as deleting from the is table. Any advice would be greatly appreciated (or pointing me in the right direction would be greatly appreciated) Thanks in advance.

weilai-irl commented 2 years ago

Hi @geobuc1,

Sorry for not getting back to you sooner. We have been busy with the latest release of the plugins.

In short, the easiest option is to delete the connection record of the course from the mdl_local_o365_objects table, and let the next course sync scheduled task run (\local\o365\groupcreate) to create a new group/team. You can use SQL statement such as this one: DELETE FROM mdl_local_o365_objects WHERE type = 'group' AND moodleid = COURSE_ID;

Please post back if this answers your question.

Regards, Lai

geobuc1 commented 2 years ago

Hi Lai,

No need to apologise as I can fully appreciate how busy you are! Thank you for the reply. This worked and solved my problem. 365 group\Team recreated on the next cron run.

Many thanks for your help and good luck with the latest release of plugins.

Regards

George

On Fri, Apr 8, 2022 at 2:34 PM Lai Wei @.***> wrote:

Hi @geobuc1 https://github.com/geobuc1,

Sorry for not getting back to you sooner. We have been busy with the latest release of the plugins.

In short, the easiest option is to delete the connection record of the course from the mdl_local_o365_objects table, and let the next course sync scheduled task run (\local\o365\groupcreate) to create a new group/team. You can use SQL statement such as this one: DELETE FROM mdl_local_o365_objects WHERE type = 'group' AND moodleid = COURSE_ID;

Please post back if this answers your question.

Regards, Lai

— Reply to this email directly, view it on GitHub https://github.com/microsoft/o365-moodle/issues/2019#issuecomment-1092866877, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD7ESE4HWM27C6CSGY3SAATVEAYWHANCNFSM5SBVY4JQ . You are receiving this because you were mentioned.Message ID: @.***>