Jump to content

iceman

Members
 View Profile  See their activity

  • Posts

    99

  • Joined

  • Last visited

Reputation

10 Good

About iceman

  1. iceman
    I thought just for reference I would detail here the steps that created the problem in case anyone else experiences it. It appeared to surface after the last SIMS update prior to 9th May 2016 as it didn't happen in earlier years. In spring of 2011 one student was entered as an applicant for Sept 2011 entry but never took up their place In spring of 2013 three students were entered as an applicants for Sept 2013 entry but never took up their places For some reason the data team never marked these four as withdrawn or deleted them following their decision not to accept the place In the spring of 2016 (on 9th May) the data team uploaded into SIMS the new list of applicants for Sept 2016 entry This is where it went wrong Without notifying the user, when the 2016 applicants were entered into SIMS, SIMS also included those four historical applicants from 2011 and 2013 in the 2016 applicant list (it didn't do this in 2014 or 2015) At the same time it assigned a status to just those four such that any report based upon Population: On Roll considered them to be currently on roll Hence, at least in my case, any report based upon Population:On Roll included those four non existent students who were not on roll, had no admission number, no attendance and in one case no UPN. The data team at the school have been able to delete them from the Sept 2016 applicant list, which solves my problem, but I have advised them to report this to Capita as a bug.
  2. iceman
    I'll tell the school to find out how to delete them, or at least mark them as withdrawn - it's their problem! I quite agree. When it was all a huge set of DB4 files it was relatively straight forward to create a synchronised 'replicated' version of the data in a proper SQL database and then use that copy for analysis. But as soon as they ported it to SQL I had a quick browse to see what was going on and decided it was better to use the tools they provide to extract data for the very reason you suggest - if it goes wrong then its their fault not mine. Thanks to all for your help. At least I now fully understand the problem and I have explained it all to the school. Now its up to them, together with their 'paid for' County ICT support unit, to implement the solution! Regards
  3. iceman
    Ah, yes I understand. I'll have a go with that as it would be interesting to know what is really in that status field. Might have to be later though as I shall need to go into the school to use that (I work from home using remote access into the school). I'll stick with the exports for data extraction on the grounds that 'if it ain't broke'. Trouble is it looks like something in sims is broke!
  4. iceman
    No, the only place is in my reports and also they appear in the sims 'general student list report' We have contacted the ICT services for our county and they suggest marking those four as withdrawn in order to explicitly set the status flag. However that doesn't explain why they are suddenly showing up now, after an upgrade. I also notice they are now showing up in many other reports using population students on roll that are nothing to do with me eg ParentPay and GroupCall exporter to various external bodies like go4schools and sisra. I think we shall have to delete them.
  5. iceman
    Thanks for that. I know a lot about SQL but don't know anything about the SQL Query Analyser tool - don't even know if we have it or where to get it. However if that allows me to run SQL queries against the sims database that would greatly simplify my development work!
  6. iceman
    No, that's also odd. They don't appear in the student search with status selected as , current, guest or any of the other possible values. They only appear in reports.
  7. iceman
    @jinnantonnixx Yes they look like they have a status of null, and a null admin number - that's what is causing the null conversion error in the external program. How would I check what is actually in that field? After all an empty string could look like null on the screen. Come to think of it how could an empty string get in there anyway and why would it suddenly appear now?
  8. iceman
    Hello Bob, glad you picked up my post. It gets worse, when I added the admission date and leaving date I got some really strange dates - see below. That would seem to indicate that the data team is wrong, they are not pre-admissions for sept 2016 but from much earlier. But those students have never been exported before now and the report hasn't changed for ages. I might add that I don't deal with the data entry side of sims at all, the data team do that. My role is the analytical processing the data that is already in sims
  9. iceman
    I have several SIMS reports that export data to xml files every night for further processing externally. All of them are based on: Data area: Student - Population: On Roll They have all been running fine for a year or so. On 9th May the external processing reported an error which I traced to the reports exporting four students who were not on roll and did not have an admission number or any attendance record. They had simply been entered into SIMS by the data team as being accepted for a September 2016 intake. As a test I added the student status field to one of the reports and you can see that the status is not shown as 'on roll', so they shouldn't have been exported. We are running SIMS Build 50 ver 7.168. Is this a bug introduced by the latest upgrade? Below is the design of one of my reports and the preview showing the four students who should not be there I think I may be able to do a workaround by explicitly adding a filter where student status is 'on roll', but I've never had to do that before. Any other suggestions?
  10. iceman
    @vicpaw Yes, I export the aspectID and use that in my database as a PK, but that's quite easy to ripple through if/when the ID changes on recreation.
  11. iceman
    OK fixed it. I wrote a report to show me aspects and templates and found it in a dummy test template that I had made nearly 6 months ago and had completely forgotten about (as you mentioned, Bobsmith). Deleted that template and then it was a five minute job to delete the aspect in question, recreate it with the same name but as decimal and pop it back into the proper template in place of the integer one. All that effort because the Dep. Head told me they would only ever need integers stored in that aspect - except when they don't!
  12. iceman
    Thanks Vikpaw, that's essentially where I had got to. Fortunately only one single value had been entered into the aspect. The SIMS manager had entered the number 38 for one student and then tried to enter 27.6 for the next one, that's when they discovered the problem! My main issue is that this aspect, along with many others, is only really used for data entry and then exported overnight to an external SQL database and processed from there in another program. That program looks for the aspect name Aspect_1 in the database in order to decide what to do with it. If I change the templates and reports to use the name Aspect_2 instead, then the external database needs to be changed, the external system changed to use Aspect_2 everywhere where it used to use Aspect_1 and then recompiled and re-distributed to everyone that uses it. That's much more work than simply deleting Aspect_1 in SIMS and recreating it as a decimal one. But deleting it has defeated me so far as SIMS keeps telling me its being used, even though I've deleted the data in this aspect and removed any reference to it from the template, mark sheets and reports that used to use it.
  13. iceman
    Thanks but I sorted out the grade set thing within minutes of posting my question (as usual). What!!? Surely not. Never heard of such a thing. Actually they communicated quite clearly, its just the idiots devising this project hadn't thought through the implications before they communicated. If only they would simply tell me what knowledge or information they wanted to get and left me to work out how to get it from the data it would be done by now.
  14. iceman
    Its more of a convenience than a necessity. I have templates and mark books that use Aspect_1 and reports that export it so they would all need to be changed to use Aspect_2 and, more importantly, so would all the follow up processing done by the external database and analysis system as it needs to know what the aspect is called. But either way, without deleting the Aspect_1 SIMS gets even more cluttered up with yet more aspects that aren't used by anything.
  15. iceman
    @PhilNeal Yes you are right if SIMS treats this in a simplistic manner, You obviously cannot convert a textual data type into a numerical one if it already contains the value 'Fred'. But there are several routes by which databases will allow data type changes - or at least should do. If all the data in the aspect has been deleted, which I had already done using the method that RootsSchImp mentioned, then there would be no conversion issues. Secondly, if the data type is changing from a base type to a derived type. In my case that is what I wanted to do, change an integer type to a floating point type. Every integer can be expressed as a floating point value as the field size is increasing (clearly it is more problematic the other way round but SIMS handles it when you copy/paste columns) . SIMs could even change the data type using one line of SQL executed against its back end database ALTER TABLE TheTableName ALTER COLUMN TheAspectName float; The only issue would be if the aspect is used as a foreign key to another table. But if so it would make sense to for SIMS to have set the constraints so that changes in the FK are rippled through anyway. Never mind, thanks to all who replied. I deal mainly with SQL databases and the odd user interface of SIMS always frustrates me. It seems to get in the way more than help. This is evident by the many answers in this forum which, whilst absolutely correct, usually involve lengthy, repetitive manual operations in SIMS to get something simple done.
×
×
  • Create New...