How to Export Data in Django using django-import-export Module.

#django #python

Hello Devs, In this tutorial I'm gonna teach you how to use django-import-export module, I write this blog because I faced some errors during my project so that's why I write this blog and want to give you information or my code..

Github Link:- https://github.com/ShivamRohilllaa/django-import-export

Django-import-Export

First of all install this module

pip install django-import-export

Now add this in your installed apps

# settings.py
INSTALLED_APPS = (
    ...
    'import_export',
)

How to implement this in your Admin Panel

Admin.py

from import_export.admin import ImportExportModelAdmin

class ModelnameAdmin(ImportExportModelAdmin):
    model = Modelname

now register this model and you will se import or export button in your admin panel, just click on export and export the complete model data.

How to get exact values of Foreignkey-Field in django-import-export

This value can be achieved by dehydratemethod in django-import-export, I'll show you the code how you can do this.

Create two Models and connect them with foreignkey

class author(models.Model):
    auth = models.OneToOneField(User, on_delete=models.CASCADE)
    full_name = models.CharField(max_length=100)

    def __str__(self):
        return self.full_name

class publisher(models.Model):
    auth = models.OneToOneField(User, on_delete=models.CASCADE)
    full_name = models.CharField(max_length=100)

    def __str__(self):
        return self.full_name

class book(models.Model):
    writer = models.ForeignKey(author, on_delete=models.CASCADE)
    publisher = models.ForeignKey(publisher, on_delete=models.CASCADE)
    bookname = models.CharField(max_length=50)
    qty = models.IntegerField()

    def __str__(self):
        return self.bookname

Now, write this code in your admin.py file

from .models import *
from import_export.fields import Field
from import_export import resources


class BookResource(resources.ModelResource):
    writer = Field()
    publisher = Field()

    class Meta:
        model = book
        exclude = ['qty']

    def dehydrate_writer(self, book):
        return '%s by %s' % 
              (book.bookname,book.writer.auth.username)

    def dehydrate_publisher(self, book):
        return '%s by %s' % 
             (book.bookname,book.publisher.auth.username)

class BookAdmin(ExportMixinAdmin):
    resource_class = BookResource


admin.site.register(book, BookAdmin)

So, this is how you can get exact values of your foreignkey in your spreadsheet..

Thank You