Forum Members, a very good morning to you,
My colleague and I are working in Moodle v3.5 soon to be v3.6.
We have to create multiple courses and digital content ahead of the NHS Patient Electronic Health Record software deployment project; which is scheduled for delivery in autumn of this year going live. The impacted audience size is a little over 7,000 staff members across multiple hospitals sites in the UK Kent region, and the training team is tasked with delivering the training strategy and all subsequent reporting.
We have created 10 courses, where each course has a module of eLearning in SCORM 1.2, a Confidence Report Choice Activity (Pre and Post Course), PDF Activities and other references materials, including processes and workflow maps which define patient pathways and treatment plans as links to reference materials.
The problem we are experiencing is, when running reports, our exported data is not giving us all of the information we so desperately need. We can produce multiple reports that have the data which, is stored in different parts of the LMS database and we have made arrangements so that we can connect our Excel App to the ODBC LMS Databases on the server directly. However, when connecting to the database and having access to all of the tables, we struggle to source the information and data we need, to create the desired report.
Therefore, we are calling upon the good will of the Moodle community and those who wish to receive and take credit for helping us in our plight, to assist us in creating a Single SQL report which collates the data from all courses and user profiles in addition to data from the Category, Course and Learner reports. If it pulled just one record we could figure the rest out for ourselves but we really are struggling as none of us are SQL coders.
Your reward for helping us, would be recognition both locally and nationally across the UK NHS Trust community via all social media outlets promoting your professional services, helping you to generate future business.
I know this is somewhat of an unorthodox request but we have exhausted all avenues available to us and only have until the 16th April to get the matter resolved before it starts to impact the projects delivery data as all Ward Managers and Team Leaders are going to need this reporting to track and follow their staff progress.
My sincerest thanks in advance for any contribution you can make.
Mark Jones
T3 Training & Development Specialists
NHS East Kent Hospitals University Foundation Trust.
+44 (0) 7851 74 43 11
+44 (0) 1227 20 66 53
mark.jones39@nhs.net