{"action":"created","issue":{"url":"https://api.github.com/repos/artfulrobot/uk.artfulrobot.civicrm.importhelper/issues/6","repository_url":"https://api.github.com/repos/artfulrobot/uk.artfulrobot.civicrm.importhelper","labels_url":"https://api.github.com/repos/artfulrobot/uk.artfulrobot.civicrm.importhelper/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/artfulrobot/uk.artfulrobot.civicrm.importhelper/issues/6/comments","events_url":"https://api.github.com/repos/artfulrobot/uk.artfulrobot.civicrm.importhelper/issues/6/events","html_url":"https://github.com/artfulrobot/uk.artfulrobot.civicrm.importhelper/issues/6","id":214572169,"number":6,"title":"Why are the original Firstname and Lastname columns preserved if they're not changed?","user":{"login":"kenwest","id":4818337,"avatar_url":"https://avatars3.githubusercontent.com/u/4818337?v=3","gravatar_id":"","url":"https://api.github.com/users/kenwest","html_url":"https://github.com/kenwest","followers_url":"https://api.github.com/users/kenwest/followers","following_url":"https://api.github.com/users/kenwest/following{/other_user}","gists_url":"https://api.github.com/users/kenwest/gists{/gist_id}","starred_url":"https://api.github.com/users/kenwest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kenwest/subscriptions","organizations_url":"https://api.github.com/users/kenwest/orgs","repos_url":"https://api.github.com/users/kenwest/repos","events_url":"https://api.github.com/users/kenwest/events{/privacy}","received_events_url":"https://api.github.com/users/kenwest/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-03-16T01:16:38Z","updated_at":"2017-03-16T09:27:27Z","closed_at":null,"body":"If I download a processed CSV file, the Firstname and Lastname columns match the original Firstname and original Lastname columns.\r\n\r\nWhy are the original Firstname and Lastname columns preserved if they're not changed?\r\n\r\nOr if you anticipate cases where they will change, what are they and what happens in those cases?\r\n\r\nEg, if the original csv contains\r\n\r\n`    Fred    Smith   f@smith.com`\r\n\r\nand the database contains\r\n\r\n`    1234    Bill    Jones   f@smith.com`\r\n`    1357    Mark    Wells   f@smith.com`\r\n\r\nand I match that row with contact 1357, then the processed CSV contains\r\n\r\n`    1357   Fred    Smith   Fred    Smith   f@smith.com`"},"comment":{"url":"https://api.github.com/repos/artfulrobot/uk.artfulrobot.civicrm.importhelper/issues/comments/287001791","html_url":"https://github.com/artfulrobot/uk.artfulrobot.civicrm.importhelper/issues/6#issuecomment-287001791","issue_url":"https://api.github.com/repos/artfulrobot/uk.artfulrobot.civicrm.importhelper/issues/6","id":287001791,"user":{"login":"artfulrobot","id":870343,"avatar_url":"https://avatars2.githubusercontent.com/u/870343?v=3","gravatar_id":"","url":"https://api.github.com/users/artfulrobot","html_url":"https://github.com/artfulrobot","followers_url":"https://api.github.com/users/artfulrobot/followers","following_url":"https://api.github.com/users/artfulrobot/following{/other_user}","gists_url":"https://api.github.com/users/artfulrobot/gists{/gist_id}","starred_url":"https://api.github.com/users/artfulrobot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/artfulrobot/subscriptions","organizations_url":"https://api.github.com/users/artfulrobot/orgs","repos_url":"https://api.github.com/users/artfulrobot/repos","events_url":"https://api.github.com/users/artfulrobot/events{/privacy}","received_events_url":"https://api.github.com/users/artfulrobot/received_events","type":"User","site_admin":false},"created_at":"2017-03-16T09:27:27Z","updated_at":"2017-03-16T09:27:27Z","body":"Yes, I've thought about this as a processing option. Basically the only purpose of the additional columns is to allow for the unpacking of compound names in the first name column. i.e. if you feed it in a CSV with \"Ms. Wilma Flintstone\" in the first name column it will separate the title, first and last name out into the othe r columns. This was designed to help a client who had a lot of data with a single name field.\r\n\r\nIt seems there's these options for functionality:\r\n\r\n1. As is. The new columns are only populated with the input data.\r\n\r\n    *or*\r\n\r\n2. When a contact is matched, populate the new columns from CiviCRM. When it is not matched, use the input data.\r\n\r\n    *or*\r\n\r\n3. As (2) but when a contact is matched, populate the new columns from CiviCRM **but only if the input data is missing from the input data**. i.e. if you input \"Wilma\" but not \"Flintstone\" and you match it to \"Flintstone, W\" in CiviCRM, then it would add in \"Flintstone\" as the last name, but use the input \"Wilma\" for the first name.\r\n\r\nWhich do you think would make the most sense to users? I think that's an important guide to making the right call here!"}}
{"actor":{"display_login":"artfulrobot"}}