Как передать данные выпадающего поля через лист excel в django?

exel sheet import page

это моя модель

class Items(models.Model):

model_no= models.CharField(max_length=30,null= True)
description=models.CharField(max_length=50,null= True )
total_qty=models.PositiveIntegerField(default=0,null=True)
created = models.DateTimeField(default=datetime.now())

class ItemDetails(models.Model): STATUS = [ ('In-Stock', 'In-Stock'), ('Out-of-Stock', 'Out-of-Stock'), ('issued-to', 'issued-to') ] serial_no = models.CharField(max_length=50,null=True) tag_no = models.CharField(max_length=50, null=True) rem_qty = models.IntegerField(default=0) status = models.CharField(max_length=30, default='In-stock', choices=STATUS) model_no=models.ForeignKey(Items,on_delete= models.CASCADE) issued_to =models.ForeignKey(Prosecutions,on_delete=models.CASCADE) имя_сотрудника = models.CharField(max_length=50,null=True) назначение_сотрудника = models.CharField(max_length=50, null=True) created = models.DateTimeField(default=datetime.now())

def excel_import_item_details_db(request): try: if request.method == 'POST' and request.FILES['myfile']: myfile = request.FILES['myfile']. fs = FileSystemStorage() filename = fs.save(myfile.name, myfile) uploaded_file_url = fs.path(filename) itemdetailsexceldata = pd.read_csv(uploaded_file_url, sep=",", encoding='utf-8') dbframe = itemdetailsexceldata для dbframe в dbframe.itertuples(): if ItemDetails.objects.filter(serial_no = dbframe.serial_no).exists(): messages.warning(request, dbframe.serial_no + "уже существует в базе данных") else: obj = ItemDetails.objects.create(serial_no=dbframe.serial_no,tag_no=dbframe.tag_no,status=dbframe.status, Items_model_no=dbframe.model_no, Prosecutions_issued_to=dbframe.issued_to, employee_name=dbframe.employee_name,employee_designation=dbframe.employee_designation) obj.save() filename = fs.delete(myfile.name) calc_total_qty() messages.success(request, "New Items uploaded to Database") #return render(request, 'excel_import_db.html', {'uploaded_file_url': uploaded_file_url}) return render(request, 'add_items_details.html', {}) except Exception as identifier: print(identifier) return render(request, 'add_items_details.html', {})

Вернуться на верх