+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Report List in Technical; Is there a way to export a list of the reports in SIMS into something usefull (like Excel/CSV) I'm just ...
  1. #1

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,675
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45

    Report List

    Is there a way to export a list of the reports in SIMS into something usefull (like Excel/CSV)

    I'm just having a bit of a tidly up and want to get rid of all the rubbish public report staff have created and just leave the usefull ones. However to do that I need a list and I don't want to manually type them all out.

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Print Screen is the easiest way I found.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    @stuart - you realise that you can't delete other peoples reports right? you have to be the report creator and then delete it from there. unless you mean individual reports. in which case it's okay to delete whatever.

    either way, as well as print screen, the print button on most SIMS screens now does a pretty good printout, not sure if it's there on the data reports list though.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    one thing to consider is to use Categories, it allows you to effectively promote the reports that you want and categorise them. The only problem is that each user has to enable categories, however i have a flash video that hows people how to do this if required.

  5. #5

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Quote Originally Posted by vikpaw View Post
    either way, as well as print screen, the print button on most SIMS screens now does a pretty good printout, not sure if it's there on the data reports list though.
    Good point. Also, if you know where to look you must be able to get a list directly out of SQL?

  6. #6

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,675
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    Quote Originally Posted by vikpaw View Post
    @stuart - you realise that you can't delete other peoples reports right? you have to be the report creator and then delete it from there. unless you mean individual reports. in which case it's okay to delete whatever.

    either way, as well as print screen, the print button on most SIMS screens now does a pretty good printout, not sure if it's there on the data reports list though.
    Can I, with full rights to everything, not delete them? What if the person't left?

    Anyway my first point of call is to send out the list with all the public reports on to their creators and say "are these usefull/Needed by everyone?" If not then save them as private and delete the public ones.

  7. #7
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    When somebody leaves I edit their Password, log in as them and then delete the unwanted reports!
    Care has to be taken though that other Staff are not using the Public ones!
    Invariably I have a copy of the original as they normally clone mine and then edit them just slightly and save as Private!

  8. #8

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Quote Originally Posted by Stuart_C View Post
    Can I, with full rights to everything, not delete them? What if the person't left?

    Anyway my first point of call is to send out the list with all the public reports on to their creators and say "are these usefull/Needed by everyone?" If not then save them as private and delete the public ones.
    Currently only the author of the report (as in the username) can delete reports. Doesn't matter how many permissions you have.

    Best advice is to reactive that user account in SIMS, login as that user, and tidy up. I did it, it is a pain but once done is out of the way.

  9. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Not even with global GOD rights. If someone leaves you have to reset their password and log in as them to delete their reports. great hey.

    If they're not useful i wouldn't even bother telling them to make them private. just delete.

    What you can do is to export any reports you're not sure about, so can re-import later if someone complains. i backup all my custom reports this way, as the templates have a way of getting borked during editing at times.

  10. #10
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    175
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    I've just knocked up a quick utility to list all the reports in Sims.

    http://blog.salamandersoft.co.uk/ind...f-all-reports/

  11. Thanks to rpwillis from:

    vikpaw (6th January 2011)

  12. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    cool, does it tell you the owner too. that will be brill. wish i could test, but wont be online with work for a bit (hopefully).

  13. #12

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Now if you can only delete them as well...

  14. #13
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    There has been at least one CR on SupportNet for this for some considerable time!
    It isn't such a major issue though.
    I just delete the reports as a integral part of my procedure for removing users from the system.

  15. #14
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    175
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    Quote Originally Posted by vikpaw View Post
    cool, does it tell you the owner too. that will be brill. wish i could test, but wont be online with work for a bit (hopefully).
    Yes it does. First couple of lines from the Green Abbey test database are:

    Name,Focus,Description,IsPrivate,Creator,Allow Output Choice,Agency,Last Updated
    "ACH - School Summary by date","Student","ACH - School Summary by date","False","Adrian Blacker","False","Green Abbey School","16/06/2009 21:37:00"
    "ACH - Year/Reg Group Summary, Dated","Student","","False","Imported","False","Gr een Abbey School","31/07/2009 16:41:00"

SHARE:
+ Post New Thread

Similar Threads

  1. Exclusions Report
    By newcareer in forum MIS Systems
    Replies: 1
    Last Post: 1st October 2010, 09:06 AM
  2. Replies: 8
    Last Post: 15th December 2008, 03:41 PM
  3. SIMS Report Class List with Siblings
    By mmuk08 in forum MIS Systems
    Replies: 1
    Last Post: 24th September 2008, 03:55 PM
  4. Damage Report
    By alan-d in forum School ICT Policies
    Replies: 0
    Last Post: 26th September 2007, 10:44 AM
  5. sism report
    By Jamie_a in forum MIS Systems
    Replies: 0
    Last Post: 2nd July 2007, 10:15 AM

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
  •