Jump to content

AdminServers/ASV: Difference between revisions

From UmsWiki
← Older editNewer edit →
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
No edit summary
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
No edit summary
Line 2: Line 2:


====Full path and name to database====
====Full path and name to database====
API key to access the webservice.
A file copy of the production database from ASV


====Path to java.exe====
====Path to java.exe====
Client ID to access the webservice.
<br />


====Path to H2 bin folder====
====Path to H2 bin folder====
Client secret to access the webservice.
<br />


School year
==== School year ====
Specify the school year to extract data from.


===[[AdminServers/Export Settings|Export settings]]===
===[[AdminServers/Export Settings|Export settings]]===
Line 24: Line 25:
|Employee ID
|Employee ID
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|-
|Employee ID
|IDFromAdministrativeSystem
|
|-
|GivenName
|Fornavn
|
|-
|Surname
|EFTERNAVN
|
|-
|Initials
|StudieNr
|
|-
|CivilRegistrationNumber
|CPR
|
|-
|AdUsername
|AlternativID
|
|-
|ProtectedGivenName
|PublicRegisteredFirstName
|
|-
|ProtectedSurname
|PublicRegisteredSurName
|
|-
|Email
|WorkMail
|
|-
|PhoneNumber
|WorkMobilePhone
|
|-
|PhoneNumber
|MobilePhone
|
|-
|JobTitle
|Employee_Description
|
|-
|Department ID
|DepartmentID
|
|-
|Department Name
|Department
|
|-
|AddressLine
|Adresse
|
|-
|PostalCode
|PostNummer
|
|-
|Place
|Sted
|
|-
|CareOfAddressLine
|COAddress
|
|-
|ProtectedNameAndAddress
|SecretAddress
|
|-
|Department ID
|AktivitetsID
|
|-
|Department Name
|Aktivitet
|
|-
|Department Name
|ActivityDisplayName
|
|-
|Department Name
|ActivityDescription
|
|-
|Department Name
|Kort_Betegnelse
|
|-
|EmploymentStartDate
|StartDato
|If department start date is after employment start date then department start date is used if not then employment start date is used
|-
|EmploymentResignationDate
|SlutDato
|If department end date is before employment resignation date then department end date is used if not then employment resignation date is used
|-
|Department ValidFrom
|Aktiviteter_StartDato
|
|-
|Department ValidTo
|Aktiviteter_SlutDato
|
|-
|EmploymentStartDate
|Employement_StartDate
|
|-
|EmploymentResignationDate
|Employement_EndDate
|
|-
|AreasOfResponsibility Name
|Employee_ResponsibilityArea
|
|
|}
|}
Line 160: Line 37:
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|
|-
|Students ID
|IDFromAdministrativeSystem
|
|-
|GivenName
|Fornavn
|
|-
|Surname
|EFTERNAVN
|
|-
|CivilRegistrationNumber
|CPR
|
|-
|AdUsername
|StudieNr
|
|-
|ProtectedGivenName
|PublicRegisteredFirstName
|
|-
|ProtectedSurname
|PublicRegisteredSurName
|
|-
|Email
|PrivateMail
|
|-
|PhoneNumber
|PrivateMobilePhone
|
|-
|PhoneNumber
|MobilePhone
|
|-
|StudyStartDate
|StudyStart_Education
|
|-
|StudyEndDate
|StudyEnd_Education
|
|-
|StudyExpectedCompletionDate
|Expected_EducationEndDate
|
|-
|Department ID
|DepartmentID
|
|-
|Department Name
|Department
|
|-
|SubjectCourse ID
|AktivitetsID
|
|-
|SubjectCourse Designation
|Aktivitet
|
|-
|SubjectCourse Designation
|ActivityDisplayName
|
|-
|SubjectCourse Name
|ActivityDescription
|
|-
|SubjectCourse Designation
|Kort_Betegnelse
|
|-
|SubjectCourse LmsIndicator
|Aktivitet_LMS
|
|-
|Subject Course Enrollment StartDate
|StartDato
|
|-
|Subject Course Enrollment EndDate
|SlutDato
|
|-
|SubjectCourse StartDate
|Aktiviteter_StartDato
|
|-
|SubjectCourse EndDate
|Aktiviteter_SlutDato
|
|-
|UVM Course ID
|Course_ID
|
|-
|UVM Course Subject
|Skolefag
|
|-
|UVM Course Description
|Skolefag_Betegnelse
|
|-
|UVM Course Level
|CourseLevel
|If Level is a - then Null is written to UMS
|-
|
|SkoleFag_LMS
|Is set to true if there is a UVM course connected
|-
|AddressLine
|Adresse
|
|-
|PostalCode
|PostNummer
|
|-
|Place
|Sted
|
|-
|CareOfAddressLine
|COAddress
|
|-
|ProtectedNameAndAddress
|SecretAddress
|
|-
|DepartmentEducation ID
|EducationDepartmentID
|
|-
|DepartmentEducation Name
|EducationDepartmentname
|
|-
|Student Studies EducationId
|EducationID
|
|-
|Student Studies EducationName
|Education
|
|-
|Student Studies EducationVersion
|EducationVersion
|
|-
|Student Studies Coesa
|COSA_FORMAL
|
|-
|Student Studies DsDepartmentNumber
|Skolekode
|
|-
|Guardian information
|Guardian information
|This is copied to the guardian fields in UMS
|}
|}
===Template criteria mapping===
===Template criteria mapping===
Line 343: Line 48:
|Institutions kode
|Institutions kode
|School Code
|School Code
|
|
|-
|Afdelings navn
|Department
|
|
|-
|Ansvarsområde
|Responsibility area
|
|
|
|
Line 365: Line 60:
|Institutions kode
|Institutions kode
|School Code
|School Code
|
|
|-
|Afdelings navn
|Department
|
|
|-
|Uddannelses kode
|CØSA Number
|
|
|
|
|}
|}
= FAQ =
<br />

Revision as of 08:50, 7 December 2020

Full path and name to database

A file copy of the production database from ASV

Path to java.exe


Path to H2 bin folder


School year

Specify the school year to extract data from.

Export settings

Data mapping

Employees
Admin system UMS Remarks
Employee ID UMS_IDFromAdministrativeSystem
Students
Admin system UMS Remarks
Students ID UMS_IDFromAdministrativeSystem

Template criteria mapping

Employees
Admin system UMS Picture from admin system Remarks
Institutions kode School Code
Students
Admin system UMS Picture from admin system Remarks
Institutions kode School Code

FAQ


Retrieved from "https://wiki.inlogic.dk/index.php?title=AdminServers/ASV&oldid=3709"