django-import-export | Django application library | CSV Processing library

 by   django-import-export Python Version: 4.0.9 License: BSD-2-Clause

kandi X-RAY | django-import-export Summary

kandi X-RAY | django-import-export Summary

django-import-export is a Python library typically used in Utilities, CSV Processing applications. django-import-export has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has high support. You can install using 'pip install django-import-export' or download it from GitHub, PyPI.

Django application and library for importing and exporting data with admin integration.

            kandi-support Support

              django-import-export has a highly active ecosystem.
              It has 2685 star(s) with 746 fork(s). There are 66 watchers for this library.
              There were 10 major release(s) in the last 6 months.
              There are 82 open issues and 828 have been closed. On average issues are closed in 955 days. There are 5 open pull requests and 0 closed requests.
              It has a positive sentiment in the developer community.
              The latest version of django-import-export is 4.0.9

            kandi-Quality Quality

              django-import-export has 0 bugs and 0 code smells.

            kandi-Security Security

              django-import-export has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
              django-import-export code analysis shows 0 unresolved vulnerabilities.
              There are 0 security hotspots that need review.

            kandi-License License

              django-import-export is licensed under the BSD-2-Clause License. This license is Permissive.
              Permissive licenses have the least restrictions, and you can use them in most projects.

            kandi-Reuse Reuse

              django-import-export releases are available to install and integrate.
              Deployable package is available in PyPI.
              Build file is available. You can build the component from source.
              It has 5849 lines of code, 667 functions and 63 files.
              It has low code complexity. Code complexity directly impacts maintainability of the code.

            Top functions reviewed by kandi - BETA

            kandi has reviewed django-import-export and discovered the below as its top functions. This is intended to give you an instant insight into django-import-export implemented functionality, and help decide if they suit your requirements.
            • Implementation of import
            • Returns the class attribute of the confirm import form
            • Returns the import form
            • Creates a confirmation form
            • Process import form
            • Implementation of import_data
            • Processes a dataset
            • Process result
            • Show the changelist view
            • Adds the admin url to the admin view
            • Returns widget for m2m field
            • Check if tablib format is available
            • Format the value
            • Returns the keyword arguments passed to the form
            • Include the changelist view
            • Render a value
            • Return a decoded value
            • Return the value for the widget
            • Exports resources
            • Cleans the queryset
            • Return the admin url
            • Get an instance from a row
            • Returns an instance of the given row
            • Creates a widget for the given field
            • Saves data to object
            • Reset all rows from the database
            Get all kandi verified functions for this library.

            django-import-export Key Features

            No Key Features are available at this moment for django-import-export.

            django-import-export Examples and Code Snippets

            Dehydrate the same field django
            Pythondot img1Lines of Code : 11dot img1License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            class ClassResource(resources.ModelResource):
                class Meta:
                    model = Class
                    fields = ('student__name', 'student__lastname')
                name = Field(
            copy iconCopy
            from import_export.widgets import ManyToManyWidget
            class BinResource(ModelResource):
                item = Field(
                    widget=ManyToManyWidget(Category, field='part_number',
            Django import-export, only export one object with related objects
            Pythondot img3Lines of Code : 16dot img3License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            class ReferenceResource(resources.ModelResource):
                def __init__(self, customer_id):
                    self.customer_id = customer_id
                def get_queryset(self):
                    qs = Customer.objects.filter(
            foreign key in django-import-export
            Pythondot img4Lines of Code : 16dot img4License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            class StudentResource(resources.ModelResource):
                def __init__(self, *args, **kwargs):
                    self._institution=kwargs.pop('institution', None)
                    super().__init__(*args, **kwargs)
                def be
            Select which fields to export in django-import-export
            Pythondot img5Lines of Code : 30dot img5License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            class BookResource(ModelResource):
                class Meta:
                    model = Book
                def __init__(self, form_fields=None):
                    self.form_fields = form_fields
                def get_export_fields(self):
                    return [
            How to capture a field instance during django-import-export upload
            Pythondot img6Lines of Code : 14dot img6License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            class ImportStudentsResource(resources.ModelResource):
                def __init__(self, school_id):
                    self.school_id = school_id
                def before_save_instance(self, instance, using_transactions, dry_run):
            Django-import-export problem importing foreignkey field
            Pythondot img7Lines of Code : 43dot img7License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            class SitePartResource(resources.ModelResource):
                system_no = fields.Field(
            How to get file from django-import-export?
            Pythondot img8Lines of Code : 6dot img8License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            class BookResource(resources.ModelResource):
                def before_import(self, dataset, using_transactions, dry_run, **kwargs):
                    for row in dataset.dict:
            Django model: Generate series number for each identifier upon saving the model
            Pythondot img9Lines of Code : 18dot img9License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            def save(self, *args, **kwargs): 
                data_counter = Item.objects.filter(location=self.location).aggregate(counter=Count('id'))['counter'] # Count existing instance with matching "location id" of the new instance
                if is None and
            How to solve MultipleObjectsReturned with ForeignKeywidget in django-import-export
            Pythondot img10Lines of Code : 5dot img10License : Strong Copyleft (CC BY-SA 4.0)
            copy iconCopy
            Jaq / class 2
            Lucy / class 2
            # only 1 can have 2 as its a ForeignKey
            # same error will happen in stream row 4 Eagle 2 Hawk

            Community Discussions


            TypeError: __init__() got an unexpected keyword argument 'export_job'
            Asked 2022-Mar-08 at 16:36

            I am implementing an export function with django-import-export-celery and the instructions are only three steps. I followed all of them, and when I try to do an export, it gives me an error on the celery process:

            This is what my code looks like:



            Answered 2022-Mar-04 at 08:38

            You have to make a migrate. Django doesn't recognize "export_job" until you make a migrate.



            Import wants to override unchanged fields
            Asked 2022-Feb-22 at 19:07

            If i export to xlsx and reimport, Django-Import-Export reports overwritten fields but there are no changes. I already tried to debug this myself with the skip_row() method but i think im generally doing sommething wrong




            Answered 2022-Feb-22 at 19:07

            Some points which may help:

            • The import process is going to try to load existing data based on all four attributes in import_id_fields
            • It will then compare all fields from your Excel file (which correspond to attributes in FormatClass) with what is persisted, and if any of them do not match, it will report an 'update'
            • Set a breakpoint here to catch which field it thinks has changed.



            Customize admin import forms
            Asked 2022-Feb-19 at 21:31

            I want to add an additional field to my Import-Form on the Admin page. I did everything the Docs say but the entered values for year and calender_week wont show up.



            Answered 2022-Feb-19 at 21:29

            If I understand correctly, you want to select a value from a dropdown and have that inserted for all rows. This means that if there is a value for 'Jahr' in the import file, this will be ignored in favour of the value selected from the dropdown.

            Setting an import field to the selection in the dropdown can be achieved by assigning the value of the dropdown onto the instance of the object to be imported as follows. (I've used the single field 'year' instead of 'Jahr' and 'Kalenderwoche' but you can update your implementation along the same lines).



            Exporting field data in many to many relationships using django-input-output only shows primary key
            Asked 2022-Feb-01 at 14:35

            I am trying to export the data from my database from the django admin page using the django-import-export package. When I export a model, I also want to show the data in a particular field for every object in a many to many relationship.

            It looks something like this:




            Answered 2022-Feb-01 at 14:35

            If you want the exported m2m column to contain a different field, you can simply pass the name of the field when declaring the ManyToManyWidget on the field.

            For example:



            How i can to delete record when import file using django-import-export?
            Asked 2022-Jan-30 at 15:33

            My project use Django framework and installed django-import-export plugin. I can import and export everything normally. But when i imported file to database. All new records from file upload was imported successfully. but old record that is not in the new records not delete.

            old data in database ...


            Answered 2022-Jan-30 at 15:33

            django-import-export won't do this for you by default, but you can easily add some hooks to achieve this.

            You can track the id of each row imported or updated, and then delete any others at the end of the import.

            for example:



            Import model without id field as primary key with django import_export
            Asked 2021-Dec-21 at 10:22

            just tried out django-import-export to import som things from a csv-file. Followed the doc but I always get an error when trying to import the following Model:



            Answered 2021-Dec-21 at 10:22

            There is no field id within my model the primary key field is key so why it is not taken?

            The default field for identifying whether an object exists or not is called 'id'. However you can override using import_id_fields, so in your case the following should work:



            django-import-export-celery summary page not found
            Asked 2021-Dec-14 at 21:30

            I have created a new task in django-import-export-celery and it has successfully imported the tasks.

            But I cannot view the summary of the changes.

            I already added this in my urlpatterns:

            The files are present on my directory, but they cannot show the view. I'm following this repo as my reference.

            EDIT: The line url(r'^',, messes up with the URL. When I remove it, I can see the template, but all other app pages do not show. When I let it stay, I can see all other pages but the template throws an error.



            Answered 2021-Dec-14 at 21:29

            I put static first like so:



            Django - resource was not found on this server on production
            Asked 2021-Dec-14 at 21:27

            I am trying to access these files used from the django-import-export-celery module:

            I am able to see my view on local:

            But its not showing on my production server:

            This is my urlpattern:



            Answered 2021-Dec-14 at 21:27


            Django-import-export-celery Import error [Errno 13] Permission denied
            Asked 2021-Dec-14 at 21:26

            I have a minor issue where I always see an error 13:



            Answered 2021-Dec-14 at 21:26

            I just enabled permission with chown 755



            Django import-export, only export one object with related objects
            Asked 2021-Dec-09 at 13:34

            I have a form which enables a user to register on our website. Now I need to export all the data to excel, so I turned towards the import-export package. I have 3 models, Customer, Reference and Contact. The latter two both have a m2m with Customer. I also created Resources for these models. When I use Resource().export() at the end of my done() method in my form view, it exports all existing objects in the database, which is not what I want.

            I tried googling this and only got one result, which basically says I need to use before_export(), but I can't find anywhere in the docs how it actually works.

            I tried querying my customer manually like:



            Answered 2021-Dec-09 at 13:34

            One way is to override get_queryset(), you could potentially try to load all related data in a single query:


            Community Discussions, Code Snippets contain sources that include Stack Exchange Network


            No vulnerabilities reported

            Install django-import-export

            You can install using 'pip install django-import-export' or download it from GitHub, PyPI.
            You can use django-import-export like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.


            For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .
            Find more information at:

            Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items

            Find more libraries
          • PyPI

            pip install django-import-export

          • CLONE
          • HTTPS


          • CLI

            gh repo clone django-import-export/django-import-export

          • sshUrl


          • Stay Updated

            Subscribe to our newsletter for trending solutions and developer bootcamps

            Agree to Sign up and Terms & Conditions

            Share this Page

            share link