Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/django-import-export/django-import-export/issues/1485 below:

NOT NULL constraint failed for non-nullable Charfields in xlsx · Issue #1485 · django-import-export/django-import-export · GitHub

When using the .xslx import, non-nullable CharFields will fail with an exception when their value is left empty. Presumably because the cell has a value of None in that case.

As seen on StackOverflow where a workaround was provided. IMHO this should simply be fixed instead.

To Reproduce
Steps to reproduce the behavior:

1. Start the example app
2. Edit a book, make the field "author_email" empty.
3. Export all books as .xlsx
4. Import this .xlsx
5. sqlite3.IntegrityError: NOT NULL constraint failed: core_book.author_email

Versions (please complete the following information):

• Django Import Export: [2.8.0]

Expected behavior
I expect no error. In particular: I expect that the output of an export is a valid input for an import.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4