1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

from import_export import resources

from .. import models


class BankCodeResource(resources.ModelResource):
    class Meta:
        model = models.BankCode
        import_id_fields = ["code", "branch_code"]
        fields = ["code", "branch_code", "kana", "name", "branch_kana", "branch_name"]

    def before_import_row(self, row, row_number=None, **kwargs):
        for field in self._meta.fields:
            # ヘッダーは verbose_name に合わせている
            value = row.pop(self._meta.model._meta.get_field(field).verbose_name, None)
            if value is None:
                continue

            # コードは0埋めする
            if field == "code":
                value = str(value).zfill(4)
            elif field == "branch_code":
                value = str(value).zfill(3)

            row[field] = value