Problem

Importing CRM data via CSV file in Virtual Contact Center fails. (Particularly affects users without Excel, using a Mac, etc.)

Cause

Currently, VCC only accepts Windows-style "newlines." (In programming, this means CR, LF—Carriage Return, Line Feed—as common "unix-style" types of carriage return. CR, LF is the native method for Windows.)

For Mac users, the VCC CRM import fails due to Mac not appending a CR, LF for each row of data.

(Note: Notepad++ used to show all characters.)

See also:

Resolution

Bulk reformat troublesome data strings in Windows

  1. Open CSV file in Notepad++ (Download http://notepad-plus-plus.org/download/v6.5.5.html).
  2. Perform Search and Replace function.
  3. Find:  \r
  4. Replace with:  \r\n
  5. Click Replace All.
  6. Save.

Bulk reformat troublesome data strings in Mac OS

  1. Open CSV file in TextWrangler (Download http://www.barebones.com/products/textwrangler/download.html).
  2. Click Search > Find.
  3. Select the Group checkbox.
  4. Type:  \r
  5. Replace with:  \r\n
  6. Save.