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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.