← Previous page

Field Restrictions for Uploading Data Sets

Subjects

Field Heading	Field Type	Number of Characters
Subject Code	Text	Max 5
Subject Name	Text	Max 32

Subject codes must be unique in the system.

Example of Subjects CSV File Layout:

Subject Code	Subject Name
MLIT	MLIT
MATH	Mathematics
NS	Natural Sciences
ENG1	English 1st Language
AFR1	Afrikaans 1st Language
SS	SS
LO	LO
GEO	GEO
HIST	HISTORY
ART	ART
AFR2	Afrikaans 2
AFR3	Afrikaans 3
AFR4	Afrikaans 4
PE	PhysED

Educators

Field Heading	Field Type	Number of Characters
Educator Code	Text	Max 5
Title	Text	Max 16
Initials	Text	Max 5
Surname	Text	Max 32

Educator codes must be unique in the system.

Example of Educators CSV File Layout:

Educator Code	Title	Initials	Surname
GG	Mr	G	Groenewald
AS	Mr	AF	Sebanda
AZ	Mr	AA	Zeelie
DD1	Ms	D	Domingo
DD2	Mrs	DR	Dawson
HH	Mr	H	Harold
WS	Mr	W	Singh
CC	Ms	C	Cooper
BB	Ms	BE	Banda
FF	Mrs	F	Fourie
EE	Mr	EBA	Espach

Grades

Field Heading	Field Type	Number of Characters
Grade Code	Text	Max 5
Grade Name	Text	Max 16

Grade codes must be unique in the system.

Example of Grades CSV File Layout:

Grade Code	Grade Name
GR07	Grade 7
GR05	Grade 5
GR06	Grade 6
GR09	Grade 9
GR08	Grade 8
GR04	Grade 4
GR10	Grade 10

Classes

Field Heading	Field Type	Number of Characters
Grade Code	Text	Max 5
Class Code	Text	Max 5
Class Name	Text	Max 16

Grade Codes must be valid – They must exist in the system prior to the Import of the Classes.

Grade Codes & Class Code combinations must be unique in the system.

Example of Classes CSV File Layout:

Grade Code	Class Code	Class Name
GR08	8A	Class 8A
GR06	6A	Class 6A
GR06	6B	Class 6B
GR05	5B	Class 5B
GR08	8B	Class 8B
GR07	7A	Class 7A
GR05	5A	Class 5A
GR05	5C	Class 5C
GR05	5D	Class 5D
GR09	9A	Class 9A
GR04	4A	Class 4A
GR10	10A	Class 10A
GR10	10C	Class 10C
GR10	10F	Class 10F
GR10	10D	Class 10D
GR10	10B	Class 10B

General

WARNING:

(i) When data is uploaded, the system does a check to determine if the specific information already exists in the database. Should

this be the case, the information is updated. If the Information does not exist, a new entry is created.

(ii) Should the user not adhere to the field rules above, the Import process will ignore the specific entry.

Golden Rule: DO NOT MAKE USE OF COMMAS IN ANY OF THE FIELDS THAT IS ENTERED.

Made with help of Dr.Explain

← Previous page