Jump to content

pubgrub277

Members
  • Posts

    157
  • Joined

  • Last visited

Everything posted by pubgrub277

  1. Does anyone have routines in place to delete old staff and students from Sims? I know i can manually go through and delete old students (im talking left more than five years ago) but i have to do this one by one (buttons clicks to automated where possible). Is there a routine to remove old staff records? Again I'm talking people who haven't worked for us for years. Some records hold NI numbers and bank details and im reasonably sure we don't have a right/need/Want to hold the data any more. We've had a big lecture about data security and information management for our LEA recently as well. Am i the only one in this position or am i missing a trick somewhere?
  2. That's also part of our policy. TBH i'm sick of hearing "when have i got time to check x number of marksheets" from Heads of department. I always feel like it implies i've got lots of time on my hands to check a few thousand myself in my spare time (between forum posts at least). my systems are damn near perfect at times if i could just get staff to do there part and do the input.
  3. Anythings got to be better than the system i use. finally sitting in my office rocking backwards and forwards repeating the phrase, "assessments are due, assessments are due!" until the people in white coats take me away. someitme i think they are al ignoring me edit: assesment due at the end of this week and have alreay had the classic conversation "what do we record again" and "how do we know what the levels are" FFS
  4. I'm running a report on Behaviour records. The filter is for records between dates, hence start and end date. Is your report in another thread on here? i seem to remember reading it earlier for weekly attendance? can't see why it wouldn't work in the same vein as this.
  5. No it works perfectly. changing the date manually in a .bat file at the moment but am scripting something else to amend how that runs. I don't plan on amending the report in sims only using the scripts to export the data.
  6. sorry i was busy posting/working both times when you replied. i have seen you excellent correction and understand what i need. Many thanks again
  7. Thanks LosOjos. The first one was a misscopy&paste. with the schema tag. Your correct about the quotes and im now getting different files now when using you suggested code. DateDateRangeDate is between2011-11-01T13:39:042011-12-01T13:39:04 at least now i can skip having to prepare a /paramafile when automating the report and pass the values direct to the script. Thanks for you help. Much appreciated.
  8. /params:"2011-12-01T00:00:002011-12-02T00:00:00" This runs, give no errors but seems to ignore the report filter. I checked this by amending the dates in the code and the report output is always the same.
  9. I've managed to generate a couple of error messages whilst trying various strings of data. /params:"2011-11-29T13:39:042011-12-01T13:39:04" Gives me If i use the whole of the parameters text from the pramadef file i've generate DateDateRangeDate is between2011-11-01T13:39:042011-12-01T13:39:04 i get
  10. i Know a few people have been looking at CommandLineReporter for a while and ive had a lot of success automating my reports using the /pramdef and /paramfile switches in my coding. if im understanding this correctley though i should be able to use /params:"ABCD" (from the help file in cmd) to supply the code directly in my script rather than having to refer to another file. Does anyone know this format? Do i need to buy into the SDK to use a string as opposed to using a paramfile? The functionality of using commandlinereporter is the same, just a little easier if i can use a string instead of having to prep a file before running the rest of my code.
  11. Just been having a look at Bromcom's teachers web folder and must say im quite impressed. It seems to give a good web based version of a MIS front end (sims or bromcoms own) for teachers to use. In the usual "all that glitters isn't gold" vein of thought, is anyone using it? How good is it in real life? What's it like to live with?
  12. pubgrub277

    SIMS

    These will probably be the only tablets i see at Christmas. Just about the only one the wife will let me spend money on to.
  13. I don't for the same reasons but always have that worry that something will break after an update (regardless of how many tests have been done at other sites/on test data). We depend so heavily on this system now that i find myself thinking should i make the effort/time just to be sure it works on our data.
  14. They cant win either way really can they. some will want it now now now and others will be of the wait and see type. I would say that it does seem a very small minority and perhaps on this occasion they might have left it up. Does anyone test a version of the updates on a mirror/non live environment but with their data? i've used a VM a few times to test various things and wondered if anyone has the time to do this a matter of course?
  15. pubgrub277

    SIMS

    we had a member of SLT who carried around a Fujitsu machine a newer version would be Tablet PCs STYLISTIC Q550 Fujitsu. I think they run normal versions of windows still so a standard install would do. I would have to agree that if your showing someone how to use a system, showing them on their own machine would probably be a better idea.
  16. I've just started to look at the Bromcom option and am very impressed so far. Would be good to hear some feedback from people actually using it. In the demo's ive seen in looked more pleasing on the eye then TASC and with the same kind of functionality.
  17. Vikpaw, staff are asked to check after the import, however i fear that they will cast an eye over it and say "yes, some things there for everyone". I find my checks are more rigorous than our HOD or class room staff. it always amazes when it comes to writing reports and we always seem to and up with "Dave is working well and she is a pleasant student to teach!!" having seen that other people have had an issue i always like to check and make sure to remove any doubt.
  18. TBH i've never had anyone report that problem to me/ noticed it with our import. (very large imports so only ever check a small percentage) I think i might have to do an audit when i next run it in a few weeks time and check the import is OK.
  19. Are u you using windows server 2008? Do you need to change the UAC to start the service as administrator?
  20. are the results entered on the spreadsheet in the grade set assigned to the aspect in sims? You should get a report when the files finish importing with any values skipped or updated or added. I'd check that first.
  21. I use command line reporter and excel to automate sending out weekly data to staff. part of the maco i use is: Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = Range("H1")'Cell of the to: persons email form tutor .CC = Range("I1") & ";" & Range("J1") ' People being copied in i.e heads of year .Subject = "Weekly BMR Data" .Body = "enter body text here" .Attachments.Add ("U:\sample file.xls) .send 'Or use display to preview message first End With This creates the email based on values in cells H1 for the To feild and I1 & J1 for CC. Other macros filter the list/ data and graphs and save as .pdf. the attachment part of the above macro is set to include the created file (this stops staff breaking/playing with my sheet templates) to send to staff.
  22. Its how i get staff to do their student tracking at home. Bulk export and import of formatted sheets can be done through: Tools> performance > Assessment > System Utilities > Marksheets. Use the wizard to export or import to/from a directory you specify.
  23. no it's not free, i don't think I've seen a free solution. You sound like we're in a similar boat "why pay for it when we can just get so and so to do it manually!!" It took a while and a change of line manager to understand that if it takes me two hours now to script it it takes me 30 seconds for the next 100 request for a task, opposed to an hour everytime you want something.
  24. It sounds to me like there a a great number of us, as mentioned in other posts, are all working along the same lines with things like CLR to get at data so we can manipulate it outside of SIMS to produce "custom" analysis/reporting ideas (probably all our custom ideas are very similar) I would love to have a more specific group to share /Vet my coding through, being the only individual in my school working on this its often difficult to find people to bounce ideas off. I took some of my coding and ideas of templates to my LEA Sims user group, they were impressed with what we were producing but i would say they were along the lines of "users" who would want to run with the ideas rather than being at a level to contribute to the development of such things. Have you looked at cohession software's solution for writing documents to DMS.
  25. Id used =TODAY()-8 And then =today()-1 within the sheet to create the date because some of the date ranges are not always monday to friday but thanks for the tip, it will probably be very useful for some other work im doing.
×
×
  • Create New...