Advanced search...

Forums

Search results: 17

WeBWorK Main Forum -> Get an error "The spreadsheet file report_grades.msg cannot be found. " -> Re: Get an error "The spreadsheet file report_grades.msg cannot be found. "

by Malcolm Harper -
If all that you want to do is prevent the error from appearing to students then
  • put an empty report_grades.msg file into the course's templates/email directory
  • put an empty report_grades_data.csv into the course's scoring directory
You would have to do this for every course, so perhaps it is better to do in the model courses.

WeBWorK Main Forum -> Get an error "The spreadsheet file report_grades.msg cannot be found. " -> Re: Get an error "The spreadsheet file report_grades.msg cannot be found. "

by Michael Gage -
It's an undocumented feature that was mostly used by me. Now-a-days I tend to use the moodle-webwork bridge one scheme and use the moodle gradebook so this feature has become somewhat redundant.

I'll try to write semi-complete documents up on the wiki -- but the idea is the same as if you send an email message to your students which merges grade information from the spreadsheet. (There are documents on how to do that.
see http://webwork.maa.org/wiki/A_day_in_the_life_of_a_WeBWorK_instructor#Sending_Email_to_Students )

If you save this email with file name: report_grades.msg then it gets picked up and displayed whenever a student views their grade in WeBWorK using the link in the upper left margin. (You don't actually have to send the email.). The email file is in the email directory, the corresponding merge file spreadsheet is in the scoring directory with the name specified in composing the email file.

What I've written above is essentially right, but I don't have time to check that I've gotten all the details right now. If someone gets this to work and feels like posting more detailed directions on the wiki please feel free to do so. I'll get to it eventually, but perhaps not that soon. :-)

-- Mike

WeBWorK Main Forum -> Get an error "The spreadsheet file report_grades.msg cannot be found. " -> Re: Get an error "The spreadsheet file report_grades.msg cannot be found. "

by Gavin LaRose -
Hi Pan,

I'm not an expert on this function, but I believe this is a mundane warning message. The WeBWorK system supports uploading additional grades to be included in the grades report, and I think this may be the message indicating that there is no such file.

Gavin

WeBWorK Main Forum -> Get an error "The spreadsheet file report_grades.msg cannot be found. " -> Re: Get an error "The spreadsheet file report_grades.msg cannot be found. "

by Pan Luo -
Additional information.

Screenshot attached. The message appears below the grades table.

Message is generated from /webwork/webwork2/lib/WeBWorK/ContentGenerator/Grades.pm
On line 96 in function scoring_info:
return "There is no additional grade information. The spreadsheet file $filePath cannot be found." unless -e "$scoringDirectory/$merge_file";

I'm guessing it's just some feature we're not using, does anybody know what it is?

Attachment webwork.png

Forum archive 2000-2006 -> Brian Camp - Bug 1133: Grading errors, submitting answers and not enough permissions

by Arnold Pizer -
inactiveTopicBug 1133: Grading errors, submitting answers and not enough permissions topic started 11/27/2006; 4:27:31 PM
last post 11/29/2006; 8:09:42 PM
userBrian Camp - Bug 1133: Grading errors, submitting answers and not enough permissions  blueArrow
11/27/2006; 4:27:31 PM (reads: 70, responses: 6)
Hi Mike,

I just ran into Bug 1133 however I am a little unclear on which file I should modify. [note: Bug 1133 essentially gives you a warning every time "submit answer" is clicked because WW 2.3 has some relative path issues]

You say in the bug report: <quote>

OK. I think I have it. There is an error in the global.conf.dist

 

# The transaction log contains data from each recorded answer submission. This
# is useful if the database becomes corrupted.
$webworkFiles{logs}{transaction}    = "$courseDirs{logs}/transaction.log";



The mismatch is that as currently defined the "transaction" logging facility is expected to be under the webworkDirs, not the courseDirs. The quick fix for now is to change courseDirs{logs} to webworkDirs{logs}.

Hopefully that will work. </quote>

I just want to be clear. Am I supposed to correct global.conf or global.conf.dist? I do not really understand CVS and so I am not sure of what the big difference between * and *.dist are (if they have anything to do with CVS at all).

Also, I am running into a related (?) issue. When I click the "grades" link under the Main Menu, I get a list of grades in a table and then some warnings underneath. Is this a bug or do I have some permissions set incorrectly?

Here are the errors (this is for a student with no permissions):

Error messages

Failed to open scoring file '/opt/webwork/courses/modelCourse-math240/scoring/report_grades_data.csv' for reading: No such file or directory

Call stack

The information below can help locate the source of the problem.

* in WeBWorK::File::Scoring::parse_scoring_file called at line 1962 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm
* in WeBWorK::ContentGenerator::read_scoring_file called at line 96 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/Grades.pm
* in WeBWorK::ContentGenerator::Grades::scoring_info called at line 53 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/Grades.pm
* in WeBWorK::ContentGenerator::Grades::body called at line 152 of /opt/webwork/webwork2/lib/WeBWorK/Template.pm
* in WeBWorK::Template::template called at line 480 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm
* in WeBWorK::ContentGenerator::content called at line 188 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm
* in WeBWorK::ContentGenerator::go called at line 338 of /opt/webwork/webwork2/lib/WeBWorK.pm

