Update DataverseNO affiliations file

[philippconzett]

Task:
@4tikhonov @Louis-wr An updated version of the DataverseNO affiliation file (dvnoaffiliations.tsv or dvnoaffiliations.txt) needs to be uploaded to dataverse.no, demo.dataverse.no, and test.dataverse.no. The files can be found in Teams >> Shiboleth >> Files.

Question:
How does the trigger solution differentiate between email addresses that have identical last parts?

Easy case:
@Student.uio.no
@sv.uio.no
@Student.uio.no

They are all addresses from the same organisation (UiO) and should all be assigned to the uio.no user group.

Tricky case:
@norsus.no
@sus.no

They are addresses from two different organisations (Norsus and SUS). @norsus.no needs to be assigned to the norsus.no user group, whereas @sus.no needs to be assigned to the sus.no user group.

[Louis-wr]

location :
/distrib/private/affiliations.csv
/root/distrib/5.8/dataverse-docker/affiliation2data.py
vi /root/distrib/5.8/dataverse-docker/affiliations.sql

[Louis-wr]

https://teams.microsoft.com/l/message/19:915be9eca31e403782525e00dee4c408@thread.tacv2/1643373296092?tenantId=4e7f212d-74db-4563-a57b-8ae44ed05526&groupId=76666a69-927e-472f-9332-7e94bdd03b5c&parentMessageId=1643282517080&teamName=O365-UiT-DvNO-cloud-deployment&channelName=Shibboleth&createdTime=1643373296092

Script to produce affiliation SQL /root/distrib/5.8/dataverse-docker/affiliation2data.py

[philippconzett]

Question: How is this issue resolved?

[philippconzett]

Has been solved; cf.
https://github.com/DataverseNO/dataverse-docker/tree/dataverse.no/distros/dataverse.no/init.d/affiliations