+ Post New Thread
Results 1 to 7 of 7
Virtual Learning Platforms Thread, Moodle/Sims - Timetable and course integration HELP in Technical; Hello All, I am having difficulty setting up the Moodle-SIMS integration We already have all users set up in active ...
  1. #1

    Join Date
    Nov 2009
    Posts
    79
    Thank Post
    3
    Thanked 4 Times in 4 Posts
    Rep Power
    11

    Moodle/Sims - Timetable and course integration HELP

    Hello All,

    I am having difficulty setting up the Moodle-SIMS integration

    We already have all users set up in active directory. If i am led to believe correct the employeeid is what needs to be set to join LDAP and SIMS

    What i have done is as follows

    Using sql 2005, php-cgi.exe on iis

    Moodle Install and can connect to SIMS
    LDAP works as i have logged in as some users
    i have manually set the employeeid on some accounts
    When i login as the user and click on the timetable it says it can't connect to sims.net

    Enrolment settings

    SIMS.net Server Settings
    enrol_dbtype = mssql
    enrol_dbhost = 192.168.16.17\sims2005
    enrol_dbport = 1427
    enrol_dbuser = [user]
    enrol_dbpass = [SA Password]
    enrol_dbacyear = 2009 (or current academic year)

    Connect to mssql page

    <?php
    $link = mssql_connect('192.168.16.17:1427\sims2005', '[user]', '[password]');
    if(!$link) {
    echo'Could not connect';
    die('Could not connect: ' . mssql_error());
    }
    echo'Successful connection';
    mssql_close($link);
    ?>

    And that connects fine.

    So any ideas anyone?

    Thanks
    Last edited by Danlewis3; 8th January 2010 at 04:48 PM. Reason: adding

  2. #2

    Join Date
    Nov 2009
    Posts
    79
    Thank Post
    3
    Thanked 4 Times in 4 Posts
    Rep Power
    11
    moodle config file

    <?php /// Moodle Configuration File

    unset($CFG);

    $CFG->dbtype = 'mssql_n';
    $CFG->dbhost = '192.168.16.17\sims2005';
    $CFG->dbname = 'moodle';
    $CFG->dbuser = '[user]';
    $CFG->dbpass = '[password]';
    $CFG->dbpersist = false;
    $CFG->prefix = 'mdl_';

    $CFG->wwwroot = 'http://portal/moodle';
    $CFG->dirroot = 'C:\Inetpub\wwwroot\moodle';
    $CFG->dataroot = 'C:\Inetpub/moodledata';
    $CFG->admin = 'admin';

    $CFG->directorypermissions = 00777; // try 02777 on a server in Safe Mode

    $CFG->passwordsaltmain = 'k?bg#3{gQk)pd_v^g)49-ld5%)';

    require_once("$CFG->dirroot/lib/setup.php");
    // MAKE SURE WHEN YOU EDIT THIS FILE THAT THERE ARE NO SPACES, BLANK LINES,
    // RETURNS, OR ANYTHING ELSE AFTER THE TWO CHARACTERS ON THE NEXT LINE.
    ?>

  3. #3

    Join Date
    Nov 2009
    Posts
    79
    Thank Post
    3
    Thanked 4 Times in 4 Posts
    Rep Power
    11
    freetds.conf

    [global]
    host = 192.168.16.17 (ip of the MSSQL server)
    port = 1427
    client charset = UTF-8
    tds version = 8.0
    text size = 20971520

  4. #4

    Join Date
    Nov 2009
    Posts
    79
    Thank Post
    3
    Thanked 4 Times in 4 Posts
    Rep Power
    11
    Right i have just checked for the views that should install onto the 2005sql

    CREATE VIEW mdl_student_timetable_v1_0
    AS SELECT TOP (100) PERCENT sims.rpt_vix_timetable.period_name, sims.rpt_vix_timetable.class_name,sims.stud_via_st udent_browse.unique_pupil_no,sims.rpt_vix_timetabl e.staff_initials, sims.rpt_vix_timetable.room_name
    FROM sims.stud_via_group_members INNER JOIN sims.curr_class_period ON sims.stud_via_group_members.base_group_id = sims.curr_class_period.base_group_id
    INNER JOIN sims.stud_via_student_browse ON sims.stud_via_group_members.person_id =
    sims.stud_via_student_browse.person_id INNER JOIN sims.rpt_vix_timetable ON sims.curr_class_period.class_period_id = sims.rpt_vix_timetable.class_period_id
    WHERE (sims.curr_class_period.person_id IS NOT NULL) AND (sims.rpt_vix_timetable.end_date > GETDATE()) AND (sims.stud_via_group_members.start_date < GETDATE()) AND (sims.stud_via_group_members.end_date > GETDATE())
    ORDER BY sims.rpt_vix_timetable.period_name

    This one is erroring when i try to create it manually
    Msg 102, Level 15, State 1, Procedure mdl_student_timetable_v1_0, Line 2
    Incorrect syntax near '.'.

    this table dont exist sims.rpt_vix_timetable.period_name,

  5. #5
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    1,003
    Thank Post
    60
    Thanked 167 Times in 119 Posts
    Rep Power
    69
    @Danlewis3

    It looks like Capita have modified the database. The version of SIMS and Moodle Integration you are using is not supported.

    Both Myself and webanywhere offer supported versions of SIMS and Moodle Integration. If you would like some more information PM me.

    Sorry i couldn't be more help.

  6. Thanks to penfold_99 from:

    Danlewis3 (11th January 2010)

  7. #6

    Join Date
    Nov 2009
    Posts
    79
    Thank Post
    3
    Thanked 4 Times in 4 Posts
    Rep Power
    11
    Thanks for the info, i have pm'd you.

  8. #7
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    1,003
    Thank Post
    60
    Thanked 167 Times in 119 Posts
    Rep Power
    69
    Quote Originally Posted by Danlewis3 View Post
    Thanks for the info, i have pm'd you.
    I have replied.



SHARE:
+ Post New Thread

Similar Threads

  1. RELEASED: SIMS.net Timetable Block V1.0 for Moodle
    By penfold_99 in forum Virtual Learning Platforms
    Replies: 9
    Last Post: 16th November 2014, 08:46 PM
  2. Moodle Sims integration help
    By ssiruuk2 in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 8th November 2010, 02:53 PM
  3. The Definitive Guide to SIMS.net, Moodle and LDAP Integration
    By penfold_99 in forum Virtual Learning Platforms
    Replies: 130
    Last Post: 8th September 2010, 05:50 PM
  4. SIMS Timetable Module for Moodle
    By Hightower in forum Virtual Learning Platforms
    Replies: 102
    Last Post: 4th February 2009, 02:50 PM
  5. Moodle/SIMS integration
    By localzuk in forum Virtual Learning Platforms
    Replies: 23
    Last Post: 7th December 2007, 10:18 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
  •