I'm interested in this because I am responsible for a pupil tracking program and have met and solved this bug.
Here's an excerpt from an email I received from a (very useful) user.
No, the user was doing nothing wrong - users like that are absolutely invaluable."Anyway, I think I may have tracked down the problem. I experimented with importing a ctf from SIMS of just one child, who I know used to be on our SEN Register but has since been taken off. On the ctf it says:
I can see that it shows the child was put at SAP in 2005 but removed from our SEN Register in 2008, giving him the code N, which is what you get in SIMS when you remove a child’s SEN status and means ‘No Special Educational Need’.
But - when I import the ctf into ****** ******* it brings him up as a P under SEN status.
Hope this helps. Please let me know if you think we are doing something wrong."
It was my mistake....my Tracker was keeping only the last SEN value.
Once the problem was known it took only a couple of hours to correct it (storing all the values and their dates and sorting by date - taking the latest). BTW, you can't rely on the last date being the latest.
Since then I've also put in a copy and paste function. The user can export a report from CMIS with two fields, UPN and SEN Status (or anything else you want), copy both columns and then paste into the Tracker grid.
How can the developers of the program you use say it is not their fault?
It's easy to open the CTF and find a child with two or more SEN entries and decide whether or not the program is picking up the most recent one. If it hasn't then it is at fault.