|
|
| Line 1: |
Line 1: |
| [[File:AdminServer Esas.jpg|none|thumb|656x656px]] | | [[File:AdminServer MitID Erhverv.jpg|none|thumb|765x765px]] |
| ====Certificate file====
| |
| 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]
| | ===Certificate file=== |
| | The certificate used to access the webservices. |
|
| |
|
| [https://confluence.umit.dk/display/esasdokumentation/Import+af+certifikater How to Certificates]
| | ==== How to order test certificate ==== |
| | Creating new certificate: |
|
| |
|
| ====Certificate password====
| | See picture below for example |
| Password for the certificate file.
| |
|
| |
|
| ===Username===
| | Or |
| Username to access webservices.
| |
|
| |
|
| This information in given by [https://ufm.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas]
| | * "Typer af cerfikater" |
| ===Password===
| | ** Oces organisationscertifikat |
| Password to access webservices.
| | * "Metode til identifikation" |
| | ** Bruger-login |
| | * "Ja, gå direkte til udstedelse efter bestilling" |
| | ** Check this |
| | * "Metode til udstedelse" |
| | ** Internetbrowser |
|
| |
|
| This information in given by [https://ufm.dk/uddannelse/videregaende-uddannelse/studieadministrative-systemer/projekt-esas Esas]
| | <br /> |
| ===[[AdminServers/Export Settings|Export settings]]===
| | [[File:MitId Erhverv Order certificate picture.jpg|none|thumb|1102x1102px]] |
|
| |
|
| ===Data mapping=== | | ===Certificate password=== |
| {| class="wikitable"
| | Password for the certificate file. |
| |+
| |
| 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===
| | This will be given to you when you login after completing the order. |
| {| class="wikitable"
| |
| |+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
| |
| |}
| |
