Sunday, August 10, 2014

MySQL (MariaDB) converting character-set


mysqldump --user=username --password=password --default-character-set=latin1 --skip-set-charset dbname > dump.sql
sed -r 's/latin1/utf8/g' dump.sql > dump_utf.sql
mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;"
mysql --user=username --password=password --default-character-set=utf8 dbname < dump_utf.sql
credit goes tp: 
originally at

Friday, May 30, 2014

Badges - Revisit

Revisit -- Why?  
  • Things changed -- MOOCs --> OOCs 
  • And, with one of my student developers leaving, it gives me the opportunity of rethinking of the University Badge system design. People changing is always the time for changes!

Basically, what makes our system unique is that we want to take advantage of the popularity of Badging concept to 'promote and market' our online programs -- yes, it was indeed under the influence of MOOCs. When we looked at the Open and Bb badging systems, they were (are?) lacking of the seamless 'manageability' features for the online program providers. So, the in-house developed Badge system is designed to also provide a tracking and management system for the program owners outside of traditional formal SIS -- by taking advantage of the Badge concept, we are hoping to be able to stay out of being needing to keep grades.

Design Focuses:


  • Programs - Badges online catalog

  • Optional: Program WEB-flyer and multimedia

Badges Creation and Issuance -- Automagically

Badges are created and issued directly within Learning Management Systems (LMS) thru Learning Tools Interoperability (LTI). Badges and User Identity information are created automatically using the information in the LMS: Course Title, Course ID, User Name, and User Email information.
Wish List:- Issuing Milestone badges- Issuing Badges for NON LMS based Trainings


  • Default Badge template with 'realtime' computer generated imprint of Program and Recipient information. 
  • Allowing uploads of custom designed Badges
Wish List: Issuing Milestone badges; Issuing Badges for NON LMS based Trainings 
As you are aware, our system do not provide Milestone based badges as most MOOC only issues badge after completion of the course -- I may be wrong on that, let me know. However, to accomplish Milestones, the program manager can just create a Track with multiple UNITs (aka Bb course shells). That will accommodate the same goal. 

Manageability and Reporting

Background: The system intends to provide delegation of badge management (independent and isolated by programs) and database access in the tiered structure of Programs > Tracks > Units hierarchy. A program manager can manage and create tracks to group units (aka Bb course shells) into them. So, the program managers will also be able to run reports of identifying which students have complete what units as well as progress made in Tracks in a simple view. This does not seen to be an available function for the open self-evidence based badge systems; at least, it was not available 6 months ago when we looked.
  • Branding
  • Dashboard
  • Delegation of Badge management and report access. Program manager has access to badge management and reporting features of ALL Tracks and Units under the program. Track Manager has access to ALL management and reporting features of Units.

    Current hierarchy:

    • Programs
      • Tracks
        • Units (aka. LMS course shells)
  • Badge Management: badges can be mapped to a branch of Program and Track for delegate access and reporting purpose

Share Achievement

  • Realtime Lookup VIA a unique code AT

  • Printable certificate
  • Embedding Badge image
  • Embedding HTML code
Wish List: Converting the Unicode Code to a QR; Backpack


  • Institutional Maintained Data ware house allow Reporting:
    • List of Badge recipients
    • List of Badge recipients of a Track by Units (online version being implementing)
    • List of Badge recipients of a Program by Tracks and Units (online version being implementing)
  • Secured database for accreditation
-- This is an information document -- 

Saturday, May 10, 2014

Take Notes: ORTC

Object RTC (ORTC)

A free, open project that enables mobile endpoints to talk to servers and web browsers with Real-Time Communications (RTC) capabilities via native and simple Javascript APIs. The Object RTC components are being optimized to best serve this purpose. --

* tbc

Take Notes: WebRTC


WebRTC is a free, open project that enables web browsers with Real-Time Communications (RTC) capabilities via simple JavaScript APIs. The WebRTC components have been optimized to best serve this purpose. --


- VoIP
- Video Conferencing
- and so on


So, to keep it LIGHT (especially, Mobile):
iLBC (internet Low Bitrate Codec) is a FREE speech codec suitable for robust voice communication over IP. The codec is designed for narrow band speech and results in a payload bit rate of 13.33 kbit/s with an encoding frame length of 30 ms and 15.20 kbps with an encoding length of 20 ms. The iLBC codec enables graceful speech quality degradation in the case of lost frames, which occurs in connection with lost or delayed IP packets. --

Supported Browsers:

  • Chrome
  • Firefox
  • Opera
  • IE?


re-Linking Blog Posts to Twitter - testing keyword filter option

via twitterfeed