+ Post New Thread
Page 5 of 7 FirstFirst 1234567 LastLast
Results 61 to 75 of 103
Virtual Learning Platforms Thread, SIMS Timetable Module for Moodle in Technical; Originally Posted by barney As an institution we are possibly being railroaded into buying Fronter, so I thought we'd take ...
  1. #61

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    242
    Quote Originally Posted by barney View Post
    As an institution we are possibly being railroaded into buying Fronter, so I thought we'd take peek moodle to see what it can/can't do and to try and setup something as close to an MLE as we would end up buying.
    We're currently taking a look at Moodle also, and I've found it to do so much compared to our current setup (SharePoint). Everything we've wanted we've found in the downloads area.

    I'm playing with this SIMS.net thing also, will report back on any breakthroughs.

  2. #62

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,820
    Thank Post
    883
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    @barney

    Are there any parts in particular you are stuck at?
    The Moodle Docs should be fairly up to date now after my input

  3. #63
    barney's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    53
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Gatt View Post
    @barney

    Are there any parts in particular you are stuck at?
    The Moodle Docs should be fairly up to date now after my input
    Yes!

    In the documentation Configuring SQL Server 2005
    [edit] Add a new view to MS SQL Server is mentioned twice, is this an oversight? I have it in my head moodle doesn't talk directly to the SIMS.Net database and that you create an intermediary or have I dreamt this??? Told you, I've been out the loop on the tech side of things for years now.
    Secondly, is FreeTDS 0.64 only required when using Linux??
    And thirdly, is the link between moodle and the sims.net databde (or the intermediary database dynamic or does it need to be scheduled?

    Many thanks

  4. #64


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,033 Times in 813 Posts
    Rep Power
    341
    You do need to add a view to the SQL - the connection from moodle is direct to the SQL database, it is read only so the SQL is safe.
    FreeTDS is Linux only - I'm not sure what you need to do a windows connection
    The link is live so nothing needs to be schedules unless you want to do autocreation of user accounts.

  5. #65

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    242
    How do you test FreeTDS is doing its job? I have followed the steps in the docs and have a table for the timetable with the periods I set, but it is blank.

    Also, does the account for Enrolements have to be the 'sa' account or can it be a system managers account?

  6. #66


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,033 Times in 813 Posts
    Rep Power
    341
    Quote Originally Posted by Hightower View Post
    How do you test FreeTDS is doing its job? I have followed the steps in the docs and have a table for the timetable with the periods I set, but it is blank.
    use the tsql command. I know that works on centos/rhel. but I think I read a thread that there was a problem with ubuntu
    FreeTDS User Guide

  7. #67

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    242
    Have tried that - doesn't work with Ubuntu

  8. #68
    barney's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    53
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by CyberNerd View Post
    You do need to add a view to the SQL - the connection from moodle is direct to the SQL database, it is read only so the SQL is safe.
    FreeTDS is Linux only - I'm not sure what you need to do a windows connection
    The link is live so nothing needs to be schedules unless you want to do autocreation of user accounts.
    Thanks, that's quite interesting.
    I've followed the instructions and created the templates and setup the external database for the enrolments but alas I can't see any courses. What I can't figure out is where the view created by pasting in the query is referenced. I've actually "run" the view in SQL studio manager and it works but it looks to me like it uses UPN number to indentify students. Therefore would I be right in thinking that we need UPN's in AD too?

  9. #69


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,033 Times in 813 Posts
    Rep Power
    341
    Quote Originally Posted by barney View Post
    Thanks, that's quite interesting.
    I've followed the instructions and created the templates and setup the external database for the enrolments but alas I can't see any courses. What I can't figure out is where the view created by pasting in the query is referenced. I've actually "run" the view in SQL studio manager and it works but it looks to me like it uses UPN number to indentify students. Therefore would I be right in thinking that we need UPN's in AD too?
    yes, you need to have the UPN data in active directory.
    It is the UPN data that is used as a reference point to tie SIMS/AD and moodle together.

    Quote Originally Posted by Hightower
    Have tried that - doesn't work with Ubuntu
    you may need to compile it manually.

  10. #70

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    242
    Just to ask again... Does anyone know if it has to be the 'sa' account or can it be an account of a system manager in SIMS?

  11. #71
    barney's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    53
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Hightower View Post
    Just to ask again... Does anyone know if it has to be the 'sa' account or can it be an account of a system manager in SIMS?
    I would imagine it has to be SA account. SA is root account for the database and it's context within the SQL server. SIMS System admin account if for use with the sims.net application which accesses the SIMS database.

  12. #72
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    183
    Thank Post
    53
    Thanked 66 Times in 52 Posts
    Rep Power
    27
    You shouldn't really be using UPNs to identify pupils to other systems. You should really be using the admission number. The UPN's purpose is purely tracking of pupils’ movement and progress within the maintained school system in England, not as a general purpose identifier.

    From the guidance notes on UPNs at http://www.teachernet.gov.uk/_doc/11...ate%202007.rtf

    • the UPN to be as far as possible a ‘blind number’, held by schools on the pupil's electronic record, and only output when required to provide information to the LA, to the Department or other central agencies (e.g. QCA/NAA), or to another school to which the pupil is transferring. The UPN should not be regarded as an automatic adjunct to the pupil's name, routinely appearing on any record or document relating to them;

    • schools should not enter UPNs on pupils' paper files or on any other physical documents, including admission and attendance registers, and should continue to use the admission number, not the UPN, as a general pupil reference number within the school.

    Richard

  13. #73

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    242
    Ok, now I gotsa find out the 'sa' password - hmmmm

  14. #74
    barney's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    53
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Hightower View Post
    Ok, now I gotsa find out the 'sa' password - hmmmm
    was SIMS installed by your Local Authority? If so, ring them and say you need it. Alternatively, it may actually be blank

  15. #75

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    242
    Found the password, set it - and still get a blank timetable.

    Any ideas?



SHARE:
+ Post New Thread
Page 5 of 7 FirstFirst 1234567 LastLast

Similar Threads

  1. SIMS.Net & Timetable planning
    By Ravening_Wolf in forum MIS Systems
    Replies: 22
    Last Post: 4th November 2009, 04:27 PM
  2. SIMS Lesson Monitor Timetable Structure
    By Sylv3r in forum MIS Systems
    Replies: 8
    Last Post: 15th March 2009, 10:45 PM
  3. Timetable T6 or Sims.net confused
    By training_needed in forum MIS Systems
    Replies: 4
    Last Post: 26th June 2008, 11:07 AM
  4. Sims Timetable Front end
    By Jamie_a in forum MIS Systems
    Replies: 5
    Last Post: 28th March 2007, 05:49 PM
  5. Moodle Blog Module SQL Injection Vulnerability - Heads Up
    By OutToLunch in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 9th October 2006, 03:25 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
  •