def import_just_standard_test(self, test=None):
inserted = 0
msg = ""
try:
sheet = self.book.sheet_by_index(0) # Just get the first one
inserted = self.import_standard_test(sheet, test)
msg += "%s standard tests inserted <br/>" % (inserted)
except: pass
if msg == "":
msg = "No files found. Check if sheets are named correctly. "
msg += unicode(self.errors) + " error(s). "
filename = 'import_error.xls'
if len(self.error_data):
report = XlReport()
save = False
for key, error_page in self.error_data.items():
if len(error_page):
save = True
report.add_sheet(error_page, header_row=self.error_titles[key][0], title=key)
if save:
report.save(filename)
else:
filename = None
return msg, filename
def import_just_standard_test(self, test=None):
inserted = 0
msg = ""
try:
sheet = self.book.sheet_by_index(0) # Just get the first one
inserted = self.import_standard_test(sheet, test)
msg += "%s standard tests inserted <br/>" % (inserted)
except:
pass
if msg == "":
msg = "No files found. Check if sheets are named correctly. "
msg += unicode(self.errors) + " error(s). "
filename = 'import_error.xls'
if len(self.error_data):
report = XlReport()
save = False
for key, error_page in self.error_data.items():
if len(error_page):
save = True
report.add_sheet(error_page,
header_row=self.error_titles[key][0],
title=key)
if save:
report.save(filename)
else:
filename = None
return msg, filename
def magic_import_everything(self):
"""Import a workbook using sheet names to determine what to import"""
self.make_log_entry()
inserted = 0
updated = 0
msg = ""
sheet = self.get_sheet_by_case_insensitive_name("standard test")
if sheet:
inserted = self.import_standard_test(sheet)
msg += "%s standard tests inserted <br/>" % (inserted)
sheet = self.get_sheet_by_case_insensitive_name("alumni note")
if sheet:
inserted, updated = self.import_alumni_note(sheet)
msg += "%s alumni note entries inserted,<br/>" % (inserted, )
sheet = self.get_sheet_by_case_insensitive_name("alumni email")
if sheet:
inserted, updated = self.import_alumni_email(sheet)
msg += "%s alumni email inserted,<br/>" % (inserted, )
sheet = self.get_sheet_by_case_insensitive_name("alumni number")
if sheet:
inserted, updated = self.import_alumni_number(sheet)
msg += "%s alumni numbers inserted,<br/>" % (inserted, )
sheet = self.get_sheet_by_case_insensitive_name("college enrollment")
if sheet:
inserted, updated = self.import_college_enrollment(sheet)
msg += "%s college enrollments inserted, %s college enrollments updated. <br/>" % (
inserted, updated)
if msg == "":
msg = "No files found. Check if sheets are named correctly. "
msg += unicode(self.errors) + " error(s). "
filename = 'import_error.xlsx'
if len(self.error_data):
self.log.errors = True
self.log.save()
report = XlReport()
save = False
for key, error_page in self.error_data.items():
if len(error_page):
save = True
report.add_sheet(error_page,
header_row=self.error_titles[key][0],
title=key)
if save:
report.save(filename)
else:
filename = None
return msg, filename
def magic_import_everything(self):
"""Import a workbook using sheet names to determine what to import"""
self.make_log_entry()
inserted = 0
updated = 0
msg = ""
sheet = self.get_sheet_by_case_insensitive_name("standard test")
if sheet:
inserted = self.import_standard_test(sheet)
msg += "%s standard tests inserted <br/>" % (inserted)
sheet = self.get_sheet_by_case_insensitive_name("alumni note")
if sheet:
inserted, updated = self.import_alumni_note(sheet)
msg += "%s alumni note entries inserted,<br/>" % (inserted,)
sheet = self.get_sheet_by_case_insensitive_name("alumni email")
if sheet:
inserted, updated = self.import_alumni_email(sheet)
msg += "%s alumni email inserted,<br/>" % (inserted,)
sheet = self.get_sheet_by_case_insensitive_name("alumni number")
if sheet:
inserted, updated = self.import_alumni_number(sheet)
msg += "%s alumni numbers inserted,<br/>" % (inserted,)
sheet = self.get_sheet_by_case_insensitive_name("college enrollment")
if sheet:
inserted, updated = self.import_college_enrollment(sheet)
msg += "%s college enrollments inserted, %s college enrollments updated. <br/>" % (inserted, updated)
if msg == "":
msg = "No files found. Check if sheets are named correctly. "
msg += unicode(self.errors) + " error(s). "
filename = 'import_error.xlsx'
if len(self.error_data):
self.log.errors = True
self.log.save()
report = XlReport()
save = False
for key, error_page in self.error_data.items():
if len(error_page):
save = True
report.add_sheet(error_page, header_row=self.error_titles[key][0], title=key)
if save:
report.save(filename)
else:
filename = None
return msg, filename
