The project involves interfacing an Access database (probably via a custom vba macro) to a custom user administration web app and a Moodle e-learning installation. Prefer someone with previous Moodle customization experience and excellent English skills. Understanding the stengths and liitations of Moodle is also very important. Client will periodically run the Access macro which will update a new online database with User Administration contacts,log-in details and which courses that organization can access. The User Administator(s) for each organization can then log-in and add new users to this customer database; functionality will also insert/update this information in the Moodle database. Moodle will then authenticate all users against the new custom database.
Client must be able to update online DB on-demand (anytime) via Access DB. Access DB should be modified as little as possible. Fields passed from Access DB to online will include: Name, Organization (Facility), License Number, Subscribed Newsletters/Courses, Start and Stop dates for each, Flag if Organization was once active and no longer is active. Data in DB is arranged specific to each publication/newsletter/course.
Authorization requirements: Each organization has a unique customer number and a Primary contact (stored within the Access DB). This primary contact will initially be designated as an administrator of the e-learning system. They will have the ability to add/edit/delete users of the system as well as other Administrators within their organization. If someone attempts to login and their registration is expired, display facility name and customer number along with a message “Your registration is expired. Please contact your administrator (list admin's name and phone) ASAP.”
If an individual does not log in for more than 3 months, disable access and display message “You have not logged in for more than 3 months. Please contact you administrator (display administrator name) to regain access.
Project entails writing the Access macro, creating the new online database (server will support MS SQL Server and MySQL), creating the front-end web user interface and back-end code for User Administration and writing the SQL for updating of the new database and Moodle database.
Additional work will be available on an hourly basis once these tasks are complete.