Marty Soupcoff

Im not a developer so can't help with writing code. However, i do have an alternative. I believe both Windows and OS X have the ability to print screen to PDF when you hit CRTL + P or CMD + P. If this is just for you, this may be sufficient. If this is for any teacher in your Moodle instance, then this may be too much because you will need to write instructions on how to do so. Another similiar alternative is researching the various add-ons and extensions available for the browser you use. I have heard of some that allow you to print your screen to PDF.

I don't understand. You don't want to publish the gradebook but you want the students to be able to see their grades?

Happy oodling!

You received the message of a successful upload because well it was successful in doing what you asked to import: nothing.

By ignoring the Grade item mapping section you had selected nothing to import. In the Grade item mapping section, leave everything to ignore that you do not mean to upload/update. For the things you want to upload/update, you need to either select to create a new grade item so these grades have somewhere to go or if you create a blank grade item before hand, select that grade item.

I wrote a step-by-step instruction process for doing this for my university. I can't give you access to my university's system but I have taken a screenshot with the exact instructions. See here.

In my instructions I detail on how you should first create the blank grade item, export your gradebook to excel, enter the grades into excel file and then upload CSV file. The reason I recommend that is so that during the upload process you already have the blank grade item created. You can then just select it in the Grade item mapping section. In addition, I recommend to export the Moodle gradebook so that you have the email address for each student in the excel file. You could technically have your own created excel file but then you have to make sure each email address is correct. If you misspell one then the mapping won't work. So in my mind, just pull the data that is already in Moodle since you are going to push it back that way.

Tip: In my directions I map from Email address to useremail. Technically there are other options. For my university's Moodle instance, we have a 9 digit numeric code entered in the ID number field. I recommend against using this though because if some of your student's ID numbers start with a zero, those may be removed from excel if you have the cells formatted as "numbers" instead of just "general text".

Further reading on topic - Moodle Docs

Happy oodling!

So I have never worked with MS Access before so I may be jumping way off base here but I thought I might throw out a possible solution.

First, you would need to create all the courses that you are looking to upload grades to. I'm not sure how big your institution is but this could be your first big pain point.

Second, you would have to create the users that aren't in your Moodle system. There are bulk options to do this. Inside your MS Access database you would need certain information for each student though (username, first & last name, etc.) If you have that info, it is fairly easy to then upload the CSV file to create their accounts. At the same time you create them though, you can include info on the course that you want them enrolled in. For example, Jane Smith is not in the system yet but I want her to be enrolled in ART 101. At the same time you create the account, you can have it enroll her in ART 101. In a way, it is combining two parts of the process.

Third, you can then upload the grades. This could be another pain point. I don't have access to the backend of our system nor do I have experience in databases. I'm assuming there is some way to do it on the backend but someone else would have to give you instructions on how to do that. If your institution is small, you could do it from the frontend but you would probably need to do it one course at a time.

If you have any questions, you can message me directly and I'll see what kind of advice I can offer.

Happy oodling!

I thought the vampire discussion was really starting to take off though. They were bringing up some good points.

Happy oodling!