Since the database module was introduced, I have periodically tried, on several versions of moodle, over the course of about one year, to import entries into the database using a text file. It has never worked, and I have usually asked a few questions and then ended up giving up on it. I have tried every conveivable combination of CSV including enclosed, unenclosed, simple comma separation, and even copied the example in the help file but nothing has worked. I therefore have the following questions.
1) Has anybody on here ever successfully imported a text file into a database using moodle?
2) If so, what was the file encoding (Unicode?, UTF-8, . . . ) and exact format of the file (comma separation? enclosed?).
3) Did the successfully imported file simply contain English? If so, has anybody imported a file other than English (my files contain Japanese and English).
4) Have most people, as I suspect, ended up bypassing this function and ended up inserting the entries directly into the database via php admin or some similar approach?