Archives For Moodle


How can you upload SCORM 1.2 package to Moodle 2.0? or Is your SCORM Packages is not working in Moodle 2.0?

When I upload SCORM1.2 to Moodle 2.0 and try to access the SCORM file, I was getting this error message

" Sorry, the requested file could not be found"  The reason I was getting this error because of the file names and they way I zipped the contents before I upload to Moodle.

This is what I have to do to make my SCORM 1.2 package work for me in Moodle 2.0.  I hope this will help you or get some idea about how you can upload SCROM 1.2 package to Moodle 2.0

1.  Go to to your folder where you have your SCORM 1.2 files are located.

2. Do not right click and zip the file. If you right click and create a zip package, it creates folder with in folder.  

SCORM Package for Moodle

3. Go inside of your folder and select all or CTRL + A and Right click on any file WinZip | Add to Zip |

 select-all-files-zip-2

4. Keep your zip file name simple.
I had problem after uploading SCORM file with long name with spaces

wrong-file-name-3-1

Simple name for SCORM package
My SCROM package worked in Moodle when I renamed the file with simple name with out any spaces

simple-name-scorm-2-1

5. Go to your Moodle site and Add an Activity and SCORM Package

add-an-activity-scorm-package

6.  Add a name and description for your SCROM package and choose a package file

scorm-general-4

7.  When you choose a file, File Picker window will open and select Upload a file and browse and attach your SCROM File

upload-scorm-package-to-moodle-5

8. Select your SCROM package and open and click on Upload this file to Moodle

upload-zip-scorm-file-to-moodle-6

9.  Your  SCORM package is ready for Moodle.  

open-scorm-package-7

10. When you click your SCROM package, you will get a option to preview or normal mode. Click on Normal and Enter to see your QUIZ

 open-scorm-in-moodle-7

11. Successfully uploaded SCROM 1.2 package to Moodle 2.0

scorm-quiz-in-moodle-8


In Moodle 2.X, by default maximum upload file size is 2MB. How do you increase the max upload size for Moodle?

The solution which you see here apply to you if your Moodle is running in a Shared Hosting.  Right now my Moodle site is hosted at Bluehost.com and using cPanel.

1. Use your FTP client and connect to your Moodle server and open public_html folder.  In public_html folder you will find a file called php.in.  Click on php.in file and press edit button.

Editing PHP.INI fine in Moodle

2.  The php.in file which you open will have one line.  You need to add

upload_max_filesize = 20M
post_max_size = 20M

to your php.in file and save the file to your server.  If you want to increase the file size just change the numbers

Upload Max file Size  in Moodle

3.  Now login to your Moodle site as administrator
Go to Site Administration | Security | Site Policies | Maximum Uploaded file section

This specifies a maximum size that uploaded files can be throughout the whole site. This setting is limited by the PHP settings post_max_size and upload_max_filesize, as well as the Apache setting LimitRequestBody. In turn, maxbytes limits the range of sizes that can be chosen at course level or module level. If ‘Server Limit’ is chosen, the server maximum allowed by the server will be used.

Click on the drop down list and you should see your new maximum uploaded file size in Moodle.  Select your new maximum uploaded file size and click OK


maximum_uploaded_file_moodle

4. Also go to Course Administration | Edit Settings|  if you don’t see the new maximum uploaded file size , just click on the dropdown and apply new size 

edit_course_settings_maximum_upload_size


Your site configuration might not be secure. Please make sure that your dataroot directory (/home3/parent/public_html/datarootdir) is not directly accessible via web.

Above is a typical message you get when you login into Moodle if it’s installed  in shared hosting.

Your site configuration might not be secure. Please make sure that your dataroot director

How do we block dataroot directory not directly accessible via web? 

We have to move dataroot directory from public_html folder to the root of your web hosting. Here are the instructions what you have to do to move the dataroot folder away from public_html in Moodle.

1. Connect to your web server using any FTP client (I am using WS_FTP) and go to public_html folder.

