|
|
| (22 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| [[File:AdminServer Esas.jpg|none|thumb|656x656px]]
| | === Requirements === |
| ====Certificate file====
| | Minimum Windows 2019 |
| The certificate used to access esas webservices.
| |
|
| |
|
| [https://www.nets.eu/dk-da/kundeservice/medarbejdersignatur/oevrige-signaturer/Pages/bestil-funktionssignatur.aspx How to order function certificate]
| | Users must have work mail. |
|
| |
|
| [https://confluence.umit.dk/display/esasdokumentation/Import+af+certifikater How to Certificates]
| | === Recommandations === |
| | It could be good idea to make sure the Administrators are not a part of the synchronization. Leave them out be entering their usernames in the SQL sentence. |
|
| |
|
| ====Certificate password==== | | Or create a new user with a unique mail address to have as a backup if your automatic user is somehow disabled. |
| | |
| | StudieNr Not In ('Username') |
| | === How to get MitID Erhverv customer account === |
| | https://mitid-erhverv.dk/[[File:AdminServer MitID Erhverv.jpg|none|thumb|765x765px]] |
| | |
| | ===[[AdminServers/Export Settings|Export settings]]=== |
| | |
| | ===Certificate file=== |
| | The certificate used to access the webservices. |
| | |
| | ====How to order test certificate==== |
| | Creating new certificate: |
| | |
| | ===== Expand "Systemrettigheder (frivilligt) Trin 2 af 4" ===== |
| | If this step is not shown, then you need to perform these steps. (Could take a couple of days before a return answer) |
| | |
| | * https://mitid-erhverv.dk/avanceret/lokal-idm/ |
| | ** Write a mail and ask for |
| | **# Lokal IdM light |
| | |
| | [[File:AdminServer MitID Erhverv IDM Light.jpg|none|thumb]] |
| | |
| | check "'''Adgang til IdM services i MitID Erhverv'''" |
| | |
| | See picture below for example |
| | |
| | Or |
| | |
| | *"Typer af cerfikater" |
| | **Oces organisationscertifikat |
| | *"Metode til identifikation" |
| | **Bruger-login |
| | *"Ja, gå direkte til udstedelse efter bestilling" |
| | **Check this |
| | *"Metode til udstedelse" |
| | **Internetbrowser |
| | |
| | <br /> |
| | [[File:MitId Erhverv Order certificate picture.jpg|none|thumb|1102x1102px]] |
| | |
| | ===Certificate password=== |
| Password for the certificate file. | | Password for the certificate file. |
|
| |
|
| ===Username=== | | This will be given to you when you login after completing the order. |
| Username to access webservices.
| | |
| | ==FAQ== |
| | |
| | ===Test enviroment setup=== |
|
| |
|
| This information in given by [https://ufm.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas]
| | ====Create==== |
| ===Password===
| | https://www.nemlog-in.dk/vejledningertiltestmiljo/forside/vejledning-til-tjenesteudbydere-tilslut-jeres-tjeneste-til-test-miljoet/ |
| Password to access webservices.
| |
|
| |
|
| This information in given by [https://ufm.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas]
| | ====Login URL's==== |
| ===[[AdminServers/Export Settings|Export settings]]=== | | https://erhvervsadministration.devtest4-nemlog-in.dk/login?returnUrl=%2Fusers |
| | |
| | https://administration.devtest4-nemlog-in.dk/ |
| | |
| | ====Log viewer Only for SSO and logins:==== |
| | https://www.nemlog-in.dk/media/q2wicxi3/nemlog-in2-log-viewer.pdf |
| | |
| | https://logviewer.test-nemlog-in.dk/ |
|
| |
|
| ===Data mapping=== | | ==== Other documentation ==== |
| {| class="wikitable"
| | https://migrering.nemlog-in.dk/mitid-erhverv/test-og-dokumentation/ |
| |+
| |
| Students
| |
| !Admin system
| |
| !UMS
| |
| !Remarks
| |
| |-
| |
| |esas_personid
| |
| |UMS_IDFromAdministrativeSystem
| |
| |
| |
| |-
| |
| |ContactId
| |
| |IDFromAdministrativeSystem
| |
| |
| |
| |-
| |
| |FirstName + MiddleName
| |
| |Fornavn
| |
| |If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
| |
| |-
| |
| |LastName
| |
| |EFTERNAVN
| |
| |If esas_navne_addressebeskyttet = true then use esas_kaldenavn from Personoplysning
| |
| |-
| |
| |esas_lokalt_studienummer
| |
| |StudieNr
| |
| |
| |
| |-
| |
| |esas_cpr_nummer_uden_formatering
| |
| |CPR
| |
| |
| |
| |-
| |
| |BirthDate
| |
| |BirthDay
| |
| |
| |
| |-
| |
| |FirstName + MiddleName
| |
| |PublicRegisteredFirstName
| |
| |
| |
| |-
| |
| |LastName
| |
| |PublicRegisteredSurName
| |
| |
| |
| |-
| |
| |esas_postnummer
| |
| |Postnummer
| |
| |
| |
| |-
| |
| |esas_by
| |
| |City
| |
| |
| |
| |-
| |
| |esas_kommune_id
| |
| |Sted
| |
| |
| |
| |-
| |
| |Address1_Line1
| |
| |Adresse
| |
| |
| |
| |-
| |
| |esas_privatemail
| |
| |PrivateMail
| |
| |
| |
| |-
| |
| |esas_mobiltelefonnummer
| |
| |PrivateMobilePhone
| |
| |
| |
| |-
| |
| |esas_mobiltelefonnummer
| |
| |MobilePhone
| |
| |
| |
| |-
| |
| |esas_sso_id
| |
| |OtherInfo
| |
| |
| |
| |-
| |
| |esas_studieemail
| |
| |WorkMail
| |
| |
| |
| |-
| |
| |esas_navne_addressebeskyttet
| |
| |SecretAddress
| |
| |
| |
| |-
| |
| |esas_uddannelsesaktivitetId
| |
| |EducationID
| |
| |From table ImportFromDBesas_Uddannelsesaktivitet
| |
| |-
| |
| |esas_cosa_formaalskode
| |
| |COSA_FORMAL
| |
| |From table ImportFromDBesas_Uddannelsesaktivitet
| |
| |-
| |
| |esas_aktivitetsgruppekode
| |
| |Education
| |
| |From table ImportFromDBesas_Uddannelsesaktivitet
| |
| |-
| |
| |esas_betegnelse
| |
| |EducationDescriptionShort
| |
| |From table ImportFromDBesas_Uddannelsesaktivitet
| |
| |-
| |
| |esas_titel
| |
| |EducationDescription
| |
| |From table ImportFromDBesas_Uddannelsesaktivitet
| |
| |-
| |
| |esas_personoplysningerId
| |
| |ExtraField1
| |
| |
| |
| |-
| |
| |esas_studiestart
| |
| |StudyStart_Education
| |
| |
| |
| |-
| |
| |esas_afgangsdato
| |
| |StudyEnd_Education
| |
| |If null then use esas_forventet_afslutning
| |
| |-
| |
| |esas_forventet_afslutning
| |
| |Expected_EducationEndDate
| |
| |
| |
| |-
| |
| |esas_afdelingId
| |
| |DepartmentID
| |
| |
| |
| |-
| |
| |esas_navn
| |
| |Department
| |
| |
| |
| |-
| |
| |Address1_Line1
| |
| |DepartmentStreet
| |
| |From table ImportFromDBesas_InstitutionVirksomhed
| |
| |-
| |
| |esas_postnummer
| |
| |DepartmentPostalCode
| |
| |
| |
| |-
| |
| |esas_by
| |
| |DepartmentCity
| |
| |
| |
| |-
| |
| |esas_institutionsnummer
| |
| |SkoleKode
| |
| |
| |
| |-
| |
| |esas_navn
| |
| |EducationVersion
| |
| |
| |
| |-
| |
| |esas_lokalt_studienummer
| |
| |AlternativID
| |
| |
| |
| |-
| |
| |NationalAfgangsaarsag.esas_national_afgangsaarsagId
| |
| |DepartureCauseCode
| |
| |
| |
| |-
| |
| |NationalAfgangsaarsag.esas_navn
| |
| |DepartureCause_Description
| |
| |
| |
| |}
| |
| {| class="wikitable"
| |
| |+Extra fields when extracting students with rowtype<br>Student
| |
| !Admin system
| |
| !UMS
| |
| !Remarks
| |
| |-
| |
| |esas_navn_dansk
| |
| |Klassebetegnelse
| |
| |This is based on esas_stamhold_id on Studieforloeb
| |
| esas_navn_dansk is from table ImportFromDBesas_Hold
| |
| |}
| |
| {| class="wikitable"
| |
| |+Extra fields when extracting students with rowtype<br>Undervisningshold, Stamhold, Skabelonhold and Semesterhold
| |
| !Admin system
| |
| !UMS
| |
| !Remarks
| |
| |-
| |
| |Address1_Line1
| |
| |ActivityDepartmentStreet
| |
| |If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
| |
| |-
| |
| |esas_postnummer
| |
| |ActivityDepartmentPostalCode
| |
| |If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
| |
| |-
| |
| |esas_by
| |
| |ActivityDepartmentCity
| |
| |If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
| |
| |-
| |
| |esas_afdelingId
| |
| |ActivityDepartmentNumber
| |
| |If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
| |
| |-
| |
| |esas_navn
| |
| |ActivityDepartmentName
| |
| |If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
| |
| |-
| |
| |esas_institutionsnummer
| |
| |AktivitetsAfdeling
| |
| |If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
| |
| |-
| |
| |esas_uddannelseselement_planlaegningId
| |
| |ExtraField2
| |
| |
| |
| |-
| |
| |esas_holdId
| |
| |AktivitetsID
| |
| |From Hold
| |
| |-
| |
| |esas_navn_dansk
| |
| |Aktivitet
| |
| |From Hold
| |
| |-
| |
| |esas_navn_dansk
| |
| |ActivityDisplayName
| |
| |From Hold
| |
| |-
| |
| |esas_navn_dansk
| |
| |ActivityDescription
| |
| |From Hold
| |
| |-
| |
| |esas_navn_dansk
| |
| |Kort_Betegnelse
| |
| |From Hold
| |
| |-
| |
| |
| |
| |Activity_LMS_AllowRoll
| |
| |True if publication has been set
| |
| |-
| |
| |
| |
| |Aktivitet_LMS
| |
| |True if publication has been set
| |
| |-
| |
| |esas_publiceringsmulighed_institutionsspecifik
| |
| |Activity_PublicationCode
| |
| |From Hold
| |
| |-
| |
| |Label
| |
| |ActivityType
| |
| |Using Label from OptionSetValueString based on esas_holdtype
| |
| |-
| |
| |esas_startdato
| |
| |StartDato
| |
| |From table ImportFromDBesas_Hold
| |
| |-
| |
| |esas_slutdato
| |
| |SlutDato
| |
| |Use Studieforloeb esas_afgangsdato if lower then ImportFromDBesas_Hold esas_slutdato
| |
| |-
| |
| |esas_startdato
| |
| |Aktiviteter_StartDato
| |
| |if null use PUE esas_startdato
| |
| |-
| |
| |esas_slutdato
| |
| |Aktiviteter_SlutDato
| |
| |if null use PUE esas_slutdato
| |
| |-
| |
| |esas_uddannelseselementId
| |
| |Course_ID
| |
| |From SUE
| |
| |-
| |
| |esas_uvm_fagkode
| |
| |Skolefag
| |
| |From SUE
| |
| |-
| |
| |esas_navn
| |
| |Skolefag_Betegnelse
| |
| |From SUE
| |
| |-
| |
| |esas_fagkode_niveau
| |
| |CourseLevel
| |
| |From SUE
| |
| |-
| |
| |Label
| |
| |CourseType
| |
| |Using Label from OptionSetValueString based on esas_fagtype
| |
| |-
| |
| |esas_uddannelsesaktivitetId
| |
| |Activity_EducationID
| |
| |
| |
| |-
| |
| |esas_aktivitetsgruppekode
| |
| |Activity_Education
| |
| |
| |
| |-
| |
| |esas_betegnelse
| |
| |Activity_EducationDescription
| |
| |
| |
| |-
| |
| |FirstName
| |
| |Activity_Teacher_FirstName
| |
| |
| |
| |-
| |
| |LastName
| |
| |Activity_Teacher_LastName
| |
| |
| |
| |-
| |
| |esas_cpr_nummer_uden_formatering
| |
| |Activity_Teacher_SSN
| |
| |
| |
| |}
| |
|
| |
|
| ===Template criteria mapping=== | | === Why are my users not created === |
| {| class="wikitable"
| | They must have work mail, firstname, lastname and CPR. |
| |+Students
| |
| !Admin system
| |
| !UMS
| |
| !Picture from admin system
| |
| !Remarks
| |
| |-
| |
| |Cosa formaalskode
| |
| |COSA_FORMAL
| |
| |
| |
| |
| |
| |-
| |
| |Studieforløb -> Uddannelsesstruktur -> Uddannelsesaktivitet -> Aktivitets gruppekode
| |
| |Education
| |
| |
| |
| |
| |
| |-
| |
| |Studieforløb -> Department
| |
| |Department
| |
| |
| |
| |
| |
| |-
| |
| |Studieforløb -> Institution code
| |
| |SkoleKode
| |
| |
| |
| |
| |
| |-
| |
| |PUE -> Activity Department
| |
| |ActivityDepartmentName
| |
| |
| |
| |If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE
| |
| |-
| |
| |Activity Cosa formaalskode
| |
| |
| |
| |
| |
| |You can find this in table ImportFromDBesas_Uddannelsesaktivitet column esas_cosa_formaalskode
| |
| |-
| |
| |Activity gruppekode
| |
| |Activity_Education
| |
| |
| |
| |
| |
| |-
| |
| |PUE -> Activity Institution code
| |
| |AktivitetsAfdeling
| |
| |
| |
| |If afdeling from PUE is null then use Aktivitetsudbud afdeling from PUE
| |
| |-
| |
| |Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling
| |
| |
| |
| |
| |
| |You can find this in table ImportFromDBesas_Afdeling column esas_navn
| |
| |-
| |
| |Studieforløb -> Aktivitetsudbud -> Aktivitetsafdeling code
| |
| |
| |
| |
| |
| |You can find this in table ImportFromDBesas_Afdeling column esas_institutionsnummer
| |
| |-
| |
| |Hold -> Department
| |
| |ActivityDepartmentName
| |
| |
| |
| |If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
| |
| |-
| |
| |Hold -> Institution code
| |
| |AktivitetsAfdeling
| |
| |
| |
| |If afdeling from Hold is null then use Aktivitetsudbud afdeling from Hold
| |
| |}
| |
