Athena Classlist Parsing Tool

...because your sectioning officer had better things to do

A small utility for converting Athena's 'Detailed Class List' into WebWork format by Jason Cantarella.

Getting the data from Athena

With the transition to Athena, we have a new procedure for converting your class rolls into WebWork format. First, log into Athena, and select 'Faculty Services'. Then choose 'Summary Class Roll'. You should see your course, under 'Course Information', and below it, a link marked 'CRN'. Click on the number next to 'CRN'. You should get a page called 'Detail Class List'.

We will use this page to generate your WebWork class roll. You'll notice that there is no helpful 'Download' link of any kind on this page. In your web browser (I use Chrome), select 'File->Save Page As' and choose a filename. You want to save the page as 'Webpage, HTML only' and NOT as 'Webpage, Complete'.

You will only get 30 students per page in this view, so you'll have to repeat the process for students 31-60, 61-90, and so on and so forth (if you have a large class). For calculus instructors with no overloads, you should only have two pages to find and save: 1-30, and 31-40.

Processing the data

Click the 'Choose file' button below, and select your HTML file. Then select a format for the output and click the 'Process data' button. The data will appear below the horizontal line: copy and paste it into your favorite text editor and save it.

  1. To import your data into WebWork, choose the 'WebWork classlist format', and save your text file with the extension .lst (that's 'list', not 'first'). In WebWork,

    1. Go to 'File Manager' and select 'Choose file'.

    2. Find your file and click 'Upload'. You should get a green bar that says 'myfile.lst uploaded successfully' (or whatever your filename is).

    3. Go to 'Classlist Editor2', choose 'Import', and select your file from the drop-down menu. (If you didn't choose the right extension, (.lst) for your file, it won't appear in this drop-down.)

    4. Click 'Take Action'.

    It's ok to do this several times as your classlist changes with different files. As long as you have 'Replace which users?' set to 'no users', you won't mess up your existing students. Note: If you're teaching several sections, you can text replace the word 'section' or 'recitation' in the text editor to distinguish different classes in WebWork.

  2. To get a list of names and emails only, compatible with gmail's 'Import Contacts from CSV' function, choose 'Name and Email'. You should save this file with the extension '.csv' to be imported into gmail. For further instructions, google 'import contacts into gmail from csv'.

  3. 'Anki Card Format' is another choice of format. I use a flashcard program called 'Anki' to memorize my students' names from photos. Anki is too complicated to explain here, but this format will make template cards for you. Note that you'll have to save the file with the extension '.txt' in order to import it into Anki.

  4. 'CSV containing all data' includes all the data I was able to scrape from the HTML file (so far). I'm not sure what you'll use it for, but that's everything I have.

For most of these file types, you can repeat the process for the other HTML files you've saved, just adding the new lines to the text file. Beware the gmail format, which has a header line 'First Name, Last Name, Email Address'. You'll need to delete that where it occurs in the middle of the file.

Data Security

Your uploaded file is deleted as soon as it is converted, so none of your data is stored on the server. However, you should take care with the data on your end. Close the browser window when you're done downloading, and make sure that the HTML file and the classlist (.lst) file are deleted after you're done with this process.





Last modified: Fri Aug 15 09:47:34 EDT 2014