Interaction import changes punctuation characters in comments to question marks

When importing interactions with comments, you may notice that if the comments have punctuation marks like parenthesis, apostrophe, or quotation marks that these marks are changed into question mark symbols in batch that then show up in the constituent's record in the interaction with these marks.These question marks are visible in the batch before committal.
 
  1. Right click on the CSV file, and open with Notepad
  2. Once the csv file is open in Notepad, click File\Save As
  3. Change the encoding to UTC-8 (this is not available in Excel, which is why you have to open the file in Notepad to change the coding, but the file does retain the .csv file extension)
  4. Click Save
  5. You will see the shortcut for the document turn into a notepad shortcut, but you can right click on it and open with Excel again.
     6. Use this newly saved file for your import process.

Steps to Duplicate

1. Create an import process using the interaction batch template.
2. Upload a csv file that contains comments with punctuation marks like commas, parenthesis, apostrophe or quotes.
3. Start the import process
4. Open the batch that gets created, and look at the comments column
5. Note that the punctuation marks have all been changed to question mark symbols.

 

Environment

 Blackbaud CRM
 4.0
 4.0.157.0

Was this article helpful?