def export(flg_ids, stichtag, mail):
"""This should be the "shared" export function.
"""
from z3c.saconfig import Session
session = Session()
book, adressen, rc = getXLSBases()
flg_ids = [x for x in flg_ids]
createRows(session, rc, flg_ids, stichtag)
fn = "/tmp/fortbildung_%s.csv" % stichtag.strftime('%Y_%m_%d')
#for z, line in enumerate(rc):
# tt= [unicode(cell).encode('utf-8') for cell in line]
# print ';'.join(tt)
# print line
# adressen.append([cell for cell in line])
#print "Writing File %s" % fn
#book.save(fn)
import csv
with open(fn, 'wb') as csvfile:
writer = UnicodeWriter(csvfile)
for line in rc:
writer.writerow(line)
fn = makeZipFile(fn)
text=u"Bitte öffen Sie die Datei im Anhang"
import transaction
with transaction.manager:
send_mail('*****@*****.**', (mail,), "Versandliste Fortbildung", text, [fn,])
return fn
def export(flg_id, dateiname, mail):
"""This should be the "shared" export function.
"""
session = Session()
book, adressen = getXLSBases()
createSpalten(adressen)
createRows(book, adressen, session, flg_id)
fn = "/tmp/%s" % dateiname
xls_file = open(fn, 'w+')
book.save(xls_file)
xls_file.close()
fn = makeZipFile(fn)
text=u"Bitte öffen Sie die Datei im Anhang"
import transaction
with transaction.manager as tm:
send_mail('*****@*****.**', (mail,), "Fortbildung Datenquelle", text, [fn,])
return fn
def export(flg_id, mail):
"""This should be the "shared" export function.
"""
from z3c.saconfig import Session
session = Session()
fn = "/tmp/statusliste_%s.xlsx" % flg_id
book, adressen, rc = getXLSBases()
createRows(rc, session, flg_id)
with open(fn, 'wb') as csvfile:
writer = UnicodeWriter(csvfile)
for line in rc:
writer.writerow(line)
fn = makeZipFile(fn)
text=u"Bitte öffen Sie die Datei im Anhang"
import transaction
with transaction.manager:
send_mail('*****@*****.**', (mail,), "Statusliste", text, [fn,])
return fn