Little bit of spying

Maybe under slight influence of the latest James Bond movie, but more probably because I was asked for it, I provide you with SQL query to spy on your teachers. This asnwers a question which courses have a teacher (or teachers) and when was the first time and last time they visited their courses.
It could be used for 1.8+ version of Moodle, with default setting of roles (as roleid = 3 means "teacher" role).
I don't know about speed of this thing, so be careful of running this on production servers under heavy load. Use it lightly, no whipping of lazy teachers please :)


Btw I used Adminer, very lightweight MySql tool, for running this. This can come really handy, if you don't have anything stronger at hand.

Move category up, up and away!

Recently I needed to move newly created category name higher. So I logged as administrator, went to mymoodle.com/course/index.php page, pressed Turn editing On and..waited..waited..and waited.


I am not sure about using Ajax with moving up/down categories, but by default it could take a while to render form with all categories and subcategories. It surely took me a while for a form with 144 categories and subcategories. When you have subcategories in three level category tree it is getting to add up ;-).

Move newly created category, of course it placed itself just at the bottom, would be really bothersome with such a loading times.

So I got an idea with a quick, dirty solution. Maybe I am just dumb and you all know this, but it took me a while so I want to spare you some minutes thinking.

Survive first form loading, select category to be moved, press up or down arrow in the direction you want category to move, click it, wait for a second, just for page to start to render and stop the loading.

It's a red cross right of refresh button on your browser.



This will stop rendering form with categories and subcategories, but all hard work has already been done behind the curtains. So just enter URL in your address bar (there should be something like yourmoodle.com/course/index.php?moveup=66&sesskey=HoNFzG43Zy - moveup parameter is for category and sesskey is needed for security) or press refresh button (F5 key usually) and repeat stopping/refreshing page few steps needed for category to find new shiny place to live.

I hope I didn't insult my dear readers with such a lazy dirty trick, but these tricks are the best one and sometimes the hardest ones to think up.

Moodlerooms binds Moodle and Google Apps together

Google is getting to the schools and universities with offer of Google Apps (solution for e-mails, document management) more and more. And so it makes a sense to use widely known Moodle and create something that will be useful for both sides.

I think that recently released news on Moodlerooms site(company that is certified Moodle partner and company that brings some really good Moodle stuff again and again ;-)) about offering single sign-on between Moodle and Google App is great and I think this will help another schools to decide what they will be using to solve their e-learning needs.

Press release is to be found HERE

New features ideas? It is time...

Do you have idea for new feature for Moodle that will blow everybody minds? Feature that will be used around the world and in the nearby universe? Now it is perfect time to make something about it.

Moodle.org is preparing for another round of GSOC (Google supported contest for students) and needs new ideas.

More can be found in this announcement

(Via www.moodlerific.org )

VPN driving me mad

Today something different than usual Moodle ramblings ;-).

I use VPN connection on one of my projects. VPN is for Virtual private network. You can picture VPN as small, safe island in rough sea of the Internet ;-). It combines conveniences of private network - security and global network - access from anywhere, you can mount disks from server as local disks etc.

Set up VPN is fairly easy, you can see tutorial with pictures for example here. I created VPN connection without problem, only thing that bothered me (I am used to restarting IM services - skype, icq when connecting to the VPN) was annoying popup window demanding me to login to VPN even if I didn't want to use it.

It jumped on me on random moments, I noticed, that this may have something to do with problems with internet connection. If there were some hiccup when loading web pages, VPN thought there is a problem with net, jumped in to save the day...which has happened to be very bothering and unnecessary.



I am using Windows XP and Firefox 3, I tried to find where is the problem. Checked the network setting to disallow VPN to redial, checked Firefox setting for connection, but without luck. At last I found solution where I have never expected it. You have to go to Internet Explorer setting and set VPN connection to never dial. Windows thinks VPN as dial-up connection and Firefox takes this setting directly from Internet Explorer (strange, I know).



You can find how to set this up for example on this page .

I hope this will help someone with same problem, saves you some needed time, nerves and hairs :-)

Ugly category names on front page? Pimp it!

Did you ever take a look at your Moodle front page and thought: "This looks bad, lame textual category names everywhere, it's so boring" ?

You can change that easily and add some appropriate images instead of dull category names.

• turn on Include topic section (see here how - don't forget to turn off displaying old categories list)


• create or update Label in topic section on the front page


• create or download some fancy icons, web is full of them (search www.iconarchive.com, use www.iconfinder.net, www.webappers.com has nice selections or just Google it :-) )


• add icons into created Label


• place them into html table or use css to position them correctly
  


• select icon and Insert weblink with url to selected category to it


• save changes

With little effort you can create beautiful Moodle front page. See examples here and here

Idea from http://www.edugeek.net forum, icons used in my examle: Lord application icon by FixIcon

Moodle failed my trust

I read today this blogpost about author's experience with "overwhelming" teachers with Moodle rich features on the training, on the presentations, just to confuse or even scare them..

I found I am guilty with that too ;-).

