(Message inbox:1022)
MessageName: (Message inbox:1022)

Date:    Fri, 25 Aug 2000 14:28:43 CDT
To:      "E. H. Johston" <johnston@math.iastate.edu>
cc:      all@math.iastate.edu

From:    "Roger Alexander, ISU Math Dept" <alex@iastate.edu>
Subject: Re: Class Lists 
-------------------------------------------------------------------------------


"E. H. Johston" sez:

=> Class lists are now available at Access Plus.  These lists contain links 
=> for further
=> information about each student and can be downloaded.  The address is
=> 
=> http://www.adp.iastate.edu/accessplus.html

Thanks, Elgin, for publicizing this!

	ADP assumes we all keep our records in obscure PC software package
files.  For u*ix users here's an awk program that grabs names from the
downloaded class list and creates an ASCII text roster in the format I use.
You can easily customize it to format additional desired information for
you.

Cheers,
Roger Alexander

                             o /
--------------Cut Here------- X --snip snip------------------------------
                             o \                                         


# setup.awk -- Creates a class roster file 
#              from the AccessPlus download.
#
# Usage: Save the AccessPlus class list in a file "roster".
#        Then
#
#        % sed 's/"//g' roster | gawk -f setup.awk  >roster.txt
#
# (sed deletes all double-quotes that begin and terminate fields.)

#     Fields are separated by commas

BEGIN { FS = "," }

#     First, Middle and Last names are fields 21-23. 
#     Strip trailing blanks from names. 
#     Create a blank record for this student.

$1 ~ "FALL"  { sub(/\ *$/,"",$21)
               sub(/\ *$/,"",$22)
               sub(/\ *$/,"",$23)
               printf("%s, %s %s\t\tCode:\n",$23,$21,$22) 
               printf("  In-Class:\n  Quizzes:\n  Projects:\t\tExams:\n\n")
             }

END { printf("ZzzLow, Aaa\t\tCode: ZzzMin A-\n")
      printf("  In-Class:\n  Quizzes:\n  Projects:\t\tExams:\n\n")
      printf("ZzzLow, Bbb\t\tCode: ZzzMin B-\n")
      printf("  In-Class:\n  Quizzes:\n  Projects:\t\tExams:\n\n")
      printf("ZzzLow, Ccc\t\tCode: ZzzMin C-\n")
      printf("  In-Class:\n  Quizzes:\n  Projects:\t\tExams:\n\n")
      printf("ZzzLow, Ddd\t\tCode: ZzzMin D-\n")
      printf("  In-Class:\n  Quizzes:\n  Projects:\t\tExams:\n\n")
    }