Glossary items used in a quiz

Glossary items used in a quiz

by Vlad Kuzba -
Number of replies: 56

I would like to make much more use of our glossary entries by using them in a quiz - short questions, for example. I can't figure out how to do it. I know I can use them in the excellent Game module, but for my student a game is not a quiz/test. Is there a way?

Average of ratings: -
In reply to Vlad Kuzba

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Hi Vlad,

I do not really see how one could use the glossary entries for SHORTANSWER questions. Can you expand and provide some examples of how you would do this? On the other hand, it might be interesting to use the glossary entries for MATCHING questions, i.e. match entries with their definitions. Unfortunately this is not possible from the Moodle interface at the moment, it would need some development.

All the best,

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Vlad Kuzba -

Hello Joseph,

thanks for your answer. Well, I often use Jcross from Hot Potatoes for students to practise vocabulary. If you import JCross file to questions, the items from the crosswords import as short questions. So far this has been the technique I've been using. The downsize is, that I have to do double work - I have to create the crosswords and the glossary separately which of course takes a lot of time.

I would be perfect and very useful to be able to use glossary items in questions generally. I think just being able to import (previously exported) glossaries to questions would do.

And yes, being able to use glossaries items for MATCHING question or some other would great.

Regrads

Vlad

In reply to Vlad Kuzba

Re: Glossary items used in a quiz

by Frank Ralf -
Hi Vlad,

Couldn't you use one of the import/export formats of Moodle as a workaround? Import and export FAQ should give you some pointers.

hth
Frank
In reply to Frank Ralf

Re: Glossary items used in a quiz

by Vlad Kuzba -

Hi Frank,

the export/import thing was the first to try out. But you can only export glossaries in XML which is not the one used in questions. If I tried to import this file into questions I finished with an error message. I have also examined the stucture of both, there seems to be a way of converting the glossary export file to questions XML manualy using Find/Replace, but the result is not guaranteed and its very tiring. I'm not a programmer so writing my own piece of code is out of the question smile

Regards

Vlad


In reply to Vlad Kuzba

Re: Glossary items used in a quiz

by Frank Ralf -
Hi Vlad,

Converting one XML format into another is usually done using XSLT. I've started exploring the possibilities some time ago but haven't come far yet. You might have a look at User:Frank Ralf/Moodle XML1 and XML FAQ.

It would be nice if you could post a short sample XML file here for further investigation.

Cheers,
Frank
In reply to Frank Ralf

Re: Glossary items used in a quiz

by Vlad Kuzba -

Hi Frank,

here is a sample of XML exported from questions and a sample from glossary export. Hope it helps. I've tried converting the file using a AutoHotKey script, but no result so far.

Cheers

Vlad

In reply to Vlad Kuzba

Re: Glossary items used in a quiz

by Frank Ralf -
Thanks! Will have a look as soon as I find the time.

I've already dabbled a bit myself, see http://docs.moodle.org/en/User:Frank_Ralf/Converting_Moodle_glossary_XML_to_question_XML

As I understand the basic mapping is as follows:

Glossary:
<ENTRY>
    <CONCEPT>Gorilla</CONCEPT>
    <DEFINITION>Gorillas are the largest of the primates.</DEFINITION>
</ENTRY>

Quiz question:
<question type="shortanswer">
    <questiontext>Gorilla</questiontext>
    <answer>Gorillas are the largest of the primates.</answer>
</question>

Cheers,
Frank

PS:
There's also a Moodle for Language Teaching forum which might be interesting for you: http://moodle.org/course/view.php?id=31
In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Hi Vlad and Frank,

I have started work on this feature, which I think can be resolved nicely with a block. Will keep you posted here shortly.

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Vlad Kuzba -

Joseph, this sounds like heaven! Thanks a lot!

Best wishes

Vlad

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Making good progress on that "export Glossary to Question bank" block. I will report here very soon.

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Vlad Kuzba -

Eagerly, but patiently waiting to try it smile

In reply to Vlad Kuzba

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

After 3 days' hard worksad I am pleased to offer a beta version of the "Export Glossary to Quiz" block. Before releasing it in the Moodle plugins database, I invite moodlers to test it on my test site and report here any bugs or wishes for new features (not too many of either, hopefullywink).

