Raphael's Pflock

#!/usr/bin/python

import smtplib
import csv

# CONFIG
CSVFILE = "accounts.csv"
TEMPLATE = "mail_template.txt"

SENDER = '"Sender Name" <sender@example.com>'
SMTP_SERVER = 'smtp.example.com'

USE_TLS = 0 # for encrypted connection to SMTP server set to 1
AUTH_REQUIRED = 0 # if you need to use SMTP AUTH set to 1
SMTP_USER = 'sender'  # for SMTP AUTH, set SMTP username here
SMTP_PASS = 'pass'  # for SMTP AUTH, set SMTP password here

# You have to set the following two variables to 0 
# in order to actually send the e-mails to the recipients!
DRY_RUN = 1 # do not actually send e-mails but print what would have happened
SAFE_MODE = 1 # if set, all mails wil be sent to RECIPIENTS instead of the address specified in the csv file.
RECIPIENTS = ['sender@example.com']

template = open(TEMPLATE, "r")
csvfile  = open(CSVFILE, "r")

mail_template = template.read()
csv_reader = csv.reader(csvfile)

######## Open SMTP session ########
smtpresult = 0  # define it so we do not get an error during DRY_RUN
if not DRY_RUN:
    print "Opening SMTP session"
    session = smtplib.SMTP(SMTP_SERVER)
    #session.set_debuglevel(1)
    session.ehlo()
    if USE_TLS and session.has_extn("STARTTLS"): # not tested!
        session.starttls()
        session.ehlo()
    if AUTH_REQUIRED:
        session.login(SMTP_USER, SMTP_PASS)

######## Send Mails ########
for row in csv_reader:
    # adapt these fields to your needs
    surname = row[0]
    givenname = row [1]
    email = row[2]
    login = row[6]
    passwd = row[7] 
    # you might want to remove this part:
    if passwd == "":
        print "Skipping " + login + " - account already existed"
    else:
        print "Sending mail to " + email
        mssg = mail_template.replace("$NAME$", givenname + " " + surname)
        mssg = mssg.replace("$USERNAME$",login)
        mssg = mssg.replace("$PASSWORD$",passwd)
        if SAFE_MODE:
            recipients = RECIPIENTS
            mssg = mssg + "\r\nThis message would have been sent to " + email
        else:
            recipients = [email]
        if DRY_RUN:
            print "[DRY RUN] Sending mail to " + recipients[0]
            print mssg
        else:
            smtpresult = session.sendmail(SENDER, recipients, mssg)

        if smtpresult:
            errstr = ""
            for recip in smtpresult.keys():
                errstr = """Could not deliver mail to: %s

        Server said: %s
        %s

        %s""" % (recip, smtpresult[recip][0], smtpresult[recip][1], errstr)
            raise smtplib.SMTPException, errstr

From: "Raphael" <example@example.com>
Reply-to: test@example.com
Subject: [MT] Accounts

Hallo $NAME$,
Du erhältst mit dieser E-Mail deine Account-Daten für die Windows-Arbeitsplätze.
Beim ersten Login wirst Du aufgefordert, das Passwort zu ändern. 

Benutzername: $USERNAME$
Passwort: $PASSWORD$

Gruß,
Raphael 

Miller,Peter,miller@example.com,12,232445,Student,peter.miller,Zgsd.aSda