(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
|}
Requirements Minimum Windows 2019
Users must have work mail.
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.
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/
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)
check "Adgang til IdM services i MitID Erhverv "
See picture below for example
Or
"Typer af cerfikater"
Oces organisationscertifikat
"Metode til identifikation"
"Ja, gå direkte til udstedelse efter bestilling"
"Metode til udstedelse"
Certificate password Password for the certificate file.
This will be given to you when you login after completing the order.
FAQ Test enviroment setup Create https://www.nemlog-in.dk/vejledningertiltestmiljo/forside/vejledning-til-tjenesteudbydere-tilslut-jeres-tjeneste-til-test-miljoet/
Login URL's 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/
Other documentation https://migrering.nemlog-in.dk/mitid-erhverv/test-og-dokumentation/
Why are my users not created They must have work mail, firstname, lastname and CPR.
