+ Post New Thread
Page 6 of 7 FirstFirst ... 234567 LastLast
Results 76 to 90 of 103
Virtual Learning Platforms Thread, SIMS Timetable Module for Moodle in Technical; Originally Posted by rpwillis You shouldn't really be using UPNs to identify pupils to other systems. You should really be ...
  1. #76


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by rpwillis View Post
    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

    That is a good point. The admission number could be used.
    We chose the UPN simply because it was unique and we put it in a field in Active Directory, as is the students username, DOB etc. so it should be secure from a data handling PoV

  2. #77
    AWicher's Avatar
    Join Date
    Nov 2008
    Location
    Preston
    Posts
    316
    Thank Post
    57
    Thanked 40 Times in 31 Posts
    Rep Power
    18
    Nice one, my school has only just started looking into moodle and this would sure help integration.

  3. #78

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    I've got a php script:

    PHP Code:
    <?php
    $server 
    'SERVERNAME\INSTANCE';
    $link = ($server'sa''SA PASSWORD');

    if(!
    $link){
    die(
    'Not working');
    }
    ?>
    But I am receiving this error:

    Code:
    Warning:  mssql_connect() [function.mssql-connect]: Unable to connect to server:  SERVERNAME\INSTANCE in /var/www/test.php on line 5
    Do I need to do anything on the MSSQL server to ensure other machines can connect to it? What is going wrong?!

    Thanks,

  4. #79


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by Hightower View Post
    Do I need to do anything on the MSSQL server to ensure other machines can connect to it? What is going wrong?!
    first see if you can connect to the server using telnet
    Code:
    telnet xxx.xxx.xxx.xxx 1427
    (or 1433)

    if you can't connect it is an MSSQL issue.
    If you can connect, then try tsql.
    Download the source and compile it, then try tsql - it should install in /usr/local/bin/tsql and the config will be here /usr/local/etc/
    freetds.conf


    Code:
    wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
    extract, configure,compile, install
    Code:
    tar xzvf freetds-stable.tgz
    Code:
    cd freetds-0.82
    Code:
    ./configure
    Code:
    make && sudo make install

  5. #80

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Tried telnet - can't connect. Any steps to resolve this?

  6. #81


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by Hightower View Post
    Tried telnet - can't connect. Any steps to resolve this?
    this help?
    SIMS Timetables & Moodle

  7. Thanks to CyberNerd from:

    Hightower (29th January 2009)

  8. #82

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Thank you so much! Lets see where I get stuck now ;

  9. #83

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Ok, here we go again. TestPupil now has assigned courses of 10x/Ma5,10c/En1 etc etc even though them courses do not exist - so I'm guessing these are being pulled somehow from the DB - but the timetable is still blank.

    Is this an easy fix? Am I getting closer?

  10. #84


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    10x/Ma5,10c/En1 etc sound suspiciously like they could have come from the SIMS database.
    Penfold_99 is usually on hand for sims timetable problems.

  11. #85

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Ok, thanks CyberNerd. I await the help of the shopkeeper

  12. #86

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Just as an after thought - the connection is working somewhere as it has created the course as mentioned above, and enrolled the user on them.

    I'm wondering if I've installed the blocks correctly - is there any special method to it? Or is it a case of wacking them on the server as is and away we go.

  13. #87
    barney's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    52
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by CyberNerd View Post
    That is a good point. The admission number could be used.
    We chose the UPN simply because it was unique and we put it in a field in Active Directory, as is the students username, DOB etc. so it should be secure from a data handling PoV


    Does anyone know what the field for admission number is in the SIMS database? I'd like to change the sql query to replace m.unique_pupil_no as person to blah.admin_number as person

  14. #88

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Could my problem be caused by the moodle plugin I downloaded? Have I installed it correctly? Here's what I did - was this correct?

    1) Downloaded from Moodle
    2) Uploaded the 'simstimetable' folder in mod to the mod folder on my server
    3) Uploaded the 'simstimetable' folder in blocks to the blocks folder on my server
    4) Went to the admin homepage to complete install - no errors given
    5) Added College timetable block to homepage

    Get a blank timetable. Are more steps than this required?

    Also, if I click the 'Configuration' button on the College Timetable block (as admin of course) I get:

    This block has not been implemented correctly and thus cannot provide a configuration interface.

    This doesn't sound normal - what have I done wrong. Argghhhhh!

  15. #89
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    922
    Thank Post
    56
    Thanked 161 Times in 113 Posts
    Rep Power
    67
    Quote Originally Posted by Hightower View Post
    Could my problem be caused by the moodle plugin I downloaded? Have I installed it correctly? Here's what I did - was this correct?

    1) Downloaded from Moodle
    2) Uploaded the 'simstimetable' folder in mod to the mod folder on my server
    3) Uploaded the 'simstimetable' folder in blocks to the blocks folder on my server
    4) Went to the admin homepage to complete install - no errors given
    5) Added College timetable block to homepage

    Get a blank timetable. Are more steps than this required?

    Also, if I click the 'Configuration' button on the College Timetable block (as admin of course) I get:

    This block has not been implemented correctly and thus cannot provide a configuration interface.

    This doesn't sound normal - what have I done wrong. Argghhhhh!
    Hi hightower,

    when did you download the module? as there have been many updates.

    The main reason for it not working is the separator, could you please post an example of the output of the sql view.

  16. #90

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Quote Originally Posted by penfold_99 View Post
    Hi hightower,

    when did you download the module? as there have been many updates.

    The main reason for it not working is the separator, could you please post an example of the output of the sql view.
    I have literally just this minute downloaded it. I have also tried a known working block and mod folder (thanks Gatt) which didn't suss it.

    I've added an example of each of the three views. Thanks

SHARE:
+ Post New Thread
Page 6 of 7 FirstFirst ... 234567 LastLast

Similar Threads

  1. SIMS.Net & Timetable planning
    By Ravening_Wolf in forum MIS Systems
    Replies: 22
    Last Post: 4th November 2009, 03:27 PM
  2. SIMS Lesson Monitor Timetable Structure
    By Sylv3r in forum MIS Systems
    Replies: 8
    Last Post: 15th March 2009, 09:45 PM
  3. Timetable T6 or Sims.net confused
    By training_needed in forum MIS Systems
    Replies: 4
    Last Post: 26th June 2008, 10:07 AM
  4. Sims Timetable Front end
    By Jamie_a in forum MIS Systems
    Replies: 5
    Last Post: 28th March 2007, 04: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, 02: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
  •