By the way, if the student logs out and then logs back in, there is still a record of the their score. And the instructor can see all of the past answers so this does not appear to be an issue of those records being kept. Is this truly an annoyance that the students may ignore (for now)?

Thanks in advance, Brian

<| Post or View Comments |>

userMichael Gage - Re: Bug 1133: Grading errors, submitting answers and not enough permissions  blueArrow
11/27/2006; 9:31:53 PM (reads: 62, responses: 0)
just want to be clear. Am I supposed to correct global.conf or global.conf.dist? I do not really understand CVS and so I am not sure of what the big difference between * and *.dist are (if they have anything to do with CVS at all).

Correct global.conf. Eventually we will figure out a permanent fix ( my vote is to move the log files so that they are stored under each course separately -- or else do more extensive modifications to the log writing subroutine so that one can choose on a course by course basis). When that happens we'll distribute the new "standard" configuration in global.conf.dist.

Whenever you update via CVS you will want to check changes in global.conf.dist and database.conf.dist etc. to see if you want to move those changes over to your local course. Because you have made local configuration choices in global.conf, database.conf etc. we don't want those choices automatically overridden when you update from CVS. You'll need to transfer any changes you think appropriate by hand.

 

Your second problem is a cosmetic bug (and a new one in the latest release) but your students can ignore it for now. The error message used to appear more friendly -- just indicating that you had not yet added any additional grades (besides the ones generated by WeBWorK).

I'll report the bug.

-- Mike

<| Post or View Comments |>

userBrian Camp - Re: Bug 1133: Grading errors, submitting answers and not enough permissions  blueArrow
11/27/2006; 11:47:31 PM (reads: 60, responses: 0)
Mike,

Changing my global.conf worked wonders. Thanks :)

Also, for the cosmetic problem, I have created an empty file called "report_grades_data.csv" in the scoring directory and that gets rid of the error messages. I guess I need to put this file in my modelCourse so that when I create courses from this template, the file is always there.

This works for now. I am mostly concerned about students reactions when they go to see their grades and they see a bunch of errors at the bottom. I am sure this will cause some students to be somewhat uneasy (!) about how they are doing.

Brian

<| Post or View Comments |>

userMichael Gage - Re: Bug 1133: Grading errors, submitting answers and not enough permissions  blueArrow
11/28/2006; 10:17:20 AM (reads: 52, responses: 0)
Glad that works. I've already submitted a bug report about the over alarming error message.

<| Post or View Comments |>

userBrian Camp - Re: Bug 1133: Grading errors, submitting answers and not enough permissions  blueArrow
11/29/2006; 12:35:52 AM (reads: 49, responses: 0)
[note: the following refers to webwork 2.3 with Apache 2.054 on Fedora Core 4]

For anyone needing a script to place multiple copies of a blank .csv file, I did the following. First, create a blank file called "report_grades_data.csv" (use vi, emacs, or whatever). I placed this file in the /opt/webwork/courses directory and then did the following:

 

$ cd /opt/webwork/courses
$ for each in /opt/webwork/courses/*/scoring; do ( cp report_grades_data.csv $each ) done

Also, here is another piece of information about this empty file "report_grades_data.csv" that I placed in the courses/scoring directory.

Today I went to create a simple email to send to a class with their student ID's (i.e. distributing their initial passwords as $SID). But the mail failed to send. Here is the error that I got:

No merge data file

Can't read merge file None. No message sent

I had not selected a merge file (not sure why I needed to really). But I noticed that in the drop down menu for "merge file" was listed the blank .csv file that I put in the scoring directory. So I decided to select it and send again (since it was the only option that I could select other than "None").

This time the email went through fine. Not sure how this is related but I thought it was interesting.

By the way, it does not seem to make a difference whether I try to send email only to selected students or to the whole class.

Thoughts?

<| Post or View Comments |>

userSam Hathaway - Re: Bug 1133: Grading errors, submitting answers and not enough permissions  blueArrow
11/29/2006; 11:11:52 AM (reads: 40, responses: 0)
This looks like a bug. I did some work on scoring file parsing recently and probably broke the special "None" case. I'll look into it.

 

$ cd /opt/webwork/courses
$ for each in /opt/webwork/courses/*/scoring; do ( cp report_grades_data.csv $each ) done

Use caution, this will replace any existing report_grades_data.csv file. You might want to add the -i switch to the cp command so you'll at least be prompted.
-sam

<| Post or View Comments |>

userSam Hathaway - Re: Bug 1133: Grading errors, submitting answers and not enough permissions  blueArrow
11/29/2006; 8:09:42 PM (reads: 33, responses: 0)
Hi,

I committed a fix for this problem to rel-2-3-dev. The fixed file is lib/WeBWorK/ContentGenerator.pm. Please update and test.
-sam

<| Post or View Comments |>