import_sheet foreign key about django-excel HOT 4 CLOSED

yes, you will get it. Please reference import_data function where it imports data for two tables.

What you need to do is to write a custom constructor for choice, where you find the question and assign it to Choice.question.

from django-excel.

What if I need to save data to a table using 2 Foreign keys from different tables??
This is my model:

class SkuScore(models.Model):

    sku           = models.ForeignKey(Sku)
    month       = models.SmallIntegerField()
    year          = models.SmallIntegerField()
    customer  = models.ForeignKey(Customer)

There are two fields from different tables: Sku & Customer.
Is this code right?

        def other_keys(row):
            s = Sku.objects.filter(sku=row[0])[0]
            row[0] = s

            c = Customer.objects.filter(customer=row[2])[0]
            row[1] = c
            
            return row

I'm a bit confused about the row[x]

from django-excel.

The position x is indicated by your mapping dict.

from django-excel.

Thank you chfw!

from django-excel.