But another idea crossed my mind. Did you ever "hype" some Moodle feature that didn't work as you expected later? Did you say to yourself: "Oh man, I wish I have never installed this, I wish I have never spoken about that, this is so much pain in ...". Did you ever regret you went with Moodle?

This article is not about blaming Moodle, unfortunate events happen all the time everywhere. I am just interested in situations, features that didn't go well or as you planned and how did you solve that? I love happy endings ;-).

I am looking forward to your comments :-).

Alfresco and Remote-Learner.net Partnered

I am more and more looking into Java language and CMS Alfresco, that is very powerful as a repository, content version tracking system etc. and I am glad to hear, that Alfresco is going to collaborate with Moodle more (see Alfresco tie-in in Moodle 2.0 on moodleman.net blog ).

Today I found that Alfresco made a connection with a Remote-Learner.net, who is a provider for Open source e-learning solutions, Moodle partner by the way, and together they will provide new Enterprise Learning Intelligence Suite for Moodle (ELIS) that, I hope, will solve some problems with content sharing, content management and security Moodle is having.

And here is a LINK where I found this news.

How is Moodle developing?

Did you ever wondered, how it is going in Moodle development? What is being done right now, when you will be able to try new features?

I found today on moodleman.net (btw really fine blog) link to Google doc with constantly revised Moodle development planning.

So take a look, it is really interesting and it will put you in the picture, how much work Moodle is ;-).

LINK

Dimdim out of Beta

Dimdim is a startup who promise easy conferencing platform without need to install additional desktop client, looking for hosting, anything. All you need is a browser :-). You can create online conference, share your desktop, voice and video (imho for for sharing your desktop is some plugin needed to install).



It's been a while Dimdim successfully integrates in Moodle, now the company releases new version, it's out of beta and will be releasing its source codes under GPL3 license.

Basic, free version, allows 20 attendees in the room, but if you need create bigger conferences you have to pay.

I saw some captures from Dimdim usage, it is looking very promising. Maybe it is a time to check it too, it is on my to-do list for a long time.

Some goodies here, if you will sign-up through this Techcrunch arcticle you may be awarded with Pro version (worth $99 annually, room for 100 attendees etc) for free :-).

Did you try Dimdim in Moodle? What's your experience?

One Minute Video: Adding Youtube clip to the Moodle course

Online video sharing servers are on the rise. YouTube.com is one of the biggest and most known. Many teachers found this site useful for learning, they are uploading their's videos, homemade screencast etc to this service and are inserting these clips to their Moodle courses.

This screencast is first (I hope that it won't be last ;-)) in series of One Minute Videos where I want to show some basic things you can do with Moodle in just one minute.

It's without sound for now, I am little bit shy about my spoken English(not native as you already learned ;-)) and my voice (do you hate hearing yourself on some recordings too?), but in the future... :-D.

Feel free to ask if something is not obvious, I tried to not move fast to everything stays distinguishable.

How to change Enrollment key

One of my teachers forgot how to change enrollment key for new semester. I made small video to show and I would like to share it with you.

Moodle allow teachers to "lock" their courses with enrollment key (this is for default enrollment, if you are using for example external enrollment plugin, it might be different).

If you have set enrollment key, users have to fill this key before their access locked course for the first time. After they successfully fill that key, they are enrolled.

On the page with enrollment key form, link to the course teacher is displayed to allow users to contact someone to obtain that key.



If your enrollment key became corrupted, you can change that key, get rid of unwanted students in your course with Role assignment and your already enrolled students won't be affected by this change of enrollment key. Please, take better care for your new key, see MI for example, how it should be done :)

Remember Mission Impossible "As always, should you or any of your IM force be caught or killed, the Secretary will disavow any knowledge of your actions. This tape will self-destruct in five seconds. Good luck, Jim." :-D

Back to Course Setting. You will scroll down, there you will find field for Enrollment key. This key is stored in database in plain text, so if you only need refresh memory what key you are using, check Unmask checkbox next to the Enrollment key field.(in 1.9 version)

You will find option to allow access for guest just below this field.

Enrollment key will allow you to insert new students to group automatically, but about that maybe next time ;).

And now promised video finally:

Moodle as LEGO

Have you ever wondered how to explain Moodle in easy way? You don't have to anymore, just watch this video ;-)

More wonderful 2 minutes Moodle tutorial videos

Undefined method domdocument:load() in Moodle 1.9

Hello my faithful followers, I hope there remained some after so long blogging hiatus. You know, been busy ;). New fulltime work, less time for Moodle. But now I am preparing upgrade to Moodle 1.9 for my installations, so I plan to blog more about various things I'll met on the road to new shiny Moodle :).

I am going to start right now. I am using XAMPP package on my development machine, currently had installed
1.6.7 version. XAMPP is really easy to install, you are good to go in any time. This time I plan some tweaking, multiple virtual hosts with different documents root etc., but this is for another post (after I make it work ;)).

I downloaded current Moodle 1.9 version through CVS, started to install it, but just after few steps I have been rewarded with this error:

Fatal error: Call to undefined method domdocument:load() in \lib\xmldb\classes\XMLDBFILE.class.php on line 85


