AdminServers/ASV: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Created page with "none|thumb|656x656px ====API Key==== API key to access the webservice. ====Client ID==== Client ID to access the webservice. ====Client..."
 
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
 
(31 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[File:AdminServer KMD Studica.jpg|none|thumb|656x656px]]
[[File:AdminServer ASV.jpg|none|thumb|656x656px]]


====API Key====
====SQL Server====
API key to access the webservice.
DNS or IP address of the Postgres server where the database is stored.


====Client ID====
====Database====
Client ID to access the webservice.
Database name.


====Client secret====
====Port number====
Client secret to access the webservice.
The port number of the SQL server.
 
====Username====
SQL Username to access database.
 
====Password====
SQL Password to access database.


===[[AdminServers/Export Settings|Export settings]]===
===[[AdminServers/Export Settings|Export settings]]===
Line 20: Line 26:
!Remarks
!Remarks
|-
|-
|Employee ID
|ASV.SVP_LEHRER_STAMM.ID
|UMS_IDFromAdministrativeSystem
|
|-
|Employee ID
|IDFromAdministrativeSystem
|IDFromAdministrativeSystem
|
|
|-
|-
|GivenName
|'E' + ASV.SVP_LEHRER_STAMM.ID
|Fornavn
|UMS_IDFromAdministrativeSystem
|
|Prefixed with increase identifier + '_' if used
|-
|-
|Surname
|ASV.SVP_LEHRER_SCHULJAHR_SCHULE.NAMENSKUERZEL
|EFTERNAVN
|
|-
|Initials
|StudieNr
|StudieNr
|
|
|-
|-
|CivilRegistrationNumber
|'E' + ASV.SVP_LEHRER_STAMM.ID
|CPR
|CPR
|
|Prefixed with increase identifier + '_' if used
|-
|-
|AdUsername
|ASV.SVP_LEHRER_STAMM.GEBURTSDATUM
|AlternativID
|BirthDay
|
|
|-
|-
|ProtectedGivenName
|ASV.SVP_LEHRER_STAMM.RUFNAME
|PublicRegisteredFirstName
|Fornavne
|
|
|-
|-
|ProtectedSurname
|ASV.SVP_LEHRER_STAMM.FAMILIENNAME
|PublicRegisteredSurName
|Efternavn
|
|
|-
|-
|Email
|ASV.SVP_LEHRER_STAMM.VORNAMEN
|WorkMail
|PublicRegisteredFirstName
|
|
|-
|-
|PhoneNumber
|ASV.SVP_LEHRER_STAMM.FAMILIENNAME
|WorkMobilePhone
|PublicRegisteredSurName
|
|
|-
|-
|PhoneNumber
|ASV.SVP_LEHRER_STAMM.WL_GESCHLECHT_ID
|MobilePhone
|Gender
|
|1099_1 = Male else female
|-
|-
|JobTitle
|ASV.SVP_SCHULE_STAMM.SCHULNUMMER
|Employee_Description
|Skolekode
|
|
|-
|-
|Department ID
|ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_VON
|DepartmentID
|StartDato
|
|
|-
|-
|Department Name
|ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_BIS
|Department
|SlutDato
|
|
|-
|-
|AddressLine
|ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_VON
|Adresse
|Employement_StartDate
|
|
|-
|-
|PostalCode
|ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_BIS
|PostNummer
|Employement_EndDate
|
|
|-
|-
|Place
|ASV.SVP_WL_AMTSBEZEICHNUNG.LANGFORM
|Sted
|Employee_Description
|
|
|-
|-
|CareOfAddressLine
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|COAddress
|PrivateMail
|
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|-
|ProtectedNameAndAddress
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|SecretAddress
|PhoneNumber
|
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|-
|Department ID
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|AktivitetsID
|PrivateMobilePhone
|
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|-
|Department Name
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Aktivitet
|MobilePhone
|
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|-
|Department Name
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|ActivityDisplayName
|Adresse
|
|
|-
|-
|Department Name
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|ActivityDescription
|postnummer
|
|
|-
|-
|Department Name
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|Kort_Betegnelse
|City
|
|
|-
|-
|EmploymentStartDate
|ASV.SVP_ANSCHRIFT.ORTSTEIL
|StartDato
|Sted
|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 155: Line 129:
!Remarks
!Remarks
|-
|-
|Students ID
|ASV.SVP_SCHUELER_STAMM.ID
|IDFromAdministrativeSystem
|
|-
|'S' + ASV.SVP_SCHUELER_STAMM.ID
|UMS_IDFromAdministrativeSystem
|UMS_IDFromAdministrativeSystem
|
|Prefixed with increase identifier + '_' if used
|-
|-
|Students ID
|ASV.SVP_SCHUELER_STAMM.ID
|IDFromAdministrativeSystem
|StudieNr
|
|
|-
|-
|GivenName
|'S' + ASV.SVP_SCHUELER_STAMM.ID
|Fornavn
|CPR
|
|Prefixed with increase identifier + '_' if used
|-
|-
|Surname
|ASV.SVP_SCHUELER_STAMM.GEBURTSDATUM
|EFTERNAVN
|BirthDay
|
|
|-
|-
|CivilRegistrationNumber
|ASV.SVP_SCHUELER_STAMM.RUFNAME
|CPR
|Fornavne
|
|
|-
|-
|AdUsername
|ASV.SVP_SCHUELER_STAMM.FAMILIENNAME
|StudieNr
|Efternavn
|
|
|-
|-
|ProtectedGivenName
|ASV.SVP_SCHUELER_STAMM.VORNAMEN
|PublicRegisteredFirstName
|PublicRegisteredFirstName
|
|
|-
|-
|ProtectedSurname
|ASV.SVP_SCHUELER_STAMM.FAMILIENNAME
|PublicRegisteredSurName
|PublicRegisteredSurName
|
|
|-
|-
|Email
|ASV.SVP_SCHUELER_STAMM.WL_GESCHLECHT_ID
|Gender
|1099_1 = Male else female
|-
|ASV.SVP_SCHULE_STAMM.SCHULNUMMER
|Skolekode
|
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PrivateMail
|PrivateMail
|
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PhoneNumber
|PhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PrivateMobilePhone
|PrivateMobilePhone
|
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|-
|PhoneNumber
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|MobilePhone
|MobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|Adresse
|
|
|-
|-
|StudyStartDate
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|StudyStart_Education
|postnummer
|
|
|-
|-
|StudyEndDate
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|StudyEnd_Education
|City
|
|
|-
|-
|StudyExpectedCompletionDate
|ASV.SVP_ANSCHRIFT.ORTSTEIL
|Expected_EducationEndDate
|Sted
|
|
|-
|-
|Department ID
|ASV.SVP_SCHUELER_STAMM.SCHUELERNUMMER
|DepartmentID
|AlternativID
|
|
|-
|-
|Department Name
|ASV.SVP_WL_JAHRGANGSSTUFE.KURZFORM
|Department
|YearLevel
|
|
|-
|-
|SubjectCourse ID
|ASV.SVP_KLASSENGRUPPE.ID
|AktivitetsID
|AktivitetsID
|
|
|-
|-
|SubjectCourse Designation
|ASV.SVP_KLASSE.KLASSENNAME
|Aktivitet
|Aktivitet
|
|Adds '_' + ASV.SVP_KLASSENGRUPPE.KENNUNG if it's not 1
|-
|-
|SubjectCourse Designation
|ASV.SVP_KLASSE.KLASSENNAME
|ActivityDisplayName
|ActivityDisplayName
|Adds '_' + ASV.SVP_KLASSENGRUPPE.KENNUNG if it's not 1
|-
|ASV.SVP_KLASSE.KLASSENNAME_LANG
|ActivityDescription
|
|
|-
|-
|SubjectCourse Name
|ASV.SVP_WL_SCHULJAHR.BEGINN
|ActivityDescription
|Aktiviteter_StartDato
|
|
|-
|-
|SubjectCourse Designation
|ASV.SVP_WL_SCHULJAHR.Ende
|Kort_Betegnelse
|Aktiviteter_SlutDato
|
|
|-
|-
|SubjectCourse LmsIndicator
|ASV.SVP_KOPPEL.ID
|Aktivitet_LMS
|ExtraField1
|
|
|-
|-
|Subject Course Enrollment StartDate
|ASV.SVP_WL_SCHULJAHR.BEGINN
|StartDato
|StartDato
|
|Uses ASV.SVP_SCHUELER_STAMM.EINTRITTSDATUM if this is after ASV.SVP_WL_SCHULJAHR.BEGINN
|-
|-
|Subject Course Enrollment EndDate
|ASV.SVP_WL_SCHULJAHR.Ende
|SlutDato
|SlutDato
|Uses ASV.SVP_SCHUELER_STAMM.AUSTRITTSDATUM if it is before ASV.SVP_WL_SCHULJAHR.Ende
|-
|ASV.SVP_SCHUELERFACH.ID
|Course_ID
|
|
|-
|-
|SubjectCourse StartDate
|ASV.SVP_SCHUELERFACH.Kurzform
|Aktiviteter_StartDato
|SkoleFag
|Adds '_' + ASV.SVP_FACHGRUPPE.Nummer if it's not 1
|-
|IsNull(ASV.SVP_SCHUELERFACH.LANGFORM, ASV.SVP_SCHUELERFACH.ANZEIGEFORM)
|SkoleFag_betegnelse
|
|
|-
|-
|SubjectCourse EndDate
|ASV.SVP_SCHUELERFACH.Kurzform
|Aktiviteter_SlutDato
|SkoleFag_Kort_Betegnelse
|Adds '_' + ASV.SVP_FACHGRUPPE.Nummer if it's not 1
|-
|'E' + ASV.SVP_LEHRER_STAMM.ID
|Activity_Teacher_SSN
|
|
|-
|-
|UVM Course ID
|ASV.SVP_LEHRER_STAMM.VORNAMEN
|Course_ID
|Activity_Teacher_FirstName
|
|
|-
|-
|UVM Course Subject
|ASV.SVP_LEHRER_STAMM.FAMILIENNAME
|Skolefag
|Activity_Teacher_LastName
|
|
|-
|-
|UVM Course Description
|ASV.SVP_PERSON.ID
|Skolefag_Betegnelse
|Guardian1SSN
|AUSKUNFTSBERECHTIGT = 1 And REITER_NR = 1
|-
|ASV.SVP_PERSON.VORNAMEN
|Guardian1Name
|
|
|-
|-
|UVM Course Level
|ASV.SVP_PERSON.FAMILIENNAME
|CourseLevel
|Guardian1SurName
|If Level is a - then Null is written to UMS
|
|-
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|Guardian1Address
|
|
|SkoleFag_LMS
|Is set to true if there is a UVM course connected
|-
|-
|AddressLine
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|Adresse
|Guardian1City
|
|
|-
|-
|PostalCode
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|PostNummer
|Guardian1PostalCode
|
|
|-
|-
|Place
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Sted
|Guardian1PhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian1Mail
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian1MobilePhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_PERSON.ID
|Guardian2SSN
|AUSKUNFTSBERECHTIGT = 1 And REITER_NR = 12
|-
|ASV.SVP_PERSON.VORNAMEN
|Guardian2Name
|
|
|-
|-
|CareOfAddressLine
|ASV.SVP_PERSON.FAMILIENNAME
|COAddress
|Guardian2SurName
|
|
|-
|-
|ProtectedNameAndAddress
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|SecretAddress
|Guardian2Address
|
|
|-
|-
|DepartmentEducation ID
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|EducationDepartmentID
|Guardian2City
|
|
|-
|-
|DepartmentEducation Name
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|EducationDepartmentname
|Guardian2PostalCode
|
|
|-
|-
|Student Studies EducationId
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|EducationID
|Guardian2PhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian2Mail
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian2MobilePhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|}
{| class="wikitable"
|+
Parents
!Admin system
!UMS
!Remarks
|-
|ASV.SVP_PERSON.ID
|IDFromAdministrativeSystem
|
|
|-
|-
|Student Studies EducationName
|'P' + ASV.SVP_PERSON.ID
|Education
|UMS_IDFromAdministrativeSystem
|Prefixed with increase identifier + '_' if used
|-
|ASV.SVP_PERSON.ID
|StudieNr
|
|
|-
|-
|Student Studies EducationVersion
|'P' + ASV.SVP_PERSON.ID
|EducationVersion
|CPR
|Prefixed with increase identifier + '_' if used
|-
|ASV.SVP_PERSON.GEBURTSDATUM
|BirthDay
|
|
|-
|-
|Student Studies Coesa
|ASV.SVP_PERSON.VORNAMEN
|COSA_FORMAL
|Fornavne
|
|
|-
|-
|Student Studies DsDepartmentNumber
|ASV.SVP_PERSON.FAMILIENNAME
|Efternavn
|
|-
|ASV.SVP_PERSON.VORNAMEN
|PublicRegisteredFirstName
|
|-
|ASV.SVP_PERSON.FAMILIENNAME
|PublicRegisteredSurName
|
|-
|ASV.SVP_PERSON.WL_GESCHLECHT_ID
|Gender
|1099_1 = Male else female
|-
|ASV.SVP_SCHULE_STAMM.SCHULNUMMER
|Skolekode
|Skolekode
|
|
|-
|-
|Guardian information
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|Guardian information
|PrivateMail
|This is copied to the guardian fields in UMS
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PhoneNumber
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|PrivateMobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE
|MobilePhone
|ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
|-
|ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer
|Adresse
|
|-
|ASV.SVP_ANSCHRIFT.POSTLEITZAHL
|postnummer
|
|-
|ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG
|City
|
|-
|ASV.SVP_ANSCHRIFT.ORTSTEIL
|Sted
|
|}
|}
===Template criteria mapping===
===Template criteria mapping===
{| class="wikitable"
{| class="wikitable"
Line 339: Line 441:
!Remarks
!Remarks
|-
|-
|Institutions kode
|School number
|School Code
|Skolekode
|
|
|}
{| class="wikitable"
|+Students
!Admin system
!UMS
!Picture from admin system
!Remarks
|-
|School number
|Skolekode
|
|
|
|
|-
|-
|Afdelings navn
|Class
|Department
|Aktivitet
|
|
|
|
|-
|-
|Ansvarsområde
|Year level
|Responsibility area
|YearLevel
|
|
|
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+Students
|+Parents
!Admin system
!Admin system
!UMS
!UMS
Line 361: Line 476:
!Remarks
!Remarks
|-
|-
|Institutions kode
|School number
|School Code
|Skolekode
|
|
|
|
|-
|-
|Afdelings navn
|Class
|Department
|
|
|
|
|This is the student class
|-
|-
|Uddannelses kode
|Year level
|CØSA Number
|
|
|
|
|This is the student year level
|}
|}
===Requirements for extracting to UMS===
====Staff====
He must be active in the current school year.
ZUGANG_DATUM or DIENSTVERHAELTNIS_VON must be entered
ABGANG_DATUM if entered and lower than today + keep alive then he won't be extracted
====Student====
He must be active in the current school year.
EINTRITTSDATUM must be entered
AUSTRITTSDATUM if entered and lower than today + keep alive then he won't be extracted
=FAQ=
===Bat script to copy ASV db to UMS server===
You need to create a scheduled task on the ASV server that runs this bat script.
net stop asv-server
md \\W1-UMS-Server.W1.local\c$\ASV
xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV /y /j
net start asv-server
===Connect with H2===
[[File:Adminserver ASV H2 Connection.jpg|none|thumb|438x438px]]
You need to change the path after localhost in the JDBC URL to match your location of the ASV database.
User Name and password is blank.<br />

