+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, How do i see what classes a student is in? in Technical; No admin people in school until next week .... How do i see what classes a student is in? i'm ...
  1. #1
    oxide54's Avatar
    Join Date
    Mar 2009
    Posts
    798
    Thank Post
    51
    Thanked 55 Times in 54 Posts
    Rep Power
    22

    How do i see what classes a student is in?

    No admin people in school until next week ....

    How do i see what classes a student is in?

    i'm trying to basically work out who their ICT teacher is from a report i'm importing into a program i wrote to create the user accounts.

    AD Accounts / exchange accounts create folder.. all those bits work and are done. i just don't know much about sims and what to add to the report?

  2. #2
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    693
    Thank Post
    52
    Thanked 188 Times in 124 Posts
    Rep Power
    101
    Has the school been promoted? At our school the new timetable doesn't go "live" until Sept 3rd, so any report showing ICT teacher would show last year's teacher.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,382
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Are you doing this as a one-off, "hey little Jonny got Mr Brown for ICT this year" or are you trying to import it into something?

  4. #4
    oxide54's Avatar
    Join Date
    Mar 2009
    Posts
    798
    Thank Post
    51
    Thanked 55 Times in 54 Posts
    Rep Power
    22
    @matt40k it is for importing, into my own program.
    @clareq no, but i can use last years data for testing my program and then just run it when the school is promoted.

  5. #5

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    211
    Thank Post
    7
    Thanked 50 Times in 45 Posts
    Rep Power
    27
    Easiest way is probably to do Reports>Student List>Class List then select classes of a teacher.
    If you pick out each IT teacher in turn you can export the lists out to Excel.
    If you dont change the date chances are the lists will all be empty as classes will have no memeberships at the moment. If your Academic Manager person has done their thing, if you change the effective date to after the start of the new term, (its done via the Settings Button) the lists will correctly show next years lists.
    Last edited by Linfit; 29th August 2012 at 12:54 PM.

  6. #6
    oxide54's Avatar
    Join Date
    Mar 2009
    Posts
    798
    Thank Post
    51
    Thanked 55 Times in 54 Posts
    Rep Power
    22
    i really don't use sims much!

    when i run a csv report it trys to make it in the root of C:\ any way to make this more sensible

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,382
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    @Linfit - you can't run those from the command line. So it's not ideal.
    @oxide54 - With the reporting engine you can set where it goes.

  8. #8
    oxide54's Avatar
    Join Date
    Mar 2009
    Posts
    798
    Thank Post
    51
    Thanked 55 Times in 54 Posts
    Rep Power
    22
    Untitled.pngi was kind of hoping something like this would work

  9. #9
    oxide54's Avatar
    Join Date
    Mar 2009
    Posts
    798
    Thank Post
    51
    Thanked 55 Times in 54 Posts
    Rep Power
    22
    @oxide54 - With the reporting engine you can set where it goes.[/QUOTE]

    tbh not really bothered the program is actually running commandreporter.exe so that works fine, its just irritating when try to design the report as you then have to quit and restart sims "as administrator"

  10. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,382
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Err? It's just a setting on the report??


    selectpath.png

  11. Thanks to matt40k from:

    oxide54 (29th August 2012)

  12. #11
    oxide54's Avatar
    Join Date
    Mar 2009
    Posts
    798
    Thank Post
    51
    Thanked 55 Times in 54 Posts
    Rep Power
    22
    ok cool.

    any takers on the class?

  13. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    And you put a sub-query on the class sub-table, with that little red icon on the right, to pick ICT or whatever....
    did that report work?

  14. #13
    oxide54's Avatar
    Join Date
    Mar 2009
    Posts
    798
    Thank Post
    51
    Thanked 55 Times in 54 Posts
    Rep Power
    22
    Quote Originally Posted by vikpaw View Post
    And you put a sub-query on the class sub-table, with that little red icon on the right, to pick ICT or whatever....
    did that report work?
    as it is no. it gave me all the students but nothing in the classes bit.

    just trying the red icon thing.

SHARE:
+ Post New Thread

Similar Threads

  1. How do i find what i am licensed for? Help!
    By farquea in forum Licensing Questions
    Replies: 6
    Last Post: 5th March 2011, 05:40 AM
  2. How do i change the name of a calendar in exchange?
    By mbird in forum How do you do....it?
    Replies: 5
    Last Post: 24th March 2010, 08:26 PM
  3. Filtering, how do you determine what gets blocked?
    By localzuk in forum General Chat
    Replies: 13
    Last Post: 26th May 2009, 10:02 AM
  4. Replies: 11
    Last Post: 15th November 2006, 03:27 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
  •