{"id":57,"date":"2008-01-18T17:20:15","date_gmt":"2008-01-18T22:20:15","guid":{"rendered":"http:\/\/blogs.cae.tntech.edu\/mwr\/2008\/01\/18\/getting-an-email-list-for-your-class-from-web-for-faculty\/"},"modified":"2024-10-27T14:26:19","modified_gmt":"2024-10-27T14:26:19","slug":"getting-an-email-list-for-your-class-from-web-for-faculty","status":"publish","type":"post","link":"https:\/\/sites.tntech.edu\/renfro\/2008\/01\/18\/getting-an-email-list-for-your-class-from-web-for-faculty\/","title":{"rendered":"Getting an email list for your class from Web For Faculty"},"content":{"rendered":"

For all the improvements Web For Faculty\/Advisors may have over the old SIS system, it sure doesn’t make it easy to generate an email list from your class roll. I can see who’s in my class, click on a flagrant abuse of the HTML select element to see their permanent address, phone numbers, off-campus email address, and other such information, but if I actually want to use my class roll as data<\/strong> in some other application, I’m pretty well screwed. I seem to recall a procedure buried somewhere on the old SIS system that would generate a comma-separated file of student names, email addresses, or something similar, and I’d use those to make a spreadsheet for recording grades for the semester. There doesn’t seem to be such a feature in Web For Faculty\/Advisors.<\/p>\n

But since I’m far too lazy to type them all in myself, and I don’t have a grader or other underling to task with it, here’s what I did:<\/p>\n

    \n
  1. Find your class roll, and then click on the “Send E-mail to Class” link.<\/li>\n
  2. This will bring up a page with a link of the form “E-mail Group: Lastname1, Firstname1 Middlename1 to LastnameN, FirstnameN MiddlenameN”. This is a fairly clever mailto: link that puts all the students on a BCC list. Mind you, this doesn’t look like it will work in Thunderbird, since WFF formats the spaces after each comma as a %20 instead of an actual space, so the second through Nth email address are all of the form “%20FMLastname21@tntech.edu”, but since I’m not going to actually hand this list to an email client, that’s ok by me.<\/li>\n
  3. Right-click that link in Firefox, and select “Copy Email Address”.<\/li>\n
  4. Open up your trusty Unix-style shell prompt (you do run MacOS X, Cygwin, or have an account on a Unix\/Linux\/BSD system somewhere, right? If not, can’t really help you here), and type the following command:
    \ncut -d= -f2- | sed 's\/, \/\\n\/g' | cut -d@ -f1 | sed 's\/[0-9]\/\/g'<\/code>
    \n(What? You mean it’s not obvious what that does? Ok. First, it cuts off everything before the first = sign, global search\/replaces all ‘, ‘ strings with a newline, cuts off everything after the @ symbol, and deletes all numbers.)<\/li>\n
  5. After you’ve typed that command, hit Enter and then paste in the copied email addresses.<\/li>\n
  6. Hit Enter again. Watch the reformatted student names fly by.<\/li>\n
  7. Copy\/paste the names into whatever file you want.<\/li>\n
  8. (Optional) Marvel that your class information is held in a form that’s almost, but not quite, entirely unlike<\/a> something useful.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    For all the improvements Web For Faculty\/Advisors may have over the old SIS system, it sure doesn’t make it easy to generate an email list from your class roll. I can see who’s in my class, click on a flagrant abuse of the HTML select element to see their permanent address, phone numbers, off-campus email … <\/p>\n

    Continue reading “Getting an email list for your class from Web For Faculty”<\/span><\/a><\/p>\n","protected":false},"author":87,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-57","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/posts\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/users\/87"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/comments?post=57"}],"version-history":[{"count":1,"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":475,"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/posts\/57\/revisions\/475"}],"wp:attachment":[{"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/media?parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/categories?post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.tntech.edu\/renfro\/wp-json\/wp\/v2\/tags?post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}