Importing into Moodle

Re: Importing into Moodle

by Ule Hacker -
Number of replies: 0
After having difficulties importing, because there were utf characters, which moodle seemed not to like in Version 1.9, and I do not want to use Microsoft Office products anymore, I came up with a copy / paste solution, which seems to work without flaws.
You need:
  1. openoffice Calc
  2. Yasu Imao's Moodle glossaryXMLconverter_html
  3. MIcrosoft XML Notepad (free download but needs net2)
Using other languages than English in Moodle, makes it often tricky to get out of the trouble. This is my solution:
  1. Start openoffice Calc with an empty table
  2. Start glossaryXMLconverter_html in your Browser (Firefox/IE7 or whatever)
  3. Start MIcrosoft XML with an empty file
  4. Write your list into openoffice Calc columns A B (C D)*
  5. Select the entries and CTRL-C to copy the list
  6. Switch to the Browser
  7. Paste with CTRL-V the list into the left window
  8. Click CONVERT
  9. Copy the entire converted list in the right window with CTRL-A CTRL-C
  10. Switch to Microsoft XML Notepad
  11. Paste with CTRL-V the list into the right editor field
  12. Save the file (xxx.xml)
What the last two steps do for you is, the editor seems to convert the characters properly into the html format. If you try to write e.g. : »this …never would work« and only copy the from glossaryXMLconverter_html converted xml file into a normal editor, Moodle would fail later.