+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Sims database structure in Technical; Hi All, Does anyone have any information on the sims.net database structure ? I am particularly interested in how the ...
  1. #1

    Join Date
    Feb 2007
    Posts
    73
    Thank Post
    3
    Thanked 4 Times in 2 Posts
    Rep Power
    16

    Smile Sims database structure

    Hi All,
    Does anyone have any information on the sims.net database structure ? I am particularly interested in how the time table is stored ? and how to tell which cycle the timetable is in ?
    Thanks

    Andy

  2. #2


    Join Date
    Jul 2007
    Location
    Rural heck
    Posts
    2,662
    Thank Post
    120
    Thanked 433 Times in 352 Posts
    Rep Power
    127
    Sims are quite guarded about what's goes on in their database. They also release patches every 6 weeks, and any of these could change the database structure.

    The general consensus is the best way to do this sort of thing is to get sims to generate a report with the data you need.

    A school I know use this method to use sims to automatically create accounts on AD and Moodle.

  3. #3
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    The Timetable 'Cycle' is shown in each pupil's 'Student Curriculum' via Tab 2 Timetable. It shows at bottom left when you click on any lesson.
    If you have changed the cycle part way through a year then all the cycles will show.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 675 Times in 550 Posts
    Rep Power
    166
    I think it'll be worth saying what your trying to achieve as it'll have already been done before.

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 675 Times in 550 Posts
    Rep Power
    166
    Quote Originally Posted by jinnantonnix View Post
    PM me if you want the name of the view that can do this.
    Ahh... you do listen

  6. #6

    Join Date
    Jun 2007
    Posts
    35
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by K.C.Leblanc View Post
    Sims are quite guarded about what's goes on in their database. They also release patches every 6 weeks, and any of these could change the database structure.

    The general consensus is the best way to do this sort of thing is to get sims to generate a report with the data you need.

    A school I know use this method to use sims to automatically create accounts on AD and Moodle.
    Hi,

    I am looking to something similar with merits, do you know if Sims has a way of automating this report generation? The plan is to not have to run a report once a week and have "something" do it for me every X days.

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 675 Times in 550 Posts
    Rep Power
    166
    You can schedule reports.

  8. Thanks to matt40k from:

    WiPPaH (12th October 2010)

  9. #8

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,768
    Thank Post
    1,510
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    or use CommandReporter if you want to run it from a script (it's in your /Program Files/SIMS/SIMS .net/ directory)

  10. Thanks to LosOjos from:

    WiPPaH (12th October 2010)

  11. #9

    Join Date
    Jun 2007
    Posts
    35
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thanks Matt40k & Los0jos

    The CommandReporter tool looks perfect!



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] What is the purpose of the Pastoral Structure in Sims!
    By SimsKitten in forum MIS Systems
    Replies: 6
    Last Post: 13th September 2010, 09:26 PM
  2. SIMS Permissions Structure
    By ICT_Pro in forum MIS Systems
    Replies: 2
    Last Post: 23rd June 2010, 12:47 PM
  3. Timetable Structure & Sims lesson monitor
    By artfulmatt in forum MIS Systems
    Replies: 3
    Last Post: 2nd June 2009, 10:57 PM
  4. SIMS Lesson Monitor Timetable Structure
    By Sylv3r in forum MIS Systems
    Replies: 8
    Last Post: 15th March 2009, 10:45 PM
  5. New Sims Database
    By SimAda00 in forum MIS Systems
    Replies: 0
    Last Post: 10th January 2007, 12:27 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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