Go to my test site http://rezeau.info/moodle/ and login as teacher01, password Teacher01! and go to the Demo course. Please note that that demo course has limited capacities for the teacher role, but those should suffice for the test.

A. Export from Glossary to moodle quiz XML file

  1. You don't need to be in Edit mode to configure the Export Glossary to Quiz block. Just click on the Configuration icon.
  2. Select one of the available glossaries in that course. For a quick test, I suggest selecting the Nature Glossary, either All entries or one of its categories.
  3. Maximum number of entries to export: this is default-set to 999. You do not need to change that value.
  4. Remove glossary autolinks in question text? Because the final goal of that block is to make glossary entries & definitions available as quiz questions, and the question texts might contain entries to one or the other of the course glossaries, and autolinks to these might be "too helpful" to the student, you are advised to set this option to Yes. Please note that in moodle 2.0 autolinking can be switched on or off as a setting, so this setting will not be needed in the 2.0 version of this block.
  5. When done, click OK.
  6. You are back in the course homepage, but now the block displays the settings you have selected.
  7. Click on the glossary's name link (e.g. Nature Glossary)
  8. Now you are on page Demo ► Glossaries ► (e.g.) Nature Glossary ► Export entries to Quiz (XML)
  9. Click on the Export entries to file button.
  10. At the prompt, save file to your computer. Its name is e.g. Nature_Glossary.xml.
  11. Go back to the course's homepage. You see that the the Export Glossary to Quiz block has been reset.

