def export_row(self, row, row_number, excel_workbook, excel_sheet): owner_name = excel_sheet.cell(row, export_to_excel.getColumn(self.excel_map, 'owner')).value try: owner_object = Owner.select().where(Owner.owner == owner_name).get() if not owner_object.active: return except peewee.DoesNotExist: return last_updated_date = export_to_excel.get_excel_date_column(row, 'lastupdated', self.excel_map, excel_workbook, excel_sheet) row_data = { 'Owner': owner_object 'Company': excel_sheet.cell(row, export_to_excel.getColumn(self.excel_map, 'company')).value, 'FirstName': excel_sheet.cell(row, export_to_excel.getColumn(self.excel_map, 'firstname')).value, 'LastName': excel_sheet.cell(row, export_to_excel.getColumn(self.excel_map, 'lastname')).value, 'Subject': excel_sheet.cell(row, export_to_excel.getColumn(self.excel_map, 'subject')).value, 'ActivityType': excel_sheet.cell(row, export_to_excel.getColumn(self.excel_map, 'activitytype')).value, 'ActivityStatus': excel_sheet.cell(row, export_to_excel.getColumn(self.excel_map, 'activitystatus')).value, 'LastUpdated': last_updated_date[export_to_excel.CELL_DATE], 'LastUpdatedIsoWeek': last_updated_date[export_to_excel.CELL_ISO_WEEK], 'LastUpdatedIsoYear': last_updated_date[export_to_excel.CELL_ISO_YEAR], 'LastUpdatedIsoYearWeek': last_updated_date[export_to_excel.CELL_ISO_YEAR_WEEK_SLASH], 'RowNumber': row_number, 'SourceSpreadsheet': self.excel_spreadsheet, 'CrmEntity': 'Lead' } action = Action(**row_data) action.save()