README
Chu Shao
Jan 1, 2013
cshao@eng.ucsd.edu

HEROKU WEBAPP VERISON:
http://gradesource-uploader.herokuapp.com/

REQUIREMENTS:
Python 2.7.x
This will not work on Python3++ and is untested for anything besides Python 2.7.x

Usage:
This python script is used to mass import grades into Gradesource.
It has four functions: 
- Download student name and email into a CSV file (CSV format: Name, Email)
- Download student name and PID (for iClicker usage) into a CSV file (CSV format: Last Name, First Name, Email)
- Send a CSV file to Gradesource to update a certain score using PID (CSV format, PID, Score)
- Send a CSV file to Gradesource to update a certain score using Email (CSV format: Email, score)


To find the course ID:
Login to Gradesource.
Click on edit course.
In the URL it should be https://www.gradesource.com/editcourse.asp?id=XXXXX
the number after id= is your course ID

To find the assignment ID:
Login to Gradesource.
Click on Scores.
Find the Assignment that you would like to modify.
In the URL it should be https://www.gradesource.com/editscores1.asp?id=XXXXXX
the number after id= is your assignment ID

To use: 
To download student name and email (don't forget to use quotes):

python -c 'import gradesourceuploader; gradesourceuploader.downloadEmail(login, courseID)'
EXAMPLE: 
python -c 'import gradesourceuploader; gradesourceuploader.downloadEmail("cshao", "99999")'

To download student name and PID (don't forget to use quotes and mainly for iClicker)
python -c 'import, gradesourceuploader; gradeseourceuploader.downloadiClicker(login, courseID)'
EXAMPLE:
python -c 'import gradesourceuploader; gradesourceuploader.downloadiClicker("cshao", "99999")'

The overwrite feature is to overwrite 0s. If Overwrite is set to 1, then 0s will be treated as 0s and when sent to gradesource, they will overwrite
the previous score wit ha 0. If Overwrite is set to 0, then 0 will be treated as null and when sent to gradesource, they will not overwrite the previous score.


To upload scores from a CSV file using email:
python -c 'import gradesourceuploader; gradesourceuploader.updateScoresByEmail(login, courseID, assignmentID, CSVFile, overwrite)'
EXAMPLE:
python -c 'import gradesourceuploader; gradesourceuploader.updateScoresByEmail("cshao", "99999", "111111", "grades.csv", "0")'

the CSV file should contain
email@email.com,score
score can be empty as well

To upload scores from a CSV file using PID:
python -c 'import gradesourceuploader; gradesourceuploader.updateScoresByPID(login, courseID, assignmentID, CSVFile, overwrite)'
EXAMPLE:
python -c 'import gradesourceuploader; gradesourceuploader.updateScoresByPID(login, courseID, assignmentID, CSVFile, "1")'

####NOTE####
MAKE SURE THE CSV CONTAINS EVERY EMAIL FROM GRADESOURCE FOR THAT ACCOUNT.
AN EASY WAY IS TO GENERATE THE CSV  DOCUMENT AND THEN REMOVE THE FIRST COLUMN AFTER DONE INPUTTING GRADES


See sample.csv for example of updateScores