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