Exporting data of non-related with the model

Question

I'm using Django-import-export on django admin. I want to export the data that are not related. (Are related but it's weird..) Example:

models.py

class A(models.Model):
    name = models.CharField(default=False)
    size= models.CharField(default=True)

class B(models.Model):
    relation = models.ForeignKey(A,on_delete=models.CASCADE)
    title = models.CharField(default=False)
    category = models.CharField(default=False)

I want something like this:

admin.py
class export(resources.ModelResource):
   name = Field(column_name='something',attribute='name')
   category =Field(column_name='something_else',attribute='category')

   class Meta:
       model = A
       fields = ('name','category')
class A_Admin(ExportActionMixin,admin.ModelAdmin):
    resource_class=export
    ....
    ....

I need to get the data from model B that have a relation with A but A dont have relation with B...

There can be zero, one or multiple such Bs, so how would you "merge" the collection of values of the Bs? — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Jan 21, 2024 at 22:40
What do u mean? the english it's not my main language, please be more specify — juan carlos espinosa lozano
– juan carlos espinosa lozano, Commented Jan 21, 2024 at 22:49

Nayem Jaman Tusher · Accepted Answer · 2024-01-22 09:39:59Z

1

To export data from model B that has a relation with A, but where A does not have a direct relation with B, you can use the

ForeignKey__isnull

field in your export class. This will filter out the instances of A that do not have a related instance in B.

from import_export import resources, fields
from import_export.admin import ExportActionMixin
from .models import A, B

class ExportResource(resources.ModelResource):
    name = fields.Field(column_name='something', attribute='name')
    category = fields.Field(column_name='something_else', attribute='b__category')

    class Meta:
        model = A
        fields = ('name', 'category')

class A_Admin(ExportActionMixin, admin.ModelAdmin):
    resource_class = ExportResource
    list_display = ('name', 'size')  # Add any other fields you want to display in the admin

    def get_queryset(self, request):
        # This queryset filters out instances of A that do not have a related instance in B
        return super().get_queryset(request).exclude(b__isnull=True)

admin.site.register(A, A_Admin)

answered Jan 22, 2024 at 9:39

Nayem Jaman Tusher

1,1283 gold badges11 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

juan carlos espinosa lozano Over a year ago

This doesn't work for me. Send the column name but the data it's empty ¿Do u forgive to use a widget maybe?

Collectives™ on Stack Overflow

Exporting data of non-related with the model

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related