SVP_update

Updating the School Administration Software (Schulverwaltungsprogramm, SVP)

NOT using the ID

If you have NOT used Field 5 in students.csv (the ID from your SVP), the upgrade is easy: just use andupload the new file.

Using the ID

If you are using the ID from your SVP as Field 5 in students.csv, and you are updating to another SVP, then this ID will change!

We assume:

• ID changes
• most students have the same surname (sn), given name (givenName) and birthday.
• some students have typos in sn,givenName,birthday
• students may be in another class (new school year)
• If your new SVP is ASV-BW, you should consider the sophomorix filter for asv-bw

This is the recommended way to upgrade:

1. upload the new file using sophomorix-nefile (maybe using a filter)

2. Test the data with

   sophomorix-check --edit-distance 0

   (This matches only students with identical sn,givenName,birthday)

3. Only updates the exact matched students with (use -i first to see what is happening)

   sophomorix-update

   If the exact matched students are in the same class, the ID is updated

4. To make sure the new ID is updated do the steps again:

   sophomorix-check --edit-distance 0

   sophomorix-update

   Now all the IDs are updated

5. Check the data for small changes:

   sophomorix-check --edit-distance 1

   sophomorix-update -i

   sophomorix-check --edit-distance 2

   sophomorix-update -i

   sophomorix-check --edit-distance 3

   sophomorix-update -i

   sophomorix-check --edit-distance 4

   sophomorix-update -i

   Refer to your school office if you have suspicious data to update

   • i.e. Dummy bithdays like 1.1.2000
   • i.e. changes of students that are in the school since a long time (possible typos)

   Maybe you have to request a new data file from your office at this stage

6. If you have good matches (only typos), report them to the office and update the data (will be fixed next time):

   sophomorix-update

7. And again to also update the ID:

sophomorix-check

sophomorix-update

8. Add the new users:

   sophomorix-add

9. It is recommended NOT to delete users right after the SVP update. Just wait a few weeks to make sure all users have a usable account.