import m2m relation in django-import-export

Question

use application django-import-export. Here is an example configuration for one of the models:

class ImportExportAdsTypeResource(resources.ModelResource):
    class Meta:
        model = AdType
        import_id_fields = ('name',)
        fields = ['name', 'active', 'position', 'categories', 'sites']

sites and categories - is a m2m field. Export works fine, we get such CSV file with the following contents:

name,active,position,sites,categories
Excport CSV test,1,13,1,"19,26"

but when you try to import m2m field are not added. How to import data with m2m relationships?!

[Here](https://github.com/django-import-export/django-import-export/issues/49) is an example with some code, so you can have an idea of the proper way of implementation. — pazitos10, Dec 08 '15 at 14:32
This partly helped me, but I'm still working on a complete solution — Алексей Стародубцев, Dec 09 '15 at 11:30

Dhia · Accepted Answer · 2018-04-10T09:10:17.040

11

django-import-export has it's own widgets to handle models relationships:

    from import_export import fields, resources
    from import_export.widgets import ManyToManyWidget

    class ImportExportAdsTypeResource(resources.ModelResource):
        categories = fields.Field(widget=ManyToManyWidget(Category))
        sites = fields.Field(widget=ManyToManyWidget(Site))

        class Meta:
            model = AdType
            import_id_fields = ('name',)
            fields = ['name', 'active', 'position', 'categories', 'sites']

Check here for other widgets: django-import-export Widgets

edited Apr 10 '18 at 09:10

answered Dec 12 '15 at 03:04

Dhia

10,119
11
58
69

1

For version `1.2.0` this worked without using `ManyToManyWidget`. Just add field in `fields` and import/export works fine. – Taranjeet Feb 07 '19 at 05:51

import m2m relation in django-import-export

1 Answers1

Linked