public-html-moodle

2. In public_html folder find dataroot folder.  Download this folder to your desktop or any where in your computer. You can also copy and past the folder in the root folder but it take long time. Do not delete the datarootdir in public_html folder NOW.

datarootdir-in-moodle

3. Now move datarootdir to your root directory. Root directory is folder/

move-datarootdir-to-root-folder

4. Once you moved datarootdir folder into Root directory, click on public_html folder and edit config.php file.  We need to change the path so that it can point to new location of datarootdir folder.

open-config-php

5.  This is how your config.php file will look like.  Where it says $CFG—>dataroot = “/home/root/public_html/datarootdir’; you need to change this to “/home/root/datarootdir’.  Just remove /public_html  line  and save the file.

remove-public-html

 

6. Now if you log back into Moodle, you will not see

Your site configuration might not be secure. Please make sure that your dataroot directory (/home3/parent/public_html/datarootdir) is not directly accessible via web.

message anymore. now you can go to your public_html folder and delete your datarootdir


Installed Moodle 2.0 using shared hosting. When I logon to my Moodle site,  this is the message I am getting

"Database tables are using MyISAM database engine, it is recommended to use ACID compliant engine with full transaction support such as InnoDB."

In my previous post I mention that you can change the MyISAM database engine to InnoDB using phpMyAdmin : Convert MyISAM to INNODB using phpMyAdmin for Moodle but it will take some time to change each table one by one.

I was looking for a good solutions to convert the MYISAM engine to InnoDB very fast and I found a blog which gives very good instructions.How to Migrate Your MySQL Database from MyISAM to INNODB

Two problem I found in the above post:

1. I was not able to see the video files from work to see the full instruction

2. It shows how to import the database but not showing what are the limitations involved in when you host Moodle in shared hosting environment.

Here are the instructions how you can resolve "Database tables are using MyISAM database engine, it is recommended to use ACID compliant engine with full transaction support such as InnoDB."  message in your Moodle 2.x

 

My current Moodle site is hosted at http://www.bluehost.com and I installed Moodle using Simple Scripts.  When you install Moodle using Simple Scripts, it will create MySQL Database and User name by default.

1. Login to your control Panel. Go where it says Database and you can see MySQL Database and phpMyAdmin. 

image

2. Click on MySQL Database to your current database

MySQL Database to your current database

As you can see Moodle installation created a database and user name.  We are going to export the current database and change MyISAM to INNODB and import back to MySQL using myPHPAdmin

3. Go to phpMyAdmin and export your database

Export Database using phpMyAdmin

 

For the database name you can leave it as since it’s know the current database name and click GO

image

 

Save the file

 

Exporting Database from myPHPAdmin

 

 

4. Open your database file in any tools which you have. In my case, I am using Dreamweaver.

Click on CTRL + F  to  find and replace of "myISAM" with "INNODB" (without quotes, of course) in the SQL dump text file

 

Find-myISAM-Replace-Innodb

5. Go to the top of the sql file which you opened and enter SET AUTOCOMMIT = 0;

set-autocommit=0

 

6. Now go to the end of the file and enter  COMMIT; and save your file.

image

 

Now  are going to import this file into phpMyAdmin but before we do that we have to drop the current database.

7. Go back to phpMyAdmin, Since I am hosting my Moodle in shared hosting I don’t have any options to drop a database.  

Drop Database from myPHPAdmin

8. When I run the SQL query Drop Database “database_name” I got following error message.  Drop Database statements are disabled

 

drop-database-statement-are-disabled 

9. Only way I can drop the database is by going to Cpanel and delete the database from MySQL Admin.  Login to your control panel

Click on MySQL Databases

mysql-database-cpanel

Delete your current database

delete-database-file

10. Confirmation to delete database

 

delete-database-mysql

 

11. Now create a new database but the name should be same as the one which you deleted.  Add user to Database.

 

Create new database in MySQL

 

