python - Django-Import-Export导入CSV，如何处理u'\\ufeff，UTF-8 BOM问题？

Question

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

KeyError: u"Column 'id' not found in dataset. Available columns are: [u'\ufeffid', u'username', u'name', u'email']"

Answer 1

这对我有用，更改 import_export/admin.py 文件中 ImportMixin 类中 django-import-export 模块的编码，

将 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