Tabulex
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