importing xls file into modle with models.ForeignKey filed about django-import-export HOT 14 CLOSED

@grillazz fields from related models would not be imported automatically. I advise you to read Import data workflow to see which methods you can override if you need to populate related models.

from django-import-export.

thx @bmihelac will try this way

from django-import-export.

Actally. I don't need to populate related models. I just want to use related model Authors containing few records which I added first to populate books using author name not author id for author = models.ForeginKey(Authors,)
What you think @bmihelac ?

from django-import-export.

If I understand, your Book model has FK to Author and you would like to import this FK by author name and not pk?

from django-import-export.

Yup

from django-import-export.

Sublclassing and using ForeignKeyWidget should do the trick.

from django-import-export.

Not sure that below is ok. Think it is wokring just for export :/

class BookResource(resources.ModelResource):
    name = fields.Field(widget=widgets.ForeignKeyWidget(Author,))

    class Meta:
        model = Book
        fields = ('id', 'name',)
        pass

from django-import-export.

This one also i snot working for me

name = widgets.ForeignKeyWidget('Autor',)

from django-import-export.

I have something like this in my mind, this is totally untested

class MyForeignKeyWidget(ForeignKeyWidget):
     def clean():
         # return author  object for author name
     def render():
         # retur author name

class BookResource(resources.ModelResource):
    author = fields.Field(column_name='author', attribute='author', widget=widgets.MyForeignKeyWidget(Author,))

from django-import-export.

export was easy and working fine

   def render(self, value):
        return value.name

struggling with def clean() for imports

from django-import-export.

See how it is made in ForeignKeyWidget.

https://github.com/bmihelac/django-import-export/blob/master/import_export/widgets.py#L128

from django-import-export.

yup working

    def clean(self, value):
        t1 = super(widgets.ForeignKeyWidget, self).clean(value)
        return self.model.objects.get(name=t1) if t1 else None

from django-import-export.

I own you beer dude ;)
Cheers,

from django-import-export.

glad it worked :)

from django-import-export.