Tabulex: Difference between revisions
Jump to navigation
Jump to search
| (18 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
==Technical settings== | ==Technical settings== | ||
The field order in the txt files must match the table definitions exactly to be imported correctly. | The field order in the txt files must match the table definitions exactly to be imported correctly. | ||
| Line 70: | Line 68: | ||
| | | | ||
| | | | ||
|- | |||
|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=== | ===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 | |||
|- | |||
|Skolekode | |||
| | |||
| | |||
|- | |||
|ElevID | |||
| | |||
| | |||
|- | |||
|Holdnavn | |||
|Aktivitet | |||
| | |||
|- | |||
|Blank | |||
| | |||
|This is not used | |||
|} | |||
Example: | |||
2021 | |||
501001¤4778323¤¤ | |||
===File structure for Personale.txt=== | ===File structure for Personale.txt=== | ||
{| class="wikitable" | |||
|+ | |||
!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=== | ===File structure for Personale-hold.txt=== | ||
{| class="wikitable" | |||
|+ | |||
!Admin system | |||
!UMS | |||
!Remarks | |||
|- | |||
|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