{"action":"created","issue":{"url":"https://api.github.com/repos/bmihelac/django-import-export/issues/201","labels_url":"https://api.github.com/repos/bmihelac/django-import-export/issues/201/labels{/name}","comments_url":"https://api.github.com/repos/bmihelac/django-import-export/issues/201/comments","events_url":"https://api.github.com/repos/bmihelac/django-import-export/issues/201/events","html_url":"https://github.com/bmihelac/django-import-export/issues/201","id":55990111,"number":201,"title":"Matching Excel column names to database fields","user":{"login":"jtiki","id":1173792,"avatar_url":"https://avatars.githubusercontent.com/u/1173792?v=3","gravatar_id":"","url":"https://api.github.com/users/jtiki","html_url":"https://github.com/jtiki","followers_url":"https://api.github.com/users/jtiki/followers","following_url":"https://api.github.com/users/jtiki/following{/other_user}","gists_url":"https://api.github.com/users/jtiki/gists{/gist_id}","starred_url":"https://api.github.com/users/jtiki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jtiki/subscriptions","organizations_url":"https://api.github.com/users/jtiki/orgs","repos_url":"https://api.github.com/users/jtiki/repos","events_url":"https://api.github.com/users/jtiki/events{/privacy}","received_events_url":"https://api.github.com/users/jtiki/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-30T03:22:26Z","updated_at":"2015-01-30T13:10:07Z","closed_at":null,"body":"I was wondering if there was a way to match column's in an Excel sheet to a database field with a different name. For example if my models.py looks like this:\r\n```python\r\n...\r\nclass Talk(models.Model):\r\n    name = models.CharField(max_length=100)\r\n    talk_day = models.DateField()\r\n    time_start = models.TimeField()\r\n    time_end = models.TimeField()\r\n    conference = models.ForeignKey(Conference, related_name=\"talks\")\r\n    users = models.ManyToManyField(User, related_name=\"talks\")\r\n...\r\n```\r\nCould I match an excel sheet with a column name \"Day of Talk\" to 'talk_day'? I tried setting up a resource like so:\r\nadmin.py\r\n```python\r\nclass TalkResource(resources.ModelResource):\r\n    talk_day = fields.Field(attribute=\"day of talk\",\r\n                            column_name=\"day of talk\",\r\n                            widget=DateWidget)\r\n\r\n    class Meta:\r\n        model = Talk\r\n```\r\nThen importing the following excel sheet:\r\n|-------------------------------------------------------------------------------------------------|\r\n| id | name          | day of talk   | time_start | time_end | conference | users |\r\n|-------------------------------------------------------------------------------------------------|\r\n|    | Some Talk  | 1/1/15      |  ...                | ...             |   1               |           |\r\n|-------------------------------------------------------------------------------------------------|\r\n\r\nBut when the preview shows up all of the fields are filled in except 'talk_day'. "},"comment":{"url":"https://api.github.com/repos/bmihelac/django-import-export/issues/comments/72198271","html_url":"https://github.com/bmihelac/django-import-export/issues/201#issuecomment-72198271","issue_url":"https://api.github.com/repos/bmihelac/django-import-export/issues/201","id":72198271,"user":{"login":"jtiki","id":1173792,"avatar_url":"https://avatars.githubusercontent.com/u/1173792?v=3","gravatar_id":"","url":"https://api.github.com/users/jtiki","html_url":"https://github.com/jtiki","followers_url":"https://api.github.com/users/jtiki/followers","following_url":"https://api.github.com/users/jtiki/following{/other_user}","gists_url":"https://api.github.com/users/jtiki/gists{/gist_id}","starred_url":"https://api.github.com/users/jtiki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jtiki/subscriptions","organizations_url":"https://api.github.com/users/jtiki/orgs","repos_url":"https://api.github.com/users/jtiki/repos","events_url":"https://api.github.com/users/jtiki/events{/privacy}","received_events_url":"https://api.github.com/users/jtiki/received_events","type":"User","site_admin":false},"created_at":"2015-01-30T13:10:07Z","updated_at":"2015-01-30T13:10:07Z","body":"I changed the resource to the following:\r\n```python\r\nclass TalkResource(resources.ModelResource):\r\n        talk_day = fields.Field(column_name=\"day of talk\",\r\n                                            widget=DateWidget)\r\n\r\n        class Meta:\r\n            model = Talk\r\n```\r\nand tried to import the same excel sheet but get this preview:\r\n![screen shot 2015-01-30 at 8 06 40 am](https://cloud.githubusercontent.com/assets/1173792/5976038/5160bb34-a857-11e4-9490-da51f9c8659a.png)\r\n\r\n\r\n"}}