Latest revision as of 07:36, 20 May 2022

SQL Server

DNS or IP address of the Postgres server where the database is stored.

Database

Database name.

Port number

The port number of the SQL server.

Username

SQL Username to access database.

Password

SQL Password to access database.

Export settings

Data mapping

Employees
Admin system UMS Remarks
ASV.SVP_LEHRER_STAMM.ID IDFromAdministrativeSystem
'E' + ASV.SVP_LEHRER_STAMM.ID UMS_IDFromAdministrativeSystem Prefixed with increase identifier + '_' if used
ASV.SVP_LEHRER_SCHULJAHR_SCHULE.NAMENSKUERZEL StudieNr
'E' + ASV.SVP_LEHRER_STAMM.ID CPR Prefixed with increase identifier + '_' if used
ASV.SVP_LEHRER_STAMM.GEBURTSDATUM BirthDay
ASV.SVP_LEHRER_STAMM.RUFNAME Fornavne
ASV.SVP_LEHRER_STAMM.FAMILIENNAME Efternavn
ASV.SVP_LEHRER_STAMM.VORNAMEN PublicRegisteredFirstName
ASV.SVP_LEHRER_STAMM.FAMILIENNAME PublicRegisteredSurName
ASV.SVP_LEHRER_STAMM.WL_GESCHLECHT_ID Gender 1099_1 = Male else female
ASV.SVP_SCHULE_STAMM.SCHULNUMMER Skolekode
ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_VON StartDato
ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_BIS SlutDato
ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_VON Employement_StartDate
ASV.SVP_LEHRER_STAMM.DIENSTVERHAELTNIS_BIS Employement_EndDate
ASV.SVP_WL_AMTSBEZEICHNUNG.LANGFORM Employee_Description
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PrivateMail ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PhoneNumber ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PrivateMobilePhone ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE MobilePhone ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer Adresse
ASV.SVP_ANSCHRIFT.POSTLEITZAHL postnummer
ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG City
ASV.SVP_ANSCHRIFT.ORTSTEIL Sted
Students
Admin system UMS Remarks
ASV.SVP_SCHUELER_STAMM.ID IDFromAdministrativeSystem
'S' + ASV.SVP_SCHUELER_STAMM.ID UMS_IDFromAdministrativeSystem Prefixed with increase identifier + '_' if used
ASV.SVP_SCHUELER_STAMM.ID StudieNr
'S' + ASV.SVP_SCHUELER_STAMM.ID CPR Prefixed with increase identifier + '_' if used
ASV.SVP_SCHUELER_STAMM.GEBURTSDATUM BirthDay
ASV.SVP_SCHUELER_STAMM.RUFNAME Fornavne
ASV.SVP_SCHUELER_STAMM.FAMILIENNAME Efternavn
ASV.SVP_SCHUELER_STAMM.VORNAMEN PublicRegisteredFirstName
ASV.SVP_SCHUELER_STAMM.FAMILIENNAME PublicRegisteredSurName
ASV.SVP_SCHUELER_STAMM.WL_GESCHLECHT_ID Gender 1099_1 = Male else female
ASV.SVP_SCHULE_STAMM.SCHULNUMMER Skolekode
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PrivateMail ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PhoneNumber ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PrivateMobilePhone ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE MobilePhone ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer Adresse
ASV.SVP_ANSCHRIFT.POSTLEITZAHL postnummer
ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG City
ASV.SVP_ANSCHRIFT.ORTSTEIL Sted
ASV.SVP_SCHUELER_STAMM.SCHUELERNUMMER AlternativID
ASV.SVP_WL_JAHRGANGSSTUFE.KURZFORM YearLevel
ASV.SVP_KLASSENGRUPPE.ID AktivitetsID
ASV.SVP_KLASSE.KLASSENNAME Aktivitet Adds '_' + ASV.SVP_KLASSENGRUPPE.KENNUNG if it's not 1
ASV.SVP_KLASSE.KLASSENNAME ActivityDisplayName Adds '_' + ASV.SVP_KLASSENGRUPPE.KENNUNG if it's not 1
ASV.SVP_KLASSE.KLASSENNAME_LANG ActivityDescription
ASV.SVP_WL_SCHULJAHR.BEGINN Aktiviteter_StartDato
ASV.SVP_WL_SCHULJAHR.Ende Aktiviteter_SlutDato
ASV.SVP_KOPPEL.ID ExtraField1
ASV.SVP_WL_SCHULJAHR.BEGINN StartDato Uses ASV.SVP_SCHUELER_STAMM.EINTRITTSDATUM if this is after ASV.SVP_WL_SCHULJAHR.BEGINN
ASV.SVP_WL_SCHULJAHR.Ende SlutDato Uses ASV.SVP_SCHUELER_STAMM.AUSTRITTSDATUM if it is before ASV.SVP_WL_SCHULJAHR.Ende
ASV.SVP_SCHUELERFACH.ID Course_ID
ASV.SVP_SCHUELERFACH.Kurzform SkoleFag Adds '_' + ASV.SVP_FACHGRUPPE.Nummer if it's not 1
IsNull(ASV.SVP_SCHUELERFACH.LANGFORM, ASV.SVP_SCHUELERFACH.ANZEIGEFORM) SkoleFag_betegnelse
ASV.SVP_SCHUELERFACH.Kurzform SkoleFag_Kort_Betegnelse Adds '_' + ASV.SVP_FACHGRUPPE.Nummer if it's not 1
'E' + ASV.SVP_LEHRER_STAMM.ID Activity_Teacher_SSN
ASV.SVP_LEHRER_STAMM.VORNAMEN Activity_Teacher_FirstName
ASV.SVP_LEHRER_STAMM.FAMILIENNAME Activity_Teacher_LastName
ASV.SVP_PERSON.ID Guardian1SSN AUSKUNFTSBERECHTIGT = 1 And REITER_NR = 1
ASV.SVP_PERSON.VORNAMEN Guardian1Name
ASV.SVP_PERSON.FAMILIENNAME Guardian1SurName
ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer Guardian1Address
ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG Guardian1City
ASV.SVP_ANSCHRIFT.POSTLEITZAHL Guardian1PostalCode
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE Guardian1PhoneNumber ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE Guardian1Mail ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE Guardian1MobilePhoneNumber ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
ASV.SVP_PERSON.ID Guardian2SSN AUSKUNFTSBERECHTIGT = 1 And REITER_NR = 12
ASV.SVP_PERSON.VORNAMEN Guardian2Name
ASV.SVP_PERSON.FAMILIENNAME Guardian2SurName
ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer Guardian2Address
ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG Guardian2City
ASV.SVP_ANSCHRIFT.POSTLEITZAHL Guardian2PostalCode
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE Guardian2PhoneNumber ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE Guardian2Mail ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE Guardian2MobilePhoneNumber ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
Parents
Admin system UMS Remarks
ASV.SVP_PERSON.ID IDFromAdministrativeSystem
'P' + ASV.SVP_PERSON.ID UMS_IDFromAdministrativeSystem Prefixed with increase identifier + '_' if used
ASV.SVP_PERSON.ID StudieNr
'P' + ASV.SVP_PERSON.ID CPR Prefixed with increase identifier + '_' if used
ASV.SVP_PERSON.GEBURTSDATUM BirthDay
ASV.SVP_PERSON.VORNAMEN Fornavne
ASV.SVP_PERSON.FAMILIENNAME Efternavn
ASV.SVP_PERSON.VORNAMEN PublicRegisteredFirstName
ASV.SVP_PERSON.FAMILIENNAME PublicRegisteredSurName
ASV.SVP_PERSON.WL_GESCHLECHT_ID Gender 1099_1 = Male else female
ASV.SVP_SCHULE_STAMM.SCHULNUMMER Skolekode
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PrivateMail ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_04'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PhoneNumber ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_01'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE PrivateMobilePhone ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
ASV.SVP_KOMMUNIKATION.KOMMUNIKATIONSADRESSE MobilePhone ASV.SVP_KOMMUNIKATION.WL_KOMMUNIKATIONSTYP_ID = '1113_02'
ASV.SVP_ANSCHRIFT.Strasse + ' ' + ASV.SVP_ANSCHRIFT.Nummer Adresse
ASV.SVP_ANSCHRIFT.POSTLEITZAHL postnummer
ASV.SVP_ANSCHRIFT.ORTSBEZEICHNUNG City
ASV.SVP_ANSCHRIFT.ORTSTEIL Sted

Template criteria mapping

Employees
Admin system UMS Picture from admin system Remarks
School number Skolekode
Students
Admin system UMS Picture from admin system Remarks
School number Skolekode
Class Aktivitet
Year level YearLevel
Parents
Admin system UMS Picture from admin system Remarks
School number Skolekode
Class This is the student class
Year level This is the student year level

Requirements for extracting to UMS

Staff

He must be active in the current school year.

ZUGANG_DATUM or DIENSTVERHAELTNIS_VON must be entered

ABGANG_DATUM if entered and lower than today + keep alive then he won't be extracted

Student

He must be active in the current school year.

EINTRITTSDATUM must be entered

AUSTRITTSDATUM if entered and lower than today + keep alive then he won't be extracted

FAQ

Bat script to copy ASV db to UMS server

You need to create a scheduled task on the ASV server that runs this bat script. 

net stop asv-server
md \\W1-UMS-Server.W1.local\c$\ASV
xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV /y /j
net start asv-server

Connect with H2

You need to change the path after localhost in the JDBC URL to match your location of the ASV database.

User Name and password is blank.

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