def import_xlsx(filename):
prepare_stdout()
wb = load_workbook(filename=filename)
sheet = wb.get_sheet_by_name(name='Sheet1')
sheet.get_highest_column()
sheet.get_highest_row()
sheet.cell(row=1, column=1)
data = sheet.range(sheet.calculate_dimension())
headers = [v.value for v in data[0]]
for row in data[1:]:
vals = [str(v.value).strip() for v in row]
sys.stdout.write('\r ID=%s' % vals[0])
m = MuseumObject()
m.id = vals[0]
m.registration_number = vals[0]
m.old_registration_number = vals[1]
m.other_number = vals[2]
m.functional_category, c = FunctionalCategory.objects.get_or_create(
name=vals[3])
m.artefact_type, c = ArtefactType.objects.get_or_create(name=vals[4])
m.storage_section = vals[5]
m.storage_unit = vals[6]
m.storage_bay = vals[7]
m.storage_shelf_box_drawer = vals[8]
if vals[9] != 'None':
sys.stdout.write(' Acq_date=%s' % vals[9])
m.acquisition_date = vals[9].split(' ')[0]
m.access_status, c = AccessStatus.objects.get_or_create(
status=vals[10])
m.description = vals[11]
m.comment = vals[12]
region = vals[13]
state = vals[14]
m.acquisition_method, c = AcquisitionMethod.objects.get_or_create(
method=vals[15])
m.loan_status, created = LoanStatus.objects.get_or_create(
status=vals[16])
country = vals[17]
place = vals[18]
m.place, created = Place.objects.get_or_create(name=place,
australian_state=state,
region=region,
country=country)
m.cultural_bloc, c = CulturalBloc.objects.get_or_create(name=vals[19])
photographic_record = vals[20]
m.collector, created = Person.objects.get_or_create(name=vals[21])
m.when_collector_obtained = vals[22]
m.how_collector_obtained, created = Obtained.objects.get_or_create(
how=vals[23])
m.donor, created = Person.objects.get_or_create(name=vals[24])
# All empty when_obtained = vals[25]
# All empty how_obtained = vals[26]
# All empty category_illustration = vals[27]
# All empty artefaction_illustration = vals[28]
m.raw_material = vals[29]
m.indigenous_name = vals[30]
m.assoc_cultural_group = vals[31]
m.recorded_use = vals[32]
if vals[33]:
m.maker, created = Maker.objects.get_or_create(name=vals[33])
def mapint(attr, val):
try:
setattr(m, attr, int(val))
except ValueError:
pass
mapint('length', vals[34])
mapint('width', vals[35])
mapint('depth', vals[36])
mapint('circumference', vals[37])
mapint('weight', vals[38])
m.save()
set_categories(m)
set_photographic_record(m, photographic_record)
