AdminServers/Fguplaner - Revision history

Kia@inlogic.dk: /* Template criteria mapping */

2026-03-06T08:45:49Z

Template criteria mapping

← Older revision		Revision as of 08:45, 6 March 2026
Line 110:		Line 110:
	\|Education		\|Education
	\|Education		\|Education
			\|-
			\|track_name
			\|EducationDirection
			\|Stays
	\|-		\|-
	\|id		\|id
Line 241:		Line 245:
	\|Education		\|Education
	\|Education		\|Education
			\|
			\|
			\|-
			\|track name
			\|EducationDirection
	\|		\|
	\|		\|
	\|}		\|}

Kia@inlogic.dk: /* Data mapping */

2026-02-19T12:39:21Z

Data mapping

← Older revision		Revision as of 12:39, 19 February 2026
Line 85:		Line 85:
	\|address_protection		\|address_protection
	\|SecretAddress		\|SecretAddress
	\|
	\|-
	\|
	\|
	\|		\|
	\|-		\|-

Kia@inlogic.dk: /* Data mapping */

2026-02-19T12:38:59Z

Data mapping

Show changes

Kia@inlogic.dk: /* Template criteria mapping */

2026-02-19T12:31:03Z

Template criteria mapping

← Older revision		Revision as of 12:31, 19 February 2026
Line 170:		Line 170:
	\|}		\|}
	{\| class="wikitable"		{\| class="wikitable"
	\|+Extra fields when extracting students with rowtype<br>~~UVA~~		\|+Extra fields when extracting students with rowtype<br>HomeGroup
	!Admin system		!Admin system
	!UMS		!UMS
	!Remarks		!Remarks
	\|-
	~~\|uddelement_id~~
	~~\|AktivitetsID~~
	\|
	\|-
	~~\|KODE~~
	~~\|Aktivitet~~
	\|
	\|-
	~~\|langtnavn~~
	~~\|ActivityDisplayName~~
	\|
	\|-
	~~\|langtnavn~~
	~~\|ActivityDescription~~
	\|
	\|-		\|-
	\|navn		\|navn
	\|~~Kort_Betegnelse~~		\|HomeGroupName
	\|		\|From stays
	\|-
	~~\|ELEMENTTYPE~~
	~~\|ActivityType~~
	\|
	\|-		\|-
	\|		\|
Line 203:		Line 183:
	\|True		\|True
	\|-		\|-
	\|		\|start_date
	~~\|Activity_LMS_AllowRoll~~
	~~\|True~~
	\|-
	~~\|fra_dato~~
	\|StartDato		\|StartDato
	\|		\|From stays
	\|-		\|-
	\|~~til_dato~~		\|end_date
	\|SlutDato		\|SlutDato
	\|		\|From stays
	\|-
	~~\|fra_dato~~
	~~\|Aktiviteter_StartDato~~
	\|
	\|-
	~~\|til_dato~~
	~~\|Aktiviteter_SlutDato~~
	\|
	\|}		\|}
	{\| class="wikitable"		{\| class="wikitable"
	\|+Extra fields when extracting students with rowtype<br>~~Groups~~		\|+Extra fields when extracting students with rowtype<br>EducationModule
	!Admin system		!Admin system
	!UMS		!UMS
	!Remarks		!Remarks
	\|-
	~~\|stud_gruppe_id~~
	~~\|AktivitetsID~~
	\|
	\|-
	~~\|KODE~~
	~~\|Aktivitet~~
	\|
	\|-
	~~\|KOMMENTAR~~
	~~\|ActivityDisplayName~~
	\|
	\|-
	~~\|KOMMENTAR~~
	~~\|ActivityDescription~~
	\|
	\|-
	~~\|KODE~~
	~~\|Kort_Betegnelse~~
	\|
	\|-
	\|
	~~\|ActivityType~~
	~~\|Class~~
	\|-		\|-
	\|		\|
Line 257:		Line 201:
	\|True		\|True
	\|-		\|-
	\|		\|start_date
	~~\|Activity_LMS_AllowRoll~~
	~~\|True~~
	\|-
	~~\|oprettelsesdato~~
	\|StartDato		\|StartDato
	\|		\|From Education module attendance
	\|-		\|-
	\|~~add_months(sysdate, 1)~~		\|end_date
	\|SlutDato		\|SlutDato
	\|		\|From Education module attendance
			\|-
			\|id
			\|Course_ID
			\|From Education Modules
			\|-
			\|name
			\|Skolefag
			\|From Education Modules
			\|-
			\|type
			\|CourseType
			\|From Education Modules
	\|-		\|-
	\|~~oprettelsesdato~~		\|name
	\|~~Aktiviteter_StartDato~~		\|Skolefag_Betegnelse
	\|		\|From Education Modules
	\|-		\|-
	\|~~add_months(sysdate, 1)~~		\|name
	\|~~Aktiviteter_SlutDato~~		\|SkoleFag_Kort_Betegnelse
	\|		\|From Education Modules
	\|}		\|}

Kia@inlogic.dk: /* Data mapping */

2026-02-19T12:17:47Z

Data mapping

