Tabulex: Difference between revisions
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 69: | Line 69: | ||
| | | | ||
|- | |- | ||
| | |Blank | ||
| | | | ||
|This is not used | |This is not used | ||
| Line 95: | Line 95: | ||
|- | |- | ||
|Holdnavn | |Holdnavn | ||
| | |Aktivitet | ||
| | | | ||
|- | |- | ||
| | |Blank | ||
| | | | ||
|This is not used | |This is not used | ||
| Line 207: | Line 207: | ||
|- | |- | ||
|HoldID | |HoldID | ||
| | |AktivitetsID | ||
| | | | ||
|- | |- | ||
|Holdnavn | |Holdnavn | ||
| | |Aktivitet | ||
| | | | ||
|} | |} | ||
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