Agora members list generator. Uses .csv as input

utils.py

#!/usr/bin/python2
# coding: utf-8

import csv
import codecs
import sys


class UTF8Recoder(object):
    """
    Iterator that reads an encoded stream and reencodes the input to UTF-8
    """
    def __init__(self, f, encoding):
        self.reader = codecs.getreader(encoding)(f)

    def __iter__(self):
        return self

    def next(self):
        return self.reader.next().encode("utf-8")


class UnicodeReader(object):
    """
    A CSV reader which will iterate over lines in the CSV file "f",
    which is encoded in the given encoding.
    """

    def __init__(self, f, dialect=csv.excel, encoding="utf-8", **kwds):
        f = UTF8Recoder(f, encoding)
        self.reader = csv.reader(f, dialect=dialect, **kwds)

    def next(self):
        row = self.reader.next()
        return [unicode(s, "utf-8") for s in row]

    def __iter__(self):
        return self


if __name__ == "__main__":
    print sys.argv[1]

    with open(sys.argv[1], 'rb') as fp:
        reader = UnicodeReader(fp)
        for row in reader:
            text = u"""<tr>
    <td><a href="mailto:{email}">{namn}</td>
    <td>{group}</td>
    <td align="center">{department}</td>
</tr>
""".format(namn=row[0], group=row[2], department=row[3], email=row[4])
            print text