Tabulex: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
 
(19 intermediate revisions by the same user not shown)
Line 2: Line 2:


==Technical settings==
==Technical settings==
All 4 files below must be present. If there are no employees the files must still be there.
The field order in the txt files must match the table definitions exactly to be imported correctly.


===File structure for Elev.txt===
===File structure for Elev.txt===
First line contains only the school year in which the text file was generated. Normally the school year is defined from 01-08 to 31-07 next year.
{| class="wikitable"
{| class="wikitable"
|+
|+
Employees
 
!Admin system
!Admin system
!UMS
!UMS
!Remarks
!Remarks
|-
|-
|AnsatID
|ElevID
|UMS_IDFromAdministrativeSystem
|
|
|-
|Skolekode
|
|
|-
|Skolenavn
|
|
|
|-
|-
|Initialer
|Fornavn
|IDFromAdministrativeSystem
|
|
|
|-
|-
|Initialer
|Efternavn
|StudieNr
|
|
|
|-
|-
|CPR
|CPR
|CPR
|
|
|-
|Adresse
|
|
|-
|Område
|
|
|-
|Postnummer
|
|
|-
|By
|
|
|
|-
|-
|ForNavn
|Klassetrin
|
|
|
|
|-
|-
|EFTERNAVN
|Klassespor
|
|
|
|
|-
|-
|Privattlf
|Elevens første skoleår
|PhoneNumber
|
|
|This is not used
|-
|-
|Mobiltlf
|Stamklasse
|MobilePhone
|
|
|
|-
|-
|SkoleID
|Blank
|ElevAfdelingsKode
|
|
|This is not used
|}
Example:
2021
501001¤280202¤inLogic Skole¤Test¤Testesen¤1234567890¤Silkeborgvej 140¤Lund¤8700¤Horsens¤9¤Y¤2011¤Y10¤
===File structure for Elev-valgfag.txt===
First line contains only the school year in which the text file was generated. Normally the school year is defined from 01-08 to 31-07 next year.
{| class="wikitable"
|+
!Admin system
!UMS
!Remarks
|-
|-
|AnsatTypeBeskrivelse
|Skolekode
|Employee_Description
|
|
|
|-
|-
|SkoleID
|ElevID
|SkoleKode
|
|
|
|-
|-
Line 60: Line 98:
|
|
|-
|-
|Holdnavn
|Blank
|ActivityDisplayName
|
|This is not used
|}
Example:
2021
501001¤4778323¤¤
===File structure for Personale.txt===
{| class="wikitable"
|+
 
!Admin system
!UMS
!Remarks
|-
|Skolekode
|
|
|-
|AnsatID
|
|
|-
|CPR
|
|
|-
|Initialer
|
|
|-
|Fornavn
|
|
|
|-
|-
|Holdnavn
|Efternavn
|Kort_Betegnelse
|
|
|
|-
|-
|Skolenavn
|Blank
|AfdelingsNavn
|
|
|This is not used
|-
|-
|Gade
|Adresse
|Adresse
|
|
|
|-
|-
|Sted
|Sted
|Sted
|
|
|
|-
|Postnummer
|
|
|-
|By
|
|
|-
|Privat telefon
|
|
|-
|Mobil telefon
|
|
|-
|Blank
|
|This is not used
|-
|Blank
|
|This is not used
|-
|Blank
|
|This is not used
|-
|-
|PostNr
|Roller
|PostNummer
|
|
|This is a comma seperated list
Each item in the list will be imported as activities into UMS
|-
|-
|Holdnavn
|Stilling
|ActivityType
|
|If hold is not null then Activity is written to this field
|
|}
|}
<br />[[File:Tabulex Tea Student2.jpg|none|thumb|807x807px]]
Example:
501001¤232957¤12345678905¤KH¤Test¤Testesen¤¤Silkeborgvej 140¤Lund¤8700¤Horsens¤¤22918055¤¤¤¤Ledelse,Lærer¤Lærer


===File structure for Elev-valgfag.txt===
===File structure for Personale-hold.txt===
There must be a minimum of 1 line per student in this file[[File:Tabulex Tea Student Groups.jpg|none|thumb|785x785px]]
{| class="wikitable"
|+


===File structure for Personale.txt===
!Admin system
[[File:Tabulex Tea Staff.jpg|none|thumb|810x810px]]
!UMS
 
!Remarks
===File structure for Personale-hold.txt===
|-
[[File:Tabulex Tea Staff Groups.jpg|none|thumb|795x795px]]
|Skolekode
|
|
|-
|AnsatID
|
|
|-
|HoldID
|AktivitetsID
|
|-
|Holdnavn
|Aktivitet
|
|}
Example:
501001¤4778323¤862026¤MOT torsdag


==FAQ==
==FAQ==

Latest revision as of 11:53, 9 March 2022

Tabulex Tea is an administrative system.

Technical settings

The field order in the txt files must match the table definitions exactly to be imported correctly.

File structure for Elev.txt

First line contains only the school year in which the text file was generated. Normally the school year is defined from 01-08 to 31-07 next year.

Admin system UMS Remarks
ElevID
Skolekode
Skolenavn
Fornavn
Efternavn
CPR
Adresse
Område
Postnummer
By
Klassetrin
Klassespor
Elevens første skoleår This is not used
Stamklasse
Blank This is not used

Example: 

2021
501001¤280202¤inLogic Skole¤Test¤Testesen¤1234567890¤Silkeborgvej 140¤Lund¤8700¤Horsens¤9¤Y¤2011¤Y10¤

File structure for Elev-valgfag.txt

First line contains only the school year in which the text file was generated. Normally the school year is defined from 01-08 to 31-07 next year.

Admin system UMS Remarks
Skolekode
ElevID
Holdnavn Aktivitet
Blank This is not used

Example: 

2021
501001¤4778323¤¤

File structure for Personale.txt

Admin system UMS Remarks
Skolekode
AnsatID
CPR
Initialer
Fornavn
Efternavn
Blank This is not used
Adresse
Sted
Postnummer
By
Privat telefon
Mobil telefon
Blank This is not used
Blank This is not used
Blank This is not used
Roller This is a comma seperated list

Each item in the list will be imported as activities into UMS

Stilling

Example: 

501001¤232957¤12345678905¤KH¤Test¤Testesen¤¤Silkeborgvej 140¤Lund¤8700¤Horsens¤¤22918055¤¤¤¤Ledelse,Lærer¤Lærer

File structure for Personale-hold.txt

Admin system UMS Remarks
Skolekode
AnsatID
HoldID AktivitetsID
Holdnavn Aktivitet

Example: 

501001¤4778323¤862026¤MOT torsdag

FAQ

Retrieved from "http://wiki.inlogic.dk/index.php?title=Tabulex&oldid=4285"