Our university is currently working on adopting Moodle. We're trying to figure out how to get the files out of our student information system, into Moodle on a automatic basis. I was curious if any other universities are doing this or have tried to do it and what are you thoughts? Any help would be greatly appreciated!
We creating the courses via a custom made import script. We then use the Moodle Enrollment Plugin (external database) to automatically enroll the users when they login for the first time.
I hope this helps,
You do not need LMB to use the module, it just adds more features. My school, and a decent number of other schools, use the module to import data from Banner.
I would be glad to answer any questions you may have.
Dear Eric and fellow community members,
May you kindly point me to the function name / any resource about the fore-said "banner export to XML" function?
My institute is looking to do the Banner - Moodle integration, without LMB module. When I ask Sungradhe support centre about the function, they say they are unaware of any baseline Banner features that extract banner data into XML format. I was surprised.
Any information/advice is welcomed.
Both Moodlerooms and Remote-Learner have standard tools to bring in CSV files from Banner (I know because I designed the MR tool and work extensively with the ones we have at RL. A big problem with CSV export is there is often no standard format for the export (unlike the XML format that Eric's tool uses) - so often each campus has their own format and may need to choose either to change their output or to write or adapt a custom importer from another campus.
Is anyone moving Moodle grade book results back to Banner grade book or academic history ?
Is the plan is to use the existing Banner GradeAdapter functionality (i.e. the UpdateReply topics) in the LMB to create this functionality? Also what is involved in getting this functionality into the Gradebook interface.
We are currently integrating Blackboard 8 using the LMS for elearning but are looking around at our LMS options (It looks like you have done some great work on the Enrolment end of things.)
We are about to embark on implementing moodle and are definitely interested in the owrk you mention. Are there any updates on pushing gradebook data from moodle back into banner?
Hello Eric! Any progress on a module to pass grades back to Banner? Thank you!
Hope all is well. Suzanne States
Has there been any progress on pushing grades into Banner from Moodle?
Most likely not, since it is absolutely non-trivial task. I did that integration for certain institution long time ago and I can tell you it is pain to do.
An associate at our institution developed some Banner code to pull grades (test scores for particular graded items) from a Moodle web service (local plugin). It's initiated at the opposite end (push vs. pull), but appears to work. If you're still interested, I'll inquire with the Banner developer, but he has mentioned that "it gets pretty complicated with the grading
rules..." on the Banner end of things.
It is sadly very complicated. And now Ellucian is changing the way things talk with Banner. I'm working on a new version to support the new ILP interface system, and I'm hoping that it will be simpler to do grade exchange when that happens.
We use LDAP for authentication so we sync all of our users from that before syncing enrollments. In LDAP we store the user's Banner PIDM and use that as the primary key for Moodle's userfields.
For enrollments at minimum the tables you will need access to in Oracle (Banner 7) are:
If you want to use departmental names as course categories you will need the course catalog tables in Oracle as well.
We create a couple of views out of these tables:
We grab the course information from the course catalog table join it with the CRN and TERMCODE in SSBSECT. We concatenate CRN || '-' || TERMCODE and use that as the unique courseid for Moodle. We don't allow any external enrollment so we create 100 var char random string for the course password and we manually set the course enrollable bit to 0.
For the Enrollments, we have 2 views:
1. We grab the relevant fields from SFRSTCR, concatenate CRN || '-' || TERMCODE and hardcode the Moodle Student Role Identifier (3 is the default).
2. We grab the instructor's PIDM from SIRASGN oncatenate CRN || '-' || TERMCODE and hardcode the Moodle Teacher Role Identifier (5 is the default).
From these 2 enrollment views, we create a 3 view that UNIONS them so you get a master view of both students and teachers, and Moodle's External DB Enrollment patch from http://tracker.moodle.org/browse/MDL-18144 references this view plus the course view from above to put it all together.
Let me know if you want more indepth stuff. We are still ironing out some semester-to-semester rollover engineering at the moment.
We use perl and ODBC to read from Oracle and perl and the postgresql DBD driver to insert into postgres.
Here is a sanitized example: