MoodleDocs - Wkład użytkownika [pl]

Progress Bar block

2014-05-07T05:33:48Z

Deraadt: Updating after recent functional changes

[[Blocks|Back to Blocks page]]

== Features ==

[[Image:Bar_in_block_-_with_details.png|right|A progress bar for a student]]
* The Progress Bar is a time-management tool for students.
* It visually shows what activities/resources a student is supposed to interact with in a course.
* It is colour coded so students can quickly see what they have and have not completed/viewed.
* The teacher selects which pre-existing activities/resources are to be included in the Progress Bar and when they should be completed/viewed.
* Ordering can be done by times/deadlines or by the ordering of activities in the course.
[[Image:Overview_of_students.png|thumb|right|The overview page]]
* There is an overview page allowing teachers to see the progress of all students in a class, which is helpful for finding students at risk.

<mediaplayer>http://www.youtube.com/watch?v=06LA5Cv9Fhw</mediaplayer>

== Installation ==

The Progress Bar block is added like other blocks ([[Installing_contributed_modules_or_plugins|How to install a block]]).

== Setting up a Progress Bar ==

Once the progress bar is installed, you can use it in a course as follows.
# Turn editing on
# Create your activities/resources as normal
# Add the Progress Bar block to your page ([[Blocks|How to add a block]])
# Move your Progress Bar block into a prominent position (click and drag the block title)
# Choose to:
#* Monitor all activities (pre-fills configuration page)
#* Select which activities to monitor (start from scratch)
# Set the activities/resources you want shown in the block to "Yes" and those you don't to "No".
# Set the date and time when the activity/resource is expected to be completed/viewed by (some activities have deadlines set, if so, that deadline can be used or another can be set in the Progress Bar block configuration).
# Save changes.

<mediaplayer>http://www.youtube.com/watch?v=ekH8IfCyGzM</mediaplayer>

Hidden items will not appear in the Progress Bar until they are unhidden. This is useful for a scheduled release of activities.

== Links ==

* [http://moodle.org/plugins/view.php?plugin=block_progress Block code in Plugins repository]
* [http://tracker.moodle.org/browse/CONTRIB/component/10489 Bug Tracker Page] (Please report bugs here)
* [http://cvs.moodle.org/contrib/plugins/blocks/progress/ CVS Repository]

== Acknowledgements ==

* Thanks to:
** Toshimi Hatanaka for contributing a Japanese translation
** Yvonne Schneider and Joachim Vogelgesang for contributing a German translation
** Maria João Spilker for contributing a Portuguese-Brazilian translation
** Pieter Wolters for contributing a Dutch translation
** Fernando Sánchez for contributing a Spanish translation
** Fabien Sartoretti for contributing a French translation
** Adam Levy for contributing queries and strings for Hot Potatoes support
** Petras Virzintas for contributing queries for Turnitin support
** Willian Mano for helping with the modern look CSS
** Matthieu Rolland for contributing queries for the Questionnaire module
** Johan Reinalda for contributing global config changes for block colours

[[Category:Contributed code]]

Progress Bar block

2014-04-14T04:54:05Z

Deraadt: Adding Johan Reinalda's contribution

[[Blocks|Back to Blocks page]]

== Features ==

[[Image:Bar_in_block_-_with_details.png|right|A progress bar for a student]]
* The Progress Bar is a time-management tool for students.
* It visually shows what activities/resources a student is supposed to interact with in a course.
* It is colour coded so students can quickly see what they have and have not completed/viewed.
* The teacher selects which pre-existing activities/resources are to be included in the Progress Bar and when they should be completed/viewed.
* Ordering can be done by times/deadlines or by the ordering of activities in the course.
[[Image:Overview_of_students.png|thumb|right|The overview page]]
* There is an overview page allowing teachers to see the progress of all students in a class, which is helpful for finding students at risk.

<mediaplayer>http://www.youtube.com/watch?v=d43KVlMBmLA </mediaplayer>

== Links ==

* [http://moodle.org/plugins/view.php?plugin=block_progress Block code in Plugins repository]
* [http://tracker.moodle.org/browse/CONTRIB/component/10489 Bug Tracker Page] (Please report bugs here)
* [http://cvs.moodle.org/contrib/plugins/blocks/progress/ CVS Repository]

== Installing ==

The Progress Bar block is added like other blocks ([[Installing_contributed_modules_or_plugins|How to install a block]]).

Once the progress bar is installed, you can use it in a course as follows.
# Turn editing on
# Create your activities/resources as normal
# Add the Progress Bar block to your page ([[Blocks|How to add a block]])
# Move your Progress Bar block into a prominent position, eg. top-left (click and drag the block title)
# Click the Configuration icon on the block below the title
# Give your Progress Bar block a title (default is "Progress Bar")
# Set the activities/resources you want shown in the block to "Yes"
# Set the date and time when the activity/resource is expected to be completed/viewed by (some activities have deadlines set, if so, that deadline can be used or another can be set in the Progress Bar block configuration)
# Save changes

Hidden items will not appear in the Progress Bar until they are unhidden. This is useful for a scheduled release of activities.

== Acknowledgements ==

* Thanks to:
** Toshimi Hatanaka for contributing a Japanese translation
** Yvonne Schneider and Joachim Vogelgesang for contributing a German translation
** Maria João Spilker for contributing a Portuguese-Brazilian translation
** Pieter Wolters for contributing a Dutch translation
** Fernando Sánchez for contributing a Spanish translation
** Fabien Sartoretti for contributing a French translation
** Adam Levy for contributing queries and strings for Hot Potatoes support
** Petras Virzintas for contributing queries for Turnitin support
** Willian Mano for helping with the modern look CSS
** Matthieu Rolland for contributing queries for the Questionnaire module
** Johan Reinalda for contributing global config changes for block colours

[[Category:Contributed code]]

Assignment settings

2014-03-20T03:35:45Z

Deraadt: Undo revision 111194 by Deraadt (talk)

{{Assignment}}
'''Note''': This page describes settings for the new Assignment module in Moodle 2.3 onwards. For documentation on Assignments (2.2) settings, see [https://docs.moodle.org/22/en/Assignment_settings Assignment settings] in the 2.2 docs.

==Adding and editing an Assignment activity==
*To add a new Assignment activity to your course, login with the appropriate access rights (e.g.editing teacher, course creator or administrator) and Turn Editing On. Within the required Week or Topic Block click Add and Activity or Resource link.
*In the Add an activity or resource dialogue box that appears, select Assignment and click Add.
*To edit an existing Assignment activity, login to your course with the appropriate access rights (e.g. editing teacher, course creator or administrator) and Turn Editing On. Select the Update icon against the relevant Assignment item.
*Alternatively, after logging into your course simply click on the name of the Assignment activity you wish to edit and then click the Edit Settings link under Assignment administration within the Settings block.

The following configuration options are available when creating or editing/updating any Assignment activity. Only General,Availability and Submission types are open by default;the others are collapsed. To expand everything, click the "Expand all" link top right.
Click on any screenshot to see it full size.

==General ==
The General section allows you to give your assignment a name and description.
{|
|[[File:assignmentgeneral26.png|General settings for an assignment]]
|}

===Assignment name===
Give your Assignment a name (e.g. “Report on Topic 1 Content”). The title entered here will be the name that learners see in the course content area. Learners will click on this name to view the details of the assignment and, if applicable, submit their work.

===Description===
Provide instructions for your students here so they are clear what they have to do.
Click the icon on the left to expand the toolbar and drag the bottom right of the text box out to expand it.

You can also provide information or resources related to the assignment, such as a video clip, an image, or a link to a webpage.

===Display description on course page===
Enabling this will display the description on the course page just below the link to the assignment activity.

==Availability==
{|
|[[File:AssignAvailability.png|thumb|450px|Availability settings for an assignment]]
|}

===Allow submissions from===
The Allow submissions from setting prevents students from submitting their assignment before the shown date. A teacher can to set a day, month, year and time (24 hour clock) from which learners can begin to submit their assignments. Please note that this setting does not hide the activity from the learners. Instead, the learner will see the activity, be able to view the instructions and use any materials you have included in the description, but the learner will not be able to submit or complete the assignment until the Allow submissions from date.

This setting is enabled (ticked/checked) by default and is set at the day and time you added the assignment. To disable this, remove the tick/check.

===Due date===
The Due date setting establishes when the assignment is due. Submissions will still be allowed after this date, but any assignments submitted after this date are marked as late.

This option allows an teacher to set a day, month, year and time (24 hour clock) before which learners must submit their assignment.

By default the Due date is Enabled (ticked) and is set at 7 days ahead of the day and time you selected Add Assignment. To disable this feature, simply ensure the Enable checkbox is not marked. For more information on using the Due Date see Assignment FAQ

Note: Assignments without a Due date will appear on the My home page with “No Due date” displayed.

===Cut-off date===

The Cut-off date is the date beyond which students will not be able to send in their assignment as the button for doing so will no longer be displayed. After that date (or time) a teacher may, on request, grant an extension by going to the class assignment grading screen, clicking the "Edit" column and choosing "grant extension" for the relevant student.

For more details, see this Youtube screencast [http://www.youtube.com/watch?v=UaL0LzZwyYI&feature=share&list=UUCRg_EbhU9tdpLdiGGN1Mgg Assignment Extensions]

===Always show description===
This setting is used in conjunction with the Allow submissions from setting. If it is set to Yes, the assignment Description will become visible to students at the Allow submissions from date. If it is set to No, the assignment Description will be hidden from students until the Allow submissions from date, only the assignment Name will be displayed as shown in the screenshot below. (Click to see full size.)
{|
|[[File:alwaysshowdescription.png|thumb|450px|Always show description]]
|}

If Allow submissions from is disabled, then this setting has no meaning: the assignment description will always be visible to students.

==Submission types==

{|
|[[File:26submissioncomments.png|thumb|450px|Select the type of submission here]]
|}
Here you can decide how you wish students to submit their work to you.

''Note that if Submission comments are enabled in ''Administration>Plugins>Activity modules>Assignment>Submission plugins'' then students will be able to add a note to their teacher on submitting work. If Blind marking is enabled, student comments display as from "Participant 01 etc" to avoid revealing identities. These comments will appear in the grading table in the Submission comments column.''

===Online text===
Learners can type their response directly in Moodle using the text editor.

===File submissions===
Learners can upload and edit one or more files of any type the teacher can open.

If the student uploads a pdf file, the teacher can annotate it within the browser, and on saving, the annotated file is made available to the student. See section 5.3.1 Annotating pdfs in [[Using Assignment]]

Note: This requires Ghostscript to be enabled on the server. This can be checked in ''Administration>Site administration>Plugins>Activity modules>Assignments>Feedback plugins>Annotate pdf''.

===Maximum number of uploaded files===
Here you can decide the maximum number of files which may be uploaded by each learner. (It might be helpful to display the number in the assignment description.)

===Maximum submission size===
This setting specifies the maximum size per file of each of the files that the students can upload as part of their submission. This maximum upload size may only be equal to or less than the course limit (which in turn may only be equal to or less than the site limit). The maximum size of each file is displayed to students at the point where they upload files.

{|
|[[File:submission comments.jpg|thumb|Submission comments]]
|[[File:maximum file size.jpg|thumb|Maximum file size]]
|}

==Feedback types==
(This setting is collapsed by default)

{|
|[[File:feedbacktypes.png|Feedback types]]
|}

===Feedback comments===
Setting this to yes means that markers can leave feedback comments for each submission. It enables the Feedback Comments column in the grading table.(To access the grading table, click on the assignment activity and then ''View/Grade all Submissions'').
Feedback comments are also accessible by clicking on the green tick in the grade column on the grading table.

{|
|[[File:feedback comments.jpg|thumb|The Feedback comments column]]
|[[FIle:feedback comments 2.jpg|thumb|Type feedback comments into the box]]
|}

===Offline grading worksheet===

If set to yes, the teacher will have a link to download the grading list as a spreadsheet. They will then be able to enter grades and feedback comments offline:

{|
|[[File:emptygradebook.png|thumb|The empty gradebook on Moodle]]
|[[File:downloadgradingworksheet.png|thumb|The dropdown to download the list]]
|[[File:excelgrades.png|thumb|Editing the grades offline]]
|}

When the teacher has completed their grading offline, they can then upload the spreadsheet, confirm the changes and the grades and comments will be transferred over into Moodle's gradebook:

{|
|[[File:uploadgradingworksheet.png|thumb|Uploading the grading worksheet]]
|[[File:confirmchanges.png|thumb|Confirming the changes]]
|[[File:fullgradebook.png|thumb|Grades and feedback transferred into Moodle]]
|}

See also [http://www.somerandomthoughts.com/blog/2012/11/19/offline-grading-worksheet-in-moodle-2-4-assignment/ Offline grading worksheet] blog post by Gavin Henrick.

===Feedback files===
This allows markers to upload files with feedback when marking. These files may be the marked up student assignments, documents with comments, a completed marking guide, or spoken audio feedback. It enables the Feedback Files column in the grading table. (To access the grading table click on the assignment activity and then ''View/Grade all Submissions'')To upload feedback files, click on the green tick in the grade column on the grading table and then upload either with drag and drop or using the [[File picker]].

Feedback is displayed to students on the assignment submission page.

{|
|[[File:feedback files.jpg|thumb|The Feedback files column]]
|[[File:feedback files 2.jpg|thumb|Upload files here]]
|[[File:feedback view for students.jpg|thumb|Student view with comments and file feedback both enabled]]
|}
====Uploading multiple feedback files====

It is also possible to upload multiple feedback files as a zip, from the dropdown above the grading list:

#Download the students' assignments using the "Download all submissions" link from the same dropdown menu;
#Extract the folder offline and add your comments to the student's submissions.Keep the names the same.
#Select the students' submissions and zip them into a new folder. Important: Don't just edit them inside their original folder and re-zip this; it will not work. The folder name does not matter as long as the feedback files have the same names as before.
#Upload this newly zipped folder.
#You will be presented with a confirmation screen displaying your feedback files.

{|
|[[File:mutiplefeedbackzip.png|thumb|Choose from the dropdown menu]]
|[[File:multiplezip1.png|thumb|Confirmation screen displaying the feedback files to be uploaded]]
|[[File:multiplezip2.png|thumb|Screen confirming uploaded feedback]]
|}

''Note:''If you zip files on a Mac, you may get a folder included in the zip called _MACOSX_ which needs to be removed otherwise moodle will not recognise the changes in the files.

==Submission settings==
(This setting is collapsed by default)

{|
|[[File:submissionsettings.png|Submission settings]]
|}
===Require students click submit button===
Students can upload draft versions of the assignment until such time as they are ready to submit.Once they click the submit button they indicate to the teacher that they have finished working on the assignment. In earlier versions of Moodle this was called ''"Send for marking"''.)

They can then longer edit their submission. If they need to change it, they must ask the teacher who can revert the assignment to draft status.

To revert to the draft stage, click on the assignment activity and then View/Grade all Submissions. Locate the student and click the action icon in the Edit column. Select Revert the submission to draft.

If this setting is No, then students do not have to to click a submit button and are able to make changes to uploaded files at any time.

If this setting is No but the teacher wishes to grade students work, then you can stop students from making further changes by using Prevent submission changes. Prevent submission changes can also be used in cases where students have neglected to click the Submit button and grading has commenced.
To prevent submission changes, click on the assignment activity, then click on the View/Grade all submissions button. On the grading table, locate the student and click the action icon in the Edit column. Select Prevent submission changes.

To do either of these with a number of students, use the ''With selected'' menu at the bottom of the grading table.

{|
|[[File:revert to draft.jpg|thumb|Reverting to draft]]
|[[File:prevent submission changes.jpg|thumb|Prevent submission changes]]
|[[File:with selected.jpg|thumb|"With selected"..]]
|}

To do either of these with a number of students, use the ''With selected'' menu at the bottom of the grading table.

===Require that students accept the Submission statement===

An administrator can define a "Submission statement", ie, a statement where students promise the work is their own and which they must agree to before submitting their work. This may be done via ''Settings>Site administration>Plugins>Activity modules>Assignment.''

If preferred, the available default statement which may be used instead: ''This assignment is my own work, except where I have acknowledged the use of the works of other people''

If the administrator has given teachers the option of using a submission statement or not, then it will be available in the assignment settings screen. The section [[#Submission_Statement]] explains how an administrator can set this up.

For more details, see this blog post [http://ourlearning.co.uk/2012/10/moodle-assignment-all-my-own-work/ "All my own work"]

When this setting is enabled, students will have to check a button before they can submit their assignment:

If the administrator has forced the statement throughout the site, a teacher will not have this option in the settings but a student will see the statement when accessing their assignment.

===Attempts reopened===

This setting allows the teacher to decide how submissions are reopened. The default is "Never", in that students may only submit once. However, a teacher can set this to "Manually" and reopen it themselves for the student to resubmit, or to "Automatically until pass". The student must then keep trying and resubmitting until they get a pass grade. [[Grade_items#Activity-based_grade_items|Passing grades]] are set in the Gradebook.

===Maximum attempts===

If a student is allowed to resubmit, this setting will determine how many times they can resubmit before they are no longer allowed to do so. (For example, if a student has to keep trying until they get a pass grade, the teacher might decide that ten attempts is enough even though they have not yet passed!)

==Groups submission settings==
(This setting is collapsed by default)
{|
|[[File:groupsubmissionsettings.png|Group submission settings]]
|}

===Students submit in groups===

If this box is ticked, then students are able to collaborate on an assignment. This might involve for example, working in the same online text area, or one student uploading an MS Powerpoint which another student downloads, improves and re-uploads to the common assignment area.

When grading, the teacher may choose to give a common grade and feedback to all students in the group or to give individual grades and feedback to each member.

If no groups have been made, then Moodle will make a default group of every student in the course.

For more details see this Youtube video [http://www.youtube.com/watch?v=G16gYZJFCrM&feature=share&list=UUCRg_EbhU9tdpLdiGGN1Mgg Group Assignment 2.4]

===Require all group members submit===

This setting will only appear if the teacher has ticked the "Require students click submit button" earlier. The assignment will not be classed as "submitted" until all members of the group have made a contribution. When one student has submitted, the other members of the group will be able to see who still has to submit.

===Grouping for student groups===
If a particular grouping is selected here, then the gradebook will display any other groups and non-grouped students in the "default group", while naming the group(s) that are in the chosen grouping. If "none" is selected, then the gradebook will display the names of all groups and put any non-grouped students in the "default group". See this [https://moodle.org/mod/forum/discuss.php?d=216399#p942913 forum post on grouping for student groups] for examples of how this might be used.

==Notifications==
(This setting is collapsed by default)

{|
|[[File:notifications25.png|Notifications]]
|}
===Notify graders about submissions===
Teachers will receive a message (of a type they choose) whenever a student submits an assignment. Please note if you are using the assignment in Groups Mode (eg Separate or Visible Groups), the teacher will need to be a member of the group in order to receive the submission notification.
===Notify graders about late submission===
Teachers will receive a message (of a type they choose)whenever a student submits a late assignment. Please note if you are using the assignment in Groups Mode (eg Separate or Visible Groups), the teacher will need to be a member of the group in order to receive the submission notification.

==Grade==
(This setting is collapsed by default)
{|
|[[File:grade25.png|Grade]]
|}

===Grade===
Specify the maximum grade or [[Scales|Scale]] to be applied to the assignment. If you will not be giving a grade for the assignment, choose No Grade.

===Grading method===

There are 3 options:
* Simple direct grading (entering a grade or scale item)
* [[Marking guide]]
* [[Rubric]]

===Grade Category===
Any custom [[Grade_categories|Grade Categories]] that have been created within your site or course will be listed here and will be available for selection. Select the required Grade Category to add this assignment as a [[Grade_items|Grade item]] within this Category.

===Blind marking===

If this setting is enabled, then a teacher will not see the names of students who have submitted their assignments. Instead, they will see randomly generated Participant numbers. (The student view of the assignment does not change.) This is also the case if student comments have been enabled. Once they have graded the assignment, it is however possible for teachers to see who submitted what by clicking on "Reveal student identities" in the Assignment settings.

====Returning Marks to Students ====
Because of the nature of blind marking, the students cannot see the final grade until all of the students names have been revealed. This is found in Assignment Settings > Reveal Student Names. However, feedback comments will appear.

''Note:'' Beacuse of this, the level of anonymity might not suit the privacy requirements of your establishment. See this tracker entry MDL-35390 - "Blind Marking is not so blind"

For more details on this feature, see this Youtube video [http://youtu.be/Biiw3E13mgM Blind marking in 2.4].

===Use marking workflow===
{{New features}}
When set to Yes, teachers will be able to specify the stage they are at in their grading of individual assignments (as in the screenshot below)

{|
|[[File:26markingworkflow.png|thumb|Marking workflow state in the individual grading screen]]
|[[File:26quickgradingworkflow.png|thumb|Dropdown to select marking workflow state when quick grading]]
|}

One advantage of using marking workflow is that the grades can be hidden from students until they are set to 'Released'. The actual list of steps are:

* Not marked (the marker has not yet started)
* In marking (the marker has started but not yet finished)
* Marking completed (the marker has finished but might need to go back for checking/corrections)
* In review (the marking is now with the teacher in charge for quality checking)
* Ready for release (the teacher in charge is satisfied with the marking but wait before giving students access to the marking)
* Released (the student can access the grades/feedback)

====Example use cases====

One marker, Marker, wants to release all grades at the same time
* Marker enables "Use marking workflow"
* Marker marks each submission and transitions the grading to "Marking completed" as each submission is graded.
* Marker then uses the batch operations to transition all grades to "Released" at the same time.

Multiple markers,
* Marker enables "Use marking workflow"
* Marker marks each submission and transitions the grading to "Marking completed" as each submission is graded.
* Marker then uses the batch operations to transition all grades to "Released" at the same time.

===Use marking allocation===
{{New features}}
If marking workflow (see above) is set to Yes, it is possible to enable marking allocation. This means that teachers can be selected to grade or review the submitted work of specific students. Colleagues can monitor progress through the displayed marking workflow states:

{|
|[[File:26markingworkflowallocatedmarkers.png|thumb|Allocated markers on the grading screen]]
|}

==Common module settings==
See [[Common module settings]]

==Restrict access settings==
The [[Restrict_access_settings|Restrict access]] area becomes visible in Moodle activities and resource settings if [[Conditional_activities|Conditional Activities]] have been enabled.

==Locally assigned roles==

In ''Settings > Assignment administration > Locally assigned roles'' selected users can be given additional roles in the activity. See the Using Moodle [http://moodle.org/mod/forum/discuss.php?d=98208 Custom role for 'Course Monitor'] forum discussion for an example.

==Assignment capabilities==

* [[Capabilities/mod/assign:exportownsubmission|Export own submission]]
* [[Capabilities/mod/assign:grade|Grade assignment]]
* [[Capabilities/mod/assign:submit|Submit assignment]]
* [[Capabilities/mod/assign:view|View assignment]]

Role permissions for the activity can be changed in ''Settings > Assignment administration > Permissions''.

==Site administration settings==

The following configuration options are available for an administrator under ''Administration > Site administration > Plugins > Activity modules > Assignment''.

===Assignment settings===
====Feedback plugin====
The comments that are pushed to the gradebook from the assignment are limited to a single text only comment. An Administrator can specify which of the feedback plugins will be push comments to the gradebook. On a standard Moodle install the choices are "Feedback comments" (default) or "Feedback file" but there may be additional options if your Moodle install contains additional feedback plugins.

====Show recent submissions====
This option allows everyone to see notifications of submissions in [[Recent activity]] reports and the Recent Activity Block, within a course context. Note that the default for this option is No which means students will not be able to see when classmates have submitted or updated any Assignments.

====Send submission receipt to students====
This switch will enable submission receipts for students. Students will receive a notification every time they successfully submit an assignment.
{|
|[[File:ass_settings.jpg|thumb|350px|Submission receipts settings]]
|}

====Submission Statement====

An administrator can enter text in the box here which will appear when students are about to submit their assignment.

{|
|[[File:newsubmissionstatement.png|thumb|Admin view of Submission statement set up screen - click to enlarge]]
|[[File:submissionstatement.png|thumb|Student view when about to submit - click to enlarge]]
|}

If it is left as the default "No", then teachers will have the choice within their own assignments to force this or not.

====Default assignment settings====
{{New features}}
The administrator can specify here the default assignment settings which may be set as 'Advanced' (ie, they will appear when clicking 'Show more') or 'Locked' (ie the teacher cannot change them.)
{|
|[[File:26assignmentdefaults.png|thumb|Default, Advanced and Locked checkboxes]]
|}

The following configuration options are available for an administrator under ''Administration > Site administration > Plugins > Assignment''.

===Submission plugins===
====Manage assignment submission plugins====
Here you can change the order, check the settings or uninstall a particular submission plugin.
====File submissions====
'''Enabled by default''' If set, this submission method will be enabled by default for all new assignments.

'''Maximum submission size''' An Administrator can specify the maximum size of any individual file uploaded within the assignment module across all courses on the site. This limit may be equal to or less than course file upload limit.

====Online text submissions====
'''Enabled by default''' If set, this submission method will be enabled by default for all new assignments.

====Submission comments====

'''Enabled by default''' If set, students will be able to send a message to their teacher when submitting their assignment.

===Feedback plugins===
====Manage assignment feedback plugins====
Here you can change the order, check the settings or uninstall a particular feedback plugin.
====Feedback comments====
'''Enabled by default''' If set, this submission method will be enabled by default for all new assignments.
====Annotate pdf====

Here you can upload stamps for teachers to use when annotating student pdfs. You can also check the ghostscript path:
{|
|[[File:Selection_116.png|thumb|Ghostscript not installed or incorrectly installed]]
|[[File:Selection_115.png|thumb|Ghostscript correctly installed]]
|}

If the default stamps are deleted by accident, they can be found in mod/assign/feedback/editpdf/pix and re-uploaded.

====File feedback====
'''Enabled by default''' If set, this submission method will be enabled by default for all new assignments.

===Offline grading worksheet===

'''Enabled by default''' If set, this will be enabled by default for all new assignments

==See also==
Synergy Learning blog post: [http://www.synergy-learning.com/moodle-2-5-improvements-assignment-resubmissions/ Assignment resubmissions]
[[de:Aufgabe konfigurieren]]
[[fr:Ajouter/modifier un devoir]]
[[ja:課題を追加/編集する]]
[[es:Configuraciones de tarea]]

Assignment settings

2014-03-20T03:30:09Z

Deraadt: Fixing link with target

{{Assignment}}
'''Note''': This page describes settings for the new Assignment module in Moodle 2.3 onwards. For documentation on Assignments (2.2) settings, see [https://docs.moodle.org/22/en/Assignment_settings Assignment settings] in the 2.2 docs.

==Adding and editing an Assignment activity==
*To add a new Assignment activity to your course, login with the appropriate access rights (e.g.editing teacher, course creator or administrator) and Turn Editing On. Within the required Week or Topic Block click Add and Activity or Resource link.
*In the Add an activity or resource dialogue box that appears, select Assignment and click Add.
*To edit an existing Assignment activity, login to your course with the appropriate access rights (e.g. editing teacher, course creator or administrator) and Turn Editing On. Select the Update icon against the relevant Assignment item.
*Alternatively, after logging into your course simply click on the name of the Assignment activity you wish to edit and then click the Edit Settings link under Assignment administration within the Settings block.

The following configuration options are available when creating or editing/updating any Assignment activity. Only General,Availability and Submission types are open by default;the others are collapsed. To expand everything, click the "Expand all" link top right.
Click on any screenshot to see it full size.

==General ==
The General section allows you to give your assignment a name and description.
{|
|[[File:assignmentgeneral26.png|General settings for an assignment]]
|}

===Assignment name===
Give your Assignment a name (e.g. “Report on Topic 1 Content”). The title entered here will be the name that learners see in the course content area. Learners will click on this name to view the details of the assignment and, if applicable, submit their work.

===Description===
Provide instructions for your students here so they are clear what they have to do.
Click the icon on the left to expand the toolbar and drag the bottom right of the text box out to expand it.

You can also provide information or resources related to the assignment, such as a video clip, an image, or a link to a webpage.

===Display description on course page===
Enabling this will display the description on the course page just below the link to the assignment activity.

==Availability==
{|
|[[File:AssignAvailability.png|thumb|450px|Availability settings for an assignment]]
|}

===Allow submissions from===
The Allow submissions from setting prevents students from submitting their assignment before the shown date. A teacher can to set a day, month, year and time (24 hour clock) from which learners can begin to submit their assignments. Please note that this setting does not hide the activity from the learners. Instead, the learner will see the activity, be able to view the instructions and use any materials you have included in the description, but the learner will not be able to submit or complete the assignment until the Allow submissions from date.

This setting is enabled (ticked/checked) by default and is set at the day and time you added the assignment. To disable this, remove the tick/check.

===Due date===
The Due date setting establishes when the assignment is due. Submissions will still be allowed after this date, but any assignments submitted after this date are marked as late.

This option allows an teacher to set a day, month, year and time (24 hour clock) before which learners must submit their assignment.

By default the Due date is Enabled (ticked) and is set at 7 days ahead of the day and time you selected Add Assignment. To disable this feature, simply ensure the Enable checkbox is not marked. For more information on using the Due Date see Assignment FAQ

Note: Assignments without a Due date will appear on the My home page with “No Due date” displayed.

===Cut-off date===

The Cut-off date is the date beyond which students will not be able to send in their assignment as the button for doing so will no longer be displayed. After that date (or time) a teacher may, on request, grant an extension by going to the class assignment grading screen, clicking the "Edit" column and choosing "grant extension" for the relevant student.

For more details, see this Youtube screencast [http://www.youtube.com/watch?v=UaL0LzZwyYI&feature=share&list=UUCRg_EbhU9tdpLdiGGN1Mgg Assignment Extensions]

===Always show description===
This setting is used in conjunction with the Allow submissions from setting. If it is set to Yes, the assignment Description will become visible to students at the Allow submissions from date. If it is set to No, the assignment Description will be hidden from students until the Allow submissions from date, only the assignment Name will be displayed as shown in the screenshot below. (Click to see full size.)
{|
|[[File:alwaysshowdescription.png|thumb|450px|Always show description]]
|}

If Allow submissions from is disabled, then this setting has no meaning: the assignment description will always be visible to students.

==Submission types==

{|
|[[File:26submissioncomments.png|thumb|450px|Select the type of submission here]]
|}
Here you can decide how you wish students to submit their work to you.

''Note that if Submission comments are enabled in ''Administration>Plugins>Activity modules>Assignment>Submission plugins'' then students will be able to add a note to their teacher on submitting work. If Blind marking is enabled, student comments display as from "Participant 01 etc" to avoid revealing identities. These comments will appear in the grading table in the Submission comments column.''

===Online text===
Learners can type their response directly in Moodle using the text editor.

===File submissions===
Learners can upload and edit one or more files of any type the teacher can open.

If the student uploads a pdf file, the teacher can annotate it within the browser, and on saving, the annotated file is made available to the student. See section 5.3.1 Annotating pdfs in [[Using Assignment]]

Note: This requires Ghostscript to be enabled on the server. This can be checked in ''Administration>Site administration>Plugins>Activity modules>Assignments>Feedback plugins>Annotate pdf''.

===Maximum number of uploaded files===
Here you can decide the maximum number of files which may be uploaded by each learner. (It might be helpful to display the number in the assignment description.)

===Maximum submission size===
This setting specifies the maximum size per file of each of the files that the students can upload as part of their submission. This maximum upload size may only be equal to or less than the course limit (which in turn may only be equal to or less than the site limit). The maximum size of each file is displayed to students at the point where they upload files.

{|
|[[File:submission comments.jpg|thumb|Submission comments]]
|[[File:maximum file size.jpg|thumb|Maximum file size]]
|}

==Feedback types==
(This setting is collapsed by default)

{|
|[[File:feedbacktypes.png|Feedback types]]
|}

===Feedback comments===
Setting this to yes means that markers can leave feedback comments for each submission. It enables the Feedback Comments column in the grading table.(To access the grading table, click on the assignment activity and then ''View/Grade all Submissions'').
Feedback comments are also accessible by clicking on the green tick in the grade column on the grading table.

{|
|[[File:feedback comments.jpg|thumb|The Feedback comments column]]
|[[FIle:feedback comments 2.jpg|thumb|Type feedback comments into the box]]
|}

===Offline grading worksheet===

If set to yes, the teacher will have a link to download the grading list as a spreadsheet. They will then be able to enter grades and feedback comments offline:

{|
|[[File:emptygradebook.png|thumb|The empty gradebook on Moodle]]
|[[File:downloadgradingworksheet.png|thumb|The dropdown to download the list]]
|[[File:excelgrades.png|thumb|Editing the grades offline]]
|}

When the teacher has completed their grading offline, they can then upload the spreadsheet, confirm the changes and the grades and comments will be transferred over into Moodle's gradebook:

{|
|[[File:uploadgradingworksheet.png|thumb|Uploading the grading worksheet]]
|[[File:confirmchanges.png|thumb|Confirming the changes]]
|[[File:fullgradebook.png|thumb|Grades and feedback transferred into Moodle]]
|}

See also [http://www.somerandomthoughts.com/blog/2012/11/19/offline-grading-worksheet-in-moodle-2-4-assignment/ Offline grading worksheet] blog post by Gavin Henrick.

===Feedback files===
This allows markers to upload files with feedback when marking. These files may be the marked up student assignments, documents with comments, a completed marking guide, or spoken audio feedback. It enables the Feedback Files column in the grading table. (To access the grading table click on the assignment activity and then ''View/Grade all Submissions'')To upload feedback files, click on the green tick in the grade column on the grading table and then upload either with drag and drop or using the [[File picker]].

Feedback is displayed to students on the assignment submission page.

{|
|[[File:feedback files.jpg|thumb|The Feedback files column]]
|[[File:feedback files 2.jpg|thumb|Upload files here]]
|[[File:feedback view for students.jpg|thumb|Student view with comments and file feedback both enabled]]
|}
====Uploading multiple feedback files====

It is also possible to upload multiple feedback files as a zip, from the dropdown above the grading list:

#Download the students' assignments using the "Download all submissions" link from the same dropdown menu;
#Extract the folder offline and add your comments to the student's submissions.Keep the names the same.
#Select the students' submissions and zip them into a new folder. Important: Don't just edit them inside their original folder and re-zip this; it will not work. The folder name does not matter as long as the feedback files have the same names as before.
#Upload this newly zipped folder.
#You will be presented with a confirmation screen displaying your feedback files.

{|
|[[File:mutiplefeedbackzip.png|thumb|Choose from the dropdown menu]]
|[[File:multiplezip1.png|thumb|Confirmation screen displaying the feedback files to be uploaded]]
|[[File:multiplezip2.png|thumb|Screen confirming uploaded feedback]]
|}

''Note:''If you zip files on a Mac, you may get a folder included in the zip called _MACOSX_ which needs to be removed otherwise moodle will not recognise the changes in the files.

==Submission settings==
(This setting is collapsed by default)

{|
|[[File:submissionsettings.png|Submission settings]]
|}
===Require students click submit button===
Students can upload draft versions of the assignment until such time as they are ready to submit.Once they click the submit button they indicate to the teacher that they have finished working on the assignment. In earlier versions of Moodle this was called ''"Send for marking"''.)

They can then longer edit their submission. If they need to change it, they must ask the teacher who can revert the assignment to draft status.

To revert to the draft stage, click on the assignment activity and then View/Grade all Submissions. Locate the student and click the action icon in the Edit column. Select Revert the submission to draft.

If this setting is No, then students do not have to to click a submit button and are able to make changes to uploaded files at any time.

If this setting is No but the teacher wishes to grade students work, then you can stop students from making further changes by using Prevent submission changes. Prevent submission changes can also be used in cases where students have neglected to click the Submit button and grading has commenced.
To prevent submission changes, click on the assignment activity, then click on the View/Grade all submissions button. On the grading table, locate the student and click the action icon in the Edit column. Select Prevent submission changes.

To do either of these with a number of students, use the ''With selected'' menu at the bottom of the grading table.

{|
|[[File:revert to draft.jpg|thumb|Reverting to draft]]
|[[File:prevent submission changes.jpg|thumb|Prevent submission changes]]
|[[File:with selected.jpg|thumb|"With selected"..]]
|}

To do either of these with a number of students, use the ''With selected'' menu at the bottom of the grading table.

===Require that students accept the Submission statement===

An administrator can define a "Submission statement", ie, a statement where students promise the work is their own and which they must agree to before submitting their work. This may be done via ''Settings>Site administration>Plugins>Activity modules>Assignment.''

If preferred, the available default statement which may be used instead: ''This assignment is my own work, except where I have acknowledged the use of the works of other people''

If the administrator has given teachers the option of using a submission statement or not, then it will be available in the assignment settings screen. The section [[#Submission_Statement]] explains how an administrator can set this up.

For more details, see this blog post [http://ourlearning.co.uk/2012/10/moodle-assignment-all-my-own-work/ "All my own work"]

When this setting is enabled, students will have to check a button before they can submit their assignment:

If the administrator has forced the statement throughout the site, a teacher will not have this option in the settings but a student will see the statement when accessing their assignment.

===Attempts reopened===

This setting allows the teacher to decide how submissions are reopened. The default is "Never", in that students may only submit once. However, a teacher can set this to "Manually" and reopen it themselves for the student to resubmit, or to "Automatically until pass". The student must then keep trying and resubmitting until they get a pass grade. [[:en:Grade_items#Activity-based_grade_items|Passing grades]] are set in the Gradebook.

===Maximum attempts===

If a student is allowed to resubmit, this setting will determine how many times they can resubmit before they are no longer allowed to do so. (For example, if a student has to keep trying until they get a pass grade, the teacher might decide that ten attempts is enough even though they have not yet passed!)

==Groups submission settings==
(This setting is collapsed by default)
{|
|[[File:groupsubmissionsettings.png|Group submission settings]]
|}

===Students submit in groups===

If this box is ticked, then students are able to collaborate on an assignment. This might involve for example, working in the same online text area, or one student uploading an MS Powerpoint which another student downloads, improves and re-uploads to the common assignment area.

When grading, the teacher may choose to give a common grade and feedback to all students in the group or to give individual grades and feedback to each member.

If no groups have been made, then Moodle will make a default group of every student in the course.

For more details see this Youtube video [http://www.youtube.com/watch?v=G16gYZJFCrM&feature=share&list=UUCRg_EbhU9tdpLdiGGN1Mgg Group Assignment 2.4]

===Require all group members submit===

This setting will only appear if the teacher has ticked the "Require students click submit button" earlier. The assignment will not be classed as "submitted" until all members of the group have made a contribution. When one student has submitted, the other members of the group will be able to see who still has to submit.

===Grouping for student groups===
If a particular grouping is selected here, then the gradebook will display any other groups and non-grouped students in the "default group", while naming the group(s) that are in the chosen grouping. If "none" is selected, then the gradebook will display the names of all groups and put any non-grouped students in the "default group". See this [https://moodle.org/mod/forum/discuss.php?d=216399#p942913 forum post on grouping for student groups] for examples of how this might be used.

==Notifications==
(This setting is collapsed by default)

{|
|[[File:notifications25.png|Notifications]]
|}
===Notify graders about submissions===
Teachers will receive a message (of a type they choose) whenever a student submits an assignment. Please note if you are using the assignment in Groups Mode (eg Separate or Visible Groups), the teacher will need to be a member of the group in order to receive the submission notification.
===Notify graders about late submission===
Teachers will receive a message (of a type they choose)whenever a student submits a late assignment. Please note if you are using the assignment in Groups Mode (eg Separate or Visible Groups), the teacher will need to be a member of the group in order to receive the submission notification.

==Grade==
(This setting is collapsed by default)
{|
|[[File:grade25.png|Grade]]
|}

===Grade===
Specify the maximum grade or [[Scales|Scale]] to be applied to the assignment. If you will not be giving a grade for the assignment, choose No Grade.

===Grading method===

There are 3 options:
* Simple direct grading (entering a grade or scale item)
* [[Marking guide]]
* [[Rubric]]

===Grade Category===
Any custom [[Grade_categories|Grade Categories]] that have been created within your site or course will be listed here and will be available for selection. Select the required Grade Category to add this assignment as a [[Grade_items|Grade item]] within this Category.

===Blind marking===

If this setting is enabled, then a teacher will not see the names of students who have submitted their assignments. Instead, they will see randomly generated Participant numbers. (The student view of the assignment does not change.) This is also the case if student comments have been enabled. Once they have graded the assignment, it is however possible for teachers to see who submitted what by clicking on "Reveal student identities" in the Assignment settings.

====Returning Marks to Students ====
Because of the nature of blind marking, the students cannot see the final grade until all of the students names have been revealed. This is found in Assignment Settings > Reveal Student Names. However, feedback comments will appear.

''Note:'' Beacuse of this, the level of anonymity might not suit the privacy requirements of your establishment. See this tracker entry MDL-35390 - "Blind Marking is not so blind"

For more details on this feature, see this Youtube video [http://youtu.be/Biiw3E13mgM Blind marking in 2.4].

===Use marking workflow===
{{New features}}
When set to Yes, teachers will be able to specify the stage they are at in their grading of individual assignments (as in the screenshot below)

{|
|[[File:26markingworkflow.png|thumb|Marking workflow state in the individual grading screen]]
|[[File:26quickgradingworkflow.png|thumb|Dropdown to select marking workflow state when quick grading]]
|}

One advantage of using marking workflow is that the grades can be hidden from students until they are set to 'Released'. The actual list of steps are:

* Not marked (the marker has not yet started)
* In marking (the marker has started but not yet finished)
* Marking completed (the marker has finished but might need to go back for checking/corrections)
* In review (the marking is now with the teacher in charge for quality checking)
* Ready for release (the teacher in charge is satisfied with the marking but wait before giving students access to the marking)
* Released (the student can access the grades/feedback)

====Example use cases====

One marker, Marker, wants to release all grades at the same time
* Marker enables "Use marking workflow"
* Marker marks each submission and transitions the grading to "Marking completed" as each submission is graded.
* Marker then uses the batch operations to transition all grades to "Released" at the same time.

Multiple markers,
* Marker enables "Use marking workflow"
* Marker marks each submission and transitions the grading to "Marking completed" as each submission is graded.
* Marker then uses the batch operations to transition all grades to "Released" at the same time.

===Use marking allocation===
{{New features}}
If marking workflow (see above) is set to Yes, it is possible to enable marking allocation. This means that teachers can be selected to grade or review the submitted work of specific students. Colleagues can monitor progress through the displayed marking workflow states:

{|
|[[File:26markingworkflowallocatedmarkers.png|thumb|Allocated markers on the grading screen]]
|}

==Common module settings==
See [[Common module settings]]

==Restrict access settings==
The [[Restrict_access_settings|Restrict access]] area becomes visible in Moodle activities and resource settings if [[Conditional_activities|Conditional Activities]] have been enabled.

==Locally assigned roles==

In ''Settings > Assignment administration > Locally assigned roles'' selected users can be given additional roles in the activity. See the Using Moodle [http://moodle.org/mod/forum/discuss.php?d=98208 Custom role for 'Course Monitor'] forum discussion for an example.

==Assignment capabilities==

* [[Capabilities/mod/assign:exportownsubmission|Export own submission]]
* [[Capabilities/mod/assign:grade|Grade assignment]]
* [[Capabilities/mod/assign:submit|Submit assignment]]
* [[Capabilities/mod/assign:view|View assignment]]

Role permissions for the activity can be changed in ''Settings > Assignment administration > Permissions''.

==Site administration settings==

The following configuration options are available for an administrator under ''Administration > Site administration > Plugins > Activity modules > Assignment''.

===Assignment settings===
====Feedback plugin====
The comments that are pushed to the gradebook from the assignment are limited to a single text only comment. An Administrator can specify which of the feedback plugins will be push comments to the gradebook. On a standard Moodle install the choices are "Feedback comments" (default) or "Feedback file" but there may be additional options if your Moodle install contains additional feedback plugins.

====Show recent submissions====
This option allows everyone to see notifications of submissions in [[Recent activity]] reports and the Recent Activity Block, within a course context. Note that the default for this option is No which means students will not be able to see when classmates have submitted or updated any Assignments.

====Send submission receipt to students====
This switch will enable submission receipts for students. Students will receive a notification every time they successfully submit an assignment.
{|
|[[File:ass_settings.jpg|thumb|350px|Submission receipts settings]]
|}

====Submission Statement====

An administrator can enter text in the box here which will appear when students are about to submit their assignment.

{|
|[[File:newsubmissionstatement.png|thumb|Admin view of Submission statement set up screen - click to enlarge]]
|[[File:submissionstatement.png|thumb|Student view when about to submit - click to enlarge]]
|}

If it is left as the default "No", then teachers will have the choice within their own assignments to force this or not.

====Default assignment settings====
{{New features}}
The administrator can specify here the default assignment settings which may be set as 'Advanced' (ie, they will appear when clicking 'Show more') or 'Locked' (ie the teacher cannot change them.)
{|
|[[File:26assignmentdefaults.png|thumb|Default, Advanced and Locked checkboxes]]
|}

The following configuration options are available for an administrator under ''Administration > Site administration > Plugins > Assignment''.

===Submission plugins===
====Manage assignment submission plugins====
Here you can change the order, check the settings or uninstall a particular submission plugin.
====File submissions====
'''Enabled by default''' If set, this submission method will be enabled by default for all new assignments.

'''Maximum submission size''' An Administrator can specify the maximum size of any individual file uploaded within the assignment module across all courses on the site. This limit may be equal to or less than course file upload limit.

====Online text submissions====
'''Enabled by default''' If set, this submission method will be enabled by default for all new assignments.

====Submission comments====

'''Enabled by default''' If set, students will be able to send a message to their teacher when submitting their assignment.

===Feedback plugins===
====Manage assignment feedback plugins====
Here you can change the order, check the settings or uninstall a particular feedback plugin.
====Feedback comments====
'''Enabled by default''' If set, this submission method will be enabled by default for all new assignments.
====Annotate pdf====

Here you can upload stamps for teachers to use when annotating student pdfs. You can also check the ghostscript path:
{|
|[[File:Selection_116.png|thumb|Ghostscript not installed or incorrectly installed]]
|[[File:Selection_115.png|thumb|Ghostscript correctly installed]]
|}

If the default stamps are deleted by accident, they can be found in mod/assign/feedback/editpdf/pix and re-uploaded.

====File feedback====
'''Enabled by default''' If set, this submission method will be enabled by default for all new assignments.

===Offline grading worksheet===

'''Enabled by default''' If set, this will be enabled by default for all new assignments

==See also==
Synergy Learning blog post: [http://www.synergy-learning.com/moodle-2-5-improvements-assignment-resubmissions/ Assignment resubmissions]
[[de:Aufgabe konfigurieren]]
[[fr:Ajouter/modifier un devoir]]
[[ja:課題を追加/編集する]]
[[es:Configuraciones de tarea]]

Moodle security procedures

2014-02-26T08:20:10Z

Deraadt: Adding link to security development process

{{Security}}

We treat security issues in Moodle software very seriously. Even though we dedicate a lot of time designing our code to avoid such problems, it is inevitable in a project of this size that new vulnerabilities will occasionally be discovered.

==Disclosure policy==

We practice ''responsible disclosure'', which means we have a policy of disclosing all security issues that come to our attention, but only after we have solved the issue and given registered Moodle sites time to upgrade or patch their installations.

We ask that when reporting a security issue, you observe these same guidelines, and beyond communicating with the security team, do not share your knowledge of security issues with the public at large.

==How can I report a security issue?==

Please "[http://tracker.moodle.org/secure/CreateIssue.jspa Create a new issue]" in the Moodle tracker describing the problem (and solution if possible) in detail. Make sure you set the security level accurately to make sure that the security team sees it. Bugs classified as a "Serious security issue" are hidden from everyone apart from the security team and the person who reported the problem.

If you are not sure whether an issue is a security issue, you should still create a new issue in the tracker for review, using the security level "Could be a security issue".

Please do ''not'' post about security issues in the forums on moodle.org or elsewhere. This will cause the issue to be more widely known before a fix can be prepared.

==How we deal with a reported security issue==

# The security team reviews the issue and evaluates its potential impact on all supported versions of Moodle.
# The security team works with the issue reporter to resolve the problem, keeping details of the problem and its solution hidden until a release is made.
# New versions are created and tested.
# New packages are created and made available on download.moodle.org.
# Advisories are mailed to administrators of registered Moodle sites, giving a period of time when they can upgrade before the issue becomes public.
# A public announcement is made about the security issue in the [http://moodle.org/mod/forum/view.php?id=7128 Moodle security news forum].

==See also...==
* [[:dev:Process#Security_issues|Security issue development process]]

[[de:Sicherheitsprozeduren]]

Assignment settings

2014-02-17T01:14:58Z

Deraadt: Adding link to passing grades settings

OPcache

2013-11-21T07:34:00Z

Deraadt: Adding details for IIS

{{Environment}}
{{New features}}
The standard OPcache extension is strongly recommended; since Moodle 2.6, it is the only solution officially supported by PHP developers. The benefits are increased performance and significantly lower memory usage.

==Installation==

The OPcache extension is distributed as part of PHP 5.5.0 and later. It is available also for older stable PHP releases from PECL under the original name ZendOPcache.

==Configuration==

PHP.ini settings:

<code ini>
[opcache]
opcache.enable = 1
opcache.memory_consumption = 128
opcache.max_accelerated_files = 4000
opcache.revalidate_freq = 60

; Required for Moodle
opcache.use_cwd = 1
opcache.validate_timestamps = 1
opcache.save_comments = 1
opcache.enable_file_override = 0

; If something does not work in Moodle
;opcache.revalidate_path = 1 ; May fix problems with include paths

; Experimental for Moodle 2.6 and later
;opcache.fast_shutdown = 1
;opcache.enable_cli = 1 ; Speeds up CLI cron
;opcache.load_comments = 0 ; May lower memory use, might not be compatible with add-ons and other apps.
</code>

When using IIS you will need PHP 5.5 and you will need to add the extension for opcache under the ''ExtensionList'' section of the php.ini file.

<code ini>
[ExtensionList]
...
zend_extension=php_opcache.dll
</code>

==See also==
* [http://pecl.php.net/package/ZendOpcache PECL ZendOPcache]

[[Category:Environment]]
[[Category:Installation]]
[[Category:Performance]]

[[es:OPcache]]

Progress Bar block

2013-09-12T08:19:57Z

Deraadt: Adding new acknowledgements

[[Blocks|Back to Blocks page]]

== Features ==

[[Image:Bar_in_block_-_with_details.png|right|A progress bar for a student]]
* The Progress Bar is a time-management tool for students.
* It visually shows what activities/resources a student is supposed to interact with in a course.
* It is colour coded so students can quickly see what they have and have not completed/viewed.
* The teacher selects which pre-existing activities/resources are to be included in the Progress Bar and when they should be completed/viewed.
* Ordering can be done by times/deadlines or by the ordering of activities in the course.
[[Image:Overview_of_students.png|thumb|right|The overview page]]
* There is an overview page allowing teachers to see the progress of all students in a class, which is helpful for finding students at risk.

<mediaplayer>http://www.youtube.com/watch?v=d43KVlMBmLA </mediaplayer>

== Links ==

* [http://moodle.org/plugins/view.php?plugin=block_progress Block code in Plugins repository]
* [http://tracker.moodle.org/browse/CONTRIB/component/10489 Bug Tracker Page] (Please report bugs here)
* [http://cvs.moodle.org/contrib/plugins/blocks/progress/ CVS Repository]

== Installing ==

The Progress Bar block is added like other blocks ([[Installing_contributed_modules_or_plugins|How to install a block]]).

Once the progress bar is installed, you can use it in a course as follows.
# Turn editing on
# Create your activities/resources as normal
# Add the Progress Bar block to your page ([[Blocks|How to add a block]])
# Move your Progress Bar block into a prominent position, eg. top-left (click and drag the block title)
# Click the Configuration icon on the block below the title
# Give your Progress Bar block a title (default is "Progress Bar")
# Set the activities/resources you want shown in the block to "Yes"
# Set the date and time when the activity/resource is expected to be completed/viewed by (some activities have deadlines set, if so, that deadline can be used or another can be set in the Progress Bar block configuration)
# Save changes

Hidden items will not appear in the Progress Bar until they are unhidden. This is useful for a scheduled release of activities.

== Acknowledgements ==

* Thanks to:
** Toshimi Hatanaka for contributing a Japanese translation
** Yvonne Schneider and Joachim Vogelgesang for contributing a German translation
** Maria João Spilker for contributing a Portuguese-Brazilian translation
** Pieter Wolters for contributing a Dutch translation
** Fernando Sánchez for contributing a Spanish translation
** Fabien Sartoretti for contributing a French translation
** Adam Levy for contributing queries and strings for Hot Potatoes support
** Petras Virzintas for contributing queries for Turnitin support
** Willian Mano for helping with the modern look CSS
** Matthieu Rolland for contributing queries for the Questionnaire module

[[Category:Contributed code]]

Progress Bar block

2013-09-12T08:18:28Z

Deraadt: Updating screenshots

[[Blocks|Back to Blocks page]]

== Features ==

[[Image:Bar_in_block_-_with_details.png|right|A progress bar for a student]]
* The Progress Bar is a time-management tool for students.
* It visually shows what activities/resources a student is supposed to interact with in a course.
* It is colour coded so students can quickly see what they have and have not completed/viewed.
* The teacher selects which pre-existing activities/resources are to be included in the Progress Bar and when they should be completed/viewed.
* Ordering can be done by times/deadlines or by the ordering of activities in the course.
[[Image:Overview_of_students.png|thumb|right|The overview page]]
* There is an overview page allowing teachers to see the progress of all students in a class, which is helpful for finding students at risk.

<mediaplayer>http://www.youtube.com/watch?v=d43KVlMBmLA </mediaplayer>

== Links ==

* [http://moodle.org/plugins/view.php?plugin=block_progress Block code in Plugins repository]
* [http://tracker.moodle.org/browse/CONTRIB/component/10489 Bug Tracker Page] (Please report bugs here)
* [http://cvs.moodle.org/contrib/plugins/blocks/progress/ CVS Repository]

== Installing ==

The Progress Bar block is added like other blocks ([[Installing_contributed_modules_or_plugins|How to install a block]]).

Once the progress bar is installed, you can use it in a course as follows.
# Turn editing on
# Create your activities/resources as normal
# Add the Progress Bar block to your page ([[Blocks|How to add a block]])
# Move your Progress Bar block into a prominent position, eg. top-left (click and drag the block title)
# Click the Configuration icon on the block below the title
# Give your Progress Bar block a title (default is "Progress Bar")
# Set the activities/resources you want shown in the block to "Yes"
# Set the date and time when the activity/resource is expected to be completed/viewed by (some activities have deadlines set, if so, that deadline can be used or another can be set in the Progress Bar block configuration)
# Save changes

Hidden items will not appear in the Progress Bar until they are unhidden. This is useful for a scheduled release of activities.

== Acknowledgements ==

* Thanks to:
** Toshimi Hatanaka for contributing a Japanese translation
** Yvonne Schneider and Joachim Vogelgesang for contributing a German translation
** Maria João Spilker for contributing a Portuguese-Brazilian translation
** Pieter Wolters for contributing a Dutch translation
** Fernando Sánchez for contributing a Spanish translation
** Fabien Sartoretti for contributing a French translation
** Adam Levy for contributing queries and strings for Hot Potatoes support
** Petras Virzintas for contributing queries for Turnitin support

[[Category:Contributed code]]

Plik:Overview of students.png

2013-09-12T08:17:24Z

Deraadt:

Plik:Bar in block - with details.png

2013-09-12T08:16:09Z

Deraadt:

Course search

2013-08-09T03:09:54Z

Deraadt: Created page with "Placeholder"

Placeholder

Progress Bar block

2013-08-08T02:32:14Z

Deraadt:

[[Blocks|Back to Blocks page]]

== Features ==

[[Image:ProgressBar.gif|right|A progress bar for a student]]
* The Progress Bar is a time-management tool for students.
* It visually shows what activities/resources a student is supposed to interact with in a course.
* It is colour coded so students can quickly see what they have and have not completed/viewed.
* The teacher selects which pre-existing activities/resources are to be included in the Progress Bar and when they should be completed/viewed.
* Ordering can be done by times/deadlines or by the ordering of activities in the course.
* There is an overview page allowing teachers to see the progress of all students in a class, which is helpful for finding students at risk.

<mediaplayer>http://www.youtube.com/watch?v=d43KVlMBmLA </mediaplayer>

== Links ==

* [http://moodle.org/plugins/view.php?plugin=block_progress Block code in Plugins repository]
* [http://tracker.moodle.org/browse/CONTRIB/component/10489 Bug Tracker Page] (Please report bugs here)
* [http://cvs.moodle.org/contrib/plugins/blocks/progress/ CVS Repository]

== Installing ==

The Progress Bar block is added like other blocks ([[Installing_contributed_modules_or_plugins|How to install a block]]).

Once the progress bar is installed, you can use it in a course as follows.
# Turn editing on
# Create your activities/resources as normal
# Add the Progress Bar block to your page ([[Blocks|How to add a block]])
# Move your Progress Bar block into a prominent position, eg. top-left (click and drag the block title)
# Click the Configuration icon on the block below the title
# Give your Progress Bar block a title (default is "Progress Bar")
# Set the activities/resources you want shown in the block to "Yes"
# Set the date and time when the activity/resource is expected to be completed/viewed by (some activities have deadlines set, if so, that deadline can be used or another can be set in the Progress Bar block configuration)
# Save changes

Hidden items will not appear in the Progress Bar until they are unhidden. This is useful for a scheduled release of activities.

== Acknowledgements ==

* Thanks to:
** Toshimi Hatanaka for contributing a Japanese translation
** Yvonne Schneider and Joachim Vogelgesang for contributing a German translation
** Maria João Spilker for contributing a Portuguese-Brazilian translation
** Pieter Wolters for contributing a Dutch translation
** Fernando Sánchez for contributing a Spanish translation
** Fabien Sartoretti for contributing a French translation
** Adam Levy for contributing queries and strings for Hot Potatoes support
** Petras Virzintas for contributing queries for Turnitin support

[[Category:Contributed code]]

Installing MSSQL for PHP

2013-06-12T03:26:20Z

Deraadt: /* Installation overview */

{{Installing Moodle}}== Introduction ==

This short manual is suitable if you are trying to run Moodle using the SQL*Server (MSSQL) RDBMS. Steps detailed below must be performed '''before''' installing Moodle itself.

Some of this may also apply if you wish to access an MSSQL server for external db authentication/enrollment.

First of all, minimum required version of MSSQL has been stabilised to MSSQL 2005 (v.9), although it '''might work with MSSQL 2000 (v.8) or newer'''. All the development process has been performed using MSSQL 2005 and there could be some '''unknown problems''' with previous releases.

While PHP comes with one, more or less, standard extension (mssql) that provides access to MSSQL databases, early we found some hard limits on it. Basically such default extension has some limits that prevent us to use it at all (you can find more info about these problems [[Development:XMLDB problems#MSSQL, PHP, UTF-8 and UCS-2|here]]).

So, in order to allow PHP (i.e. Moodle) to access to MSSQL DBs properly we have to install a '''mssql extension alternative''' to save us from the problems related above. See the sections below for details about the various options.

== Installation overview ==

1. Get MSSQL Server installed and running. ([http://www.microsoft.com/sql/editions/express/default.mspx A free limited version, SQL Server Express Edition] is available for testing.)
:Make sure that you choose mixed authentication (Windows and local accounts) to keep things simpler later. You'll be asked to define the "sa" account password (it's the default System Administrator account which has full access to all databases by default).

2. Make sure MS SQL Server can accept incoming TCP/IP connections on port 1433 (the standard one).
:You might need to explicitly allow this in your Windows firewall (see the Control Panel). You may also need to edit options in the :'''SQL Server Configuration Manager''' -> '''Network Configuration''' -> '''Protocols''' -> '''TCP/IP enabled'''

3. Open the "SQL Server Management Studio" and create a new empty database. If you are using the "sa" account then you don't need to do anything else here.

4. Configure these settings in your created (and still empty) database:
Configure these settings in your created (and still empty) database:
:*Use a case sensitive collation, such as Latin1_General_CS_AS.
:*ANSI NULLS Enabled = true (ALTER DATABASE xxxx SET ANSI_NULLS ON)
:*Quoted Identifiers Enabled = true (ALTER DATABASE xxxx SET QUOTED_IDENTIFIER ON)
:* (Moodle 2.x only) Row Versioning Enabled (ALTER DATABASE xxxx SET READ_COMMITTED_SNAPSHOT ON)
:** This is not settable via the DB properties. To set READ_COMMITTED_SNAPSHOT, there must be no active connections to the database except for the connection executing the ALTER command. If you are viewing the DB in the Server Management Studio, disconnect from any servers in the "Object Explorer" (right-click > Disconnect), then create a "New Query" and run the ALTER command. See http://msdn.microsoft.com/en-us/library/bb522682.aspx for details.
:** If your DB name starts with a number, you may need to put quotes around the DB name in the query.

5. Get PHP installed with a web server. Unless you want to do it under IIS or some other way, the packages on the [http://download.moodle.org Moodle download page] are a good solution.

6. Choose one of the following specific sections for your server to install the '''mssql extension alternative''' installed and running properly on your PHP box.

7. Set the following settings in your php.ini file
:* mssql.textlimit = 20971520
:* mssql.textsize = 20971520

8. With all this properly configured, you can continue with a [[Installing Moodle|standard Moodle installation]].

== Microsoft Drivers for SQL Server for PHP ==

'''WARNING: This driver has known problems and is therefore not suitable for any Moodle production servers.'''

In July 2008 Microsoft [http://social.msdn.microsoft.com/forums/en-US/sqldriverforphp/thread/a10e5202-9e41-4ff8-a33e-fbcc7b951be2/ released] a new SQL Server Driver for PHP. This is a PHP extension that allows PHP scripts to read and write data on Microsoft SQL Server databases and it overcomes the problems with the native SQL Server extension that was previously bundled with PHP.

When using [[IIS]] it is strongly recommended to use the official Microsoft PHP installer from http://php.iis.net/, it should include the latest version of necessary drivers and it also simplifies future upgrades and configuration.

For Windows servers with [[Apache]] see http://www.microsoft.com/en-us/download/details.aspx?id=20098.

== Using FreeTDS on Windows ==

'''Important Note 1:''' Due to some previous bugs it's highly recommendable to use PHP >= 5.2.6 and FreeTDS 0.82 + post-release patches ([http://tracker.moodle.org/browse/MDL-14725 more info]).

If your web server is on Windows, use '''php_dblib.dll'''. Despite the name, it's FreeTDS compiled for Windows. (Go to this page for information on [https://docs.moodle.org/en/FreeTDS Using FreeTDS for Unix].)

Originally we were using the DLLs available at [http://kromann.info/article.php?Id=11062598797760000 Frank Kromann's site], but they are outdated (using old versions of FreeTDS) and that has caused [http://tracker.moodle.org/browse/MDL-14725 some problems] in the past.

So, right now, the recommended way to use FreeTDS under Windows is to use PHP 5.2.x following the following instructions:

1. Download the appropriate copy of php_dblib.dll from the list below, and save it into your /PHP/ext directory.

{| border="1" align="center" cellpadding="5" style="text-align: center;"
|-
! PHP version !! [http://www.iis-aid.com/articles/my_word/difference_between_php_thread_safe_and_non_thread_safe_binaries Thread Safe] !! FreeTDS version !! Download URL
|-
| rowspan="2" | PHP 5.2.x (vc6) || Yes || 0.82 + 20090302 patches || [http://download.moodle.org/download.php/dblib/php52/DBLIB_TS.zip Download!]
|-
| No || 0.82 + 20090302 patches || [http://download.moodle.org/download.php/dblib/php52/DBLIB_NOTS.zip Download!]
|-
| rowspan="2" | PHP 5.3.x (vc9) || Yes || 0.82 + 20090904 patches || [http://download.moodle.org/download.php/dblib/php53/DBLIB_TS.zip Download!]
|-
| No || 0.82 + 20090904 patches || [http://download.moodle.org/download.php/dblib/php53/DBLIB_NOTS.zip Download!]
|-
| rowspan="2" | PHP 5.4.x (vc9) || Yes || 0.82 + 20110906 patches || [http://inethub.olvi.net.ua/ftp/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/dblib_ts.zip Download!] [ftp://inethub.olvi.net.ua/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/DBLIB_TS.zip FTP Download!] [http://www.sendspace.com/file/vtger3 Mirror]
|-
| No || 0.82 + 20110906 patches || [http://inethub.olvi.net.ua/ftp/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/dblib_nts.zip Download!] [ftp://inethub.olvi.net.ua/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/DBLIB_NTS.zip FTP Download!] [http://www.sendspace.com/file/nkg2j4 Mirror]
|-
| colspan="4" | Thanks to [http://remote-learner.net/ Remote-Learner]] (Moodle [http://moodle.com/partners/ Partner]) and specially to Bryan Williams, donating one Visual C++ 6.0 Pro license to Moodle. Thanks to Trevor Johnson and his builds of the dblib extensions. Thanks to Daniele, Doug, Luis, Sean and many others by their collaboration in MDL-14725. Thanks to Frediano Ziglio and James K. Lowden from [http://freetds.org freetds.org] by their support. Thanks to Alastair Hole by providing the PHP 5.3 builds of the libraries. Thanks to Enyby by providing the PHP 5.4 builds of the libraries. Thanks!
|}

(alternatively here you can find some [[Development:Compiling FreeTDS under Windows|instructions to build those freetds extensions under win32]] yourself)

2. FreeTDS requires the .NET Framework v1.1 to be installed. You can [http://www.microsoft.com/downloads/details.aspx?FamilyID=262d25e3-f589-4842-8157-034d1e7cf3a3&DisplayLang=en download it from the Microsoft website] along with its [http://www.microsoft.com/downloads/details.aspx?FamilyID=a8f5654f-088e-40b2-bbdb-a83353618b38&DisplayLang=en service pack]. Alternatively, if you do not wish to install this framework, you can [http://kromann.info/ms-libs/msvcr71.dll download the required DLL] from Frank's site, and save it into your /PHP root directory.

3. Edit your /PHP/php.ini file and add this line:

extension=php_dblib.dll

Make sure that any lines referring to the php_mssql.dll extension are DISABLED (commented out).

4. When the PHP engine loads the FreeTDS extension it needs to be passed certain infiormation in order to be able to connect to your Moodle database. To retrieve this information FreeTDS looks for a file called '''freetds.conf''' in the root folder of the server that PHP installed on (e.g. C:\).

'''freetds.conf''' should have the following structure:

[global]
host = xxx.xxx.xxx.xxx (host name or ip of the MSSQL server)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520

If you want to connect to a particular [http://msdn.microsoft.com/en-us/library/aa174516(SQL.80).aspx instance] of MSSQL you should specify the instance name:

[global]
host = xxx.xxx.xxx.xxx (host name or ip of the MSSQL server)
instance = xxx (instance name, e.g. INST2)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520

'''Notes:'''
*You can configure FreeTDS to look for the freetds.conf file in any directory that you want - you don't have to use C:\. To do this create a SYSTEM environment variable called '''FREETDS''' and point it to the directory where you have installed the freetds.conf file. If you do not set this environment variable FreeTDS will look for the freetds.conf file in the C:\ folder, which is the default. One possible benefit of setting the FREETDS environment variable and using a different installation directory for freetds.conf is that C:\ is very predictable to a hacker that knows anything about FreeTDS and that is the first place that he would look if he wanted to compromise your system. So, using a different installation directory would just make your system stronger. See the FreeTDS [http://www.freetds.org/userguide/envvar.htm Setting the environment variables] documentation for more information about this FREETDS environment variable.

*Alternatively, you can [[Development:Compiling FreeTDS under Windows|recompile]] the FreeTDS extension yourself and change the default location to your preferred location at compile time. Then it is not necessary to create any environment variable. You must just ensure that freetds.conf is in the same folder that you specify when you compile php_dblib.dll.

*MSSQL is usually installed with port 1433 as the default. However, if the port was changed on your server when you installed MSSQL then you need to specify the correct port number.

5. Your Moodle '''config.php''' should include lines like these:

<code php>
$CFG->dbtype = 'mssql'; // Required
$CFG->dbhost = 'localhost'; // assuming MS SQL is on the same server, otherwise use an IP
$CFG->dbname = 'moodle'; // or whatever you called the database you created
$CFG->dbuser = 'yourusername'; // I usually use the 'sa' account (dbowner perms are enough)
$CFG->dbpass = 'yourpassword';
$CFG->dbpersist = false;
$CFG->prefix = 'mdl_'; //Prefix, you can change it, but NEVER leave it blank.
</code>

If you don't have a config.php file yet, it can be generated as normal from the Moodle installer. Alternatively you can use the config-dist.php file that comes with the Moodle package to create your own config.php file.

6. Restart or start your web server. If Moodle still cannot communicate with the database server, please turn display_startup_errors to "On" in your /PHP/php.ini file, then restart the web server and check for any errors that may indicate incorrect DLL versions or missing dependencies. These error reports, turned off by default in PHP, can be vital in locating a problem with new extension installations.

7. Database conection test, try this PHP script, just put in a text file called test.php change ('localhost', 'db_user', 'db_password') to suite your setup, and load from local host (http://localhost/test.php)...

<code php>
<?php
$link = mssql_connect('localhost', 'db_user', 'db_password');
if(!$link) {
echo'Could not connect';
die('Could not connect: ' . mssql_error());
}
echo'Successful connection';
mssql_close($link);
?>
</code>

8. Install Moodle as usual. Good luck!

=== Troubleshooting ===
If you encounter some problems you can try:
*check that you have DotNet framework 1.1 installed (later version are installed on Vista, but you could need this specific one) 
*enable TCP/IP for MSSQL: SQL Server 2005 Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP (Enable) -> Properties -> Ip Addresses -> 127.0.0.1 (Active+Enable) 
*make sure the SQL Server Browser service is running SQL Server 2005 Network Configuration -> SQL Server Services 
*if you are using SQL Server 2005 and you have the error ''4004: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier'', try the ODBTP method (next chapter). The SQL Server complaining that it doesn't support pure Unicode via TDS or older versions of ODBC. Microsoft has deprecated DB-Library a long ago, in favor of ODBC, OLE DB, or SQL Native Client. Many new features of SQL 2005 aren't accessible via DB-Library so if you need them, you could have to switch away from tools based on TDS and DB-Library :(

== FreeTDS on Linux (on Ubuntu by compiling an mssql.so extension) ==
This is a good read to [http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/ building a FreeTDS based mssql extension for apache on Ubuntu]. Do note that [http://www.freetds.org/news.html freeTDS] 0.91 was recently released, you can find latest versions [http://freetds.sourceforge.net/ here].

Note: the freetds.conf file you use should have "text size = 20971520" as mentioned in the FreeTDS on Windows section otherwise you might see sessions logging out or worse apache segmentation faults. Also see [[FreeTDS]].

== Using FreeTDS on Debian Lenny ==
I found the following solution using:
* PHP Version 5.2.6-1+lenny9
* Microsoft SQL Server Enterprise Edition, version: 9.00.4053.00
<pre>apt-get install libsybdb5 freetds-common php5-sybase
/etc/init.d/apache2 restart</pre>
At the end of the process, if all goes fine, you will find in the mssql section of phpinfo();

{| class="nicetable"
|-
! MSSQL Support
! enabled
|-
| Library version
| FreeTDS
|}

Once FreeTDS is correctly installed, don not forget to set it up following explanations in https://docs.moodle.org/en/FreeTDS

== See Also ==
* FreeTDS for Windows is obsolete and too slow as of 2011. See: [http://moodle.org/mod/forum/discuss.php?d=183987 Hardware and Performance Forum]
* [[Errors FAQ]]
* Using Moodle [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum]
* [[Installing Postgres for PHP]]
* [[Using the Microsoft SQL Server Driver for PHP]]
* [[Installing Oracle for PHP]]

[[Category:XMLDB]]
[[Category:DB]]
[[Category:SQL databases]]

Installing MSSQL for PHP

2013-06-12T03:26:03Z

Deraadt: Adding note about DB names on MSSQL queries.

{{Installing Moodle}}== Introduction ==

This short manual is suitable if you are trying to run Moodle using the SQL*Server (MSSQL) RDBMS. Steps detailed below must be performed '''before''' installing Moodle itself.

Some of this may also apply if you wish to access an MSSQL server for external db authentication/enrollment.

First of all, minimum required version of MSSQL has been stabilised to MSSQL 2005 (v.9), although it '''might work with MSSQL 2000 (v.8) or newer'''. All the development process has been performed using MSSQL 2005 and there could be some '''unknown problems''' with previous releases.

While PHP comes with one, more or less, standard extension (mssql) that provides access to MSSQL databases, early we found some hard limits on it. Basically such default extension has some limits that prevent us to use it at all (you can find more info about these problems [[Development:XMLDB problems#MSSQL, PHP, UTF-8 and UCS-2|here]]).

So, in order to allow PHP (i.e. Moodle) to access to MSSQL DBs properly we have to install a '''mssql extension alternative''' to save us from the problems related above. See the sections below for details about the various options.

== Installation overview ==

1. Get MSSQL Server installed and running. ([http://www.microsoft.com/sql/editions/express/default.mspx A free limited version, SQL Server Express Edition] is available for testing.)
:Make sure that you choose mixed authentication (Windows and local accounts) to keep things simpler later. You'll be asked to define the "sa" account password (it's the default System Administrator account which has full access to all databases by default).

2. Make sure MS SQL Server can accept incoming TCP/IP connections on port 1433 (the standard one).
:You might need to explicitly allow this in your Windows firewall (see the Control Panel). You may also need to edit options in the :'''SQL Server Configuration Manager''' -> '''Network Configuration''' -> '''Protocols''' -> '''TCP/IP enabled'''

3. Open the "SQL Server Management Studio" and create a new empty database. If you are using the "sa" account then you don't need to do anything else here.

4. Configure these settings in your created (and still empty) database:
Configure these settings in your created (and still empty) database:
:*Use a case sensitive collation, such as Latin1_General_CS_AS.
:*ANSI NULLS Enabled = true (ALTER DATABASE xxxx SET ANSI_NULLS ON)
:*Quoted Identifiers Enabled = true (ALTER DATABASE xxxx SET QUOTED_IDENTIFIER ON)
:* (Moodle 2.x only) Row Versioning Enabled (ALTER DATABASE xxxx SET READ_COMMITTED_SNAPSHOT ON)
:** This is not settable via the DB properties. To set READ_COMMITTED_SNAPSHOT, there must be no active connections to the database except for the connection executing the ALTER command. If you are viewing the DB in the Server Management Studio, disconnect from any servers in the "Object Explorer" (right-click > Disconnect), then create a "New Query" and run the ALTER command. See http://msdn.microsoft.com/en-us/library/bb522682.aspx for details.
** If your DB name starts with a number, you may need to put quotes around the DB name in the query.

5. Get PHP installed with a web server. Unless you want to do it under IIS or some other way, the packages on the [http://download.moodle.org Moodle download page] are a good solution.

6. Choose one of the following specific sections for your server to install the '''mssql extension alternative''' installed and running properly on your PHP box.

7. Set the following settings in your php.ini file
:* mssql.textlimit = 20971520
:* mssql.textsize = 20971520

8. With all this properly configured, you can continue with a [[Installing Moodle|standard Moodle installation]].

== Microsoft Drivers for SQL Server for PHP ==

'''WARNING: This driver has known problems and is therefore not suitable for any Moodle production servers.'''

In July 2008 Microsoft [http://social.msdn.microsoft.com/forums/en-US/sqldriverforphp/thread/a10e5202-9e41-4ff8-a33e-fbcc7b951be2/ released] a new SQL Server Driver for PHP. This is a PHP extension that allows PHP scripts to read and write data on Microsoft SQL Server databases and it overcomes the problems with the native SQL Server extension that was previously bundled with PHP.

When using [[IIS]] it is strongly recommended to use the official Microsoft PHP installer from http://php.iis.net/, it should include the latest version of necessary drivers and it also simplifies future upgrades and configuration.

For Windows servers with [[Apache]] see http://www.microsoft.com/en-us/download/details.aspx?id=20098.

== Using FreeTDS on Windows ==

'''Important Note 1:''' Due to some previous bugs it's highly recommendable to use PHP >= 5.2.6 and FreeTDS 0.82 + post-release patches ([http://tracker.moodle.org/browse/MDL-14725 more info]).

If your web server is on Windows, use '''php_dblib.dll'''. Despite the name, it's FreeTDS compiled for Windows. (Go to this page for information on [https://docs.moodle.org/en/FreeTDS Using FreeTDS for Unix].)

Originally we were using the DLLs available at [http://kromann.info/article.php?Id=11062598797760000 Frank Kromann's site], but they are outdated (using old versions of FreeTDS) and that has caused [http://tracker.moodle.org/browse/MDL-14725 some problems] in the past.

So, right now, the recommended way to use FreeTDS under Windows is to use PHP 5.2.x following the following instructions:

1. Download the appropriate copy of php_dblib.dll from the list below, and save it into your /PHP/ext directory.

{| border="1" align="center" cellpadding="5" style="text-align: center;"
|-
! PHP version !! [http://www.iis-aid.com/articles/my_word/difference_between_php_thread_safe_and_non_thread_safe_binaries Thread Safe] !! FreeTDS version !! Download URL
|-
| rowspan="2" | PHP 5.2.x (vc6) || Yes || 0.82 + 20090302 patches || [http://download.moodle.org/download.php/dblib/php52/DBLIB_TS.zip Download!]
|-
| No || 0.82 + 20090302 patches || [http://download.moodle.org/download.php/dblib/php52/DBLIB_NOTS.zip Download!]
|-
| rowspan="2" | PHP 5.3.x (vc9) || Yes || 0.82 + 20090904 patches || [http://download.moodle.org/download.php/dblib/php53/DBLIB_TS.zip Download!]
|-
| No || 0.82 + 20090904 patches || [http://download.moodle.org/download.php/dblib/php53/DBLIB_NOTS.zip Download!]
|-
| rowspan="2" | PHP 5.4.x (vc9) || Yes || 0.82 + 20110906 patches || [http://inethub.olvi.net.ua/ftp/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/dblib_ts.zip Download!] [ftp://inethub.olvi.net.ua/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/DBLIB_TS.zip FTP Download!] [http://www.sendspace.com/file/vtger3 Mirror]
|-
| No || 0.82 + 20110906 patches || [http://inethub.olvi.net.ua/ftp/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/dblib_nts.zip Download!] [ftp://inethub.olvi.net.ua/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/DBLIB_NTS.zip FTP Download!] [http://www.sendspace.com/file/nkg2j4 Mirror]
|-
| colspan="4" | Thanks to [http://remote-learner.net/ Remote-Learner]] (Moodle [http://moodle.com/partners/ Partner]) and specially to Bryan Williams, donating one Visual C++ 6.0 Pro license to Moodle. Thanks to Trevor Johnson and his builds of the dblib extensions. Thanks to Daniele, Doug, Luis, Sean and many others by their collaboration in MDL-14725. Thanks to Frediano Ziglio and James K. Lowden from [http://freetds.org freetds.org] by their support. Thanks to Alastair Hole by providing the PHP 5.3 builds of the libraries. Thanks to Enyby by providing the PHP 5.4 builds of the libraries. Thanks!
|}

(alternatively here you can find some [[Development:Compiling FreeTDS under Windows|instructions to build those freetds extensions under win32]] yourself)

2. FreeTDS requires the .NET Framework v1.1 to be installed. You can [http://www.microsoft.com/downloads/details.aspx?FamilyID=262d25e3-f589-4842-8157-034d1e7cf3a3&DisplayLang=en download it from the Microsoft website] along with its [http://www.microsoft.com/downloads/details.aspx?FamilyID=a8f5654f-088e-40b2-bbdb-a83353618b38&DisplayLang=en service pack]. Alternatively, if you do not wish to install this framework, you can [http://kromann.info/ms-libs/msvcr71.dll download the required DLL] from Frank's site, and save it into your /PHP root directory.

3. Edit your /PHP/php.ini file and add this line:

extension=php_dblib.dll

Make sure that any lines referring to the php_mssql.dll extension are DISABLED (commented out).

4. When the PHP engine loads the FreeTDS extension it needs to be passed certain infiormation in order to be able to connect to your Moodle database. To retrieve this information FreeTDS looks for a file called '''freetds.conf''' in the root folder of the server that PHP installed on (e.g. C:\).

'''freetds.conf''' should have the following structure:

[global]
host = xxx.xxx.xxx.xxx (host name or ip of the MSSQL server)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520

If you want to connect to a particular [http://msdn.microsoft.com/en-us/library/aa174516(SQL.80).aspx instance] of MSSQL you should specify the instance name:

[global]
host = xxx.xxx.xxx.xxx (host name or ip of the MSSQL server)
instance = xxx (instance name, e.g. INST2)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520

'''Notes:'''
*You can configure FreeTDS to look for the freetds.conf file in any directory that you want - you don't have to use C:\. To do this create a SYSTEM environment variable called '''FREETDS''' and point it to the directory where you have installed the freetds.conf file. If you do not set this environment variable FreeTDS will look for the freetds.conf file in the C:\ folder, which is the default. One possible benefit of setting the FREETDS environment variable and using a different installation directory for freetds.conf is that C:\ is very predictable to a hacker that knows anything about FreeTDS and that is the first place that he would look if he wanted to compromise your system. So, using a different installation directory would just make your system stronger. See the FreeTDS [http://www.freetds.org/userguide/envvar.htm Setting the environment variables] documentation for more information about this FREETDS environment variable.

*Alternatively, you can [[Development:Compiling FreeTDS under Windows|recompile]] the FreeTDS extension yourself and change the default location to your preferred location at compile time. Then it is not necessary to create any environment variable. You must just ensure that freetds.conf is in the same folder that you specify when you compile php_dblib.dll.

*MSSQL is usually installed with port 1433 as the default. However, if the port was changed on your server when you installed MSSQL then you need to specify the correct port number.

5. Your Moodle '''config.php''' should include lines like these:

<code php>
$CFG->dbtype = 'mssql'; // Required
$CFG->dbhost = 'localhost'; // assuming MS SQL is on the same server, otherwise use an IP
$CFG->dbname = 'moodle'; // or whatever you called the database you created
$CFG->dbuser = 'yourusername'; // I usually use the 'sa' account (dbowner perms are enough)
$CFG->dbpass = 'yourpassword';
$CFG->dbpersist = false;
$CFG->prefix = 'mdl_'; //Prefix, you can change it, but NEVER leave it blank.
</code>

If you don't have a config.php file yet, it can be generated as normal from the Moodle installer. Alternatively you can use the config-dist.php file that comes with the Moodle package to create your own config.php file.

6. Restart or start your web server. If Moodle still cannot communicate with the database server, please turn display_startup_errors to "On" in your /PHP/php.ini file, then restart the web server and check for any errors that may indicate incorrect DLL versions or missing dependencies. These error reports, turned off by default in PHP, can be vital in locating a problem with new extension installations.

7. Database conection test, try this PHP script, just put in a text file called test.php change ('localhost', 'db_user', 'db_password') to suite your setup, and load from local host (http://localhost/test.php)...

<code php>
<?php
$link = mssql_connect('localhost', 'db_user', 'db_password');
if(!$link) {
echo'Could not connect';
die('Could not connect: ' . mssql_error());
}
echo'Successful connection';
mssql_close($link);
?>
</code>

8. Install Moodle as usual. Good luck!

=== Troubleshooting ===
If you encounter some problems you can try:
*check that you have DotNet framework 1.1 installed (later version are installed on Vista, but you could need this specific one) 
*enable TCP/IP for MSSQL: SQL Server 2005 Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP (Enable) -> Properties -> Ip Addresses -> 127.0.0.1 (Active+Enable) 
*make sure the SQL Server Browser service is running SQL Server 2005 Network Configuration -> SQL Server Services 
*if you are using SQL Server 2005 and you have the error ''4004: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier'', try the ODBTP method (next chapter). The SQL Server complaining that it doesn't support pure Unicode via TDS or older versions of ODBC. Microsoft has deprecated DB-Library a long ago, in favor of ODBC, OLE DB, or SQL Native Client. Many new features of SQL 2005 aren't accessible via DB-Library so if you need them, you could have to switch away from tools based on TDS and DB-Library :(

== FreeTDS on Linux (on Ubuntu by compiling an mssql.so extension) ==
This is a good read to [http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/ building a FreeTDS based mssql extension for apache on Ubuntu]. Do note that [http://www.freetds.org/news.html freeTDS] 0.91 was recently released, you can find latest versions [http://freetds.sourceforge.net/ here].

Note: the freetds.conf file you use should have "text size = 20971520" as mentioned in the FreeTDS on Windows section otherwise you might see sessions logging out or worse apache segmentation faults. Also see [[FreeTDS]].

== Using FreeTDS on Debian Lenny ==
I found the following solution using:
* PHP Version 5.2.6-1+lenny9
* Microsoft SQL Server Enterprise Edition, version: 9.00.4053.00
<pre>apt-get install libsybdb5 freetds-common php5-sybase
/etc/init.d/apache2 restart</pre>
At the end of the process, if all goes fine, you will find in the mssql section of phpinfo();

{| class="nicetable"
|-
! MSSQL Support
! enabled
|-
| Library version
| FreeTDS
|}

Once FreeTDS is correctly installed, don not forget to set it up following explanations in https://docs.moodle.org/en/FreeTDS

== See Also ==
* FreeTDS for Windows is obsolete and too slow as of 2011. See: [http://moodle.org/mod/forum/discuss.php?d=183987 Hardware and Performance Forum]
* [[Errors FAQ]]
* Using Moodle [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum]
* [[Installing Postgres for PHP]]
* [[Using the Microsoft SQL Server Driver for PHP]]
* [[Installing Oracle for PHP]]

[[Category:XMLDB]]
[[Category:DB]]
[[Category:SQL databases]]

Installing MSSQL for PHP

2013-05-02T09:40:26Z

Deraadt: Makin

{{Installing Moodle}}== Introduction ==

This short manual is suitable if you are trying to run Moodle using the SQL*Server (MSSQL) RDBMS. Steps detailed below must be performed '''before''' installing Moodle itself.

Some of this may also apply if you wish to access an MSSQL server for external db authentication/enrollment.

First of all, minimum required version of MSSQL has been stabilised to MSSQL 2005 (v.9), although it '''might work with MSSQL 2000 (v.8) or newer'''. All the development process has been performed using MSSQL 2005 and there could be some '''unknown problems''' with previous releases.

While PHP comes with one, more or less, standard extension (mssql) that provides access to MSSQL databases, early we found some hard limits on it. Basically such default extension has some limits that prevent us to use it at all (you can find more info about these problems [[Development:XMLDB problems#MSSQL, PHP, UTF-8 and UCS-2|here]]).

So, in order to allow PHP (i.e. Moodle) to access to MSSQL DBs properly we have to install a '''mssql extension alternative''' to save us from the problems related above. See the sections below for details about the various options.

== Installation overview ==

1. Get MSSQL Server installed and running. ([http://www.microsoft.com/sql/editions/express/default.mspx A free limited version, SQL Server Express Edition] is available for testing.)
:Make sure that you choose mixed authentication (Windows and local accounts) to keep things simpler later. You'll be asked to define the "sa" account password (it's the default System Administrator account which has full access to all databases by default).

2. Make sure MS SQL Server can accept incoming TCP/IP connections on port 1433 (the standard one).
:You might need to explicitly allow this in your Windows firewall (see the Control Panel). You may also need to edit options in the :'''SQL Server Configuration Manager''' -> '''Network Configuration''' -> '''Protocols''' -> '''TCP/IP enabled'''

3. Open the "SQL Server Management Studio" and create a new empty database. If you are using the "sa" account then you don't need to do anything else here.

4. Configure these settings in your created (and still empty) database:
Configure these settings in your created (and still empty) database:
:*Use a case sensitive collation, such as Latin1_General_CS_AS.
:*ANSI NULLS Enabled = true (ALTER DATABASE xxxx SET ANSI_NULLS ON)
:*Quoted Identifiers Enabled = true (ALTER DATABASE xxxx SET QUOTED_IDENTIFIER ON)
:* (Moodle 2.x only) Row Versioning Enabled (ALTER DATABASE xxxx SET READ_COMMITTED_SNAPSHOT ON)
:** This is not settable via the DB properties. To set READ_COMMITTED_SNAPSHOT, there must be no active connections to the database except for the connection executing the ALTER command. If you are viewing the DB in the Server Management Studio, disconnect from any servers in the "Object Explorer" (right-click > Disconnect), then create a "New Query" and run the ALTER command. See http://msdn.microsoft.com/en-us/library/bb522682.aspx for details.

5. Get PHP installed with a web server. Unless you want to do it under IIS or some other way, the packages on the [http://download.moodle.org Moodle download page] are a good solution.

6. Choose one of the following specific sections for your server to install the '''mssql extension alternative''' installed and running properly on your PHP box.

7. Set the following settings in your php.ini file
:* mssql.textlimit = 20971520
:* mssql.textsize = 20971520

8. With all this properly configured, you can continue with a [[Installing Moodle|standard Moodle installation]].

== Microsoft Drivers for SQL Server for PHP ==

'''WARNING: This driver has known problems and is therefore not suitable for any Moodle production servers.'''

In July 2008 Microsoft [http://social.msdn.microsoft.com/forums/en-US/sqldriverforphp/thread/a10e5202-9e41-4ff8-a33e-fbcc7b951be2/ released] a new SQL Server Driver for PHP. This is a PHP extension that allows PHP scripts to read and write data on Microsoft SQL Server databases and it overcomes the problems with the native SQL Server extension that was previously bundled with PHP.

When using [[IIS]] it is strongly recommended to use the official Microsoft PHP installer from http://php.iis.net/, it should include the latest version of necessary drivers and it also simplifies future upgrades and configuration.

For Windows servers with [[Apache]] see http://www.microsoft.com/en-us/download/details.aspx?id=20098.

== Using FreeTDS on Windows ==

'''Important Note 1:''' Due to some previous bugs it's highly recommendable to use PHP >= 5.2.6 and FreeTDS 0.82 + post-release patches ([http://tracker.moodle.org/browse/MDL-14725 more info]).

If your web server is on Windows, use '''php_dblib.dll'''. Despite the name, it's FreeTDS compiled for Windows. (Go to this page for information on [https://docs.moodle.org/en/FreeTDS Using FreeTDS for Unix].)

Originally we were using the DLLs available at [http://kromann.info/article.php?Id=11062598797760000 Frank Kromann's site], but they are outdated (using old versions of FreeTDS) and that has caused [http://tracker.moodle.org/browse/MDL-14725 some problems] in the past.

So, right now, the recommended way to use FreeTDS under Windows is to use PHP 5.2.x following the following instructions:

1. Download the appropriate copy of php_dblib.dll from the list below, and save it into your /PHP/ext directory.

{| border="1" align="center" cellpadding="5" style="text-align: center;"
|-
! PHP version !! [http://www.iis-aid.com/articles/my_word/difference_between_php_thread_safe_and_non_thread_safe_binaries Thread Safe] !! FreeTDS version !! Download URL
|-
| rowspan="2" | PHP 5.2.x (vc6) || Yes || 0.82 + 20090302 patches || [http://download.moodle.org/download.php/dblib/php52/DBLIB_TS.zip Download!]
|-
| No || 0.82 + 20090302 patches || [http://download.moodle.org/download.php/dblib/php52/DBLIB_NOTS.zip Download!]
|-
| rowspan="2" | PHP 5.3.x (vc9) || Yes || 0.82 + 20090904 patches || [http://download.moodle.org/download.php/dblib/php53/DBLIB_TS.zip Download!]
|-
| No || 0.82 + 20090904 patches || [http://download.moodle.org/download.php/dblib/php53/DBLIB_NOTS.zip Download!]
|-
| rowspan="2" | PHP 5.4.x (vc9) || Yes || 0.82 + 20110906 patches || [http://inethub.olvi.net.ua/ftp/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/dblib_ts.zip Download!] [ftp://inethub.olvi.net.ua/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/DBLIB_TS.zip FTP Download!] [http://www.sendspace.com/file/vtger3 Mirror]
|-
| No || 0.82 + 20110906 patches || [http://inethub.olvi.net.ua/ftp/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/dblib_nts.zip Download!] [ftp://inethub.olvi.net.ua/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/DBLIB_NTS.zip FTP Download!] [http://www.sendspace.com/file/nkg2j4 Mirror]
|-
| colspan="4" | Thanks to [http://remote-learner.net/ Remote-Learner]] (Moodle [http://moodle.com/partners/ Partner]) and specially to Bryan Williams, donating one Visual C++ 6.0 Pro license to Moodle. Thanks to Trevor Johnson and his builds of the dblib extensions. Thanks to Daniele, Doug, Luis, Sean and many others by their collaboration in MDL-14725. Thanks to Frediano Ziglio and James K. Lowden from [http://freetds.org freetds.org] by their support. Thanks to Alastair Hole by providing the PHP 5.3 builds of the libraries. Thanks to Enyby by providing the PHP 5.4 builds of the libraries. Thanks!
|}

(alternatively here you can find some [[Development:Compiling FreeTDS under Windows|instructions to build those freetds extensions under win32]] yourself)

2. FreeTDS requires the .NET Framework v1.1 to be installed. You can [http://www.microsoft.com/downloads/details.aspx?FamilyID=262d25e3-f589-4842-8157-034d1e7cf3a3&DisplayLang=en download it from the Microsoft website] along with its [http://www.microsoft.com/downloads/details.aspx?FamilyID=a8f5654f-088e-40b2-bbdb-a83353618b38&DisplayLang=en service pack]. Alternatively, if you do not wish to install this framework, you can [http://kromann.info/ms-libs/msvcr71.dll download the required DLL] from Frank's site, and save it into your /PHP root directory.

3. Edit your /PHP/php.ini file and add this line:

extension=php_dblib.dll

Make sure that any lines referring to the php_mssql.dll extension are DISABLED (commented out).

4. When the PHP engine loads the FreeTDS extension it needs to be passed certain infiormation in order to be able to connect to your Moodle database. To retrieve this information FreeTDS looks for a file called '''freetds.conf''' in the root folder of the server that PHP installed on (e.g. C:\).

'''freetds.conf''' should have the following structure:

[global]
host = xxx.xxx.xxx.xxx (host name or ip of the MSSQL server)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520

If you want to connect to a particular [http://msdn.microsoft.com/en-us/library/aa174516(SQL.80).aspx instance] of MSSQL you should specify the instance name:

[global]
host = xxx.xxx.xxx.xxx (host name or ip of the MSSQL server)
instance = xxx (instance name, e.g. INST2)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520

'''Notes:'''
*You can configure FreeTDS to look for the freetds.conf file in any directory that you want - you don't have to use C:\. To do this create a SYSTEM environment variable called '''FREETDS''' and point it to the directory where you have installed the freetds.conf file. If you do not set this environment variable FreeTDS will look for the freetds.conf file in the C:\ folder, which is the default. One possible benefit of setting the FREETDS environment variable and using a different installation directory for freetds.conf is that C:\ is very predictable to a hacker that knows anything about FreeTDS and that is the first place that he would look if he wanted to compromise your system. So, using a different installation directory would just make your system stronger. See the FreeTDS [http://www.freetds.org/userguide/envvar.htm Setting the environment variables] documentation for more information about this FREETDS environment variable.

*Alternatively, you can [[Development:Compiling FreeTDS under Windows|recompile]] the FreeTDS extension yourself and change the default location to your preferred location at compile time. Then it is not necessary to create any environment variable. You must just ensure that freetds.conf is in the same folder that you specify when you compile php_dblib.dll.

*MSSQL is usually installed with port 1433 as the default. However, if the port was changed on your server when you installed MSSQL then you need to specify the correct port number.

5. Your Moodle '''config.php''' should include lines like these:

<code php>
$CFG->dbtype = 'mssql'; // Required
$CFG->dbhost = 'localhost'; // assuming MS SQL is on the same server, otherwise use an IP
$CFG->dbname = 'moodle'; // or whatever you called the database you created
$CFG->dbuser = 'yourusername'; // I usually use the 'sa' account (dbowner perms are enough)
$CFG->dbpass = 'yourpassword';
$CFG->dbpersist = false;
$CFG->prefix = 'mdl_'; //Prefix, you can change it, but NEVER leave it blank.
</code>

If you don't have a config.php file yet, it can be generated as normal from the Moodle installer. Alternatively you can use the config-dist.php file that comes with the Moodle package to create your own config.php file.

6. Restart or start your web server. If Moodle still cannot communicate with the database server, please turn display_startup_errors to "On" in your /PHP/php.ini file, then restart the web server and check for any errors that may indicate incorrect DLL versions or missing dependencies. These error reports, turned off by default in PHP, can be vital in locating a problem with new extension installations.

7. Database conection test, try this PHP script, just put in a text file called test.php change ('localhost', 'db_user', 'db_password') to suite your setup, and load from local host (http://localhost/test.php)...

<code php>
<?php
$link = mssql_connect('localhost', 'db_user', 'db_password');
if(!$link) {
echo'Could not connect';
die('Could not connect: ' . mssql_error());
}
echo'Successful connection';
mssql_close($link);
?>
</code>

8. Install Moodle as usual. Good luck!

=== Troubleshooting ===
If you encounter some problems you can try:
*check that you have DotNet framework 1.1 installed (later version are installed on Vista, but you could need this specific one) 
*enable TCP/IP for MSSQL: SQL Server 2005 Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP (Enable) -> Properties -> Ip Addresses -> 127.0.0.1 (Active+Enable) 
*make sure the SQL Server Browser service is running SQL Server 2005 Network Configuration -> SQL Server Services 
*if you are using SQL Server 2005 and you have the error ''4004: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier'', try the ODBTP method (next chapter). The SQL Server complaining that it doesn't support pure Unicode via TDS or older versions of ODBC. Microsoft has deprecated DB-Library a long ago, in favor of ODBC, OLE DB, or SQL Native Client. Many new features of SQL 2005 aren't accessible via DB-Library so if you need them, you could have to switch away from tools based on TDS and DB-Library :(

== FreeTDS on Linux (on Ubuntu by compiling an mssql.so extension) ==
This is a good read to [http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/ building a FreeTDS based mssql extension for apache on Ubuntu]. Do note that [http://www.freetds.org/news.html freeTDS] 0.91 was recently released, you can find latest versions [http://freetds.sourceforge.net/ here].

Note: the freetds.conf file you use should have "text size = 20971520" as mentioned in the FreeTDS on Windows section otherwise you might see sessions logging out or worse apache segmentation faults. Also see [[FreeTDS]].

== Using FreeTDS on Debian Lenny ==
I found the following solution using:
* PHP Version 5.2.6-1+lenny9
* Microsoft SQL Server Enterprise Edition, version: 9.00.4053.00
<pre>apt-get install libsybdb5 freetds-common php5-sybase
/etc/init.d/apache2 restart</pre>
At the end of the process, if all goes fine, you will find in the mssql section of phpinfo();

{| class="nicetable"
|-
! MSSQL Support
! enabled
|-
| Library version
| FreeTDS
|}

Once FreeTDS is correctly installed, don not forget to set it up following explanations in https://docs.moodle.org/en/FreeTDS

== See Also ==
* FreeTDS for Windows is obsolete and too slow as of 2011. See: [http://moodle.org/mod/forum/discuss.php?d=183987 Hardware and Performance Forum]
* [[Errors FAQ]]
* Using Moodle [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum]
* [[Installing Postgres for PHP]]
* [[Using the Microsoft SQL Server Driver for PHP]]
* [[Installing Oracle for PHP]]

[[Category:XMLDB]]
[[Category:DB]]
[[Category:SQL databases]]

Moodle research

2013-05-01T06:51:13Z

Deraadt: Adding link to research.moodle.net

{{About Moodle}}
There site [http://research.moodle.net research.moodle.net] has been established as a point of contact for Moodle researchers. On that site there is a [http://research.moodle.net/mod/data/view.php?id=1 Moodle Reseach Collection] containing Moodle-related research publications.

A growing, community-contributed collection of research into LMS (Learning Management Systems) and particularly Moodle.

=Moodle-specific research=
Academic, governmental, organisational research (mostly) involving Moodle (design, use, implementation...). Check [[Moodle research FAQ|here]] for details.
==Print (papers, reports, collections, theses...)==
*Al-Ajlan, A. & Zedan,H. (2008) [http://www.computer.org/portal/web/csdl/doi/10.1109/FTDCS.2008.22 Why Moodle] 12th IEEE International Workshop on Future Trends of Distributed Computing Systems, 2008
*Alier, M., Casany, J., Casado, P. (2007) [http://74.125.155.132/scholar?q=cache:9f3NRhHqyDMJ:scholar.google.com/+moodle&hl=en&as_sdt=0,5 Mobile Extension Of A Web Based Moodle Virtual Classroom]. Proceedings of E-Challenges Conference, 2007.
*Al Naddabi, Z. (2007). [http://www.editlib.org/p/26540 A Moodle Course: Design and Implementation in English for Academic Purposes Instruction]. In T. Bastiaens & S. Carliner (Eds.), Proceedings of World Conference on E-Learning in Corporate, Government, Healthcare, and Higher Education 2007
*Beatty, B. & Ulasewicz, C. (2006) [http://www.springerlink.com/content/bg0613214k409500/ Faculty Perspectives on Moving from Blackboard to the Moodle Learning Management System]. TechTrends Volume 50, Number 4, 36-45.
*Berggren, A. et al (2005) [http://74.125.155.132/scholar?q=cache:2t2PDSl4o_4J:scholar.google.com/+moodle&hl=en&as_sdt=0,5 Practical and Pedagogical Issues for Teacher Adoption of IMS Learning Design Standards in Moodle LMS]. Journal of Interactive Media in Education, 2005(02)
*Brandl, K. (2007) [http://74.125.155.132/scholar?q=cache:b1gGpxaaCR0J:scholar.google.com/+moodle&hl=en&as_sdt=0,5 Are You Ready to "Moodle"?]. Language Learning & Technology, May 2005, Vol.9(2)
*Burgos, D. et al. (2007) [http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.169.251&rep=rep1&type=pdf A First Step Mapping IMS Learning Design and Moodle]. Journal of Universal Computer Science, Vol. 13 (7).
*Cowan, P. (2006). [http://www.editlib.org/p/22507 Factors influencing Pre-Service teachers’ attitudes towards using a Moodle environment for teaching and learning]. In C. Crawford et al. (Eds.), Proceedings of Society for Information Technology & Teacher Education International Conference 2006
*Deng, Y. & Hemphill, L. (2006). [http://www.editlib.org/p/22054 Demonstrating Online K12 Teaching Strategies in a Moodle Course Management Environment]. In C. Crawford et al. (Eds.), Proceedings of Society for Information Technology & Teacher Education International Conference 2006
*DeSchryver, M., Mishra, P., Koehleer, M. & Francis, A. (2009). [http://www.editlib.org/?fuseaction=Reader.ViewFullText&paper_id=30612 Moodle vs. Facebook: Does using Facebook for Discussions in an Online Course Enhance Perceived Social Presence and Student Interaction?]. In I. Gibson et al. (Eds.), Proceedings of Society for Information Technology & Teacher Education International Conference 2009
*Dougiamas, M. & Taylor, P. (2003). [http://www.editlib.org/p/13739 Moodle: Using Learning Communities to Create an Open Source Course Management System]. In D. Lassner & C. McNaught (Eds.), Proceedings of World Conference on Educational Multimedia, Hypermedia and Telecommunications 2003.
*Graf, S. &List, B.(2005) [http://ieeexplore.ieee.org/xpl/freeabs_all.jsp?arnumber=1508637 An evaluation of open source e-learning platforms stressing adaptation issues]. Advanced Learning Technologies, 2005. ICALT 2005.
*Guttierez, E. et al. (2009) [http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6VCJ-4XB1967-2&_user=10&_coverDate=02%2F28%2F2010&_rdoc=1&_fmt=high&_orig=gateway&_origin=gateway&_sort=d&_docanchor=&view=c&_searchStrId=1688004089&_rerunOrigin=scholar.google&_acct=C000050221&_version=1&_urlVersion=0&_userid=10&md5=f9a939ec272e44d724d630209831642a&searchtype=a A new Moodle module supporting automatic verification of VHDL-based assignments]. Computers & Education, Vol 54 (2), Feb 2010.
*Hueros, D. & Sanchez, A. (2010) [http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6VDC-50HWJ4Y-4&_user=10&_coverDate=11%2F30%2F2010&_rdoc=1&_fmt=high&_orig=gateway&_origin=gateway&_sort=d&_docanchor=&view=c&_searchStrId=1687987167&_rerunOrigin=scholar.google&_acct=C000050221&_version=1&_urlVersion=0&_userid=10&md5=15927cf368be7fc0df80aa91ac4e92a3&searchtype=a Motivational factors that influence the acceptance of Moodle using Technology Acceptance Model (TAM)]. Computers in Human Behavior. Vol. 26(6) Nov 2010.
*Jide, W. & Li, Z. (2009) [http://en.cnki.com.cn/Article_en/CJFDTOTAL-YCJY200905004.htm New Progresses in the Domestic Research on Moodle] Journal of Distance Education.
*Knutzen, B. & Kennedy, D.M. (2008). [http://www.editlib.org/p/28913 Can Learning to Use Moodle Alter Teachers’ Approaches to Teaching?]. In J. Luca & E. Weippl (Eds.), Proceedings of World Conference on Educational Multimedia, Hypermedia and Telecommunications 2008
*Pfaffman, J. (2004). [http://www.editlib.org/p/13664 Integrating Moodle into a Course for Pre- and In-service Teachers]. In R. Ferdig et al. (Eds.), Proceedings of Society for Information Technology & Teacher Education International Conference 2004
*Kemp, J. Livingstone, D. (2008) [http://74.125.155.132/scholar?q=cache:Kvnq5aCMDSwJ:scholar.google.com/+moodle&hl=en&as_sdt=0,5 Integrating Web-Based and 3D Learning Environments: Second Life Meets Moodle]. UPGRADE Vol. IX, No. 3, June 2008
*Romero,C. et al (2009) [http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V03-4R98K46-7&_user=10&_coverDate=03%2F31%2F2009&_rdoc=1&_fmt=high&_orig=gateway&_origin=gateway&_sort=d&_docanchor=&view=c&_searchStrId=1687992777&_rerunOrigin=scholar.google&_acct=C000050221&_version=1&_urlVersion=0&_userid=10&md5=f15fe515105a3c120401c2a6c6d1551e&searchtype=a Evolutionary algorithms for subgroup discovery in e-learning: A practical application using Moodle data]. Expert Systems with Applications, Volume 36(2)1, March 2009.
*Romero, S. Ventura, C. & Garcia, E. (2007) [http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6VCJ-4P7FCT6-1&_user=10&_coverDate=08%2F31%2F2008&_rdoc=1&_fmt=high&_orig=gateway&_origin=gateway&_sort=d&_docanchor=&view=c&_searchStrId=1686659096&_rerunOrigin=scholar.google&_acct=C000050221&_version=1&_urlVersion=0&_userid=10&md5=b77769e114cba19d78a12526b8755858&searchtype=a Data mining in course management systems: Moodle case study and tutorial]. Computers & Education. Vol. 51 (1), Aug 2008 (Abstract only, paid access).
*Li, P. et al. (2009) [http://en.cnki.com.cn/Article_en/CJFDTOTAL-YCJY200803014.htm Classroom Response Systems Based on Moodle]. Distance Education Journal;2008-03
*Martín-Blas, T. & Serrano-Fernández (2009) [http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6VCJ-4T2RYPV-1&_user=10&_coverDate=01%2F31%2F2009&_rdoc=1&_fmt=high&_orig=gateway&_origin=gateway&_sort=d&_docanchor=&view=c&_searchStrId=1687986242&_rerunOrigin=scholar.google&_acct=C000050221&_version=1&_urlVersion=0&_userid=10&md5=81ca28b957fbd194f133ad342073759a&searchtype=a The role of new technologies in the learning process: Moodle as a teaching tool in Physics]. Computers & Education. Vol. 52(1), Jan 2009.
*Meurant, R.C. (2009) [http://www.springerlink.com/content/u08884qr83704276/ Computer-Based Internet-Hosted Assessment of L2 Literacy: Computerizing and Administering of the Oxford Quick Placement Test in ExamView and Moodle].Communications in Computer and Information Science, 2009, Vol. 60.
*Rakoczi, Gergely. (2010) [http://www.fm-kp.si/zalozba/ISBN/978-961-266-066-6/prispevki/rakoczi.pdf "Cast your Eyes on Moodle: An Eye Tracking Study investigating learning with Moodle"]
*Liu Suqin & Li Jiahou (2007) [http://en.cnki.com.cn/Article_en/CJFDTOTAL-YCJY200701002.htm Curriculum Design BIG6 Mode Based on Moodle]. Distance Education Journal.
*Stewart, B. et al (2007) [http://www.igi-global.com/bookstore/article.aspx?TitleId=1705 Choosing MOODLE: An Evaluation of Learning Management Systems at Athabasca University. International Journal of Distance Education Technologies (IJDET)]. Vol. 5(3)
*Zenha-Rela,M. & Carvalho, R.(2006) [http://ieeexplore.ieee.org/xpl/freeabs_all.jsp?arnumber=4117034 Work in Progress: Self Evaluation Through Monitored Peer Review Using the Moodle Platform]. Frontiers in Education Conference.
*Zhiqiang, M & Yanli, W. (2008) [http://en.cnki.com.cn/Article_en/CJFDTOTAL-DDJY200807013.htm An Analysis of Moodle-based Online Learning Barriers]. Distance Education in China, Aug 2008.

==Presentations and videos==
==Other material (eg projects)==

=LMS research - general=
Broader academic, governmental, organisational research on LMS/VLE useful to Moodle to learn from. Check [[Moodle research FAQ|here]] for details.
==Print (papers, reports, collections, theses...)==
*Carmean, C. & Haefner,J. (2002). [http://net.educause.edu/ir/library/pdf/ERM0261.pdf Mind over matter: Transforming course management systems into effective learning environments]. EDUCAUSE Review, Vol. 37, No. 6, pp. 27–33.
*Chang, Chinhong Lim (2008) [http://firstmonday.org/htbin/cgiwrap/bin/ojs/index.php/fm/article/view/2530/2303 Faculty Perceptions and Utilization of a Learning Management System in Higher Education] (dissertation)
*Keesee, G. & Shepard, M.(2011) [http://www.westga.edu/~distance/ojdla/spring141/keesee_shepard141.html Perceived Attributes Predict Course Management System Adopter Status]. Online Journal of Distance Learning Administration, Vol 14/1.
*Lane, L. (2009) [http://firstmonday.org/htbin/cgiwrap/bin/ojs/index.php/fm/article/view/2530/2303 Insidious pedagogy: How course management systems impact teaching]. First Monday, Vol. 14, Number 10 - 5 Oct 2009
*[http://en.wikipedia.org/wiki/Ofsted OFSTED] (2009) [http://www.ofsted.gov.uk/Ofsted-home/Publications-and-research/Browse-all-by/Documents-by-type/Thematic-reports/Virtual-learning-environments-an-evaluation-of-their-development-in-a-sample-of-educational-settings Virtual learning environments: an evaluation of their development in a sample of educational settings].
*Sancar, H. & Cagiltay, K. (2008). [http://www.editlib.org/p/28931 Effective Use of LMS: Pedagogy through the Technology]. In J. Luca & E. Weippl (Eds.), Proceedings of World Conference on Educational Multimedia, Hypermedia and Telecommunications 2008

==Presentations and videos==
==Other material==
=Questions? Try here=
See the growing list at [[Moodle research FAQ]]

Working with files

2012-11-29T03:56:34Z

Deraadt: Adding database acitivity file field

{{Managing content}}
*Moodle provides an easy way for a teacher to present materials to their students. These materials may take the form of files such as word-processed documents or slideshow presentations. The materials can be displayed on the page either as individual items or bundled together inside folders. One teacher might for instance wish to share a single research document in pdf format; another might have a folder of sample past examination papers for students to download.
*Most types of files can be uploaded and accessed through Moodle but the student needs to have the correct software to be able to open them.

==Adding files==
*To add files or folders, a teacher needs to have the editing turned on in their course and then select either [[File]] or [[Folder]] from the activity chooser (or "Add a resource" drop down menu).

{|
| [[File:filefolder23.png|thumb|Selecting a file or folder in the activity chooser]]
| [[File:Workingwithfiles.png|thumb|The "Add a resource" drop down menu]]
|}

*The screen for uploading and displaying a file (or folder of files) includes an "add" button. Clicking on this button takes you to the [[File picker]] which is the name given to the file storage and access area within Moodle. Find out more about the places you can upload or add files from in the [[File picker]] page.
*There is also a block (with an arrow) into which you can drag and drop a file straight from your desktop into Moodle.

{|
| [[File:newdraganddrop.png|thumb|Area for dragging and dropping files into]]
|}

==Viewing uploaded files==

* Once uploaded, files appear as thumbnails in the file manager for easy recognition.
* Files view can be easily toggled between icons view or a table view with sizes and dates, or a hierarchical list view.

{|
| [[File:truthumbnailsiconsview.png|thumb|File picker icon view]]
| [[File:tableview.png|thumb|File picker table view]]
| [[File:hierarchicallistview.png|thumb|File picker hierarchical list view]]
|}

==Editing or updating uploaded files==

*Clicking on the name of an uploaded file opens up a pop up dialogue box which allows file details quickly to be altered.

{|
| [[File:popupdialogue.png|thumb|File info popup dialogue]]
|}

==Creating an alias/shortcut==

*When an uploaded file (or a file from the Box.net, file system or EQUELLA repositories) is re-used elsewhere on Moodle, the teacher has the option to make a copy (a new, unconnected version) or to create a shortcut or ''alias''.
*If an alias is created, then when the original file is updated, it will change in all instances of the alias. So a teacher might add course notes to their private files for example, and then add them into a number of courses. When the teacher makes an alteration in the file in their private files, this alteration will be reflected in all instances of the course notes.
*An alias can be recognised by its thumbnail. See the difference in the screenshot below between the original file (left) and the alias (right):

{|
| [[File:alias.png|thumb|Creating an alias]]
| [[File:shortcut1.png|frame]]
|}

===Areas in which aliases cannot be made===

An alias cannot be made in the following areas of Moodle:

* an assignment submission
* a forum post attachment
* a workshop submission
* a quiz essay
* a database activity file field

This is to prevent cases such as a student uploading an item for assessment and then subsequently changing the original in their private files. When a student uses a file from their private files in one of these instances, they do not see the options to "copy" or "create an alias". Below is an example of a file added to an assignment:

{|
| [[File:aliasassignment.png|thumb|Assignment submission with no option to create an alias]]
|}

==See also==
*How to share a single file with students: [[File]]
*How to share a folder of files with students: [[Folder]]
*Questions about the file picker: [[File picker FAQ]]
* [[Restoring file aliases]]
*[http://www.youtube.com/watch?v=IrOKxYRJvGU How teachers upload files in Moodle 2 video]

[[de:Arbeiten mit Dateien und Verzeichnissen]]
[[fr:Utilisation de fichiers]]

Text editor

2012-10-31T04:02:54Z

Deraadt: Added instructions for disabling the spell checker

{{Editing text}}
The text editor (sometimes referred to as the 'HTML editor' or even 'TinyMCE') has many icons to assist the user in entering content. Many of these icons and functions should be familiar to anyone who uses a word processor. Some examples of where you will see the text editor include: Editing Section headings, description of an activity, writing an answer to a quiz question or editing the content of many blocks.

[[Image:HTMLeditor tools M2 1.png|thumb|The standard version of the text editor tool bar]]

==List of groups==
For those who are not familiar with the tool bar, here are the functions listed by group using the above example. Remember that the site administrator can edit or provide additonal toolbars.

Row 1
*[[Image:HTML_editor_group_font_style.png]] - Font, size and heading group
*[[Image:HTML_editor_group_undo_redo.png]] - Undo and Redo group
*[[Image:HTML_editor_group_find_replace.png]] - Find and Replace group
*[[Image:HTML_editor_group_fullscreen_1.png]]|Full screen toggle
Row 2
*[[Image:HTML editor group text effects.png]] - Text effect group
*[[Image:HTML editor group line format.png]] - Line format group
*[[Image:HTML_editor_group_formatting.png]] - Formatting group
*[[Image:HTML_editor_group_color.png]] - Color group
*[[Image:HTML_editor_group_paragraph.png]] - Paragraph group

Row 3
*[[Image:HTML_editor_group_lists.png]] - Number and Bullets and indents
*[[Image:HTML_editor_group_link.png]] - Link group
*[[Image:HTML_editor_group_insert.png]] - Insert group
*[[Image:HTML_editor_group_HTML_spell.png]] - HTML source toggle & spellchecker

==Special features==
===Color pickers===
*[[Image:HTML_editor_group_color.png]]
There are 4 levels of selecting a font or background color,
*A quick pick 5x8 matrix of colors
*"More colors" that links to Picker, Pallet and Named tabs
<gallery>
Image:HTML_editor_color_selector_basic_1.png|A quick pick 5x8 matrix of colors
Image:HTML_editor_color_selector_more_picker_1.png|A rainbow color picker tab
Image:HTML_editor_color_selector_more_pallet_1.png|A Pallet tab with a 18x12 matrix of colors
Image:HTML_editor_color_selector_more_named_1.png|A Named tab with custom pallets
</gallery>

===Insert images and media===
[[Image:HTML_editor_group_insert_MU_1.png|thumb|The Insert images and media group]]

* 1 Insert Image - uses [[File picker]]
* 2 Insert Emoticon (only visible if the site administrator has enabled the "show emoticons as images" ''filter in Settings>Site administration>Plugins>Filters>Manage filters'')
* 3 Insert Media - uses [[File picker]]
* 4 Insert Equation - uses java script editor
* 5 Insert Non breaking space
* 6 Insert Custom character - Special keyboard characters
* 7 Insert Table -

<gallery widths="300px">
Image:Files_File_picker_upload_files_add_1.png|File picker Upload file screen
Image:HTML editor equation editor 1.png|Equation editor
Image:HTML_editor_custom_character_selector_1.png|Custom character selector
</gallery>

====Insert table====
<gallery widths="300px">
Image:HTMLeditor_Insert_Table_general_1.png|General tab
Image:HTMLeditor_Insert_Table_advanced_1.png|Advanced tab
</gallery>

'''To add borders to a table'''

Cell borders are crucial for helping readers to follow the rows across the screen. If they aren’t showing already you can add them as follows:

#In the Wiki page containing your table, click its Edit tab
#Carefully select all the cells of the table
#Then right click (Macs: Command+click or Ctrl+Click) over any part of your selection to get a context menu; from it select Cell > Table Cell Properties; the cell properties dialog box then loads.
#Click on its Advanced tab, set Border Color to black (for instance), then click Apply, and then click Update.
#Click Save; the Wiki page containing your table will then load displaying its borders.

==Site administration settings==

===Manage editors===

A site administrator can enable / disable text editors in ''Settings > Site administration > Plugins > Text editors > Manage editors''. By default the TinyMCE HTML editor and plain text area are enabled.

====Disabling the built-in spell checker====
If you want to disable the TinyMCE spell checker and rely on browser spell checker functionality instead, you can do this by disabling the ''spellchecker'' plugin. Navigate to ''Settings > Site administration > Plugins > Text editors > TinyMCE HTML editor > General settings'' and click the eye icon for this plugin.

====Spell engine settings====
[[File:Spellengine.png]]

The TinyMCE HTML editor used by Moodle has Google Spell as its default spell engine (spell-checker). This can be changed by a site administrator in ''Settings > Site administration > Plugins > Text editors > TinyMCE HTML editor''.

If PSpellSpell is selected then aspell 0.50 or later must be installed on your server and the path to aspell set in Settings > Site administration > Server > System Paths.

[[File:Spellcheck.png]]

====HTML settings====

A site administrator can edit the emoticons (or smileys) used in the text editor in ''Settings > Site administration > Appearance > HTML settings''.

====Available fonts list====

{{New features}}In addition to the default fonts, a site administrator can add extra fonts by typing their name and string in the box in ''Settings > Site administration > Plugins > Text editors > TinyMCE HTML editor'' as demonstrated in the screencast [http://youtu.be/udP7Bnur30Y How to add extra fonts].

==See also==

* [[Text editor FAQ]]
* [http://www.youtube.com/watch?v=xJE6UhqnyjU HTML editor in Moodle 2.0 video]

[[Category:Site administration]]

[[de:Text-Editor]]

Activity completion settings

2012-10-09T01:59:15Z

Deraadt: Correction

{{Activity completion}}
==Activity settings==

Depending on the type of activity, there are different completion requirements. For example, a [[Page|Page]] might have the requirement to ''require view''; a [[Quiz|Quiz]] might have the requirement to ''require grade'' while a [[Forum|Forum]] might have the requirement to ''require posts/discussions/replies''.

<gallery widths="300px">
File:Activity_completion_settings_common.png|Common settings for most graded activities
File:Forumactivitycompletion.png|Forum activity settings
</gallery>

===Completion tracking===
There are three options:

*''Do not indicate activity completion'' - this will not show checks(ticks)next to the activity
*''Students can manually mark the activity as completed'' - students press the check(tick) to change it. (Note: they can do this even without doing the activity!)
*''Show activity as complete when conditions are met'' - the selected completion criteria must be met before the check(tick) will change style

===Require view===

When this option is turned on, students have to view the activity in order to complete it.

* In most cases, clicking the link is enough to 'view' the activity.
* You should usually not turn on the 'view' condition if you have other requirements - this makes extra work for the server and it's unlikely that a student could meet any other conditions without viewing the activity.

===Require grade===

When this option is turned on, students have to get a grade on the activity in order to complete it. For example, a quiz would be marked completed as soon as the user submits it.

It does not matter how well the student did. Getting any grade will mark the activity completed.

It is possible to distinguish between 'pass' and 'fail' grades so that the activity becomes 'completed, passed' or 'completed, not passed' instead of just 'completed'. These results show a different icon and alternative text.

To set this up, you need to specify the pass value for this activity's individual grade:

# Go to the course gradebook by clicking the 'Grades' link on the course administration block.
# From the 'Choose an action' dropdown, pick 'Categories and items'.
# Click the Edit icon next to the grade item for this activity.
# Turn on 'Show Advanced'.
# Type a grade value (e.g. 5.0) in the 'Grade to pass' box.

Once you have done this, anybody submitting the quiz will receive either the pass or fail completion icon. If the quiz can be taken multiple times, the completion icon will automatically update whenever the grade does.

There is one limitation: this only works if grades are immediately visible to students. The grade must be neither permanently hidden, nor hidden until a certain date. If a grade is hidden then only the standard 'completed' state will be displayed - even once the hidden date has passed.

===Expect completed on===

The date is not shown to students and is only displayed in the [[Activity completion report]].

===Require posts===
This setting is seen in forums. For the forum to be classed as "complete" the student must either start a discussion or reply to a discussion. The number of posts they must make can be specified in the box.

===Require discussions===
This setting is seen in forums. For the forum to be classed as "complete", the student must start a discussion topic. The number of posts they must make can be specified in the box.

===Require replies===
This setting is seen in forums. For the forum to be classed as "complete" the student must reply to a discussion. The number of posts they must make can be specified in the box.

==Locked completion options==

If at least one person has completed an activity, completion options are 'locked'. This is because changing these options may result in unexpected behaviour. For example, if somebody has ticked an activity as manually completed, and you then set it to automatic completion, the activity will become unticked - very confusing for the student who had already ticked it!

:''Tip:'' It is best not to unlock options unless you are sure it won't cause problems - for example, if you know that students don't have access to the course yet, so it will only be staff who have marked the activity completed when testing.

==What happens when you unlock==

Once you unlock options and then click 'Save changes', all completion information for the activity will be deleted and, if possible, regenerated according to the new settings.

* If the new completion option is manual, everyone will be set to 'not completed' regardless of any previous setting.
* If it is automatic then, depending on the options chosen, the system may or may not be able to construct a correct current value for everyone.
** The 'viewed' requirement will not work - even if a student has viewed the activity before, it will not be marked completed until they view it again.
** Most other options will be recalculated successfully.

If you change completion options while a student is logged in, they may not see the changes for some minutes.

==Required site settings==
To use activity completion, the feature needs to be enabled for the site by an administrator as follows:
#In ''Settings > Site administration > [[Advanced_features| Advanced features]]'' check the "Enable completion tracking".
# Click the 'Save changes' button

:''Tip:'' The default [[Cron]] trigger for activity completion is every 10 minutes. Students and Teachers often think any course completion should instantly show up in a report.

==Required course settings==

''Settings > Course administration > Edit settings'' and look for the ''Student progress'' section.

You must select at least "Enabled, control via (course) completion and activity settings".

[[Category: Completion]]

[[de:Einstellungen zum Aktivitätsabschluss]]

Upgrade overview

2012-09-21T06:52:17Z

Deraadt: Amending plugin notes

<div class="navtrail">[[Main page]] ► [[Installation]] ► [[{{PAGENAME}}]]</div>
''Moodle 2.3 available now!''
Start enjoying the cool features of the latest and greatest version of Moodle in four easy steps...
__NOTOC__
==Step 1: Make sure that your server can run Moodle 2.2==
[[File:checklist.png|right]]
(Note: You need to upgrade to Moodle 2.2 before upgrading to 2.3.)

Go to ''Settings > Site administration > Server > Environment''

Status OK for everything? Great! Go to step 2...

Any problems? You probably need to upgrade your server software (such as PHP) to a more recent version.

==Step 2: Be prepared!==
[[File:backup.png|right]]
As usual with any large upgrade, you should always be prepared to "roll back" if there's an issue with your data or some custom code you've added.

; A test install: We highly advise you make a copy of your production site to practice the upgrade on first. That way, if you run into any problems that need fixing you won't affect your main site.

; Always make backups: When upgrading your production instance, make sure you have copies of everything, just in case. Full instructions are here: [[Site backup]].

==Step 3: Replace your Moodle code==

At this point you can replace the Moodle code on your server with the version you downloaded.

; Check plugins: Any plugins you have installed will also to be replaced with a version for your new Moodle version. If there is not yet an updated version of the plugin available, it will need to be uninstalled before upgrading your site.

==Step 4: Perform the upgrade!==
[[File:gears.png|right]]
Trigger the upgrade by [[Upgrading#Finishing_the_upgrade|visiting the admin page]].

If you have a large site this may take hours, so we recommend [[Administration_via_command_line#Upgrading_via_command_line|upgrading via command line]].

==How did you go?==

; Yes - it worked!: Great! Repeat the process for Moodle 2.3, and please post in the [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum] and share your success with the Moodle community!
; No - I had an error: Don’t worry, help is at hand. Post in the [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum] where our experts are waiting to explain any errors you obtain.

==See also==

* [[Upgrading]] for full details of the process
* [[Upgrading FAQ]]

[[Category:Installation]]

Moodle security procedures

2012-09-18T06:37:56Z

Deraadt: Adding note about holding issues until release.

{{Security}}
'''Note''': This is a draft document.

We treat security issues in Moodle software very seriously. Even though we dedicate a lot of time designing our code to avoid such problems, it is inevitable in a project of this size that new vulnerabilities will occasionally be discovered.

==Disclosure policy==

We practice ''responsible'' disclosure, which means we have a policy of disclosing all security issues that come to our attention, but only after we have solved the issue and given registered Moodle sites time to upgrade or patch their installations. Please note it is considered irresponsible to publicly repost mailed security notices '''before''' they are published at moodle.org.

We ask that when reporting a security issue, you observe these same guidelines, and beyond communicating with the security team (led by Petr Škoda), do not share your knowledge of security issues with the public at large.

==How can I report a security issue?==

Please "[http://tracker.moodle.org/secure/CreateIssue.jspa Create a new issue]" in the Moodle tracker describing the problem (and solution if possible) in detail. Make sure you set the security level accurately to make sure that the security team sees it. Bugs classified as a "Serious security issue" are hidden from everyone apart from the security team and the person who reported the problem.

If you are not sure whether an issue is a security issue, you should still create a new issue in the tracker for review, using the security level "Could be a security issue".

Please do NOT post about security issues in the forums on moodle.org. This will cause the issue to be more widely known before a fix can be prepared.

==How we deal with a reported security issue==

# The security team reviews the issue and evaluates its potential impact on all supported versions of Moodle.
# The security team works with the issue reporter to resolve the problem, keeping details of the problem and its solution hidden until a release is made.
# New versions are created and tested.
# New packages are created and made available on download.moodle.org.
# Advisories are mailed to administrators of registered Moodle sites.
# A public announcement is made about the security issue in the [http://moodle.org/mod/forum/view.php?id=7128 Moodle security news forum].

[[de:Sicherheitsprozeduren]]

admin/setting/local reminders

2012-08-07T04:00:34Z

Deraadt: /* See also */

==Introduction ==
[[File:reminders_icon.png]] 
The Calendar Reminders plugin creates reminders for Moodle calendar events and sends them automatically to relevant users in a timely manner via Moodle messaging interface. This is a local plugin controlled by the site administrator.

==Features==
* Reminders can have customised delivery times/methods according to event types.
* Users can control how they receive calendar reminders in their messaging preferences.
* Reminders are automatically sent (as long as the system [[Cron]] process is set up).

==Installation==
# Fetch the plug-in from following location.
#* Go to [http://moodle.org/plugins/view.php?plugin=local_reminders Reminders] and download the latest version from the repository.
# Go to the 'local' directory inside Moodle root directory.
# Extract the downloaded zip file inside to this folder. After it is extracted, there should be a "reminders" folder in the local folder with a structure as shown in the [[:dev:Email_reminders_for_calendar_events|project developer documentation]].
# Log into the Moodle site as the admin user. Usually the new plugin will be identified and notified you when logged-in. If not, go to Settings > Site administration > Notifications to detect and automatically install the local plug-in.
# Now you can change the plug-in specific settings via Settings > Site Administration > Plugins > Local plugins > Reminders.

== Screenshots ==
=== Sample e-mail reminder ===
[[File:sample_reminder_msg.png]]

=== Administrator settings page ===
[[File:admin_settings.jpg]]

==Tips and tricks==
* If you want to change the cron frequency of reminders plugin, open version.php file in the reminders directory and change the value corresponding to $plugin->cron. That value must be in seconds and it is the interval between two cron cycles.

== Acknowledgements ==
* Mentors: [http://moodle.org/user/view.php?id=381842&course=5 Michael de Raadt] and [http://moodle.org/user/view.php?id=955449&course=5 Rossiani Wijaya]
* Special thanks goes to [http://moodle.org/user/profile.php?id=1297063 Luiggi Sansonetti] who translated the plugin into French language.

== Bugs and Improvements ==
* Please report bugs and improvements on the Tracker using the [http://tracker.moodle.org/browse/CONTRIB/component/12134 Local: Calendar Reminders] component.

== See also ==
* Download location from plugin repository, [http://moodle.org/plugins/view.php?plugin=local_reminders Local Reminders]
* CONTRIB-3647 Automating Email reminders for calendar events project in Tracker.
* Plugin development [https://github.com/isuru89/moodle-reminders-for-calendar-events Repository]
* Forum post [http://moodle.org/mod/forum/discuss.php?d=201744 Local Plugin - Email Reminders for Calendar Events]
* RSS Feed from Personal Blog, [http://uisurumadushanka89.blogspot.com/feeds/posts/default/-/gsoc RSS Feed].

admin/setting/local reminders

2012-08-07T03:59:22Z

Deraadt:

==Introduction ==
[[File:reminders_icon.png]] 
The Calendar Reminders plugin creates reminders for Moodle calendar events and sends them automatically to relevant users in a timely manner via Moodle messaging interface. This is a local plugin controlled by the site administrator.

==Features==
* Reminders can have customised delivery times/methods according to event types.
* Users can control how they receive calendar reminders in their messaging preferences.
* Reminders are automatically sent (as long as the system [[Cron]] process is set up).

==Installation==
# Fetch the plug-in from following location.
#* Go to [http://moodle.org/plugins/view.php?plugin=local_reminders Reminders] and download the latest version from the repository.
# Go to the 'local' directory inside Moodle root directory.
# Extract the downloaded zip file inside to this folder. After it is extracted, there should be a "reminders" folder in the local folder with a structure as shown in the [[:dev:Email_reminders_for_calendar_events|project developer documentation]].
# Log into the Moodle site as the admin user. Usually the new plugin will be identified and notified you when logged-in. If not, go to Settings > Site administration > Notifications to detect and automatically install the local plug-in.
# Now you can change the plug-in specific settings via Settings > Site Administration > Plugins > Local plugins > Reminders.

== Screenshots ==
=== Sample e-mail reminder ===
[[File:sample_reminder_msg.png]]

=== Administrator settings page ===
[[File:admin_settings.jpg]]

==Tips and tricks==
* If you want to change the cron frequency of reminders plugin, open version.php file in the reminders directory and change the value corresponding to $plugin->cron. That value must be in seconds and it is the interval between two cron cycles.

== Acknowledgements ==
* Mentors: [http://moodle.org/user/view.php?id=381842&course=5 Michael de Raadt] and [http://moodle.org/user/view.php?id=955449&course=5 Rossiani Wijaya]
* Special thanks goes to [http://moodle.org/user/profile.php?id=1297063 Luiggi Sansonetti] who translated the plugin into French language.

== Bugs and Improvements ==
* Please report bugs and improvements on the Tracker using the [http://tracker.moodle.org/browse/CONTRIB/component/12134 Local: Calendar Reminders] component.

== See also ==
* Download location from plugin repository, [http://moodle.org/plugins/view.php?plugin=local_reminders Local Reminders]
* [http://tracker.moodle.org/browse/CONTRIB-3647 CONTRIB-3647] Automating Email reminders for calendar events project in Tracker.
* Plugin development [https://github.com/isuru89/moodle-reminders-for-calendar-events Repository]
* Forum post [http://moodle.org/mod/forum/discuss.php?d=201744 Local Plugin - Email Reminders for Calendar Events]
* RSS Feed from Personal Blog, [http://uisurumadushanka89.blogspot.com/feeds/posts/default/-/gsoc RSS Feed].

Progress Bar block

2012-07-25T05:29:33Z

Deraadt: /* Features */

[[Blocks|Back to Blocks page]]

== Features ==

[[Image:ProgressBar.gif|right|A progress bar for a student]]
* The Progress Bar is a time-management tool for students.
* It visually shows what activities/resources a student is supposed to interact with in a course.
* It is colour coded so students can quickly see what they have and have not completed/viewed.
* The teacher selects which pre-existing activities/resources are to be included in the Progress Bar and when they should be completed/viewed.

See a [http://youtu.be/d43KVlMBmLA video demo].

== Links ==

* [http://moodle.org/plugins/view.php?plugin=block_progress Block code in Plugins repository]
* [http://tracker.moodle.org/browse/CONTRIB/component/10489 Bug Tracker Page] (Please report bugs here)
* [http://cvs.moodle.org/contrib/plugins/blocks/progress/ CVS Repository]

== Installing ==

The Progress Bar block is added like other blocks ([[Installing_contributed_modules_or_plugins|How to install a block]]).

Once the progress bar is installed, you can use it in a course as follows.
# Turn editing on
# Create your activities/resources as normal
# Add the Progress Bar block to your page ([[Blocks|How to add a block]])
# Move your Progress Bar block into a prominent position, eg. top-left (click and drag the block title)
# Click the Configuration icon on the block below the title
# Give your Progress Bar block a title (default is "Progress Bar")
# Set the activities/resources you want shown in the block to "Yes"
# Set the date and time when the activity/resource is expected to be completed/viewed by (some activities have deadlines set, if so, that deadline can be used or another can be set in the Progress Bar block configuration)
# Save changes

Hidden items will not appear in the Progress Bar until they are unhidden. This is useful for a scheduled release of activities.

== Acknowledgements ==

* Thanks to:
** Toshimi Hatanaka for contributing a Japanese translation
** Yvonne Schneider and Joachim Vogelgesang for contributing a German translation
** Maria João Spilker for contributing a Portuguese-Brazilian translation
** Pieter Wolters for contributing a Dutch translation
** Fernando Sánchez for contributing a Spanish translation
** Fabien Sartoretti for contributing a French translation
** Adam Levy for contributing queries and strings for Hot Potatoes support

[[Category:Contributed code]]

Simple Clock block

2012-07-24T04:39:05Z

Deraadt: Adding acknowledgement and shifting links to end

[[Blocks|Back to Blocks page]]

== Features ==

[[Image:SimpleClockBlockDefault.png|right|alt=Simple clock block showing site theme icon and user pic]]

* Maintains time difference between page loads
* Shows site icon and user image as clock icons

== Installing ==

The Simple Clock block is installed like other blocks ([[Installing_contributed_modules_or_plugins|How to install a block]]).

== Configuration ==

It is possible to achieve the following configurations.

* Show server clock, user clock or both
* Show day names
* Show seconds
* Hide header/title
* Hide clock icons
* Change block title

[[Image:SimpleClockBlockServerOnly.png|alt=Simple clock block shown with server only]]
[[Image:SimpleClockBlockUserOnly.png|alt=Simple clock block shown with user only]]
[[Image:SimpleClockBlockDays.png|alt=Simple clock with days shown]]
[[Image:SimpleClockBlockSeconds.png|alt=Simple clock with seconds shown]]
[[Image:SimpleClockBlockNoHeader.png‎|alt=Simple clock with no header]]
[[Image:SimpleClockBlockNoIcons.png|alt=Simple clock with no icons]]

For configuration instructions see [[blocks/simple_clock]]

== Acknowledgements ==

* Luiggi Sansonetti for a French translation

== See also ==

* [http://moodle.org/plugins/view.php?plugin=block_simple_clock Moodle Plugins repository entry]
* [http://tracker.moodle.org/browse/CONTRIB/component/10620 Bug Tracker Page for Simple Clock] (Please report bugs here)
* [https://github.com/deraadt/moodle-block_simple_clock.git Git repository for Simple Clock]

[[Category:Contributed code]]

Administration FAQ

2012-06-14T04:52:20Z

Deraadt: Adding CLI method of password change

{{Installing Moodle}}==Changing text in Moodle==

The language editing interface in ''Administration > Language> [[Language_customization|Language customisation]]'' enables you to easily change any word or phrase used on the site. You may need to search through several files to find the word or phrase you are looking for. The file moodle.php contains all common site-wide phrases and the admin.php contains many admin phrases.

== How do the limits on uploaded files work? ==

See [[File upload size]] for more information.

File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.

1. Not very likely these days (i.e. check if the other settings don't work), there is a setting in Apache 2 which you may need to change. You can change the limit by adding or editing a line in Apache's ''/usr/local/apache2/conf/httpd.conf'' with the upload size in bytes (check your operating system's documentation for the correct location - e.g. under /etc/apache2 is a common alternative):

LimitRequestBody 10485760

2. PHP also has limits. If you have access to it they are set in your site-wide '''php.ini''' file. On shared hosting you may be able to set these in a ''.htaccess'' file or a ''php.ini''. You are recommended to check with your hosting company how this works on their systems.

In a php.ini file the lines will look something like:
<pre>
upload_max_filesize 64M
post_max_size 64M
</pre>

...in .htaccess the entries will look like this:
<code>
php_value upload_max_filesize 64M
php_value post_max_size 64M
</code>

An .htaccess file usually can be placed in the root of your Moodle install and will affect the whole Moodle. A (non site-wide) php.ini file may need to be copied into all the directories it needs to affect. The following are a good start:
* public_html
* moodle/admin
* moodle/course
* moodle/files
* moodle/repository
* root of your moodledata directory

Please note that a server re-start may be required for the above changes to take effect.

3. Moodle has a site-wide limit called maxbytes that may be set in Settings > Site Administration > Security > Site Policies > Maximum uploaded file size.

To find out the server limit setting in php.ini (without server access, just using the Moodle administration interface), check out ''Site Administration block > Server > PHP info'' (Tip: search for filesize)

4. A limit may be set by teachers in the [[course/edit|Course settings]].

5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.

'''See also'''

* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=97907 Instructions to increase maximum allowed size on hosted servers] forum discussion
* [[File_upload_size|File Upload Size]] page
* Instructions below on How to change the maximum execution time

== How to change upload file size on a Windows localhost==
In a localhost (using a [[Complete install packages for Windows]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M.

Here is an example of how to change the upload file size to 100M.
*Find ..'''/php/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad.
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code>
*Change that line to
upload_max_filesize = 100M
*In the same way, find <code>post_max_size = 16M</code>
*Change that line to
post_max_size = 100M
*Save the file.

After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.

'''See also'''

* Instructions below on How to change the maximum execution time

== How to change the maximum execution time ==

A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:

max_execution_time = 600

If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:

php_value max_execution_time 600

Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.

== I have forgotten the admin password ==
First, try using the button "Send my details via email".

It is possible to reset the admin user's password using [[Administration_via_command_line#Reset_user_password|command line tools]] provided with Moodle.

Failing that, if you can access the database using an administration tool, you can modify a password there. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (the encrypted version of "guest") into the admin password field, login using it, then change the password.

Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].

== My log table has disappeared - No logs found! ==
The most likely cause is that the mdl_log table has become corrupted. See the [[How to check your database for corruption]].

==My style sheet changes aren't showing up==

Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.
Also, in ''Settings>Site Administration>Appearance>Themes>Theme selector'', click "clear theme caches".

== Site-wide scales ==
*To add a site-wide scale, available in all courses, go to ''Settings>Site administration>Grades>Scales'' and click the button "Add a new scale".
*As an administrator you also have the right to add site-wide scales within a course by going to ''Settings>Course administration>Grades>Scales''. (A regular teacher cannot do this.)

==Why do I see <nowiki>[[missing strings]]</nowiki>?==

Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).

Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.

==How do I find the version of Moodle currently installed?==
See the [[Moodle version]] information.

==How do I repair a corrupted Moodle database?==

Typically, you might see an error message like './moodle/mdl_quiz_grades' is marked as crashed and should be repaired. See [[How to check your database for corruption]] for the solution.

==My site is stuck in maintenance mode==

Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:

* Check that the web server user has write permissions to the moodledata folder.
* Manually delete the maintenance.html file.

==Incomplete page displayed when I click "Turn Editing On"==
When you see an incomplete page, it is normally a sign that an error occurred. To find out more, turn on [[Debugging]], and you should see an error message which may help you to diagnose the problem.

This is usually as a result of an incompatible contributed module or block that you have installed. Follow these steps:
#Follow the module removal instructions in [[Installing contributed modules or plugins]].
#Re-visit your course page and try clicking on the "Turn Editing On" button again.

If you find an incompatible module or block, please report the problem to the person named as the maintainer in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins database].

=="a required parameter (id) was missing" when uploading a file==

This message sometimes is generated when attempting to upload a file larger than the upload limit.

==How can I change the URL of the moodle service==

You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:
$CFG->wwwroot = 'http://mydomain/testmoodle';

Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.

'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]

==Why is the Moodle Registration button still displayed after I register my site?==
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.

If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:

* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):
mysql> USE moodle;
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());

* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:
$CFG->registered = '9999999999';
:Note that this line in your config.php will stop the reminders about re-registering.

For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.

For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]

==How do I enable/disable debugging?==
See [[Debugging]]. If you are getting a blank or partially complete page, it is probably a sign that an error is occurring. Turning on debugging will let you see what the error message is, which may help you diagnose the problem.

==I cannot login to the Moodle CVS servers==

When attempting to login to the Moodle CVS servers, you may receive a "login aborted" error as shown below (this example shows the eu cvs server, with the command in bold):

C:\gnuwin32>'''cvs -d:pserver:anonymous@eu.cvs.moodle.org:/cvsroot/moodle login'''
Logging in to :pserver:anonymous@eu.cvs.moodle.org:2401/cvsroot/moodle
CVS password: <- (blank password entered)
cvs [login aborted]: connect to uk.cvs.moodle.org(212.219.207.198):2401 failed:
Connection refused
C:\gnuwin32>

To fix this problem, check that you have entered the CVS command correctly and that port 2401 is open on your firewall.

==Why is a page blank, or half missing?==

A blank page, or a page that seems to have half missing, is normally a sign that an error occurred. If (as is recommended on production systems) you have display of error messages turned off, it can be very hard to understand what is going on.

The solution is to [[Debugging|turn on the debugging options]] temporarily. Then, when you go back to the problem page, you should see the error message. Once you had finished solving the problem, remember to turn debugging off again.

==How can I fix just one bug, without upgrading my whole site?==

Suppose:
* You are experiencing a particular bug.
* You have searched in the [http://tracker.moodle.org/ tracker], and found that your problem is MDL-abc, and that it has been fixed in the latest version.
* For some reason, you cannot upgrade your whole site, even though the latest version probably has security fixes.

Then, how can you get the fix for just this one bug, without upgrading your whole site? Well, if you are prepared to manually patch the code, you can probably get this information from the tracker. Please see [[How to fix just one bug without upgrading|this guide]].

==How can I change centre of the Front Page from course categories to something else?==

Go to Front Page > Settings and change "Front page" to None all down. Change "Front page items when logged in" to None all down. Ensure that "Include a topic section" is checked. Save changes and return to the front page. Turn editing on, obviously, and you should now see the "Add a resource" and "Add an activity" drop down combo-boxes. Select "Add a resource" and select "Insert a label". You can then edit the label in any way you want to in the WYSYWYG editor.

==How can I change the initial login screen?==

Edit one of the language files. ''Settings > Site administration > Language> Language customisation'', look in the moodle.php file. Look for ''loginusing'' or ''loginsteps'' or ''loginstepsnone'' string variables.

==How can I change the initial login screen help?==

To change or add a help message for the login go to ''Settings > Site administration > Plugins > Authentication > Manage authentication.'' Type your help message in there in the'' Instructions'' text box.

==Users can not login, they need cookies and debug mentions config.php==
Your site's [[Configuration file|config.php file]] probably has extra lines. There should be '''no spaces or lines after the final ?>'''.

:Hint: Sometimes blank lines are hard to see. Make sure they are not there.

==After using the 'Login as' function, why am I logged out of Moodle?==

After using the 'Login as' function, for security reasons you are automatically logged out of Moodle when you return to your normal role. If you login again you will be redirected to the page that you were on previously.

==See also==

* [[Errors FAQ]]
* [[Installation FAQ]]
* [[Administration hacks]]
* [[Beginning_Moodle_2.0_Administration|Beginning Moodle 2.0 Administration FAQ]]

[[Category:FAQ]]

[[es:FAQ Administración]]
[[fr:FAQ d'administration]]
[[de:Administration FAQ]]

External database enrolment

2012-05-10T07:54:31Z

Deraadt: Clarifying field information

{{Enrolment}}
Location: External database edit settings link in ''Settings > Site administration > Plugins > Enrolments > Manage enrol plugins''

You may use a external database (of nearly any kind) to control your enrolments. It is assumed your external database contains a field containing a course ID, a field containing a user ID, and optionally a field containing a role. These are compared against fields that you choose in the local course, user tables, and role tables.

The following are the supported data sources, but note that you will need to have to compiled PHP with the appropriate options or through [[ODBC]].

*access
*ado
*mssql
*borland_ibase
*csv
*db2
*fbsql
*firebird
*ibase
*informix72
*informix
*mysql
*mysqlt
*oci805
*oci8
*oci8po
*odbc
*odbc_mssql
*odbc_oracle
*oracle
*postgres64
*postgres7
*postgres
*proxy
*sqlanywhere
*sybase
*vfp

== Enrolment & Unenrolment ==

External database enrolment happens at the moment when a user logs into Moodle. The plugin will attempt to automatically enrol the student in all their courses according to the data in the external database and, optionally, create empty courses where they do not already exist. To check if it is working, you can log in as a student and then check that their list of courses is as you would expect.

The process also unenrols users from courses if they are no longer in the database. User records are marked according to their original enrolment method. Therefore the external database plugin can only unenrol users who were enroled by the plugin in the first place.

== Hidden Courses ==

Courses that are set to "Course is not available to students" can be ignored for enrolment purposes by setting the "enrol_db_ignorehiddencourse" to '''yes'''.

== Enrolment & Roles ==

The "enrol_db_defaultcourseroleid" setting in the plugin settings page specifies the role that the user will take when they are added to the course. The default setting will set them to the course default setting (initially "student"). However, you can specify a field in the external table (specified in the "enrol_db_remoterolefield" setting) that contains the short name for the user's role. This could, for example, be used to enrol both students and teachers into courses using a suitably configured database.

== Creating Courses ==

Optionally courses that do not exist in the Moodle site can be created. Switch the "enrol_db_autocreate" option to "yes" in the plugin settings. You can additionally specify the Category into which the new course will be placed and may also specify a "template" course from which the new course will be copied.

== Synchronization Script ==

A script is provided that can synchronize all your user enrollments at once - both adding and removing user enrolments (and creating courses if specified). The script is called enrol_database_sync.php and is found in the enrol/database folder.

This script is meant to be called from a system cronjob to sync moodle enrolments with enrolments in the external database. You need to make sure all the users present in the external enrolments are already created in moodle. If you are using external authentication plugins (db, ldap, etc.) you can use the scripts provided by those plugins to synchronize your users before running this script.

Example cron entry for Moodle 2.0
# 5 minutes past 4am
5 4 * * * /usr/bin/php -c /path/to/php.ini /path/to/moodle/enrol/database/cli/sync.php

Notes:
* If you have a large number of enrolments, you may want to raise the memory limits by passing -d memory_limit=256M
* For debugging & better logging, you are encouraged to use in the command line: -d log_errors=1 -d error_reporting=E_ALL -d display_errors=0 -d html_errors=0
* This only works for users that already exist in your Moodle site (see comment above)

== Setting up enrolment sync (How to) ==

You will need to perform (as a minimum) the following steps to enable external database enrolment - only a single table is required in the database which contains a record for every user/course combination. If the table is large it is a good idea to make sure appropriate indexes have been created:

* Use an existing database or create a new one. Use an existing table or create a new one with the following minimum fields.
*# A unique course identifier to match one of the following fields.
*#* the "idnumber" field in Moodle's course table (varchar 100), which is manually specified as the "Course ID number" when editing a course's settings
*#* the "shortname" field in Moodle's course table (varchar 255), which is manually specified as the "Course short name" when editing a course's settings
*#* the "id" field in Moodle's course table (int 10), which is based on course creation order
*# A unique user identifier to match one of the following fields.
*#* the "idnumber" field in Moodle's user table (varchar 255), which is manually specified as the "ID number" when editing a user's profile
*#* the "username" field in Moodle's user table (varchar 100), which is manually specified as the "Username" when editing a user's profile
*#* the "email" field in Moodle's user table (varchar 100), which is manually specified as the "Email address" when editing a user's profile
*#* the "id" field in Moodle's user table (int 10), which is based on user creation order
*# (optional) A unique role identifier to match one of the following fields.
*#* the "shortnname" field in Moodle's role table (varchar 100), for example editingteacher, coursecreator, student, ...
*#* the "name" field in Moodle's role table (varchar 255), for example Teacher, Course creator, Student, ...
*#* the "id" field in Moodle's role table (int 10), which is based on initial installation and new role creation order
* Populate the database table. Each user/course combination to have a record in the table.
* In Moodle, go to Site administration => Plugins => Enrolments => Manage enrol plugins, find External Database in the list, enable it (click the closed-eye icon) and click Settings.
* In the top panel, select the database type (make sure you have the necessary configuration in PHP for that type) and then supply the information to connect to the database.
* The middle panel creates the mapping between Moodle and the external database. The first three settings are for the local (Moodle) field names and the last three for the remote (external database) settings. They are in the same order.
** enrol_localcoursefield / enrol_remotecoursefield - in Moodle the name of the field in the course settings the uniquely identifies the course (e.g., idnumber). In the external database the name of the matching field.
** enrol_localuserfield / enrol_remoteuserfield - in Moodle the name of the field in the user profile that uniquely identified the user (e.g., idnumber). In the external database the name of the matching field.
** enrol_db_localrolefield / enrol_db_remoterolefield - (optional) in Moodle the name of the field in the role edit page the uniquely identifies the role (e.g., shortname). In the external database the name of the matching field.
* The Roles panel specifies the role that the user will get in the course if their role is not specified in the external database.
* The final panel enables auto creation of courses.
* Save changes, and then tick the box to enable external database enrolment.

== Database enrolment does not appear in the course enrolment drop down menu. Why? ==

The course enrolment drop down menu only lists [[Enrolment_plugins#Interactive_enrolment|'''interactive''' enrolment plugins]]. External database enrolment is not such a plugin, so it doesn't appear in the list. Similarly, the "Course Enrollable" setting (in the Course Settings) page also only applies to interactive enrolment plugins and has no effect on external database enrollment.

As of this writing, the only interactive enrolment plugins are ''manual'' (also know as ''internal''), ''paypal'' and ''authorize.net''.

== Field Mapping Example: ==
Choose your fields from the Moodle database:

*enrol_localcoursefield: A course identifier from mdl_course, e.g. "idnumber"
*enrol_localuserfield: A user identifier from mdl_user, e.g. "idnumber"
*enrol_localrolefield: (optional) A role identifier from mdl_role, e.g. "shortname"

Create a view in your external database which matches the chosen field values from Moodle:

*enrol_remotecoursefield: A matching course identifier from your external database table, e.g. "course_number"
*enrol_remoteuserfield: A matching user identifier from your external database table, e.g. "userid"
*enrol_remoterolefield: (optional) A matching role identifier from your external database table, e.g. "role_name"

== Potential Gotchas ==

* It almost goes without saying that the integrity of the external database is important. If data is missing from the database then there is a potential for users being unenrolled from some or all of their courses. The unenrollment process will remove them from any group assignments and also poll each module type to give the module the option of removing that user's data if appropriate (for example, however, forum posts are never deleted). It is therefore prudent that you take the utmost care to ensure that the data in the external bass is correct at all times.
* '''Minor Security Issue''' Consider that if the ID field you use to identify your students is editable by the students (in their profile), then there is a potential for them changing this to the id of another valid student and gaining access to resources that they should not. However, they will still appear as themselves, they cannot impersonate the other user or otherwise gain access to their resources.

==Errors and Diagnostics==

The plugin produces a number of diagnostic messages and/or errors which are recorded to the PHP error log (as defined in the php.ini file). In addition messages about courses that are in the database for the user but that do not exist in the Moodle site will only be produced if debugging is set to ALL or DEVELOPER.

==See also==
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=49475 MySQL enrolment plugin doesn't seem to work] forum discussion
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=74133 Someone explain external database enrolment, please??] forum discussion
*Example Setup [https://docs.moodle.org/en/Talk:External_database_enrolment#Example_External_Enrollment] Example Database Enrollment Setup

[[es:Matriculación Base de Datos Externa]]
[[fr:Base de données externe]]
[[de:Einschreibung über externe Datenbank]]
[[ja:外部データベース登録]]

Internet Information Services

2012-05-09T04:19:48Z

Deraadt: Adding capture of settings

{{Installing Moodle}}[[Internet Information Services]] ('''IIS''') is the web server software bundled with Windows Server, as well as certain client versions of Windows.

==PHP installation==

It is strongly recommended to use only the official Microsoft PHP installer from http://php.iis.net/, it automatically installs all necessary components and facilitates easy configuration with PHP manager. Manual installation attempts often fail or may not allow Moodle to function properly.

==Configuration==

Unfortunately IIS does not natively support unicode characters in so called ''slashargument URL'' which are used in Moodle for file serving. Moodle requires manual configuration of rewrite rules, the PHP installation via ''Microsoft Web Platform Installer'' installs necessary ''URL Rewrite 2.0'' module.

[[File:Rewrite_rule_-_Internet_Information_Services_(IIS)_Manager.png|thumb]]

Add following rewrite rule to enable support for unicode file names in Moodle:

* Matches the Pattern - Regular Expressions - <code>^([^\?]+?\.php)(\/.+)$</code>
* Action - Rewrite - <code>{R:1}\?file={R:2}</code> - Append query string

==Directory permissions==

The default IIS account is ''IIS_IUSRS'', make sure it has appropriate access right to Moodle dirroot (read only) and dataroot (read/write) directories.

==Debugging problems==

By default IIS contains custom error pages that intentionally hide error details on production sites. When diagnosing problems you may want to disable temporarily the IIS Error Pages.

== See also ==

* [http://www.iis.net The Official Microsoft IIS Site]
* [http://en.wikipedia.org/wiki/Internet_Information_Services Wikipedia article on IIS]
* [http://php.iis.net/ PHP installer for IIS]

[[ja:IIS]]

Plik:Rewrite rule - Internet Information Services (IIS) Manager.png

2012-05-09T04:16:45Z

Deraadt:

Theme settings

2012-04-26T05:28:51Z

Deraadt: /* Allow theme changes in the URL */

{{Themes}}
== Theme settings ==
An administrator can change theme settings in ''Settings > Site administration > Appearance > Themes > Theme settings''.

[[File:Themesettings.png]]

===Theme list===
This lists the themes available for course and user themes. Leave this blank to allow any valid theme to be used. If you want to shorten the theme menu, you may specify a comma-separated list of names, though don't use spaces (e.g. standard,orangewhite).

You can preview the available themes in ''Settings > Site Administration > Appearance > Themes > Themes selector.''

===Theme designer mode===
Turn this on if you are designing and testing themes as it will stop the themes being cached and enable you to see theme changes quickly. (You can also do this with the Clear theme cache button on the theme selector page.)

===Allow user themes===
If the option ''allowuserthemes'' is enabled, each user may select their preferred theme on the edit profile page. All Moodle pages will be displayed in the user's theme, apart from courses where a course theme has been set.

===Allow course themes===
If you enable this, then teachers will be able to set their own course themes. Course themes override all other theme choices (site, user, or session themes).

*If the option ''allowcoursethemes'' is enabled, each editing teacher may select their course theme via the Force theme option on the [[course/edit|Course settings]] page. The course will always be displayed in the theme specified in the course setting, with user and the site themes being overwritten.

===Allow category themes===
When enabled, themes can be set at the category level. This will affect all child categories and courses unless they have specifically set their own theme. WARNING: Enabling category themes may affect performance.

===Allow theme changes in the URL===
*If this is checked then the theme may be changed by adding <code>?theme=theme_name</code> (or <code>&theme=theme_name</code> if there are other URL parameters) to the URL in the browser. Theme names should be in lower case with spaces replaced by underscores, for example the theme "Formal white" should be entered as <code>?theme=formal_white</code>

===Allow users to hide blocks===
Allows users to display and hide blocks

===Allow blocks to use the docks===
*If the theme allows it, then checking this will allow the user to move blocks to the side dock.

===Custom menu items===
The custommenuitems setting allows you to create a drop down menu that can be displayed by themes that support it. Currently all themes that are provided with Moodle 2.0 support this custom menu.

You are able to create the custom menu by entering custom menu items one per line into the setting. Each item is preceded by a number of hyphens (-), the number of hyphens determines the depth of the item. So items that are '''NOT''' preceded by a hyphen appear on the top level of the menu (always visible), items with a single hyphen appear on a drop down menu below the previous top level item, and items with two hyphens appear on a drop down menu below the previous first level item and so on.

The content of each item is constructed of up to three bits, each separated by a '''|''' (Shift + \) character. The bits are '''label''' | '''url''' | '''tooltip'''.
; label : This is the text that will be shown within the menu item. You must specify a label for every item on the menu.
; url : This is the URL that the user will be taken to it they click the menu item. This is optional, if not provided then the item will not link anywhere.
; tooltip : If you provide a URL you can also choose to provide a tooltip for the link that is created with the URL. This is optional and if not set the label is used as the tooltip for the menu item.

The following is an example of how you would create a custom menu:

<pre>
Moodle community|http://moodle.org
-Moodle free support|http://moodle.org/support
-Moodle development|http://moodle.org/development
--Moodle Tracker|http://tracker.moodle.org
--Moodle Docs|https://docs.moodle.org
-Moodle News|http://moodle.org/news
Moodle company
-Moodle commercial hosting|http://moodle.com/hosting
-Moodle commercial support|http://moodle.com/support
</pre>

Note: The custom menu does not escape characters within the label, if you want to use a special HTML character such as an ampersand you must escape it yourself within the label. e.g. use & instead of &.

For more information on this setting please see the ''Using Moodle'' forum discussion [http://moodle.org/mod/forum/discuss.php?d=149803 Moodle 2.0: Custom menu in core]

==== Multilanguage support ====

You can add a language code (or a comma separated list of codes) as the 4th item of the line. The line will be then printed if and only if the user has currently selected the listed language. For example:

<pre><nowiki>
English only|http://moodle.com|English only item|en
German only|http://moodle.de|Deutsch|de,de_du,de_kids
</nowiki></pre>

===Enable device detection===
Will detect mobile and tablets that identify themselves via the web browser at the time of login to Moodle. These work with the theme selector. When the theme selector has identified a default, mobile and tablet themes, this feature will use that theme.

===Device detection regular expressions===
This will allow you to customize the theme selector options. For example, you can add a custom theme for IE6 and another for Windows CE by entering the identifying expressions the browser sends and the "Return value" you want to display as the theme selectors "Device type".

==Special themes==

=== Session themes ===
Moodle offers an additional way to set a theme - the '''session theme'''. This is set with the URL and lasts until you log out. When you next login, the site/course/user themes are active again. This option is great for theme testing and works perfectly when you want to enable different themes for different situations.

For example you can offer a special link for PDA users and integrate the session theme ''orangewhitepda'' in that link. Nobody needs to change any settings, you just click on that link. The session theme is called by the URL parameter <code>&theme=orangewhitepda</code>. The whole URL without the session theme could look like <code><nowiki>http://mymoodlesite.org/course/view.php?id=18</nowiki></code> and with the parameter for the PDA theme like <code><nowiki>"http://mymoodlesite.org/course/view.php?id=18&theme=orangewhitepda"</nowiki></code>.

In a standard Moodle installation, session themes are not active. To activate them the administrator must add the parameter <code>$CFG->allowthemechangeonurl = true;</code> to the Moodle ''config.php'' file in the Moodle base directory.

=== Page theme ===
A page theme is for special page-only themes set by code.

== Theme hierarchy ==
Here is the usual order that themes are considered by the Moodle interface.

{| style="border:1px dashed #ddd"
|- style="vertical-align:top;text-align:left"
!Theme type
! style="background:#eee"|Overwrites
!Display
! style="background:#eee"|Setting type
|- style="vertical-align:top"
|Site
|style="background:#eee"| -
|all pages*
|style="background:#eee"|saved in theme profile
|- style="vertical-align:top"
|User
|style="background:#eee"|Site theme
|all pages*
|style="background:#eee"|saved in user profile
|- style="vertical-align:top"
|Course
|style="background:#eee"|Site, user and session themes
|one course
|style="background:#eee"|saved in course profile
|- style="vertical-align:top"
|Session
|style="background:#eee"|Site and user themes
|all pages*
|style="background:#eee"|temporary until logout
|}
(* except courses with the course theme set)

=== Change default hierarchy===
The priority of themes can be set via the /moodle/config.php file. The order defines which theme wins when there are several set at different levels. You can set a variable called $CFG->themeorder (see config-dist.php for more details). By default it is set to:

<code><nowiki>$CFG->themeorder = array('page', 'course', 'category', 'session', 'user', 'site');</nowiki></code>

==Particular theme settings==

Logo, tagline, link colour, column width, custom CSS and other settings for a particular theme may be set by an administrator in ''Settings > Site administration > Appearance > Themes > Theme name''.

==See also==

*[http://www.youtube.com/watch?v=mCVsJ3Wsoj8 Video demonstrating how to set a category theme in Moodle 1.9]

[[es:Configuración de temas]]
[[fr:Configuration des thèmes]]
[[ja:テーマ設定]]
[[de:Design-Einstellungen]]

Theme settings

2012-04-26T05:28:09Z

Deraadt: Adding information about theme URLs

{{Themes}}
== Theme settings ==
An administrator can change theme settings in ''Settings > Site administration > Appearance > Themes > Theme settings''.

[[File:Themesettings.png]]

===Theme list===
This lists the themes available for course and user themes. Leave this blank to allow any valid theme to be used. If you want to shorten the theme menu, you may specify a comma-separated list of names, though don't use spaces (e.g. standard,orangewhite).

You can preview the available themes in ''Settings > Site Administration > Appearance > Themes > Themes selector.''

===Theme designer mode===
Turn this on if you are designing and testing themes as it will stop the themes being cached and enable you to see theme changes quickly. (You can also do this with the Clear theme cache button on the theme selector page.)

===Allow user themes===
If the option ''allowuserthemes'' is enabled, each user may select their preferred theme on the edit profile page. All Moodle pages will be displayed in the user's theme, apart from courses where a course theme has been set.

===Allow course themes===
If you enable this, then teachers will be able to set their own course themes. Course themes override all other theme choices (site, user, or session themes).

*If the option ''allowcoursethemes'' is enabled, each editing teacher may select their course theme via the Force theme option on the [[course/edit|Course settings]] page. The course will always be displayed in the theme specified in the course setting, with user and the site themes being overwritten.

===Allow category themes===
When enabled, themes can be set at the category level. This will affect all child categories and courses unless they have specifically set their own theme. WARNING: Enabling category themes may affect performance.

===Allow theme changes in the URL===
*If this is checked then the theme may be changed by adding <code>?theme={theme_name}</code> (or <code>&theme=theme_name</code> if there are other URL parameters) to the URL in the browser. Theme names should be in lower case with spaces replaced by underscores, for example the theme "Formal white" should be entered as <code>?theme=formal_white</code>

===Allow users to hide blocks===
Allows users to display and hide blocks

===Allow blocks to use the docks===
*If the theme allows it, then checking this will allow the user to move blocks to the side dock.

===Custom menu items===
The custommenuitems setting allows you to create a drop down menu that can be displayed by themes that support it. Currently all themes that are provided with Moodle 2.0 support this custom menu.

You are able to create the custom menu by entering custom menu items one per line into the setting. Each item is preceded by a number of hyphens (-), the number of hyphens determines the depth of the item. So items that are '''NOT''' preceded by a hyphen appear on the top level of the menu (always visible), items with a single hyphen appear on a drop down menu below the previous top level item, and items with two hyphens appear on a drop down menu below the previous first level item and so on.

The content of each item is constructed of up to three bits, each separated by a '''|''' (Shift + \) character. The bits are '''label''' | '''url''' | '''tooltip'''.
; label : This is the text that will be shown within the menu item. You must specify a label for every item on the menu.
; url : This is the URL that the user will be taken to it they click the menu item. This is optional, if not provided then the item will not link anywhere.
; tooltip : If you provide a URL you can also choose to provide a tooltip for the link that is created with the URL. This is optional and if not set the label is used as the tooltip for the menu item.

The following is an example of how you would create a custom menu:

<pre>
Moodle community|http://moodle.org
-Moodle free support|http://moodle.org/support
-Moodle development|http://moodle.org/development
--Moodle Tracker|http://tracker.moodle.org
--Moodle Docs|https://docs.moodle.org
-Moodle News|http://moodle.org/news
Moodle company
-Moodle commercial hosting|http://moodle.com/hosting
-Moodle commercial support|http://moodle.com/support
</pre>

Note: The custom menu does not escape characters within the label, if you want to use a special HTML character such as an ampersand you must escape it yourself within the label. e.g. use & instead of &.

For more information on this setting please see the ''Using Moodle'' forum discussion [http://moodle.org/mod/forum/discuss.php?d=149803 Moodle 2.0: Custom menu in core]

==== Multilanguage support ====

You can add a language code (or a comma separated list of codes) as the 4th item of the line. The line will be then printed if and only if the user has currently selected the listed language. For example:

<pre><nowiki>
English only|http://moodle.com|English only item|en
German only|http://moodle.de|Deutsch|de,de_du,de_kids
</nowiki></pre>

===Enable device detection===
Will detect mobile and tablets that identify themselves via the web browser at the time of login to Moodle. These work with the theme selector. When the theme selector has identified a default, mobile and tablet themes, this feature will use that theme.

===Device detection regular expressions===
This will allow you to customize the theme selector options. For example, you can add a custom theme for IE6 and another for Windows CE by entering the identifying expressions the browser sends and the "Return value" you want to display as the theme selectors "Device type".

==Special themes==

=== Session themes ===
Moodle offers an additional way to set a theme - the '''session theme'''. This is set with the URL and lasts until you log out. When you next login, the site/course/user themes are active again. This option is great for theme testing and works perfectly when you want to enable different themes for different situations.

For example you can offer a special link for PDA users and integrate the session theme ''orangewhitepda'' in that link. Nobody needs to change any settings, you just click on that link. The session theme is called by the URL parameter <code>&theme=orangewhitepda</code>. The whole URL without the session theme could look like <code><nowiki>http://mymoodlesite.org/course/view.php?id=18</nowiki></code> and with the parameter for the PDA theme like <code><nowiki>"http://mymoodlesite.org/course/view.php?id=18&theme=orangewhitepda"</nowiki></code>.

In a standard Moodle installation, session themes are not active. To activate them the administrator must add the parameter <code>$CFG->allowthemechangeonurl = true;</code> to the Moodle ''config.php'' file in the Moodle base directory.

=== Page theme ===
A page theme is for special page-only themes set by code.

== Theme hierarchy ==
Here is the usual order that themes are considered by the Moodle interface.

{| style="border:1px dashed #ddd"
|- style="vertical-align:top;text-align:left"
!Theme type
! style="background:#eee"|Overwrites
!Display
! style="background:#eee"|Setting type
|- style="vertical-align:top"
|Site
|style="background:#eee"| -
|all pages*
|style="background:#eee"|saved in theme profile
|- style="vertical-align:top"
|User
|style="background:#eee"|Site theme
|all pages*
|style="background:#eee"|saved in user profile
|- style="vertical-align:top"
|Course
|style="background:#eee"|Site, user and session themes
|one course
|style="background:#eee"|saved in course profile
|- style="vertical-align:top"
|Session
|style="background:#eee"|Site and user themes
|all pages*
|style="background:#eee"|temporary until logout
|}
(* except courses with the course theme set)

=== Change default hierarchy===
The priority of themes can be set via the /moodle/config.php file. The order defines which theme wins when there are several set at different levels. You can set a variable called $CFG->themeorder (see config-dist.php for more details). By default it is set to:

<code><nowiki>$CFG->themeorder = array('page', 'course', 'category', 'session', 'user', 'site');</nowiki></code>

==Particular theme settings==

Logo, tagline, link colour, column width, custom CSS and other settings for a particular theme may be set by an administrator in ''Settings > Site administration > Appearance > Themes > Theme name''.

==See also==

*[http://www.youtube.com/watch?v=mCVsJ3Wsoj8 Video demonstrating how to set a category theme in Moodle 1.9]

[[es:Configuración de temas]]
[[fr:Configuration des thèmes]]
[[ja:テーマ設定]]
[[de:Design-Einstellungen]]

Installing Oracle for PHP

2012-04-12T03:23:03Z

Deraadt: Shifting PHP instructions to earlier section

* http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html
* http://moodle.org/mod/forum/discuss.php?d=65488#p308002 (with attached html document)
* http://es.php.net/oci8

== Broken versions of OCI8 driver ==

PHP v5.2.4 (and perhaps v5.2.3 as well) have shipped with a bug in the OCI8 driver that leaks statement handles. The version of the OCI8 driver with the bug is v1.2.4. Possible workarounds:

* Upgrade to PHP v5.2.5 or later
* Downgrade to PHP v5.2.1 (reported to work)
* Downgrade only the oci8 driver to the one included in PHP 5.2.1 (it worked for us -- iarenaza)
* If you are on linux and/or can compile PECL extensions, install an older OCI8 driver (v1.2.3 seems to work) from the PECL repository http://pecl.php.net/package/oci8

More information at
* http://bugs.php.net/bug.php?id=42496 -- tracking the PHP OCI8 bug
* http://tracker.moodle.org/browse/MDL-11429 -- diagnostics on the Moodle side

== Installing Moodle on Windows with Oracle Express Edition ==

=== Introduction ===
This section explains how to install Moodle with Oracle Express Edition on Windows. I'm using it for '''debugging''' purpose. It's definitively not a production environment. The goal is to setup easily and quickly a Moodle/Windows/Oracle environment.

=== Install Oracle ===
# Download Oracle Express Edition on [http://www.oracle.com/technology/products/database/xe/index.html Oracle web site].
# You will also need the Instant client [http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html from here] (free account sign up needed). Copy everything from the unzipped folder into apache/bin.
# Install both. 
# Access to the oracle console at http://127.0.0.1:8080/apex (Login=SYS Password=the_one_you_entered_during_the_installation).
# Create a new user and give it all rights (including DBA).
# Go to the SQL Commands page and grant your new user the dmbs_lock permission...<code sql>
grant execute on dbms_lock to XXXXX;
</code>...where XXXXX is the username of your new user.
# Log out and log in as the new user.
# Run the script found in the Moodle codebase at /lib/dml/oci_native_moodle_package.sql. If you can not run this script directly, you can run its parts (separated by slashes) independently via the SQL Commands page.

Note: Oracle Express Edition 10g is limited at one database called 'XE'.

=== Set up your Oracle extension ===

This document does not explain how to setup apache/php for Oracle. You can have more information on [http://www.oracle.com/technology/tech/php/htdocs/php-oracle-tutorial.html Oracle Documentation].

Edit your phi.ini file, uncomment the following line (remove the leading semicolon) and set the value to zero.

<code>
oci8.statement_cache_size = 0
</code>

Uncomment the php_oci8 extension. In a WAMP setup, this is listed as...

<code>
extension=php_oci8.dll
</code>

You may also need to uncomment php_oracle, php_pdo_oci, php_pdo_oci8 in some set-ups.

=== Install Moodle ===
On the database setup page: 
Driver: Oracle oci8 (in the config file it should read "oci8po" for a 1.9.x install and "oci" for a 2.0.x install) 
Host: empty the field 
Database: //localhost:1521/XE 
User: the user that you created 
Password: the password you gave to the user 

=== Configure Apache ===

If you're running Moodle on Oracle with Apache on Linux, you might have issues with PHP being able to see the system environment variables. To resolve this, you can edit /etc/sysconfig/apache2 and add the following lines to the bottom: 
 
LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2# Set LANG Variables for UTF-8 
NLS_LANG=AMERICAN_AMERICA.AL32UTF8 
LANG=en_US.UTF-8 
LC_ALL=en_US.UTF-8 
LC_COLLATE=en_US.UTF-8 
LC_CTYPE=en_US.UTF-8 
LC_MESSAGES=en_US.UTF-8 
LC_MONETARY=en_US.UTF-8 
LC_NUMERIC=en_US.UTF-8 
LC_TIME=en_US.UTF-8 
NLS_NUMERIC_CHARACTERS='.,' 

export LANG LC_ALL LC_COLLATE LC_CTYPE LC_MESSAGES LC_MONETARY LC_NUMERIC LC_TIM NLS_LANG LD_LIBRARY_PATH NLS_NUMERIC_CHARACTERS 
 
Also need to add those two lines to ~/.bashrc so that the PHP command-line client can see it too. 
 

== Related links ==
* [http://lewiscarr.co.uk/node/4 Installing ORACLE drivers with PHP]
*[[Installing MSSQL for PHP]]
*[[PHP]]
*[http://moodle.org/mod/forum/discuss.php?d=134729#p588963 Can i install Moodle with Oracle database]
*[http://moodle.org/mod/forum/discuss.php?d=65488 Who uses Oracle]
*[https://docs.moodle.org/en/Step-by-step_Install_Guide_for_Solaris_10_with_Oracle_10 Step by step Install Guide for Solaris 10 with Oracle 10]
*[http://learningischange.com/2009/05/29/install-moodle-on-an-oracle-database-in-25-minutes-or-less/ Install Moodle on an Oracle Database (in 25 minutes or less)]. The related Using Moodle forum discussion is [http://moodle.org/mod/forum/discuss.php?d=124629 here].
*[http://www.mguhlin.org/2009/05/moodle-on-oracle-database.html Moodle on Oracle Database] discussion on Miguel Guhlin's blog

[[Category:Installation]]
[[Category:Developer]]
[[Category:XMLDB]]
[[Category:DB]]
[[Category:SQL databases]]

Installing Oracle for PHP

2012-04-12T03:17:44Z

Deraadt: Adding additional setup instructions

* http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html
* http://moodle.org/mod/forum/discuss.php?d=65488#p308002 (with attached html document)
* http://es.php.net/oci8

== Broken versions of OCI8 driver ==

PHP v5.2.4 (and perhaps v5.2.3 as well) have shipped with a bug in the OCI8 driver that leaks statement handles. The version of the OCI8 driver with the bug is v1.2.4. Possible workarounds:

* Upgrade to PHP v5.2.5 or later
* Downgrade to PHP v5.2.1 (reported to work)
* Downgrade only the oci8 driver to the one included in PHP 5.2.1 (it worked for us -- iarenaza)
* If you are on linux and/or can compile PECL extensions, install an older OCI8 driver (v1.2.3 seems to work) from the PECL repository http://pecl.php.net/package/oci8

More information at
* http://bugs.php.net/bug.php?id=42496 -- tracking the PHP OCI8 bug
* http://tracker.moodle.org/browse/MDL-11429 -- diagnostics on the Moodle side

== Installing Moodle on Windows with Oracle Express Edition ==

=== Introduction ===
This section explains how to install Moodle with Oracle Express Edition on Windows. I'm using it for '''debugging''' purpose. It's definitively not a production environment. The goal is to setup easily and quickly a Moodle/Windows/Oracle environment.

=== Install Oracle ===
# Download Oracle Express Edition on [http://www.oracle.com/technology/products/database/xe/index.html Oracle web site].
# You will also need the Instant client [http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html from here] (free account sign up needed). Copy everything from the unzipped folder into apache/bin.
# Install both. 
# Access to the oracle console at http://127.0.0.1:8080/apex (Login=SYS Password=the_one_you_entered_during_the_installation).
# Create a new user and give it all rights (including DBA).
# Go to the SQL Commands page and grant your new user the dmbs_lock permission...<code sql>
grant execute on dbms_lock to XXXXX;
</code>...where XXXXX is the username of your new user.
# Log out and log in as the new user.
# Run the script found in the Moodle codebase at /lib/dml/oci_native_moodle_package.sql. If you can not run this script directly, you can run its parts (separated by slashes) independently via the SQL Commands page.

Note: Oracle Express Edition 10g is limited at one database called 'XE'.

=== Set up your oracle extension ===
This document does not explain how to setup apache/php for Oracle. You can have more information on [http://www.oracle.com/technology/tech/php/htdocs/php-oracle-tutorial.html Oracle Documentation]. On my own machine I used my WAMP installation ([http://www.en.wampserver.com/ Wampserver 2.0]) which allowed me to activate all oracle extensions in few clicks (php_oci8, php_oracle, php_pdo_oci, php_pdo_oci8).

=== Install Moodle ===
On the database setup page: 
Driver: Oracle oci8 (in the config file it should read "oci8po" for a 1.9.x install and "oci" for a 2.0.x install) 
Host: empty the field 
Database: //localhost:1521/XE 
User: the user that you created 
Password: the password you gave to the user 

=== Configure Apache ===
Edit your phi.ini file, uncomment the following line (remove the leading semicolon) and set the value to zero.

<code>
oci8.statement_cache_size = 0
</code>

If you're running Moodle on Oracle with Apache on Linux, you might have issues with PHP being able to see the system environment variables. To resolve this, you can edit /etc/sysconfig/apache2 and add the following lines to the bottom: 
 
LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2# Set LANG Variables for UTF-8 
NLS_LANG=AMERICAN_AMERICA.AL32UTF8 
LANG=en_US.UTF-8 
LC_ALL=en_US.UTF-8 
LC_COLLATE=en_US.UTF-8 
LC_CTYPE=en_US.UTF-8 
LC_MESSAGES=en_US.UTF-8 
LC_MONETARY=en_US.UTF-8 
LC_NUMERIC=en_US.UTF-8 
LC_TIME=en_US.UTF-8 
NLS_NUMERIC_CHARACTERS='.,' 

export LANG LC_ALL LC_COLLATE LC_CTYPE LC_MESSAGES LC_MONETARY LC_NUMERIC LC_TIM NLS_LANG LD_LIBRARY_PATH NLS_NUMERIC_CHARACTERS 
 
Also need to add those two lines to ~/.bashrc so that the PHP command-line client can see it too. 
 

== Related links ==
* [http://lewiscarr.co.uk/node/4 Installing ORACLE drivers with PHP]
*[[Installing MSSQL for PHP]]
*[[PHP]]
*[http://moodle.org/mod/forum/discuss.php?d=134729#p588963 Can i install Moodle with Oracle database]
*[http://moodle.org/mod/forum/discuss.php?d=65488 Who uses Oracle]
*[https://docs.moodle.org/en/Step-by-step_Install_Guide_for_Solaris_10_with_Oracle_10 Step by step Install Guide for Solaris 10 with Oracle 10]
*[http://learningischange.com/2009/05/29/install-moodle-on-an-oracle-database-in-25-minutes-or-less/ Install Moodle on an Oracle Database (in 25 minutes or less)]. The related Using Moodle forum discussion is [http://moodle.org/mod/forum/discuss.php?d=124629 here].
*[http://www.mguhlin.org/2009/05/moodle-on-oracle-database.html Moodle on Oracle Database] discussion on Miguel Guhlin's blog

[[Category:Installation]]
[[Category:Developer]]
[[Category:XMLDB]]
[[Category:DB]]
[[Category:SQL databases]]

Installing Oracle for PHP

2012-04-12T03:06:21Z

Deraadt: Adding setting change to satisfy unit tests

* http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html
* http://moodle.org/mod/forum/discuss.php?d=65488#p308002 (with attached html document)
* http://es.php.net/oci8

== Broken versions of OCI8 driver ==

PHP v5.2.4 (and perhaps v5.2.3 as well) have shipped with a bug in the OCI8 driver that leaks statement handles. The version of the OCI8 driver with the bug is v1.2.4. Possible workarounds:

* Upgrade to PHP v5.2.5 or later
* Downgrade to PHP v5.2.1 (reported to work)
* Downgrade only the oci8 driver to the one included in PHP 5.2.1 (it worked for us -- iarenaza)
* If you are on linux and/or can compile PECL extensions, install an older OCI8 driver (v1.2.3 seems to work) from the PECL repository http://pecl.php.net/package/oci8

More information at
* http://bugs.php.net/bug.php?id=42496 -- tracking the PHP OCI8 bug
* http://tracker.moodle.org/browse/MDL-11429 -- diagnostics on the Moodle side

== Installing Moodle on Windows with Oracle Express Edition ==

=== Introduction ===
This section explains how to install Moodle with Oracle Express Edition on Windows. I'm using it for '''debugging''' purpose. It's definitively not a production environment. The goal is to setup easily and quickly a Moodle/Windows/Oracle environment.

=== Install Oracle ===
Download Oracle Express Edition on [http://www.oracle.com/technology/products/database/xe/index.html Oracle web site]. 
You will also need the Instant client [http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html from here] (free account sign up needed). Copy everything from the unzipped folder into apache/bin. 
Install both. 
Access to the oracle console (http://127.0.0.1:8080/apex). Login: SYS Password: the_one_you_entered_during_the_installation 
Create a new user and give it all rights (including DBA). 
Note: Oracle Express Edition 10g is limited at one database called 'XE'.

=== Set up your oracle extension ===
This document does not explain how to setup apache/php for Oracle. You can have more information on [http://www.oracle.com/technology/tech/php/htdocs/php-oracle-tutorial.html Oracle Documentation]. On my own machine I used my WAMP installation ([http://www.en.wampserver.com/ Wampserver 2.0]) which allowed me to activate all oracle extensions in few clicks (php_oci8, php_oracle, php_pdo_oci, php_pdo_oci8).

=== Install Moodle ===
On the database setup page: 
Driver: Oracle oci8 (in the config file it should read "oci8po" for a 1.9.x install and "oci" for a 2.0.x install) 
Host: empty the field 
Database: //localhost:1521/XE 
User: the user that you created 
Password: the password you gave to the user 

=== Configure Apache ===
Edit your phi.ini file, uncomment the following line (remove the leading semicolon) and set the value to zero.

<code>
oci8.statement_cache_size = 0
</code>

If you're running Moodle on Oracle with Apache on Linux, you might have issues with PHP being able to see the system environment variables. To resolve this, you can edit /etc/sysconfig/apache2 and add the following lines to the bottom: 
 
LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2# Set LANG Variables for UTF-8 
NLS_LANG=AMERICAN_AMERICA.AL32UTF8 
LANG=en_US.UTF-8 
LC_ALL=en_US.UTF-8 
LC_COLLATE=en_US.UTF-8 
LC_CTYPE=en_US.UTF-8 
LC_MESSAGES=en_US.UTF-8 
LC_MONETARY=en_US.UTF-8 
LC_NUMERIC=en_US.UTF-8 
LC_TIME=en_US.UTF-8 
NLS_NUMERIC_CHARACTERS='.,' 

export LANG LC_ALL LC_COLLATE LC_CTYPE LC_MESSAGES LC_MONETARY LC_NUMERIC LC_TIM NLS_LANG LD_LIBRARY_PATH NLS_NUMERIC_CHARACTERS 
 
Also need to add those two lines to ~/.bashrc so that the PHP command-line client can see it too. 
 

== Related links ==
* [http://lewiscarr.co.uk/node/4 Installing ORACLE drivers with PHP]
*[[Installing MSSQL for PHP]]
*[[PHP]]
*[http://moodle.org/mod/forum/discuss.php?d=134729#p588963 Can i install Moodle with Oracle database]
*[http://moodle.org/mod/forum/discuss.php?d=65488 Who uses Oracle]
*[https://docs.moodle.org/en/Step-by-step_Install_Guide_for_Solaris_10_with_Oracle_10 Step by step Install Guide for Solaris 10 with Oracle 10]
*[http://learningischange.com/2009/05/29/install-moodle-on-an-oracle-database-in-25-minutes-or-less/ Install Moodle on an Oracle Database (in 25 minutes or less)]. The related Using Moodle forum discussion is [http://moodle.org/mod/forum/discuss.php?d=124629 here].
*[http://www.mguhlin.org/2009/05/moodle-on-oracle-database.html Moodle on Oracle Database] discussion on Miguel Guhlin's blog

[[Category:Installation]]
[[Category:Developer]]
[[Category:XMLDB]]
[[Category:DB]]
[[Category:SQL databases]]

Progress Bar block

2012-01-30T01:39:33Z

Deraadt: Update for recent version

[[Blocks|Back to Blocks page]]

== Features ==

[[Image:ProgressBar.gif|right|A progress bar for a student]]
* The Progress Bar is a time-management tool for students.
* It visually shows what activities/resources a student is supposed to interact with in a course.
* It is colour coded so students can quickly see what they have and have not completed/viewed.
* The teacher selects which pre-existing activities/resources are to be included in the Progress Bar and when they should be completed/viewed.

== Links ==

* [http://moodle.org/plugins/view.php?plugin=block_progress Block code in Plugins repository]
* [http://tracker.moodle.org/browse/CONTRIB/component/10489 Bug Tracker Page] (Please report bugs here)
* [http://cvs.moodle.org/contrib/plugins/blocks/progress/ CVS Repository]

== Installing ==

The Progress Bar block is added like other blocks ([[Installing_contributed_modules_or_plugins|How to install a block]]).

Once the progress bar is installed, you can use it in a course as follows.
# Turn editing on
# Create your activities/resources as normal
# Add the Progress Bar block to your page ([[Blocks|How to add a block]])
# Move your Progress Bar block into a prominent position, eg. top-left (click and drag the block title)
# Click the Configuration icon on the block below the title
# Give your Progress Bar block a title (default is "Progress Bar")
# Set the activities/resources you want shown in the block to "Yes"
# Set the date and time when the activity/resource is expected to be completed/viewed by (some activities have deadlines set, if so, that deadline can be used or another can be set in the Progress Bar block configuration)
# Save changes

Hidden items will not appear in the Progress Bar until they are unhidden. This is useful for a scheduled release of activities.

== Acknowledgements ==

* Thanks to:
** Toshimi Hatanaka for contributing a Japanese translation
** Yvonne Schneider and Joachim Vogelgesang for contributing a German translation
** Maria João Spilker for contributing a Portuguese-Brazilian translation
** Pieter Wolters for contributing a Dutch translation
** Fernando Sánchez for contributing a Spanish translation
** Fabien Sartoretti for contributing a French translation
** Adam Levy for contributing queries and strings for Hot Potatoes support

[[Category:Contributed code]]

WebDAV repository

2012-01-10T01:44:29Z

Deraadt:

{{Repositories}}
Web-based Distributed Authoring and Versioning (WebDAV) is a set of methods based on the Hypertext Transfer Protocol (HTTP) that facilitates collaboration between users in editing and managing documents and files stored on World Wide Web servers.

A WebDAV repository can be enabled by a site administrator in ''Settings > Site administration > Plugins > Repositories > Manage repositories''.

==WebDAV configuration==

After enabling the WebDAV repository, a repository instance can be created in ''Settings > Site administration > Plugins > Repositories > WebDAV repository''.

[[Image:Webdav config.png]]

===Options===
WebDAV type: Choose from HTTP or HTTPS connection

WebDAV server: The server name

WebDAV path: The path to webdav directory

Authentication: We currently only support HTTP Basic Authentication

WebDAV server port: The webdav server port

WebDAV server user: HTTP Basic authentication username

WebDAV server password: HTTP Basic authentication password

For example, if you are going to added an webdav server at http://webdavserver.tld/path/to/dir, you should use following options:
WebDAV type: HTTP
WebDAV Server: webdavserver.tld

== Configuring WebDAV on Microsoft Windows Server 2003 R2 (Service Pack 2), IIS V6.0 ==

=== Configure Windows Server 2003 ===

First we need to install WebDAV on the server. ''Note:'' when you promote a basic Windows Server 2003 installation to an application server, it installs various IIS 6 components but WebDAV isn’t one of them.

==== Install and Enable WebDAV on the Server ====

To install WebDAV on the IIS 6 machine, use Add or Remove Programs in Control Panel and run the Windows Components Wizard. You can find WebDAV under '''Application Server -> Internet Information Services -> World Wide Web Service -> WebDAV Publishing'''.

Once WebDAV is installed it needs to be enabled. Check the WebDAV option under the Web Service Extensions node in IIS Manager.

=== Configure IIS ===

Configuring a new virtual directory in IIS is a two-step process:

#Create a new virtual directory using the Virtual Directory wizard
#Configure the access permissions on the new virtual directory

==== Create New Virtual Directory ====
#Open IIS and right-click on your Moodle website. Select '''New -> Virtual Directory'''... from the pop-up menu. [[Image:New_virtual_directory.png|200 px|Menu option required for creating new virtual directory]]
#Select '''New -> Virtual directory...''' from the pop-up menu. The '''Create New Virtual Directory Wizard''' is displayed. [[Image:Wizard_intro.png|200 px|IIS Virtual Directory Creation Wizard]]
#Call the new virtual directory '''Moodledata'''. [[Image:Name_directory.png|200 px|alt text]]
#Specify the path to the Moodledata directory. [[Image:Choose_path.png|200 px|Choosing path to folder on server]]
#Ensure the new virtual directory has '''Read''', '''Write''' and '''Browse''' permissions. [[Image:Directory_permissions.png|200 px|Specifying directory permissions]]
#Press the Finish button to create the new virtual directory.

==== Configuring Virtual Directory Properties ====

#Right-click on the new virtual directory and select Properties from the pop-up menu. [[Image:Check_properties.png|200 px|Checking new virtual directory properties]]
#Ensure that '''Read''', '''Write''', '''Directory browsing''', and '''Log visits''' are checked. Ensure '''Index this resource''' is unchecked. [[Image:Properties_view.png|200 px|Virtual directory properties correctly configured]]
#Click on the '''Directory Security''' tab and press the '''Authentication and access control''' Edit... button [[Image:Authentication_tab.png|200 px|Directory Security authentication and access control]]
#Authenticated access configuration will depend on your needs. Basic access will require you to uncheck '''Enable anonymous access''' and check '''Basic authentication (password is sent in clear text)'''. You may get a warning about security: [[Image:Authentication_warn.png|200 px|Directory security warning]]
#Your new virtual directory is ready for testing. [[Image:Final_view.png|200 px|New virtual directory ready for use]]

=== Testing WebDAV on Windows XP ===

WebDAV needs to be enabled on any client machines that will be used to create and manage content for Moodle. Windows XP has a built-in WebDAV client service that needs to be enabled:

#Open the '''Services''' console under '''Administrative Tools''' and find the '''WebClient''' service.
#Double-click on this service to open its '''Properties''' sheet.
#Change the '''Startup Type''' to ''Automatic'', then click the Start button to start the service.

''Note:'' Internet Explorer 8.0 no longer supports web folders. See [http://blogs.msdn.com/b/askie/archive/2009/03/20/open-as-web-folder-not-in-the-internet-explorer-8-file-open-dialog.aspx this blog post from David Conner] for details. Instead, you will need to map a network drive (instructions on mapping a network drive are also given in David's blog post).

WebDAV path: /path/to/dir/

==Repository permissions==

This repository is accessible by default to administrators, course creators, teachers, editing teachers and managers, but not to guests or students. This [[Capabilities/repository/webdav:view|capability]] can be changed to control access to users with specific roles.

==See also==

* MDL-22663

[[Category:Site administration]]
[[de:WebDAV Repository]]

Capabilities/repository/webdav:view

2012-01-10T01:30:27Z

Deraadt: Adding repository capability default information

* This allows a user to access the [[WebDAV repository]].
* This capability is set to allowed (CAP_ALLOW) by default for course creators, teachers, editing teachers and managers, but not to guests or students.

Server files repository

2012-01-10T01:29:59Z

Deraadt: /* Repository permissions */

{{Repositories}}The server repository allows users with the correct permissions to see files on the server. This might mean only files and folders in the context of the current course, or access to a file system that will allow them to use other courses files.

To access any repository, click on it.

[[File:File_Picker_blank_course.png|thumb|300px|center|A new course, with arrow point to Server files repository]]

Below is an example of drilling down. The breadcrumb path has built in links to the level it represents. In the example below, click on "English" and you will see folders representing all the courses in the English category at demo.moodle.org .
[[Image:File_Picker_demo_moodle_legacy_files.png|center|Server files after drilling down in demo.moodle.org]]

==Repository permissions==

This repository is accessible by default to administrators, course creators, teachers, editing teachers and managers, but not to guests or students. This [[Capabilities/repository/local:view|capability]] can be changed to control access to users with specific roles.

Capabilities/repository/local:view

2012-01-10T01:29:30Z

Deraadt: Adding repository capability default information

* This allows a user to access the [[Server files repository]].
* This capability is set to allowed (CAP_ALLOW) by default for course creators, teachers, editing teachers and managers, but not to guests or students.

File system repository

2012-01-10T01:28:28Z

Deraadt: /* Repository permissions */

{{Repositories}}
The file system repository allows users within Moodle to access files which have been uploaded via FTP into designated folders on the server. A file system repository may be available site wide for everyone; within an individual course or for an individual user.(However - see this [http://tracker.moodle.org/browse/MDL-28656 tracker entry] regarding course and individual repositories)

This must be done by a systems admin who has write permissions to the server directories.

=== Creating folders for your file system repositories===
*Find the moodledata folder on the server
*Inside it, create a folder called "repository"
*Inside that folder, create as many folders as you need, named appropriately.
[[File:Moodledatarepo2.png]]
*FTP into the appropriate folder the files you want. (The folders can hold all types of files)

=== Enabling the File System repository plugin===

*Go to ''Settings > Site administration > Plugins > Repositories > Manage Repositories'';
*Select from the drop down next to File sytem "Enabled and visible"
[[File:Filesystemrepo.png]]

===Setting up a site-wide file system repository===
*Once the repository is enabled as above, click on the "Settings" link to the right.
*Scroll down to Repositories instances of the site
*Click Create a repository instance
[[File:Sitefilesystemrepo.png]]
*Give it a name and (if there are several folders on the server) choose from the dropdown the one you want. Click save
[[File:Namedfilesystem.png]]
*It will now be available in the file picker in all courses.
''NOTE: Just repeat the process to get more than one site wide file system repository''

===Setting up a repository inside a course===
''NOTE: A regular user needs to have been given permission to do this by admin (MORE DETAILS SOON)''
*Go to the desired course and click on “repositories” in the administration block
*Scroll down and click "Create File System instance"
[[File:Courseinstance.png]]
*Follow the same process as [[#Setting_up_a_site-wide_file_system_repository|here]]

===Setting up an individual file system repository instance===
''NOTE: A regular user needs to have been given permission to do this by admin (MORE DETAILS SOON)
''
*In the navigation block, click on “my profile”
*Click on “repositories”
*Scroll down and click “create File System instance”
*Follow the same process as [[#Setting_up_a_site-wide_file_system_repository|here]]
*This will create a personal file system repository connecting just you to a folder on the server.
[[File:Privaterepo2.png]]

===Using it===
If you try to add a file in Moodle, then the File Picker should show you your new file system repository, and you should be able to browse it and select files to use.

Note that file types are respected (based on file extensions), so if you are adding an image in the editor, then you won't see Office docs (for example) appear in the File Picker.

[[File:Filesystemeg.png]]

==Repository permissions==

This repository is accessible by default to administrators, course creators, teachers, editing teachers and managers, but not to guests or students. This [[Capabilities/repository/filesystem:view|capability]] can be changed to control access to users with specific roles.

==See also==
*[[File_system_repository_FAQ|File system repository FAQ]]
* Overview of [[Repositories|Repositories]]
* [http://www.somerandomthoughts.com/blog/2010/06/15/ftp-files-into-moodle-2-0-with-the-repository-api/ FTP files into Moodle 2.0 with the repository API article from somerandomthoughts.com] including screencast

[[Category:Site administration]]
[[de:Dateisystem-Repository]]

Capabilities/repository/filesystem:view

2012-01-10T01:27:44Z

Deraadt: Adding repository capability default information

* This allows a user to access the [[File system repository]].
* This capability is set to allowed (CAP_ALLOW) by default for course creators, teachers, editing teachers and managers, but not to guests or students.

Legacy course files

2012-01-10T01:26:50Z

Deraadt: /* Repository permissions */

{{Repositories}}
Note: This page only applies to sites which have been upgraded from Moodle 1.9.
In Moodle 2.0 onwards, files are stored in separate areas, rather than together in the course files area. See [[Course files]] for a detailed explanation. When a site is upgraded from 1.9, the course files area is renamed 'Legacy course files'. By default, this area is not available in new courses.

''It is recommended that teachers make use of the new [[Repositories|repositories]] in Moodle 2.0 for storing course files, rather than saving them in the legacy course files area''.

==Enabling legacy course files areas==

To enable a legacy course files area in a new course

# Enable the legacy course files repository plugin in ''Settings > Site administration > Plugins > Repositories > [[Manage repositories]]''.
# Check the legacyfilesinnewcourses box in the Manage repositories common settings then click the 'Save changes' button.
# Set 'Legacy course files' to Yes in the course settings.

A legacy course files link will then appear in the ''Settings > Course administration'' area.

==Repository permissions==

This repository is accessible by default to administrators, course creators, teachers, editing teachers and managers, but not to guests or students. This [[Capabilities/repository/coursefiles:view|capability]] can be changed to control access to users with specific roles.

[[ja: レガシーコースファイル]]

Capabilities/repository/coursefiles:view

2012-01-10T01:25:46Z

Deraadt: Adding repository capability default information

* This allows a user to access the [[Legacy course files]] area.
* This capability is available in Moodle 2.0 onwards and replaces the capability moodle/course:managefiles.
* This capability is set to allowed (CAP_ALLOW) by default for course creators, teachers, editing teachers and managers, but not to guests or students.

[[Category:Capabilities|Repository]]
[[Category:Repositories]]

Managing repositories

2012-01-10T01:20:01Z

Deraadt: /* Repositories and capabilities */

{{Repositories}}
==Enabling repositories==

Repositories can be enabled by an administrator in ''Settings > Site administration > Plugins > Repositories > Manage repositories''.

A repository plugin may be set to

* Enabled and visible - appears in the file picker
* Enabled and hidden
* Disabled - default setting

The order in which repositories are shown in the file picker may be set using the up and down arrows.

==Vocabulary==
'''Repository plugin''': it is also called a repository type. It can be named Box.net, Flickr, Mahara, Youtube... Adding a plugin allow users to create instances of this plugin. Only instances are displayed into the file picker. Type only exist in order to let a Moodle administrator to deactivate/delete all instances of a type in one click.

'''Repository instance''': An instance is displayed into the file picker and it is the access point to an external repository. An instance can have specific settings (for example be linked to a personal account).

*First case: when you add the plugin, an instance is automatically created and can not be edited. The Moodle administrator cannot change the instance name. The instance name displayed into the file picker will be exactly the same as the plugin name. For example Youtube, Box.net...
*Second case: the plugin allow the Moodle administrator to add multiple instances. An instance has a name for example Flickr Public access to Martin account, Martin's Mahara... For this second case it is important to identify two different kind of instances:
#Common instances: The instances set by Moodle administrator in these same administration pages will be available into any file picker.
#Private instance: A teacher can set some instances available only for a course, and an user can set some instances only available for himself. In order to set instances for a course the teacher will go to the course page, and in order to set instances for a personal use, a user will go on his profile page. An administrator cannot add/edit private instances from the administration pages.

==Common repository settings==

Common repository settings can be set by an administrator in ''Settings > Site administration > Plugins > Repositories > Common Repository settings'':

===Cache Expire===

You can specify how long in seconds file listings are cached locally when browsing external repositories.

===Allow external links===

With some repositories such as Flickr, users can have the choice whether to copy the media into Moodle (the preferred solution) or to make a link to it instead.

===Legacy course files in new courses===

This repository is not normally available in new courses as it is designed for upgraded 1.9 courses. However, if it is checked here then it will appear when new courses are created - but certain backup and restore features won't work with it. See [[Legacy course files]] for more details.

==Repositories and capabilities==

Each repository plugin has a [[Roles and permissions|capability]] to control user access. This can be controlled for users of differing [[Roles and permissions|roles]]. Most, repositories distributed with Moodle are accessible to all roles, except the following repositories, which by default are accessible to administrators, course creators, teachers, editing teachers and managers, but not to guests or students.

* [[Capabilities/repository/coursefiles:view|Legacy course files]]
* [[Capabilities/repository/filesystem:view|File system]]
* [[Capabilities/repository/local:view|Server files]]
* [[Capabilities/repository/webdav:view|WebDAV repository]]

WebDAV repository

2012-01-10T01:02:47Z

Deraadt: Adding repository capability default information

{{Repositories}}
Web-based Distributed Authoring and Versioning (WebDAV) is a set of methods based on the Hypertext Transfer Protocol (HTTP) that facilitates collaboration between users in editing and managing documents and files stored on World Wide Web servers.

A WebDAV repository can be enabled by a site administrator in ''Settings > Site administration > Plugins > Repositories > Manage repositories''.

==WebDAV configuration==

After enabling the WebDAV repository, a repository instance can be created in ''Settings > Site administration > Plugins > Repositories > WebDAV repository''.

[[Image:Webdav config.png]]

===Options===
WebDAV type: Choose from HTTP or HTTPS connection

WebDAV server: The server name

WebDAV path: The path to webdav directory

Authentication: We currently only support HTTP Basic Authentication

WebDAV server port: The webdav server port

WebDAV server user: HTTP Basic authentication username

WebDAV server password: HTTP Basic authentication password

For example, if you are going to added an webdav server at http://webdavserver.tld/path/to/dir, you should use following options:
WebDAV type: HTTP
WebDAV Server: webdavserver.tld

== Configuring WebDAV on Microsoft Windows Server 2003 R2 (Service Pack 2), IIS V6.0 ==

=== Configure Windows Server 2003 ===

First we need to install WebDAV on the server. ''Note:'' when you promote a basic Windows Server 2003 installation to an application server, it installs various IIS 6 components but WebDAV isn’t one of them.

==== Install and Enable WebDAV on the Server ====

To install WebDAV on the IIS 6 machine, use Add or Remove Programs in Control Panel and run the Windows Components Wizard. You can find WebDAV under '''Application Server -> Internet Information Services -> World Wide Web Service -> WebDAV Publishing'''.

Once WebDAV is installed it needs to be enabled. Check the WebDAV option under the Web Service Extensions node in IIS Manager.

=== Configure IIS ===

Configuring a new virtual directory in IIS is a two-step process:

#Create a new virtual directory using the Virtual Directory wizard
#Configure the access permissions on the new virtual directory

==== Create New Virtual Directory ====
#Open IIS and right-click on your Moodle website. Select '''New -> Virtual Directory'''... from the pop-up menu. [[Image:New_virtual_directory.png|200 px|Menu option required for creating new virtual directory]]
#Select '''New -> Virtual directory...''' from the pop-up menu. The '''Create New Virtual Directory Wizard''' is displayed. [[Image:Wizard_intro.png|200 px|IIS Virtual Directory Creation Wizard]]
#Call the new virtual directory '''Moodledata'''. [[Image:Name_directory.png|200 px|alt text]]
#Specify the path to the Moodledata directory. [[Image:Choose_path.png|200 px|Choosing path to folder on server]]
#Ensure the new virtual directory has '''Read''', '''Write''' and '''Browse''' permissions. [[Image:Directory_permissions.png|200 px|Specifying directory permissions]]
#Press the Finish button to create the new virtual directory.

==== Configuring Virtual Directory Properties ====

#Right-click on the new virtual directory and select Properties from the pop-up menu. [[Image:Check_properties.png|200 px|Checking new virtual directory properties]]
#Ensure that '''Read''', '''Write''', '''Directory browsing''', and '''Log visits''' are checked. Ensure '''Index this resource''' is unchecked. [[Image:Properties_view.png|200 px|Virtual directory properties correctly configured]]
#Click on the '''Directory Security''' tab and press the '''Authentication and access control''' Edit... button [[Image:Authentication_tab.png|200 px|Directory Security authentication and access control]]
#Authenticated access configuration will depend on your needs. Basic access will require you to uncheck '''Enable anonymous access''' and check '''Basic authentication (password is sent in clear text)'''. You may get a warning about security: [[Image:Authentication_warn.png|200 px|Directory security warning]]
#Your new virtual directory is ready for testing. [[Image:Final_view.png|200 px|New virtual directory ready for use]]

=== Testing WebDAV on Windows XP ===

WebDAV needs to be enabled on any client machines that will be used to create and manage content for Moodle. Windows XP has a built-in WebDAV client service that needs to be enabled:

#Open the '''Services''' console under '''Administrative Tools''' and find the '''WebClient''' service.
#Double-click on this service to open its '''Properties''' sheet.
#Change the '''Startup Type''' to ''Automatic'', then click the Start button to start the service.

''Note:'' Internet Explorer 8.0 no longer supports web folders. See [http://blogs.msdn.com/b/askie/archive/2009/03/20/open-as-web-folder-not-in-the-internet-explorer-8-file-open-dialog.aspx this blog post from David Conner] for details. Instead, you will need to map a network drive (instructions on mapping a network drive are also given in David's blog post).

WebDAV path: /path/to/dir/

==Repository permissions==

This repository is accessible by default to administrators, course creators, teachers, editing teachers and managers, but not to guests or students. This [[Roles and permissions|capability]] can be changed to control access to users with specific roles.

==See also==

* MDL-22663

[[Category:Site administration]]
[[de:WebDAV Repository]]

File system repository

2012-01-10T01:02:39Z

Deraadt: Adding repository capability default information

{{Repositories}}
The file system repository allows users within Moodle to access files which have been uploaded via FTP into designated folders on the server. A file system repository may be available site wide for everyone; within an individual course or for an individual user.(However - see this [http://tracker.moodle.org/browse/MDL-28656 tracker entry] regarding course and individual repositories)

This must be done by a systems admin who has write permissions to the server directories.

=== Creating folders for your file system repositories===
*Find the moodledata folder on the server
*Inside it, create a folder called "repository"
*Inside that folder, create as many folders as you need, named appropriately.
[[File:Moodledatarepo2.png]]
*FTP into the appropriate folder the files you want. (The folders can hold all types of files)

=== Enabling the File System repository plugin===

*Go to ''Settings > Site administration > Plugins > Repositories > Manage Repositories'';
*Select from the drop down next to File sytem "Enabled and visible"
[[File:Filesystemrepo.png]]

===Setting up a site-wide file system repository===
*Once the repository is enabled as above, click on the "Settings" link to the right.
*Scroll down to Repositories instances of the site
*Click Create a repository instance
[[File:Sitefilesystemrepo.png]]
*Give it a name and (if there are several folders on the server) choose from the dropdown the one you want. Click save
[[File:Namedfilesystem.png]]
*It will now be available in the file picker in all courses.
''NOTE: Just repeat the process to get more than one site wide file system repository''

===Setting up a repository inside a course===
''NOTE: A regular user needs to have been given permission to do this by admin (MORE DETAILS SOON)''
*Go to the desired course and click on “repositories” in the administration block
*Scroll down and click "Create File System instance"
[[File:Courseinstance.png]]
*Follow the same process as [[#Setting_up_a_site-wide_file_system_repository|here]]

===Setting up an individual file system repository instance===
''NOTE: A regular user needs to have been given permission to do this by admin (MORE DETAILS SOON)
''
*In the navigation block, click on “my profile”
*Click on “repositories”
*Scroll down and click “create File System instance”
*Follow the same process as [[#Setting_up_a_site-wide_file_system_repository|here]]
*This will create a personal file system repository connecting just you to a folder on the server.
[[File:Privaterepo2.png]]

===Using it===
If you try to add a file in Moodle, then the File Picker should show you your new file system repository, and you should be able to browse it and select files to use.

Note that file types are respected (based on file extensions), so if you are adding an image in the editor, then you won't see Office docs (for example) appear in the File Picker.

[[File:Filesystemeg.png]]

==Repository permissions==

This repository is accessible by default to administrators, course creators, teachers, editing teachers and managers, but not to guests or students. This [[Roles and permissions|capability]] can be changed to control access to users with specific roles.

==See also==
*[[File_system_repository_FAQ|File system repository FAQ]]
* Overview of [[Repositories|Repositories]]
* [http://www.somerandomthoughts.com/blog/2010/06/15/ftp-files-into-moodle-2-0-with-the-repository-api/ FTP files into Moodle 2.0 with the repository API article from somerandomthoughts.com] including screencast

[[Category:Site administration]]
[[de:Dateisystem-Repository]]

Legacy course files

2012-01-10T01:02:35Z

Deraadt: Adding repository capability default information

{{Repositories}}
Note: This page only applies to sites which have been upgraded from Moodle 1.9.
In Moodle 2.0 onwards, files are stored in separate areas, rather than together in the course files area. See [[Course files]] for a detailed explanation. When a site is upgraded from 1.9, the course files area is renamed 'Legacy course files'. By default, this area is not available in new courses.

''It is recommended that teachers make use of the new [[Repositories|repositories]] in Moodle 2.0 for storing course files, rather than saving them in the legacy course files area''.

==Enabling legacy course files areas==

To enable a legacy course files area in a new course

# Enable the legacy course files repository plugin in ''Settings > Site administration > Plugins > Repositories > [[Manage repositories]]''.
# Check the legacyfilesinnewcourses box in the Manage repositories common settings then click the 'Save changes' button.
# Set 'Legacy course files' to Yes in the course settings.

A legacy course files link will then appear in the ''Settings > Course administration'' area.

==Repository permissions==

This repository is accessible by default to administrators, course creators, teachers, editing teachers and managers, but not to guests or students. This [[Roles and permissions|capability]] can be changed to control access to users with specific roles.

[[ja: レガシーコースファイル]]

Server files repository

2012-01-10T01:02:30Z

Deraadt: Adding repository capability default information

{{Repositories}}The server repository allows users with the correct permissions to see files on the server. This might mean only files and folders in the context of the current course, or access to a file system that will allow them to use other courses files.

To access any repository, click on it.

[[File:File_Picker_blank_course.png|thumb|300px|center|A new course, with arrow point to Server files repository]]

Below is an example of drilling down. The breadcrumb path has built in links to the level it represents. In the example below, click on "English" and you will see folders representing all the courses in the English category at demo.moodle.org .
[[Image:File_Picker_demo_moodle_legacy_files.png|center|Server files after drilling down in demo.moodle.org]]

==Repository permissions==

This repository is accessible by default to administrators, course creators, teachers, editing teachers and managers, but not to guests or students. This [[Roles and permissions|capability]] can be changed to control access to users with specific roles.

Managing repositories

2012-01-10T00:44:28Z

Deraadt: Adding repository capability default information

{{Repositories}}
==Enabling repositories==

Repositories can be enabled by an administrator in ''Settings > Site administration > Plugins > Repositories > Manage repositories''.

A repository plugin may be set to

* Enabled and visible - appears in the file picker
* Enabled and hidden
* Disabled - default setting

The order in which repositories are shown in the file picker may be set using the up and down arrows.

==Vocabulary==
'''Repository plugin''': it is also called a repository type. It can be named Box.net, Flickr, Mahara, Youtube... Adding a plugin allow users to create instances of this plugin. Only instances are displayed into the file picker. Type only exist in order to let a Moodle administrator to deactivate/delete all instances of a type in one click.

'''Repository instance''': An instance is displayed into the file picker and it is the access point to an external repository. An instance can have specific settings (for example be linked to a personal account).

*First case: when you add the plugin, an instance is automatically created and can not be edited. The Moodle administrator cannot change the instance name. The instance name displayed into the file picker will be exactly the same as the plugin name. For example Youtube, Box.net...
*Second case: the plugin allow the Moodle administrator to add multiple instances. An instance has a name for example Flickr Public access to Martin account, Martin's Mahara... For this second case it is important to identify two different kind of instances:
#Common instances: The instances set by Moodle administrator in these same administration pages will be available into any file picker.
#Private instance: A teacher can set some instances available only for a course, and an user can set some instances only available for himself. In order to set instances for a course the teacher will go to the course page, and in order to set instances for a personal use, a user will go on his profile page. An administrator cannot add/edit private instances from the administration pages.

==Common repository settings==

Common repository settings can be set by an administrator in ''Settings > Site administration > Plugins > Repositories > Common Repository settings'':

===Cache Expire===

You can specify how long in seconds file listings are cached locally when browsing external repositories.

===Allow external links===

With some repositories such as Flickr, users can have the choice whether to copy the media into Moodle (the preferred solution) or to make a link to it instead.

===Legacy course files in new courses===

This repository is not normally available in new courses as it is designed for upgraded 1.9 courses. However, if it is checked here then it will appear when new courses are created - but certain backup and restore features won't work with it. See [[Legacy course files]] for more details.

==Repositories and capabilities==

Each repository plugin has a [[Roles and permissions|capability]] to control user access. This can be controlled for users of differing [[Roles and permissions|roles]]. Most, repositories distributed with Moodle are accessible to all roles, except the following repositories, which by default are accessible to administrators, course creators, teachers, editing teachers and managers, but not to guests or students.

* Legacy course files
* File system
* Server files
* WebDAV repository