We have a dump of data from Salesforce, in CSV files, that we need to get into Zoho CRM. I have been using the Data Migration features to do the import. So far there has been little success and a lot of frustration.
One of the most difficult problems is, CRM is converting special characters to ASCII codes. For example:
Doral's Automotive is an account name that is coming in as Doral’s Automotive. The same thing happens in every field every time a ' or other special character is used. We can't stop using those characters so,
1. How do we keep this from happening? Can I do something before the data is imported?
2. If I cant stop CRM from doing this, how do I do a mass search and replace throughout the CRM records to fix this, in CRM?