← Older revision		Revision as of 12:17, 19 February 2026
Line 286:		Line 286:
	!Remarks		!Remarks
	\|-		\|-
	\|~~Education code~~		\|institution_number
	\|~~EducationCode~~		\|ActivityDepartmentCode
	\|
	\|
	\|-
	~~\|Education group code~~
	~~\|EducationGroupCode~~
	\|		\|
	\|		\|
	\|-		\|-
	\|~~Department code~~		\|School name
	\|DepartmentCode		\|DepartmentCode
	\|		\|
	\|		\|
	\|-		\|-
	\|~~Activity department code~~		\|Education
	\|~~ActivityDepartmentCode~~		\|Education
	\|		\|
	\|		\|
	\|-
	~~\|Group comment~~
	~~\|ActivityDisplayName~~
	\|
	~~\|Is only used when extracting groups (Rows with rowtype Groups)~~
	\|}		\|}

Kia@inlogic.dk: /* Server */

2026-02-19T12:07:32Z

Server

← Older revision		Revision as of 12:07, 19 February 2026
Line 1:		Line 1:
	[[File:Adminserver Fguplaner.png\|none\|thumb\|765x765px]]		[[File:Adminserver Fguplaner.png\|none\|thumb\|765x765px]]

	===~~Server~~===		===Institution number===
	~~DNS address of~~ the ~~Oracle server where the STADS database~~ is ~~stored~~.		Institution number assigned by the Danish government . This is 6 characters long.

	===~~SID~~===		===Token===
	~~STADS database name~~.		This is the access token used to authenticate to the webservices.

	~~===Username===~~		You need to contact Fguplaner to get an access token.
	~~Oracle Username~~ to ~~access database.~~

	~~===Password===~~
	~~Oracle Password~~ to access ~~database~~.

	===[[AdminServers/Export Settings\|Export settings]]===		===[[AdminServers/Export Settings\|Export settings]]===

Kia@inlogic.dk at 12:04, 19 February 2026

2026-02-19T12:04:42Z

Show changes

Kia@inlogic.dk: /* Setup af UNILogin */

2026-02-19T12:04:35Z

Setup af UNILogin

← Older revision		Revision as of 12:04, 19 February 2026
Line 1:		Line 1:
	~~=== Setup af UNILogin ===~~		[[File:Adminserver Fguplaner.png\|none\|thumb\|765x765px]]
	~~[[STIL UNI Login#Setup af UniSync\|STIL UNI Login - UmsWiki]]~~[[File:~~AdminServer UNILogin~~.~~jpg~~\|none\|thumb\|~~656x656px~~]]

	=== Data provider settings ===		=== Data provider settings ===

Kia@inlogic.dk: Created page with "=== Setup af UNILogin === STIL UNI Login - UmsWiki656x656px === Data provider settings === This is the new connection settings when connecting to STIL webservices [https://viden.stil.dk/spaces/INFRA2/pages/2360666/wsaIMPORT wsaIMPORT - Infrastruktur - Viden.stil.dk] You need to setup a certificate. [https://viden.stil.dk/spaces/OFFTILSLU/pages/299139464/Certifikater Certifikater - Tilslu..."

2026-02-19T12:02:23Z

Created page with "=== Setup af UNILogin === STIL UNI Login - UmsWiki none|thumb|656x656px === Data provider settings === This is the new connection settings when connecting to STIL webservices [https://viden.stil.dk/spaces/INFRA2/pages/2360666/wsaIMPORT wsaIMPORT - Infrastruktur - Viden.stil.dk] You need to setup a certificate. [https://viden.stil.dk/spaces/OFFTILSLU/pages/299139464/Certifikater Certifikater - Tilslu..."

New page

=== Setup af UNILogin ===
[[STIL UNI Login#Setup af UniSync|STIL UNI Login - UmsWiki]][[File:AdminServer UNILogin.jpg|none|thumb|656x656px]]

=== Data provider settings ===
This is the new connection settings when connecting to STIL webservices

[https://viden.stil.dk/spaces/INFRA2/pages/2360666/wsaIMPORT wsaIMPORT - Infrastruktur - Viden.stil.dk]

You need to setup a certificate.

[https://viden.stil.dk/spaces/OFFTILSLU/pages/299139464/Certifikater Certifikater - Tilslutning - Global Site]

==== System ID ====
This is the system ID from STIL.

===Data provider settings - legacy (Onlinetjeneste-abonnement)===
Indstillinger som skal bruges til WS10 (Sende data) og WS17 (hente data)

http://www.stil.dk/~/media/STIL/Filer/PDF13_14/140521%20UNI%20Login%20Import%20WS10%20v31.pdf

http://www.stil.dk/~/media/STIL/Filer/Publikationer/Tekniske%20vejledninger/UNI-ogin%20Eksport%20WS17%20v1.3.pdf

==== Username ====
Username need to access webservice.

==== Password ====
Password need to access webservice.

=== Institution numbers ===
Enter the institution numbers to get data from.
[[File:AdminServer UNILogin Institutionnumbers.jpg|none|thumb|447x447px]]

===[[AdminServers/Export Settings|Export settings]]===