This has been easy prey, luckily. After quick googling I found this thread on moodle.org.

In short, it is XAMPP fault, php_domxml.dll extension is making ruckus. For this time being I solved it as is written in mentioned thread, I have found currently loaded php.ini (with phpinfo.php script - it is present in xampp installation), added ";" before line extension=php_domxml.dll, saved php.ini and restarted apache.

Installation is working now, I will try to look into this extension problem more, if I will find more informations about it.

So, that's all for today, see you next time :)

Google analytics in Moodle course

I just read interesting post yesterday about adding Google analytics code for easier and faster monitoring your users here http://www.relearn.ie/2008/04/16/using-google-analytics-and-moodle/

Google analytics is a free tool for monitoring your site, watching visitors habits, provide lot of statistics , widely used by site creators. Check GA site to learn more.

This was quite a new for me. I did installed GA in Moodle too, but I have inserted it into the footer file in the theme. In this case GA is "watching" all your pages, all courses(I assume I am using only one theme), just everything. This could be useful, but too overcrowded with informations as you monitor all pages on your site. And you need to have access to themes of course ;).

Approach mentioned higher has some serious disadvantages, that is monitoring only front page of the course where GA code is inserted, but has one GREAT advantage. It is easy, teacher can add GA code himself, no asking and begging needed.

So if you are teacher and need something for your course (for example you want to learn what browser resolutions your students are using etc) go that way. Mentioned post is very descriptive and useful.

I am not sure about position of the block itself. GA code is usually placed to footer area of the pages or as lowest as possible. And if I am not wrong, lowest right is farthest in the code. Moodle will print left column first, then middle (well known error when you didn't upgraded all third party modules and printing of content halts after only a few topics due a missing activity or module) and right column finally.

My advice is to move the GA block to the right bottom. Eamon from the rElearn.ie wrote in the comments that he used Firebug to find best position. I just checked source code of Moodle courses and imho right lowest block is farthest in the code.

So if someone will make some experiments about positioning of the GA block, please share it.

Confirmation email sender

I wrote about confirmation emails here. I noticed I missed one thing, you can have problem about. Who is sending them?

Admin does that! Or better, confirmations emails are sent from email address that is set up in admin account. If you have more admins, it's primary admin, that is the first one, he was created when the Moodle has been installed. Change his email address and confirmation emails sender address should be changed too.

Reset role to default

Did you play with roles settings but suddenly something is not working correctly and you don't know which change is the culprit? Did you want to reset role to default and can't find button? I know solution!

I read about role resetting to default on moodle forums but couldn't find mentioned button, but I noticed in the code, that the needed part is there.

So try to edit role you want to reset


Editing page will show up. Look into address bar, there you should see something like this:

http://yourmoodleurl.com/admin/roles/manage.php?action=edit&roleid=7 (the number denotes role id you are editing)

Change action=edit to action=reset. Everything others stays as before!

Press enter. You should see notice, if you are sure to reset role to default. If you are, reset it ;-).

Let me know, if you found easier way, I tried 1.8.2 and 1.9 versions but cannot find resetting button :-(.

Unable to reset password in Moodle

You might know that Moodle helps your lost users not knowing their's password by resetting it.(It depends on the authentication plugin though.)

User needs to insert username, or registration email, Mooodle will send mail with link to reset that password. This is somehow cumbersome but it disallow pranks from malicious users trying to disable another user access.

But it can happen, that mail without the password reset confirmation links is sent. It contains these lines:
"Unfortunately your account on this site is disabled and can not be reset,
please contact the site administrator,"

In these cases please check if:

1. authentication plugin user had been registered with is enabled
2. user is not disallowed from login with 'nologin' tag in his authentication column in the DB
3. user has rights for changing his password - moodle/user:changeownpassword (Moodle 1.9)
4. authentication plugin contains these lines:

  function can_change_password() {
          return true;
     }

Hope this will help solve problem with resetting passwords.

Is Moodle ugly?

One of blogs I have in my reader published today article about Moodle : Training the Web Worker Way: Moodle

Some interesting links there, but first comment under that article has brought up a question I heard more often recently. "Moodle is bad designed", "Moodle UI is too complicated" or "Moodle is just plain ugly".

I am working with Moodle for years, I am not encountering that problem often. (And when I don't know, how something is working, I just look into code...I know, I am weird ;-) )

What do you think? Is this correct? Are you getting lost all the time when you use Moodle? Any specific ideas for better UI? Any thoughts welcomed.

Picture inspired by Disney's The Hunchback of Notre Dame

Moodle 1.9 finally stable

After long period of testing, including recently ended Bugathon, Moodle 1.9 is available and in stable version.

You can find more information here http://moodle.org/mod/forum/discuss.php?d=91667

I hope I will return after my current blog hibernation to show you some new goodies 1.9 is made of.

I am planning to stroll through all modules, look for changes and highlight most useful stuff.

I think that waiting will be worth of, that the new 1.9 version will be very successful, robust and bugfree. All developers worked very hard to achieve that.

Stay tuned :)