B. Import to the quiz questions bank

  1. Turn editing on
  2. In Administration block, click Questions
  3. On the Edit questions page, Click the Import tab
  4. Set these settings:
    File format : Moodle XML format
    General
    Category Default
    Get category from file (check it)
    Import from file upload...
  5. Go to the file you saved to your computer in step A 10 (Nature_Glossary.xml. and click Upload this file button.
  6. If all goes well, the imported questions should get displayed on the next screen.
  7. Click Continue.
  8. On the next page, the Question bank displays the new category name (formed on the name of the exported Glossary, plus the name of its category if you selected one of the glossary's categories) and of course all the questions that were imported (of the SHORTANSWER type).
  9. You can use those questions in a quiz.
  10. Or you can use those questions to create one or more Random Short-Answer Matching questions.

Enjoy!

Joseph

Average of ratings: Useful (3)
In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Vlad Kuzba -

Hi Joseph,

I have just tested the block, everything seems to work perfectly. Everything is clean and clear, even pictures are exported/imported. Great job! What's the emoticon for "STANDING OVATION"?

Great job, indeed. Thank you very much!

Regards

Vlad

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Nicholas Walker -

Hello Joseph,

I have imported your nature quiz. So smooth, so clear, so easy.  Thank you for your hard work. This is a very valuable addition to the glossary module, and I hope you release the block soon. I'm sure I will be able to find a use for it with my students in January.

A wonderful addition,

Nick

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

See improved version of the "Export Glossary to Quiz" block on my moodle test site (address above). New features: online help buttons; sort exported entries : by alphabetical order, randomly or by latest modified.

Still waiting for more testing and bug fixing before committing to the modules and plugins database.

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by ben reynolds -

I've got a very newb Moodler headed your way today, I hope.

Maybe we should start using the Martin emoticon martin for smart Moodle work.

In reply to ben reynolds

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Ben "Maybe we should start using the Martin emoticon martin for smart Moodle work."

No way, the Martin emoticon is strictly reserved for our Beloved Leader, not for His obscure followers.wink

Thanks for your appreciation, Ben.

Joseph


In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Itamar Tzadok -

I've created a Lo-Tech version of this initiative. It may be useful for those who can't freely add plugins. It's database activity based. Preset should be attached.

The procedure is not as neat as the above but ...

  1. Create a database activity using the attached preset.
  2. Export the desired glossary
    1. Exporting the glossary produces an xml file which can be stored anywhere on your computer.
    2. The glossary does not need to reside in the same course as the database activity.
  3. Add an entry for that glossary to the database activity.
    1. The entry consists of a file field.
    2. Browse the glossary export file and upload it to the entry.
  4. In the single view of the entry
    1. A list of all the glossary entries should be displayed.
    2. Select how many entries to export
      1. All - all entries (the number of entries should be displayed)
      2. None - clear all entries (0)
      3. Any number of entries from the befining of the list - enter the number of entries in the text field and click Go.
      4. Check or uncheck individual entries in the list - number of selected entries should be updated in the text field (don't click Go)
    3. Select the desired question type
      1. Currently supports short answer or multiple choice.
      2. Multiple choice are by default 4 options, shuffled. Distractors are selected randomly from the whole list.
    4. Click 'Generate Quiz XML' to generate quiz xml
      1. A textarea containing the question import xml should appear in the top right corner.
      2. Select and copy the question import xml from the textarea
  5. Paste the question import xml into a text file on your computer.
  6. Import the questions from file by 'import from file upload' into the desired questions category.

smile

In reply to Itamar Tzadok

Re: Glossary items used in a quiz

by Itamar Tzadok -

An image for illustration. smile

Attachment data-application-glossary2quiz.jpg
In reply to Itamar Tzadok

Re: Glossary items used in a quiz

by Mary Cooch -
Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Testers Picture of Translators

Just wanted to publicly thank Joseph on the English-speaking forums  ( have already tested and posted in the French ones) and also to say Itamar is King of The Databases! - I am off to test this "low tech" alternative now too smile

In reply to Itamar Tzadok

Re: Glossary items used in a quiz

by ben reynolds -

Hi Itamar,

I tried to use your database exporter just now and failed.

I first exported as multi-choice and tried to import. Got the failed message that there are no questions.

Then I exported as short answer and tried to import. Got the failed message that the file is empty.

When I pasted the copy into EditpadPro and saved, I got a message that I was working in Windows 1250 and Editpad would save as UTF-8, which I OKed. For both short answer and multi-choice, I fail.

One file is attached. Apparently, I'm not allowed to attach more than one.

In reply to ben reynolds

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Hi Ben,

The problem does come from the way you copy-pasted the "exported questions" into your text editor.

There is an error coding in the apostrophe in "Here's" which shows as follows in your file:

Repetition of initial consonant sounds in words placed close together [Hereҳ a blob a bit like a bowler hat

I have edited your file in Dreamweaver and saved and the import into questions database works fine, after DW has automatically transformed the above into

Repetition of initial consonant sounds in words placed close together [Heres a blob a bit like a bowler hat

I think that is the limit of Itamar's solution, it involves one potentially dangerous copy-paste feature. My own block solution does not have this problem. I am in the process of refining my block, but any-one wanting to trying out is welcome to email me (see my profile) for a copy.

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Itamar Tzadok -

Fortunately this limit seems limited enough to be resolvable. The attached revised preset should not encounter these problems. I even tested it with a paragraph copied directly from Word. I just added a very simple function that converts any character in the generated xml whose code is greater than 127 to its html character code (e.g. ’ is converted to &#8217;). smile

Average of ratings: Useful (2)
In reply to Itamar Tzadok

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

The block vs database competition goes on.black eye

Itamar 2 points / Joseph 2 points.

Average of ratings: Useful (1)
In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Glenys Hanson -

Hi Joseph and Itamar,

Sometimes I rate "Useful" when I really mean LOL

Keep up the good work both of you. big grin

Glenys

In reply to Itamar Tzadok

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Hi Itamar,

Just tried it, works fine. Brilliant.cool When I think that you must have knocked this out in a couple of hours whilst it took me more than 3 full days to produce my little block... sad

Just goes to show that there are always more than one way to do things. It is also a good reminder that the database activity can do more than its name implies, and is probably a neglected resource.

Well-done, Itamar,

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Itamar Tzadok -

Thanks Joseph.

A couple of hours, yes, but if you consider that for this solution I've merely glued together some code snippets which I already implemented and tested in other solutions (some of which are also posted in these forums) this is in a sense a couple of fairly long hours. big grin

Absolutely agree that the database may be given a bit more attention. In fact I've started doing just that but have put it on hold until 2.0 is stable (which is just an excuse to buy a bit more time before I dive into that wink).

smile

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

New version of block available for testing on my test site. Most of the instructions in my previous post (Saturday, 27 November 2010, 06:42 PM) still apply.

Added support for exporting glossary entries as MULTICHOICE questions or SHORTANSWER.

Joseph

PS.- Trying to beat Itamar in our friendly competition.big grin

Average of ratings: Useful (2)
In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Anthony Roberts -

Thanks for this feature, Joseph! I am relatively new to Moodle, and I am already in need of this type of tool. I explored the block on your demo site with success. Is there a way to implement it on my course site at present?

Anthony

In reply to Joseph Rézeau

Re: Glossary items used in a quiz :: Block available for download

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Export Glossary to Quiz block is now available for download in the Modules and plugins here: Block: Export Glossary to Quiz.

Version for Moodle 1.9 is available.  Version for Moodle 2.0 available as soon as some tricky new 2.0 features are solved.

English and French interface and help files. Anyone interested in translation to other languages please contact me.

Thanks to all those who helped in the tests.smile

Joseph

Average of ratings: Useful (3)
In reply to Joseph Rézeau

Re: Glossary items used in a quiz :: Block available for download

by Vlad Kuzba -

Joseph I will make the Czech translation.

In reply to Joseph Rézeau

Re: Glossary items used in a quiz :: Block available for download

by Joachim Vogelgesang -

German translation

(Help files will follow)

In reply to Joachim Vogelgesang

Re: Glossary items used in a quiz :: Block available for download

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Danke schön!

German translation is now available in the download package.

Joseph

Attachment 21-01-2011 15-31-30.jpg
In reply to Joseph Rézeau

Re: Glossary items used in a quiz :: Block available for download

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Version for Moodle 2.0 now available from the Modules and Plugins database Block: Export Glossary to Quiz..smile

English, French and German lang strings available.

Unfortunately, due to a bug in Moodle 2.0 the online help files & documentation page are unavailable for the M 2.0 version. Please vote for a quick resolution of bugs MDL-26072 and MDL-26064 which concern all blocks in Moodle 2.0

As usual, please report any bugs or remarks in this discussion (rather than in the Modules and Plugins database). This concerns all those currently testing Moodle 2.0.

Joseph

Average of ratings: Useful (1)
In reply to Joseph Rézeau

Re: Glossary items used in a quiz :: Block available for download

by Vlad Kuzba -

Joseph, the block download is not available, it has not been approved for download.

In reply to Vlad Kuzba

Re: Glossary items used in a quiz :: Block available for download

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Please wait for approval. I had forgotten that modules & plugins in the database need re-approval when changes are made (i.e. when I added the link to the 2.0 version)...

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz :: Block available for download

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Now approved.

Average of ratings: Useful (1)
In reply to Joseph Rézeau

Re: Glossary items used in a quiz :: Block available for download

by Tom Hogan -

This block is a lifesaver for us! We have many vocabulary books in use that we would otherwise have had to create questions for manually.

However, we are only able to create short answer questions. Multichoice does not seem to work.

This screenshot shows the block after configuration, note that question type is set to Multiple Choice. However, as the attached XML file shows, the block exports short answer instead!

(Not important, but:  )

I discovered an additional issue while trying to get this to work: sorting order does not matter to us, so initially I just left it at alphabetical. However, trying to see if changing options would help create the right question type, I changed sorting order. However, this option does not save properly. Again, the screenshot above was after I chose "random" as sorting order. It seems that, no matter what sorting order I choose, it reverts to alphabetical.

In reply to Tom Hogan

Re: Glossary items used in a quiz :: Block available for download

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Hi Tom,

Thanks trying out the Glossary to Quiz block.  I expect you tried it on a moodle 2.0 site, because the problems you describe do not happen in the 1.9 version of the block.

You are correct, there is a bug, I forgot to implement the multichoice question type export in the 2.0 version and will fix that bug (and the sort order bugs as well) ASAP and report here when fixed.

ATB

Joseph

EDIT.- Fixed. Please download latest version and test. Remember to visit Admin/Notifications after upgrading and watch for new version notification (2011012800).

In reply to Joseph Rézeau

Re: Glossary items used in a quiz :: Block available for download

by Guido Gautsch -

Hi Joseph,

I tried to import one of my glossaries in Moodle 2.0.2 to create a MCQ quiz but got this error when I tried to import the XML file:

Parsing questions from import file.

There are no questions in the import file

Import error

Any idea what could have happened there?

Cheers

Guido

Edit: I juxst tried with a smalled glossary (27 items) and it worked. The original one was 127 items. Must have been too much smile

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Vlad Kuzba -

Here goes the Czech translation, two versions, with/without diacritics.

In reply to Vlad Kuzba

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Hi Vlad,

Unfortunately the attached file is empty.

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Vlad Kuzba -

Oh yes, I forgot to recurse the directories in the ZIP file. Now it should be OK.

In reply to Vlad Kuzba

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Thank you. Will include your translation as soon as possible.

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Anthony Roberts -

Joseph,

I imagine you have moved well beyond troubleshooting the "Glossary items used in a quiz" in Moddle 1.9, but I am still having difficulty with it and would appreciate your assistance, if possible.

  • Everything seems to go smoothly through section B.5 in your instructions above.
  • When I select "upload this file", instead of seeing the questions displayed, I get the following message: "Parsing questions from import file. Importing 0 questions from file." And I can't seem to get beyond this point.
  • The Glossary I have exported does contain categories. I have tried exporting "*all entries (105)" [attached as Modern_Dance_Class_Glossary(6).xml"] and separate categories, but I still get the same result.

Thanks in advance for your time in letting me know what I am missing.

 

Thanks,

Anthony

In reply to Anthony Roberts

Re: Glossary items used in a quiz

by Anthony Roberts -

An additional note: After configuring the "Export to Glossary Quiz" and saving the changes, I do see the link with the correct number of glossary entries under the "Export to Glossary Quiz" block heading.

Anthony

Attachment Picture 2.png
In reply to Anthony Roberts

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Try the most recent version of that block (yours is older) :

Block Export Glossary to Quiz - Version 2011012900

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

The Glossary Export to Quiz block is now available on the new Moodle plugins repository at Glossary Export to Quiz. For Moodle 1.9 and 2.x.

The 2.x version now exports media (audio & images) embedded in the Glossary definitions.cool

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

The Moodle 2.5 version of block Glossary export to quiz is now available from the Moodle plugins database https://moodle.org/plugins/view.php?plugin=block_glossary_export_to_quiz

Non-English languages users are welcome to contribute to the translation of this add-on on AMOS. So far the following translations are available: French (complete), German (incomplete), Czech (incomplete).

A complete documentation (in English) is available in the Moodle Documentation Wiki here: http://docs.moodle.org/25/en/block/glossary_export_to_quiz/edit

Enjoy,

Joseph

In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

New version 2.5.1 (for Moodle 2.5) of block Glossary export to quiz is now available from the Moodle plugins database https://moodle.org/plugins/view.php?plugin=block_glossary_export_to_quiz

No changes to the interface but I finally managed to make my code 100% compliant with the Moodle Coding style recommendations.approve

Joseph

Average of ratings: Useful (3)
In reply to Joseph Rézeau

Re: Glossary items used in a quiz

by Daniel Tillman -

I am trying to use this addon, but am having problems with it. It is probably because I am using a PostgreSQL database rather than a MySQL database. This is the error that I am getting.

Debug info: ERROR: argument of AND must be type boolean, not type smallint

LINE 1: ..._glossary_entries ge WHERE ge.glossaryid = 1 AND ge.approve...

^

SELECT * FROM mdl_glossary_entries ge WHERE ge.glossaryid = 1 AND ge.approved ORDER BY concept ASC

[array (

)] Error code: dmlreadexception

Stack trace: line 423 of /lib/dml/moodle_database.php: dml_read_exception thrown

line 248 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()

line 753 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()

line 125 of /blocks/glossary_export_to_quiz/exportfile_to_quiz.php: call to pgsql_native_moodle_database->get_records_sql()

 

I am using the latest (as of 8/30) version of moodle and of this plugin. Moodle 2.5.1+ (Build: 20130823) Export Quiz to Glossary build 2013060900

In reply to Daniel Tillman

Re: Glossary items used in a quiz

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Daniel " It is probably because I am using a PostgreSQL database rather than a MySQL database."

That may well be the case. I need to re-install a PostgreSQL dabase on my local test site to find out and find a fix. But I'm going to be away from my base for a few days, so this will have to wait. Do message me if I forget!

Joseph

In reply to Vlad Kuzba

Re: Glossary items used in a quiz

by Vlad Kuzba -

Well after a few days of testing I'm glad to say that both the convertors work for me like a charm. The database solution is a little bit more difficult to set up, but it adds its value due to the multiple choice option.

Thank you bot very much, my students will now learn to be much more careful and precise when entering the glossary entries smile