The Challenge

Active Directory or other directory services at school offer many advantages, e.g. users do not need to set up their passwords individually on each computer.

But even so, managing the many users with the high fluctuation at a school is a challenge. Who wants to manually add or delete the many new students in each new school year?

The solution is a mass import of students. Data source for this is often e.g. an Excel file:

Excel file with student names and school classes


To this purpose, a programme will be developed to meet the special needs of the school:

UML - Use case diagram

UML - Use case diagram


For the sake of simplicity, the import takes place from a comma-separated file. This is product independent and no special drivers or interfaces are needed.
Furthermore, comma separated files can be generated from any data source.

surname;first name;date of birth;school class
Colligan;Manda;22.09.2004;c1
Hickle;Sara;31.01.2003;c2
Murchison;Jeffrey;01.09.2002;c2
Thieme;Madelaine;02.12.2000;c1
Tarleton;Vito;22.02.2004;c2

In fact, semicolons are often used as separators.


Last modified: Tuesday, 17 September 2019, 1:15 PM