12. When you add user to Database and give all privileges.

Manger User Privileges

 

13. Open your myPHPAdmin and you will see your empty database and now import your modified database

Import Database  to change to INNODB

14. You can see the Database from MyISAM to INNODB are changed. 

from MyISAM to INNODB are changed

If you open your Moodle right now it should work and you wont’ see the error message any more.  This is how you can change your MyISAM to INNODB. 
It took me while to figure it and good luck


How to convert from MyISAM to InnoDB using phpMyAdmin?

When Installed Moodle 2.x, following message are showing up in the font page of Moodle.

Database tables are using MyISAM database engine, it is recommended to use ACID compliant engine with full transaction support such as InnoDB.

Moodle Error : Database tables are using MyISAM database engine

When searched for “convert MyISAM to InnoDB using phpMyAdmin” in Google, I got many responses and I also found a link from Moodle which didn’t help me at all.

I finally found this article from http://richardcummings.info/convert-myisam-to-innodb-using-phpmyadmin/comment-page-1 and the instructions says

You can convert from MyISAM to InnoDB in phpMyAdmin with just a few clicks. To convert your data tables from MyISAM to InnoDB in phpMyAdmin, you will select the table, click the “Operations” tab, and then choose InnoDB from the drop down box next to the “Storage Engine” type. Click “Go” and you are done!

I couldn’t find the Drop Down box next to “ Storage Engine” After playing around, I came to know where to find drop down box

 
1. Go to phpMyAdmin

2. Select your database and click on Structure icon

convert MyISAM to InnoDB using phpMyAdmin

 

3. This is what you will see when you click on structure icon

convert MyISAM to InnoDB for Moodle

4.  Now click on Operations tab and now you will see Storage Engine and if you click on the drop down, you can see InnoDB.  Select InnoDB and click GO

image

5. Now if you go back to your database table, you can see type is changed to InnoDB

converted MyISAM to InnoDB using phpMyAdmin Storage Engine

 

Using this method you can easily  convert your database from MyISAM to InnoDB using phpMyAdmin. 

Many Thanks to Richard Cummings


Enabling Microsoft Office SharePoint Server as the File System for Moodle

Safeguarding files saved in Moodle just got better.  As the title suggests, the white paper explains how IT Pros and partners can configure Moodles to use Microsoft SharePoint, a world class content management system, as the file system for all of their Moodle instances.  Moreover, IT Pros and partners do not have to develop or install any new code to enable this integration.

Read More: Enabling Microsoft Office SharePoint Server as the File System for Moodle


 

How to replace standard Moodle 2.0 Icons to something fancy.


Image locations within Moodle

Core images are used throughout Moodle and are stored in moodle/pix.

The pix directory contains the following subdirectories:

a – Icons that are not widely used
c – Calendar-related icons
f – File icons for different file types
g – Default user icons and thumbnails
i – General icons
m – Currency symbols
s – Smileys
t – General icons
u – User icons and thumbnails
y – YUI icons

1. I want to change General icons in Moodle 2.0 to something fancy.

To do this Go to moode/pix

Changing Moodle 2.0 General Icons

2. Open  i – General icons folder

General icons in Moodle 2.0

3. Now go to http://server3.moodle.com/secure/attachment/15485/moodalis_tango.zip and copy download tango icons

4. Unzip the files and copy all the icons from i folder

5. Replace all the icons in your Moodle server with tango icons.  My new icons in i folder

Replace standard Moodle 2.0 Icons


1. Unzip the .zip file to an empty local directory.

2. Upload folder to your web server to the /moodle/theme/

Installing Moodle Theme in Windows Server

3. Now go to your Moodle Site  via Site Administration > Appearance > Themes > Theme selector  and select your new theme which you installed

Moodle Themes Selector

4. My new them called Universite is added to Theme Selector


If you need to know how to install Zend Server in Windows 2008 server, please visit my previous post: http://virtualizesharepoint.com/2011/04/26/installing-zend-server-community-edition-ce-in-windows-2008-server/

