+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, SIMS : Batch Schedules : Auto Running Reports in Technical; Hi All I have tried to resolve this but failed and noone on the Capita forumn has a solution either, ...
  1. #1

    Join Date
    Apr 2013
    Location
    Nottingham
    Posts
    25
    Thank Post
    11
    Thanked 6 Times in 2 Posts
    Rep Power
    5

    SIMS : Batch Schedules : Auto Running Reports

    Hi All I have tried to resolve this but failed and noone on the Capita forumn has a solution either, so I thought EDU GEEK might be a more appropriate forum to seek assistance, so here goes:

    I've built a nice little behaviour reort in the 'SIMS Report Designer'.

    Our SLT team want it run at 3.30 pm every day.

    I've managed the following with Batch Schedules (point 1 done by server geek team):

    1) Set a windows schedule task to run the SIMS AutoReports.exe software on a daily basis at a given time

    2) Gone into Focus -->Alerts --> Schedule Reports , to create some daily report requests - to be run by (1) above.

    3) The daily reports from (2) to send output to me

    Now here's the QUESTIONS for you: -

    - After some jiggery pokery we managed to get windows scheduled task to run.

    - Windows runs the schedued jobs and says it finished OK.

    - NO output appears in my scheduled reports home page widget / panel. WHY IS THIS ? -

    - I cannot find where the excel spreadsheets from the scheduled reports have gone to. WHERE HAVE THEY GONE?

    Any tips or advice will be greatly received.

    BTW : The SIMS documentation that describes the setting up process for this is out of date and does not match what you actually have to do.

    Many thanks.

    Regards Phil
    Last edited by bwfc_nottingham; 8th January 2014 at 04:20 PM.

  2. #2
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    476
    Thank Post
    181
    Thanked 86 Times in 70 Posts
    Rep Power
    51
    I use command line reporter and .bat files to export some data out of SIM's reports on a schedule every evening for our own analysis,tracking and Intervention system with help from some people on Edugeek, these are only sort of raw data so CSV (Excel) not sure this is any use to you it wouldn't display the info in SIM's but would get the data out on a schedule.

    See below if you use notepad and just copy the below in and alter the relevant details then save these as a .bat file if you double click the .bat file as long as you are able to run .bat files it will run the report you and save the report to the C drive on the machine they are run on if you change /OUTPUT="c:\reportname” for example you can change the location to a different drive you would just then need to schedule this .bat file.

    "c:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.exe" /USER:simsusername /PASSWORD:simspassword /SERVERNAME:simsservername\database /DATABASENAME:simsdatabasename /REPORT:"reportname " /OUTPUT="c:\reportname”

    Example

    "c:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.exe" /USER:Jbrown /PASSWORD:john /SERVERNAME:SIMSADMIN\SIMS20081234 /DATABASENAME:sims1234 /REPORT:"mysstudents grades" /OUTPUT="c:\My Students Grades"

    Not quite sure if this is what you after.
    Last edited by Steven_Cleaver; 8th January 2014 at 08:20 PM.

  3. Thanks to Steven_Cleaver from:

    chrisateen (10th January 2014)

  4. #3

    Join Date
    Apr 2013
    Location
    Nottingham
    Posts
    25
    Thank Post
    11
    Thanked 6 Times in 2 Posts
    Rep Power
    5
    Thanks steven, i am trying to run it via the SIMS database server....according to SIMS you can do this.

    My background is a Business Analyst and i am used to sophisticated batch schedules running on unix servers. I cannot believe how weak SIMS and windows servers are for scheduling batch runs. The way SIMS works is very weak - you appear to only be able to schedule one report event per day.

    I could use your method, but i don't want me to be a single point of failure. Our LEA support desk sre unable to resolve my problem

    Thanks for your reply

    Phil


    Quote Originally Posted by Steven_Cleaver View Post
    I use command line reporter and .bat files to export some data out of SIM's reports on a schedule every evening for our own analysis,tracking and Intervention system with help from some people on Edugeek, these are only sort of raw data so CSV (Excel) not sure this is any use to you it wouldn't display the info in SIM's but would get the data out on a schedule.

    See below if you use notepad and just copy the below in and alter the relevant details then save these as a .bat file if you double click the .bat file as long as you are able to run .bat files it will run the report you and save the report to the C drive on the machine they are run on if you change /OUTPUT="c:\reportname” for example you can change the location to a different drive you would just then need to schedule this .bat file.

    "c:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.exe" /USER:simsusername /PASSWORD:simspassword /SERVERNAME:simsservername\database /DATABASENAME:simsdatabasename /REPORT:"reportname " /OUTPUT="c:\reportname”

    Example

    "c:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.exe" /USER:Jbrown /PASSWORD:john /SERVERNAME:SIMSADMIN\SIMS20081234 /DATABASENAME:sims1234 /REPORT:"mysstudents grades" /OUTPUT="c:\My Students Grades"

    Not quite sure if this is what you after.
    Last edited by bwfc_nottingham; 8th January 2014 at 08:35 PM.

  5. #4
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    476
    Thank Post
    181
    Thanked 86 Times in 70 Posts
    Rep Power
    51
    Quote Originally Posted by bwfc_nottingham View Post
    Thanks steven, i am trying to run it via the SIMS database server....according to SIMS you can do this.

    My background is a Business Analyst and i am used to sophisticated batch schedules running on unix servers. I cannot believe how weak SIMS and windows servers are for scheduling batch runs. The way SIMS works is very weak - you appear to only be able to schedule one report event per day.

    I could use your method, but i don't want me to be a single point of failure. Our LEA support desk sre unable to resolve my problem

    Thanks for your reply

    Phil
    Hi Phil

    The method above is what we started with we sort of now have an App on the Server that extracts multiple reports on a schedule and then imports them into their own SQL database which then produces the analysis via a web front end so this all runs automatically overnight and the web front end is accessible by staff with analysed results but took us about a year to get their with various help from here and other sources.

    What you are trying to do is quite high level but sure someone here will have an idea I am sure as is a great Forum with some really bright people. SIM's works well for a lot of things but it can be sometimes difficult to get sometimes very specialised things out or setup. Hope you have some luck with this.

  6. #5

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    274
    Thank Post
    27
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    I've never tried the AutoReports, but assuming you're producing Excel output via the macros, you might need to check if there's a macro security issue.

    Just a thought though - if you'd count as a single point of failure, so would sending the scheduled reports only to you! Is it worth looking at setting up a report that more than one person could run (with a simple guide maybe), and have someone run it each day as part of their daily tasks?

  7. #6

    Join Date
    Apr 2013
    Location
    Nottingham
    Posts
    25
    Thank Post
    11
    Thanked 6 Times in 2 Posts
    Rep Power
    5
    Quote Originally Posted by MattMitchell View Post
    I've never tried the AutoReports, but assuming you're producing Excel output via the macros, you might need to check if there's a macro security issue.

    Just a thought though - if you'd count as a single point of failure, so would sending the scheduled reports only to you! Is it worth looking at setting up a report that more than one person could run (with a simple guide maybe), and have someone run it each day as part of their daily tasks?
    Matt

    The SIMS report setups lets you specify multiple recipients. Once we get the reports running, then we will add the respective staff to the recipient list.

    Focus ----> Alerts ----> Schedule Reports

    Regards

    Phil

  8. #7

    Join Date
    Mar 2013
    Posts
    172
    Thank Post
    42
    Thanked 6 Times in 5 Posts
    Rep Power
    29
    @Steven_Cleaver

    Thanks for that. Really helped as a teacher wanted some reports running and I didn't want to sit there and run the reports each time by myself.

    It's a shame I can't auto schedule it (I don't have permissions to do so )

    A question though. If I have a report which requires certain parameters (e.g I need to select the aspect name and the result set) how do I go about it?
    Last edited by chrisateen; 10th January 2014 at 11:49 AM.

  9. #8
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    476
    Thank Post
    181
    Thanked 86 Times in 70 Posts
    Rep Power
    51
    @chrisateen

    No problem, I use this method occassionally if SIM's is having an issue with a large report as it seems to run pretty silently without crashing my PC.

    To get certain parameters for example aspect name and result set you would need to design a custom report with those parameters, you add your information so in SIM's if you go to Reports --> Design Reports then select the information you want in the report, you would need to filter this to get those parameters aspect name and result set etc then save the report then use same method to extract the report as previous post please see attached image in case this helps.Filtred Report.JPG

  10. #9

    Join Date
    Mar 2013
    Posts
    172
    Thank Post
    42
    Thanked 6 Times in 5 Posts
    Rep Power
    29
    Quote Originally Posted by Steven_Cleaver View Post
    @chrisateen

    No problem, I use this method occassionally if SIM's is having an issue with a large report as it seems to run pretty silently without crashing my PC.

    To get certain parameters for example aspect name and result set you would need to design a custom report with those parameters, you add your information so in SIM's if you go to Reports --> Design Reports then select the information you want in the report, you would need to filter this to get those parameters aspect name and result set etc then save the report then use same method to extract the report as previous post please see attached image in case this helps.Filtred Report.JPG
    I dont think I have explained myself properly. I have a report in SIMS that downloads student exam marks in a subject then used vba to do all the calulations so that the data is analysed automatically when the report is downloaded. When I run the report it would prompt for a result set and an aspect name.

    If I want to download the report for each subject I will have to run the report manually for each subject (one for maths then one for english e.t.c).

    I know I can set up different reports for maths, english, science and for each result set butthat would take ages and will just have a huge list of reports in SIMS.

    What would be easier is to use command reporter to run all the reports I want then tell it which aspects and results set I want it to download.

  11. #10
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    476
    Thank Post
    181
    Thanked 86 Times in 70 Posts
    Rep Power
    51
    Is this information in a Marksheet you should be able to get all the data for all subjects in a Marksheet if they are held somewhere. I may be wrong and not quite understand what you are after but I think you need to filter by those parameter's and should be able to get this information in one report the Result Set as if you just use the one Result Set it will just pull the Grades for that result set is probably the key along with year if you can. As I say It might be me not quite grasping what you are after.

  12. #11

    Join Date
    Mar 2013
    Posts
    172
    Thank Post
    42
    Thanked 6 Times in 5 Posts
    Rep Power
    29
    Filtred Report.JPG

    I have done a report similar to what you have in the screen shot already. The only difference is that the assessment filter is prompted at run time if I do it via SIMS and I want it so that only 1 result set can be selected rather than have all the result set selected like in your screen shot.
    Now I could do it the way you did it in your screen and select multiple results sets then do some macros that would filter and analyse the data I want. Problem is that if I do it similar to how you have it in your screen shot I will be downloading a huge amount of data which will be too messy
    However what I would like to do is use command line reporter to only select for example where the resultset is End of KS3 Expect and the Grade set is KS2 Sub Levels.

  13. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Autoreports will need a fixed report, so if you ask for parameters at runtime it won't work. You will need to run multiple reports, or a single large one that you parse later.

    Command reporter allows you to pass parameters to it at runtime and is a good alternative. The difference with this will be that it's not controlled / scheduled through the SIMS interface. Also there have been some discrepancies with the way a report runs in the GUI and how it runs through CR. Particularly with date ranges. You would need it to produce an output to a location which you would then have to access outside of SIMs.

    Autoreports are run and held in the doc store and then accessed by the user through SIMS, so it's an easier way to force lay staff to look at something.

    With autoreports, you need to check the event logs and scheduled task logs to see if there are any failures, and you might need to get your 'geek' team to manually run it for you as the specified user to see what is going on. You need to run it with a SIMS account that can actually run the report and get data out, i.e. the running user must have permission, so if they used a dummy account in the command line for the scheduled task it won't run. It also needs extra perms to do the scheduled reporting. The windows user running the task also needs pretty high level access to the server files.

    One thing to bear in mind, normally they recommend schedules to run over night as normally, once set up, that one task will run all scheduled reports throughout the system. Is someone really going to look at the data at 15:35 ? If not, it might be better to run it in the evening or over night so it's either done for the day before, or ready in advance for that afternoon depending on the data. I don't really see the urgency for grades.

    There was a thread quite recently when someone kept failing to configure it right, and it ended up being the sims perms weren't fully applied to the sims user, so worth double checking that. Otherwise, start with a high up permission, e.g. admin on task and sysman on sims user just to prove it can work then reduce down perms.

  14. #13
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    476
    Thank Post
    181
    Thanked 86 Times in 70 Posts
    Rep Power
    51
    Quote Originally Posted by chrisateen View Post
    Filtred Report.JPG

    I have done a report similar to what you have in the screen shot already. The only difference is that the assessment filter is prompted at run time if I do it via SIMS and I want it so that only 1 result set can be selected rather than have all the result set selected like in your screen shot.
    Now I could do it the way you did it in your screen and select multiple results sets then do some macros that would filter and analyse the data I want. Problem is that if I do it similar to how you have it in your screen shot I will be downloading a huge amount of data which will be too messy
    However what I would like to do is use command line reporter to only select for example where the resultset is End of KS3 Expect and the Grade set is KS2 Sub Levels.
    I have edited a report I have to just pull End of KS3 or KS2 Sub Levels but both as Result Sets if I try and pull End of KS3 as a Result Set and the Grade Set Ks2 Sub Levels SIM's throws a wobbly but is probably how I am doing this, I did have issues when trying to extract stuff like this and is why I sort of take everything out and deal with just using the info I
    want outside this a see if the screen shot helps.
    Ks3 and Ks2 Sub.JPG

    To be honest I take everything out as regards Data, Classes, Students and Teachers in about five reports put these into an SQL Database and use web front end to analyse it this is all automated and runs overnight so Staff enter data as they were before the system automates all the Analysis, so Graphs, Colour Coding, By Student, Class, Department, Teacher and Teachers just simply click to go from Class to Student in the web front end and we have also added in Intervention so all Staff and SLT can easily see all data has been hugely successful here as it means staff are looking at and using the Data and acting on this in regards to intervention which really is what we were after a simple system for staff to use and get there analysis done for them so that they could use this to undertake Intervention where this was required and we could measure the success of the intervention and what works best. We have invested quite a lot of time and some money in this to get it to this stage and few people of Edugeek helped me get my head round extracting the info out of SIM's including Vikpaw who has posted a reply so would have a look through his reply as he has much better understanding of SIM's than I do.

  15. #14

    Join Date
    Mar 2013
    Posts
    172
    Thank Post
    42
    Thanked 6 Times in 5 Posts
    Rep Power
    29
    @vikpaw @Steven_Cleaver

    Thanks for the response. It seems like the easiest way is to create multiple reports in SIMS and get command reporter to extract the data or use the method that Steven_cleaver uses. Autoreports is also something I need to look into however it sounds more complicated than using command reporter

    I managed on Friday to use command reporter and task scheduler to run some basic reports for a teacher who needed some reports exported weekly and the IT person was more than happy to give me permission to use task scheduler which means I can now play around a bit more with extracting data

    I wished I knew how to use command reporter a long time ago as it would have saved me a lot of time and effort in the past.

  16. #15
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    476
    Thank Post
    181
    Thanked 86 Times in 70 Posts
    Rep Power
    51
    Quote Originally Posted by chrisateen View Post
    @vikpaw @Steven_Cleaver

    Thanks for the response. It seems like the easiest way is to create multiple reports in SIMS and get command reporter to extract the data or use the method that Steven_cleaver uses. Autoreports is also something I need to look into however it sounds more complicated than using command reporter

    I managed on Friday to use command reporter and task scheduler to run some basic reports for a teacher who needed some reports exported weekly and the IT person was more than happy to give me permission to use task scheduler which means I can now play around a bit more with extracting data

    I wished I knew how to use command reporter a long time ago as it would have saved me a lot of time and effort in the past.
    Me too as regards Command Reporter wish I had heard of this a couple of years ago as I was stuck for some time on how to automatically extract what I wanted on a schedule as we were stuck a bit until I found someone mention this on Edugeek as I was planning on getting the info straight out of the SIM's SQL but when we run SQL profiler on the SIM's database to try to look at how to extract the info it straight from SQL it creates some info on the fly so is difficult to link the information for example until a Marksheet is run, straight out of SQL would be cleaner but is difficult to link the data through and extract straight from SQL tables we did give this a go. Have found that Command Reporter works really well for getting the data out just have a method for analysing it after, Excel Vba or Excel templates as that what is what we used initially and this worked well with App front end to link the data but the only downside was that if students move class or leave etc the excel stuff was quickly out of date, might be also worth looking at SISRA as this doe a massive amount of analysis from uploading data again the only downside isn't live so any changes on Time table etc and it is out of date after upload so have to extract from SIM's and upload but analysis is excellent especially for SLT if they are reasonable with understanding systems and are happy to spend a bit of time getting to learn this.

    If you have a way through VBA of automating the analysis instantly this should work well, using our system has mean't that the MIS Officer is now analysing the data a lot more instead of just manipulating the data and driving training etc with our staff and SLT and highlighting particular areas where staff should look in regards to intervention all of this is done in a really positive way and staff see it as support rather than Performance Management and we have staff asking here to provide training on understanding and interpreting the data with effective use of this.

    We have tried to link all our IT systems together to look at the way we can help with student progress which at the end of the day is what we are after to make sure students progress and get the best grades along with best prepared for their next step be that education, apprenticeship or work. Progress Systems, we use various systems and methods to try and achieve this, we think we are going in the right direction hopefully but always more work.



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Task Scheduler and running process
    By adamf in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 13th April 2010, 09:42 PM
  2. Replies: 6
    Last Post: 16th December 2009, 12:02 PM
  3. script files to auto run
    By ajbird in forum Windows
    Replies: 0
    Last Post: 11th November 2009, 02:45 PM
  4. Block users running a batch file to run command.com?
    By reggiep in forum Windows Server 2008
    Replies: 3
    Last Post: 1st August 2009, 04:44 PM
  5. Replies: 3
    Last Post: 10th March 2006, 02:54 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •