Hi,
Please help!! I'm going crazy trying to import a set of grades. I've read most documents and posts about this, and tried everything but to no avail...
My task is to move all courses/students from one site to another. The source site has Moodle 1.9.4+ (Build: 20090225), and the target site has Moodle 1.9.9+ (Build: 20100728). Just a few hours ago I finished installing and configuring Moodle at the target site, so the database was completely clean (without courses and without users, except for me as the only user).
With most courses the backup process went fine (same with the restore process); however, there were four courses in which the backup process froze, each and every time I tried (since yesterday). My solution was to make two backups for each course:
1. one in which I unmarked all the "user data" (right column from top section), and selected "no" to "user files" and "grade histories" (from the bottom section) --from what I understand, this will backup only the course material (by the way, if there is a document that explains in more detail how the different backup settings affect what is to be backed-up, I would be grateful if someone could make a reference to it, as I still don't get the relationship between the settings at the top and bottom sections).
2. another in which I unmarked all the includes from the left column, and selected "no" to "course files" and "site files", and "yes" to "user files" and "grade histories" --I assume this will backup only user info/data/grades.
/* 1. only course data
Left column: everything On/Right column: everything Off
Users: Course
Logs: No
User Files: No
Course files: Yes
Site files: Yes
Grade histories: No
/* 2. only user data
Left column: everything Off/Right column: everything On
Users: Course
Logs: No
User Files: Yes
Course files: No
Site files: No
Grade histories: Yes
With these settings the backup processes finished succesfully (well, in a couple of them the process stopped while moving the zip file to the backup folder, but I copied them directly from moodledata/temp, as they had been completely made).
But alas! When I restored both files (the "course only" one as a new course, and the "user only" one as added to an existing course), the grades weren't there; everything else seems to be Ok, except for the grades (I haven't checked other areas, to be true, but the course structure, material, groups and participants are there).
My first attempt was to export grades to an Excel file, which I then opened and saved as a CSV file. I imported this file, taking care of mapping "from email address" to "usermail", and the respective grade entries. Didn't work. Later I opened the CSV in a text editor to save in UTF-8 and retried the import, but once again it didn't work.
My next attempt was to make a backup with everything from the top section turned off, and only selecting "yes" for "grade histories" at the bottom section:
/* only grades
Left column: everything Off/Right column: everything Off
Users: Course
Logs: No
User Files: No
Course files: No
Site files: No
Grade histories: Yes
I restored this "grades only" file, and yet, all participants appear without their grades. I checked this backup file, and the grades are there, in an XML file (it is the only file in the zip; there are folders, but they are empy).
So... what can I do?? Please, help me preserve the little sanity I've still left!
Is there a a script that could insert data directly into the database? Or a special, magical plugin to solve this? Or maybe I'm missing some kind of step, procedure, configuration? I really need to solve this as soon as possible.
Thanks to all for any help you may give,
Guillermo M.