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
Top comments (0)