+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, [SIMS] Individual Reports, Teacher Names & Result History? in Technical; Hi all, as I'm sure some of you have noticed, SIMS Individual Reports do not play nice with teacher names ...
  1. #1

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,487
    Thank Post
    1,445
    Thanked 1,182 Times in 809 Posts
    Rep Power
    709

    [SIMS] Individual Reports, Teacher Names & Result History?

    Hi all,

    as I'm sure some of you have noticed, SIMS Individual Reports do not play nice with teacher names if more than one teacher is assigned to a class, it seems to pick one of their names to display with no apprent way of defining which this is.

    Because of this, I've resorted to creating a "report author" aspect, then after each set of reports is written in AM7, I work my way through the marksheets checking the result history to see which teacher actually wrote the report, then writing their name in to the author column ready to publish on the reports.

    It's quite a long winded process!

    My question to you all is, does anybody know of a way to pull through that information (result history operator name) in to an individual report? Or alternatively, how to create a report that contains this information so I can import it back in to the relevant aspects?

    I'm open to any other suggestions you may have too...

    Any help, as always, will be much appreciated.
    Last edited by LosOjos; 28th May 2010 at 01:51 PM.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    We have this issue too!

    We ask either the teacher writing the report to fill in their name, or ask the Head of Dept. to do this. I would advise that is the best way forward, as you doing it, or finding long winded workarounds is just not practical.

    Otherwise, put the onus on the timetabler to try and sort it out, by splitting groups, and making linked classes, and whatever other tricks are available.

    Having said that, i've used some sql to extract information out of the database before which may be of use to you. You'll need to change some parts to fit in with what you want. I used it mostly to see the history of a particular aspect to see who changed what and when. I've added in the link to show resultset which i imagine would be a better way for you to use the code rather than on aspect name. You then wouldn't need the result_date part.

    I know the whole lot really should be done by lots of table joins, but i just botched it together quickly at the time and can't easily get my head around multiple table joins. For this reason it wont extract the user's forename / surname, just their login ID which may be enough for you (?).

    You may want to run a separate query to extract names of user agaist loginname, and ptu it in a lookup table.

    Oh yeah, i do this on my VM, using a backup of live data, naturally

    Hope it may be of some use

    Code:
    use sims2005;
    select
    result_date, result,
    resultset_name,
    aspect_name,
    forename, surname,
    login_name
    from sims.asm_result AS r1,
    sims.db_user AS u1,
    sims.asm_aspect AS a1,
    sims.asm_resultset AS rs1,
    sims.sims_person AS s1
    where r1.student_id = s1.person_id 
    AND r1.aspect_id = a1.aspect_id 
    AND r1.resultset_id = rs1.resultset_id
    AND aspect_name LIKE'_temp%'
    AND operator_id = u1.person_id 
    AND result_date >DATEADD(day,-3,GETDATE())
    orderby result_date desc, surname asc
    

  3. Thanks to vikpaw from:

    LosOjos (10th June 2010)

  4. #3
    Bev
    Bev is offline

    Join Date
    Oct 2009
    Posts
    158
    Thank Post
    13
    Thanked 5 Times in 5 Posts
    Rep Power
    11
    I just added teacher name to the marksheet - not clever but it does the trick.

  5. Thanks to Bev from:

    LosOjos (10th June 2010)

  6. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,487
    Thank Post
    1,445
    Thanked 1,182 Times in 809 Posts
    Rep Power
    709
    Thanks both, at the minute I'm just going to stick with entering the names manually in an aspect I think, but your SQL query is interesting vikpaw, I'll have a bit more of a play around with it when I have some spare time

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims Assessment Manager Individual Reports
    By MACIT in forum MIS Systems
    Replies: 11
    Last Post: 30th June 2011, 02:14 PM
  2. Saving edited Individual Reports to Linked Documents
    By sallie_wan in forum MIS Systems
    Replies: 10
    Last Post: 20th March 2010, 11:22 AM
  3. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 11:27 AM
  4. Replies: 2
    Last Post: 28th January 2008, 12:56 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
  •