Copy Moodle to Zend Server directory

1. Download Standard Moodle Packages from http://download.moodle.org/ and unzip the files

Download Standard Moodle Packages

2. Go to your ZEND directory where you will see four folders.  Apache2, MySQL51, phpMyAdmin and Zend Server in you Windows 2008

Installing Moodle 2.0 using Zend Server

3. Open Apache2 folder and navigate to htdocs in Windows 2008

Installing Moodle 2.0 using Zend Serve : Apache Server  

4.  Move your Moodle files to htdocs folder in Windows 2008

Move Moodle Folder to Apache 2 htdocs folder

5. Now we need to make some changes to install.php file in Moodle folder. Before we do that, we need to create a database in MySQL.

Creating Database in MySQl using phpMyAdmin:

1. Open up your Zend Server by going to Start | All Program | Zend Server | in Windows 2008 Server

Opening Zend Server in Windows 2008

2.  Enter your password for Zend Server

Enter password for Zend Server

3.  Open up phpMyAdmin

Open phpMyAdmin in Zend Server

4. Enter your user name and password for phpMyAdmin

Login to phpMyAdmin in Windows 2008

5. Create a new database for Moodle. In this case, I am creating a database called moodle which is going to be used for Moodle installation in Windows 2008 server using Zend server.

Create MySQL Database in Windows

6. Your new database is ready for Moodle installation in Windows 2008 server using Zend

Moodle Database in phpMyAdmin

7. Now we have to go and create a user account for emoodle database.  Make sure you have your new database selected and click on privileges

Creating accounts in phpMyAdmin 

8. Click on add new user

Add new user in phpMyAdmin

9. Create a new user name and password and make sure you have Grant all privileges on database “emoodle”

Adding new user in phpMyAdmin

Configuring install.php file to install Moodle in Windows 2008 server using Zend server.

1. Go to your Moodle folder and open install.php

image

2.   In Moodle 1 x, we need to manually Add dbhost, dbuser, dbpass, dbtype, dbname and save the install.php file to moodle directory but in Moodle 2.0 we don’t need to make any changes.


  image

3. now open your browser and type in http://localhost/moodle and you should see the installation screen.  Select your language and click next

Moodle in Windows 2008 Server using Zend

4. Confirm your path and click next

Moodle path in Apache2 server

5.  Choose your database drive and click next

image

6.  Enter your database settings

Moodle 2.0 database settings

7. Click Continue after reading the copyright notice

image

8. Getting a new error message : Moodle 2.0 Error with Unicode format (UTF-8)

Please see my previous post how you can resolve this problem:
http://virtualizesharepoint.com/2011/04/27/it-is-required-that-you-store-all-your-data-in-unicode-format-utf-8-while-installing-moodle-2-0/

Moodle 2.0 Error with Unicode format (UTF-8)

9. Click next to run the installation and once it’s completed, you will see the General information window. Enter all the required information and click update profile.  Next window you will see your new Moodle 2.0

Moodle 2.0 Installation: General

10. Your Moodle site is ready for action in Windows 2008 server using Zend Server:

 

image


Getting error message while Installing Moodle 2.0

It is required that you store all your data in Unicode format (UTF-8). New installations must be performed into databases that have their default character set as Unicode. If you are upgrading, you should perform the UTF-8 migration process (see the Admin page).

It is required that you store all your data in Unicode format (UTF-8).

Solution:

1. Open your Moodle database which you created in MySQL using phpMyAdmin

It is required that you store all your data in Unicode format (UTF-8): Solution

2. Run

ALTER DATABASE mydatabasename charset=utf8;

MyDataBaseName= Your Moodle database

It is required that you store all your data in Unicode format (UTF-8): Alter Database

3. No more error message saying

It is required that you store all your data in Unicode format (UTF-8). New installations must be performed into databases that have their default character set as Unicode. If you are upgrading, you should perform the UTF-8 migration process (see the Admin page).

