def _create_communication_dpoh(row):
lastname, firstname = clean.clean_last_and_first_name(row[1], row[2])
return db.CommunicationDPOH(
comlog_id=row[0],
dpoh_last_name=lastname,
dpoh_first_name=firstname,
dpoh_title=row[3],
branch_unit=row[4],
other_institution=row[5],
institution=row[6],
)
def _create_communication_registrant(row):
lastname, firstname = clean.clean_last_and_first_name(row[3], row[4])
return db.CommunicationRegistrant(
comlog_id=row[0],
client_num=row[1],
registrant_num=row[2],
registrant_last_name=lastname,
registrant_first_name=firstname,
com_date=datetime.strptime(row[5], TIME_FORMAT),
reg_type=row[6],
submission_date=datetime.strptime(row[7], TIME_FORMAT),
posted_date=datetime.strptime(row[8], TIME_FORMAT),
)
