how to import excel file with django import-export

Question

I use django import-export and I can not import an excel file I get the error:

Line number: 1 - 'id'

Traceback (most recent call last):
File "C: \ mat4 \ env \ lib \ site-packages \ import_export \ resources.py", line 317, in import_data
instance = new self.get_or_init_instance (instance_loader, row)
File "C: \ mat4 \ env \ lib \ site-packages \ import_export \ resources.py", line 149, in get_or_init_instance
instance = self.get_instance (instance_loader, row)
KeyError: 'id'

Line number: 2 - 'id'

Traceback (most recent call last):
File "C: \ mat4 \ env \ lib \ site-packages \ import_export \ resources.py", line 317, in import_data
instance = new self.get_or_init_instance (instance_loader, row)
File "C: \ mat4 \ env \ lib \ site-packages \ import_export \ resources.py", line 149, in get_or_init_instance
instance = self.get_instance (instance_loader, row)
KeyError: 'id'

my model:

class Essai_Temperature(models.Model):
name = models.ForeignKey(Material, verbose_name=_('name'))                                    
nature_unit = models.ForeignKey(Property, verbose_name=_('category'))                      
choix = ChainedForeignKey(Physic, verbose_name=_('properties'), null=True, blank=True,
                          related_name='Essai_Temperature_choix',
                          chained_field="nature_unit",
                          chained_model_field="name",
                          show_all=False,
                          auto_choose=True) 
valT= models.FloatField(_('temperature'),blank=True, null=False)   
val10= models.FloatField(_('value'), blank=True, null=False)                                               
val_ref= models.CharField(_('reference of the data'), max_length=50, default='0')

resources.py

class Essai_Temperature_Resource(resources.ModelResource):
class Meta(object):
    model = Essai_Temperature

admin.py

class Essai_TemperatureAdmin(ImportExportModelAdmin):
resource_class = Essai_Temperature_Resource 
list_display = ('name', 'nature_unit', 'choix', 'valT', 'val10', 'val_ref')
ordering = ('name__name', 'nature_unit__name', 'choix__lapropriete', 'valT',)
list_filter = ('name', 'nature_unit', 'choix')

and excel file

1   CT55    Mechanical  Hardness - Vickers (Mpa)    44  125 EF-01

2   CT55    Mechanical  Hardness - Vickers (Mpa)    44  127 EF-02

I do not understand the problem with the 'id' ?

NIKE · Accepted Answer · 2018-07-23 14:57:27Z

2

"Format None cannot be imported." error for csv file is fixed as follows:

imported_data = dataset.load(inventory.read().decode('utf-8'),format='csv')

answered Jul 23, 2018 at 14:57

NIKE

212 bronze badges

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

Comments

bmihelac · Accepted Answer · 2014-07-08 06:45:25Z

0

django-import-export expects header row to know how to map column to fields.

answered Jul 8, 2014 at 6:45

bmihelac

6,34336 silver badges45 bronze badges

6 Comments

Nalaka526 Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.

user3172700 Over a year ago

I have a problem with the field "choix". if i delete the colown "choix" (xls file), I managed to import data from the file. if i write "Harness Vickers" in choix, I have the error "Essai_Temperature.choix" must be a "Physic" instance..

bmihelac Over a year ago

@Nalaka526 Excel file posted above does not include header row. This is reason for error: KeyError: 'id'.

bmihelac Over a year ago

@user3172700 default ForeignKeyWidget displays foreign keys as integer values. If you need something else, create your own widget, see ForeignKeyWidget implementation: github.com/bmihelac/django-import-export/blob/master/…

user3172700 Over a year ago

The problem is the colown "id" in the excel file. When I want to import an excel file, I have difficulties to put the values in the id column. Is there a simple way to fill this column ?

|

Ray Jowa · Accepted Answer · 2015-10-02 08:21:45Z

0

By default django import export expects the primary key 'id' on your column headings.

You can change this behavior by changinf your resources.py to

class Essai_Temperature_Resource(resources.ModelResource):
     class Meta(object):
     model = Essai_Temperature
     import_id_fields = ('<your key field here>',)

answered Oct 2, 2015 at 8:21

Ray Jowa

1415 bronze badges

Comments

Patrick · Accepted Answer · 2016-04-06 19:24:01Z

0

This is an older question, but I got hung up on this same thing and didn't find a clear answer so I'm going to attempt that now.

You didn't share the code you were using to do the actual import so I will assume for the sake of this answer that you have a file called c:\import\data.xls. Also your file has to have a header row.

import os
import tablib
from import_export import resources


dataset = tablib.Dataset()   # We need a dataset object
Essai_Temperature_Resource = resources.modelresource_factory(model=Essai_Temperature)()
file = 'c:\import\data.xls'
dataset.xls = open(file).read()

# Add a blank ID column to each row.
dataset.insert_col(0, col=[None,], header="id")

# Do a Dry-Run and see if anything fails
result = Essai_Temperature_Resource.import_data(dataset, dry_run=True)
if (result.has_errors()):
    print(result)  # What is the error?
else:
    # If there were no errors do the import for real
    result = Essai_Temperature_Resource.import_data(dataset, dry_run=False)

When I did this, I was using a CSV file and I don't know 100% for sure the xls works the same, but I'm assuming it does.

Also, for me, when I first ran this, I got an "invalid dimensions" error. The reason for that (for me) was that I had a blank line at the end of my file. When I stripped that off it all worked great.

I hope that helps those who come next looking for this same answer.

answered Apr 6, 2016 at 19:24

Patrick

2,2572 gold badges29 silver badges46 bronze badges

1 Comment

Dharmesh Rupani Over a year ago

Can you please provide for csv file? I am getting "Format None cannot be imported." error for csv file

Collectives™ on Stack Overflow

how to import excel file with django import-export

4 Answers 4

Comments

6 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

6 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related