Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-17859

import contacts from CSV: sanitise / cleanup non-breaking spaces from records

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6.11
    • Fix Version/s: 4.7.7
    • Component/s: None
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      Importing contacts from CSV would benefit from basic clean-up and sanitation such as removing spaces from the beginnings and ends of the records.

      Lack of this feature complicates importing contacts: I select file, set options, match fields and continue to next step where I get Import_Errors.csv with list of records that did not pass validation (emails, URLs, countries, etc.). After correcting those trivial problems manually I have to restart import from step 1.

      Automatic removing of leading and trailing spaces would also prevent CiviCRM from importing organisation names beginning with spaces.

        Attachments

          Activity

            People

            • Assignee:
              saurabh.batra Saurabh Batra
              Reporter:
              onlyjob Dmitry Smirnov
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: