Case Study WCFMySQL  

Migration of Online Learning Website

Q3 migrated an e-learning website with 2 major products which are tailored specifically for the learning requirements of adults entering the work force or retraining and upgrading their skills to meet the challenges of new technologies on the job.

Q3's global sourcing model gives the maximum benefit to customers in terms of cost savings, improved quality, access to highly talented professionals, flexibility of operations and reduced time to market.

Company Profile

The client provides e-commerce data-driven web solutions to customers in various industries. The company also provides network support services, web hosting and maintenance, and customized database integration services to its clients across major verticals.


Business Situation

The client had a site which was static and contained complex code that required modifications which were not feasible. The site didn't have much in terms of functionality too as it was only compatible with Internet Explorer 7.

The client required a dynamic site which they could modify according to their needs and requirements whenever they wanted to. The fact that dynamic websites don't require a web developer to develop the site (as it can be done through a simple browser interface) made it a viable option for the client. The site would have a more user friendly interface and also be compatible with most browsers.


Challenges

  • Importing content from the old website to the Moodle application was a daunting task as it included over thousands of Images, audio files and multilingual support.
  • The HTML files were in different formats and there was no consistency in the format.
  • The audio files were not supported by Moodle. Breaking down the images into different files and embedding them into flash files was a big challenge.
  • To meet the requirements of the client for an Organization and Contract module using Moodle even though it does not allow all the required functionalities by default.

Technical Solution

  • The quiz and its responses of e-learning product were in the form of inconsistent HTML file structures. These responses were in JavaScript format. Q3 wrote importing programs which identified the tags and inserted the appropriate data in the Moodle application.
  • Q3 incorporated SAAS successfully. A custom module named Contract was developed in the admin section which handled all the permissions as per the Moodle coding standards. Q3 developed a capability system for handling page level permission restrictions for different roles.
  • Q3 enhanced the Moodle database and introduced some custom tables for contract and organization related data.
  • Q3 wrote parsers to convert the audio files into a format supported by Moodle. Q3 also created parsers to upload and link the audio files.

Technology Used

Architectural Component
Technology/Framework
Language
  • PHP 5.2/Moodle2x
Target Deployment OS
  • Windows
  • Linux
Server Software
  • Apache
Client Tier
  • PHP
Presentation Tier
  • HTML
Data Tier
  • MySQL
Tools
  • Eclipse IDE
  • SQLyog

Customer Speaks

blockquoteWe are very happy with Q3's capabilities, quality of work, and time-to-deliver; all of which are very important for us. At Janalent, we develop and deploy Microsoft technology based solutions for our customers and partners and have worked with Q3 on a number of projects. We have been extremely satisfied with the speed, accuracy, and quality provided by the Q3 team.

Q3 have been dedicated to the job, and the satisfaction of us and our customers. The Q3 team has gone the "extra mile" whenever needed and are responsive both day and night. Quality Assurance testing and Documentation are delivered as expected and issue resolution has been logical and pragmatic from diagnosis through resolution. The Q3 team has become a valuable extension of Janalent's team and we look forward to additional opportunities to work together. blockquote

Thomas Runds
VP Collaboration & Development, Janalent