Gatt Posted January 8, 2009 Posted January 8, 2009 Yes I know there are loods of threads on here about this but I thought'd be easier to start a fresh one for this.. I am looking into the possibility of linking our Moodle to SIMS to pull the timetables across into Moodle. I read that you need to sync SIMS with AD (SIMS2AD) but from lokoing at the code I am worried that this is gonig to overwrite our existing accounts HOW do I go about only getting the necessary info into the correct places?
webman Posted January 8, 2009 Posted January 8, 2009 I haven't gone all the way through it, but I think it will just be a case of re-doing parts of the script so that it modifies user accounts instead of creating them. Of course you will need to do some matching up of names so this could prove more difficult than the intended use of the script.
Gatt Posted January 8, 2009 Author Posted January 8, 2009 Yeah I know.. i'm thinking it may be better to just consign this idea to the "Would Be Nice But..." pile... Although if its relying upon the pupils UPN then I may be able to export this with a report, then use AD Modify or similar to import the UP to the employeeID field in AD.. Depends what other fields are needed I guess..
matt40k Posted January 8, 2009 Posted January 8, 2009 If from what I understand (limited) Ideally you want to export from SIMS into a "database", and export from AD into a "database" then allow the user to check that they will be matched up correctly. Once it's done then your laughing, if you extend your ad scheme you could add on a UPN field. If you get a duplicate you would want a nice flag so you have to proactivally manually transfer the data etc rather then wait until they find out. I think, at the moment, your really need a dev AD the merge the two AD together. Just remember to take passwords from the old domain and keep the same format.
CyberNerd Posted January 8, 2009 Posted January 8, 2009 The SIMS2AD scripts are comprehensive, but the ultimate goal is that you have UPN's in the AD so that SIMS,AD and Moodle can use as reference, how you achieve this is upto you. The advantage of the script that penfold_99 published is that you can have SIMS autocreate accounts without any expensive SIMS addons, and have sims enable/disable accounts etc. As long as the UPN's are in the correct part of AD (the EmployeeID field) and the SIMS/Moodle integration is working, then the timetable module should work as well.
Gatt Posted January 8, 2009 Author Posted January 8, 2009 Ok Sit Rep... I have created the SIMS/Moodle Views on the SIMS database I have exportded the UPNs from SIMS and painstakingly added them to AD's employmentID field I have added the SIMS Timetable mod to moodle (and edited link to point to Moodle instead of root web folder! Displayed the mod - got a kid to login in (Moodle finds the UPN - they click "My Timetable - a new page appears but only with the Moodle header the rest of the page is blank.. Guessing i've missed something somewhere
penfold_99 Posted January 8, 2009 Posted January 8, 2009 Ok Sit Rep... I have created the SIMS/Moodle Views on the SIMS database I have exportded the UPNs from SIMS and painstakingly added them to AD's employmentID field I have added the SIMS Timetable mod to moodle (and edited link to point to Moodle instead of root web folder! Displayed the mod - got a kid to login in (Moodle finds the UPN - they click "My Timetable - a new page appears but only with the Moodle header the rest of the page is blank.. Guessing i've missed something somewhere Hi, Have you added sims as a external database?
penfold_99 Posted January 8, 2009 Posted January 8, 2009 Yes I know there are loods of threads on here about this but I thought'd be easier to start a fresh one for this.. I am looking into the possibility of linking our Moodle to SIMS to pull the timetables across into Moodle. I read that you need to sync SIMS with AD (SIMS2AD) but from lokoing at the code I am worried that this is gonig to overwrite our existing accounts HOW do I go about only getting the necessary info into the correct places? Hi, To get SIMS2AD to be Report Only set USER_CREATION AD_REG_UPDATE AD_UPN_UPDATE All to false.
Gatt Posted January 8, 2009 Author Posted January 8, 2009 Hi, Have you added sims as a external database? You mean the course/category bit - Yeah done that... Hi, To get SIMS2AD to be Report Only set USER_CREATION AD_REG_UPDATE AD_UPN_UPDATE All to false. Is that on the MS SQL View or the VBS File? I now get a "blank" timetable with 1,2,REG... down the side but no info (copied a pupils UPN into a test account) Will try the above later on..
penfold_99 Posted January 8, 2009 Posted January 8, 2009 You mean the course/category bit - Yeah done that... Is that on the MS SQL View or the VBS File? I now get a "blank" timetable with 1,2,REG... down the side but no info (copied a pupils UPN into a test account) Will try the above later on.. Is your school on a 1 week time table or 2 week time table?
Gatt Posted January 8, 2009 Author Posted January 8, 2009 No its a completely blank table - dont think its reading the DB at all..
penfold_99 Posted January 8, 2009 Posted January 8, 2009 No its a completely blank table - dont think its reading the DB at all.. I sorry, have you manually run the view in SQL server 2005?
Gatt Posted January 8, 2009 Author Posted January 8, 2009 yeah just did it on the 3 views (enrolment_current, student_timetable, staff_timetable)
Gatt Posted January 8, 2009 Author Posted January 8, 2009 OK I have added in the SIMS2AD views to the SQL Server The adsync View returns data, but the admanager does not? Do I need to use the 'sa' username & password for enrolment?
penfold_99 Posted January 9, 2009 Posted January 9, 2009 yeah just did it on the 3 views (enrolment_current, student_timetable, staff_timetable) Can you give an example of the output from student_timetable
Gatt Posted January 9, 2009 Author Posted January 9, 2009 Am getting something similar to this.. Tue:2 10A/Sp1 <> <> 52 Mon:1 10C/Hi1 <> <> 59 Wed:5 10C/Hi1 <> <> 59 Wed:2 10B/Gg1 <> <> 57 field headers are : period_name | class_name | unique_pupil_no | staff_initial | room_name
Gatt Posted January 9, 2009 Author Posted January 9, 2009 (edited) OK, in trying to figure out whats wrong with my set up I added or die ("Cant Connect!"); to the end of the $dbhandle statement in he view.php file for the mod.. Refreshed the page and got a "Cant Connect" message in my browser - looks like I cannot talk to MS SQL!! I have been through everything - its all correct dbhost - server,1427 dbuser - sa dbpass - dbname - sims_mors dbtable - dbo.mdl_enrolment_current Question - Do you need to connect using "sa" ? - Of So then it looks like my LEA have changed it - and prob wont give me it Edited January 9, 2009 by Gatt
penfold_99 Posted January 10, 2009 Posted January 10, 2009 how is moodle setup? is it on linux or windows? if you have access to add view you will be able to reset the sa password, but hang fire until you have answered the above. If your setup is on windows then you need a slight adjustment.
CyberNerd Posted January 10, 2009 Posted January 10, 2009 OK, in trying to figure out whats wrong with my set up I added or die ("Cant Connect!"); to the end of the $dbhandle statement in he view.php file for the mod.. Refreshed the page and got a "Cant Connect" message in my browser - looks like I cannot talk to MS SQL!! I have been through everything - its all correct dbhost - server,1427 dbuser - sa dbpass - dbname - sims_mors dbtable - dbo.mdl_enrolment_current Question - Do you need to connect using "sa" ? - Of So then it looks like my LEA have changed it - and prob wont give me it have you setup freetds on fedora so that the moodle server can talk to the mssql? you need to install freetds. you also need php-mssql installed. there are rpm's available for this. our /etc/freetds.conf file looks like this: [global] host = x.x.x.x port = 1427 client charset = UTF-8 tds version = 7.0 text size = 20971520 where x.x.x.x is the hostname of the SIMS server and 1427 is the port.
Gatt Posted January 10, 2009 Author Posted January 10, 2009 yeah installed FreeTDS - will need to check the conf file but did put in the IP and port for our SIMS server Installed php-mssql and restarted apache...
CyberNerd Posted January 10, 2009 Posted January 10, 2009 test freetds on the commandline: Is the server there? I guess if that works, then look more into php-mssql
Gatt Posted January 10, 2009 Author Posted January 10, 2009 Hmm... freetds.conf is correct Cannot telnet to the SQl server when I try tsql I get "unable to connect: Adaptive server is unavailable or does not exist"
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now