No More Unicode format Error Message

Technorati Tags:

Installing Zend Server CE in Windows Server 2008 to run Moodle 2.0 using MySQL and Apache Server

1. Go to http://www.zend.com/en/products/server-ce/downloads and download Zend Server for Windows

2.  Run the installation files

Installing Zend Server in Windows Server

3.  Zend Server CE installation wizard

Zend Server CE installation wizard

4. Welcome to Zend Server Community Edition 5.1 Installer.  To continue click Next

Zend Server Installation Wizard in Windows Server

5.  Accept the term of the license agreement

Zend Server Installation: Licence Agreement

6.  Select the installation Method.  I am going for custom installation since I want to add PHPAdmin and MySQL

Custom Zend Server Installation in Windows Server
7.  Custom installation with phpMyAdmin and MySQL Server

Custom installation with phpMyAdmin and MySQL Server

 

8.  Installing an Apache Web Server in Windows 2008 Server.  Destination as D drive.

Installing an Apache Web Server in Windows 2008 Server

9. Default Port for Apache in Windows Server

 Default Port for Apache in Windows Server

10.Installation Settings Summary for Zend Server in Windows Server

Installation Settings Summary for Zend Server
11. Zend Server was successfully installed in Windows server 2008. Click finish to open Zend Server

image

12.   End User License Agreement. Add a check mark for the agreement and click next

image

 

13.  Set a password for your Zend Server Administration Interface

Zend Server Administration Interface

14. Newsletter Registration is optional and click next to access Administration Interface

image

15. Under Task click on Open phpMyAdmin

phpMyAdmin in Zend Server

16.  By default phpMyAdmin password for Zend Server installation in Windows Server is none. User name is root

user name: root
password: (nothing)

phpMyAdmin in Windows Server

17. Once you login into phpMyAdmin, you will see this message in the bottom of the screen saying root with no password

Root with no password for phpMyAdmin

18.  Click on Privileges in phpMyAdmin and setup a password for Root.

Setup password for Root in myPhpAdmin

This is how you install Zend Server in Windows 2008 server using phpMyAdmin and MySQL server.  In my next blog, I will speak about how you can install Moodle in Apache server.


Go to Site Administration > Modules > Blocks > Manage blocks.

In the Blocks listing, find Flickr and click on the eye image to disable

Disable Flicker in Moodle


  • Go to Site Administration > Users > Accounts > Upload users.
  • Click the help bubble beside the words "Upload users" and expand the pop-up window.

    Upload Users to Moodle 

    Make sure you have CSV files contain all the information which you want to upload.  If your not sure how to create CSV files, this is what you have to do.

    Open your MS Excel or any other spread sheet program. In this case, I am creating CSV files which contain User Name, Password, First Name, Last Name, Email address and My School (which is a custom filed which I created)

    Creating CSV file for Moodle

  • Once you filled all your information save this file as CSV

    Saving CSV file for Moodle User Upload

     

    Now browse and select your CSV file to upload all users to Moodle


    1. Go to Site Administration > Users > Accounts >User profile fields.

      Custom Profile Filed in Moodle

    2. Here you will find three choices in the “Choose” drop down menu: Menu of choices, text area, and text input:
      • A menu of choices allows you to enter the choices that a user will select from a drop down menu. This is a good choice if there is a pre-determined set of possible entries.
      • The text area will give the user a large text box in which to enter information. This is a good choice when the entry is long and will contain much information.
      • The text input field gives the user a much smaller text box to complete their entry. This is good for entries that will be one or just a few words. The size of the text box can be modified for either of the last two choices.
    3. Select the type of field you think will be the best based on the scenario described.

    How do I add a users as a course creater in Moodle?

    Site Administration | Permissions | Assign System Roles
    Click on Course Creator

    Assign Course Creater Role in Moodle

     

    Select the user from the list and click on Add

    Adding user as Course Creater in Moodle