Tabulex: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Kia (talk | contribs)
Line 3: Line 3:
==Technical settings==
==Technical settings==
All 4 files below must be present. If there are no employees the files must still be there.
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
|
|
|
|-
|-
|Initialer
|Skolekode
|IDFromAdministrativeSystem
|
|
|
|-
|-
|Initialer
|Skolenavn
|StudieNr
|
|
|
|-
|-
|CPR
|Fornavn
|CPR
|
|
|
|-
|-
|ForNavn
|Efternavn
|
|
|
|
|-
|-
|EFTERNAVN
|CPR
|
|
|
|
|-
|-
|Privattlf
|Adresse
|PhoneNumber
|
|
|
|-
|-
|Mobiltlf
|Område
|MobilePhone
|
|
|
|-
|-
|SkoleID
|Postnummer
|ElevAfdelingsKode
|
|
|
|-
|-
|AnsatTypeBeskrivelse
|By
|Employee_Description
|
|
|-
|SkoleID
|SkoleKode
|
|
|-
|-
|Holdnavn
|Klassetrin
|Aktivitet
|
|
|-
|Holdnavn
|ActivityDisplayName
|
|
|-
|-
|Holdnavn
|Klassespor
|Kort_Betegnelse
|
|
|-
|Skolenavn
|AfdelingsNavn
|
|
|-
|-
|Gade
|Elevens første skoleår
|Adresse
|
|
|This is not used
|-
|-
|Sted
|Stamklasse
|Sted
|
|
|-
|PostNr
|PostNummer
|
|
|-
|Holdnavn
|ActivityType
|If hold is not null then Activity is written to this field
|}
|}
<br />[[File:Tabulex Tea Student2.jpg|none|thumb|807x807px]]
<br />[[File:Tabulex Tea Student2.jpg|none|thumb|807x807px]]

Revision as of 09:28, 2 February 2022

Tabulex Tea is an administrative system.

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

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


File:Tabulex Tea Student2.jpg

File structure for Elev-valgfag.txt

There must be a minimum of 1 line per student in this file

File:Tabulex Tea Student Groups.jpg

File structure for Personale.txt

File:Tabulex Tea Staff.jpg

File structure for Personale-hold.txt

File:Tabulex Tea Staff Groups.jpg

FAQ