Tabulex: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
No edit summary
Kia (talk | contribs)
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.
The field order in the txt files must match the table definitions exactly to be imported correctly.


Line 81: Line 79:
!UMS
!UMS
!Remarks
!Remarks
|-
|ElevID
|
|
|-
|-
|Skolekode
|Skolekode
Line 90: Line 84:
|
|
|-
|-
|Skolenavn
|ElevID
|
|
|-
|Fornavn
|
|
|-
|Efternavn
|
|
|-
|CPR
|
|
|
|
|-
|-
|Adresse
|Holdnavn
|
|
|-
|Område
|
|
|-
|Postnummer
|
|
|-
|By
|
|
|-
|Klassetrin
|
|
|-
|Klassespor
|
|
|-
|Elevens første skoleår
|
|This is not used
|-
|Stamklasse
|
|
|
|
|}
|}


There must be a minimum of 1 line per student in this file[[File:Tabulex Tea Student Groups.jpg|none|thumb|785x785px]]
[[File:Tabulex Tea Student Groups.jpg|none|thumb|785x785px]]


===File structure for Personale.txt===
===File structure for Personale.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"
|+
|+
Line 150: Line 103:
!Remarks
!Remarks
|-
|-
|ElevID
|Skolekode
|
|
|-
|AnsatID
|
|
|
|
|-
|-
|Skolekode
|CPR
|
|
|
|
|-
|-
|Skolenavn
|Initialer
|
|
|
|
Line 170: Line 127:
|
|
|-
|-
|CPR
|Blank
|
|
|
|This is not used
|-
|-
|Adresse
|Adresse
Line 178: Line 135:
|
|
|-
|-
|Område
|Sted
|
|
|
|
Line 190: Line 147:
|
|
|-
|-
|Klassetrin
|Privat telefon
|
|
|
|
|-
|-
|Klassespor
|Mobil telefon
|
|
|
|-
|Blank
|
|
|This is not used
|-
|-
|Elevens første skoleår
|Blank
|
|This is not used
|-
|Blank
|
|
|This is not used
|This is not used
|-
|-
|Stamklasse
|Roller
|
|
|-
|Stilling
|
|
|
|
Line 210: Line 179:


===File structure for Personale-hold.txt===
===File structure for Personale-hold.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"
|+
|+
Line 217: Line 185:
!UMS
!UMS
!Remarks
!Remarks
|-
|ElevID
|
|
|-
|-
|Skolekode
|Skolekode
Line 226: Line 190:
|
|
|-
|-
|Skolenavn
|AnsatID
|
|
|
|
|-
|-
|Fornavn
|HoldID
|
|
|
|
|-
|-
|Efternavn
|Holdnavn
|
|
|-
|CPR
|
|
|-
|Adresse
|
|
|-
|Område
|
|
|-
|Postnummer
|
|
|-
|By
|
|
|-
|Klassetrin
|
|
|-
|Klassespor
|
|
|-
|Elevens første skoleår
|
|This is not used
|-
|Stamklasse
|
|
|
|

Revision as of 09:43, 2 February 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


File:Tabulex Tea Student2.jpg

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
File:Tabulex Tea Student Groups.jpg

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
Stilling
File:Tabulex Tea Staff.jpg

File structure for Personale-hold.txt

Admin system UMS Remarks
Skolekode
AnsatID
HoldID
Holdnavn
File:Tabulex Tea Staff Groups.jpg

FAQ