Django-Import-Export导入CSV，如何处理你的UTF-8 BOM问题？

Question

当我试图使用django导入导出模块导入CSV文件时，出现此错误，

KeyError:u"在数据集中找不到列'id'。可用列为：">

Answer 1

这对我有效，正在更改import_export/admin.py文件、中ImportMixin类中django导入导出模块的编码

将from_encoding = "utf-8"更改为from_encoding = "utf-8-sig"，如下所示。

class ImportMixin(ImportExportMixinBase):
"""
Import mixin.
"""
#: template for change_list view
change_list_template = 'admin/import_export/change_list_import.html'
#: template for import view
import_template_name = 'admin/import_export/import.html'
#: resource class
resource_class = None
#: available import formats
formats = DEFAULT_FORMATS
#: import data encoding
from_encoding = "utf-8-sig"
skip_admin_log = None
# storage class for saving temporary files
tmp_storage_class = None