My company uses a lot of email templates in Saleeforce, and occasionally we need to do a mass change (like replace all instances of "Dennis X." with "Tom W." for example).
The best way I've found to do this is by exporting all email templates using DataLoader, then opening the file in Excel and searching for "Dennis X". And this works, for the most part. The problem is when I open the file in Excel it's a complete mess. It usually starts with a couple dozen rows of normal looking data but soon degrades into page after page of HTML and text from random templates with no structure to it at all.
I don't understand why it does this and it makes searching through templates extremely tedious. Is there any workaround for this issue? Am I doing something wrong? Is there some super secret way to search through email templates within Salesforce? Should I be using another program other than Excel to open the extraced file?
5 risposte
Hm, looks like opening the file in another editor (Notepad++) doesn't help, still getting similar results.
I might not have been clear. I understand that the HTML isn't going to be displayed the way it would in a web browser, I don't want it to be. The problem is that Data Loader is taking what seems to be random pieces of it and putting them in their own cells, with no structure and no way to know which template they're associated with. Here's an example. This is cell A446 in my .csv file. It's the only cell in the row with anything in it, even though technically Column A is supposed to only have SalesForce IDs in it:
<p class=""MsoNormal""><span style=""font-size:8.0pt;font-family:"Verdana"
There are literally thousands of rows like this.
I'm starting to think Data Loader was not designed to support something like what I'm trying to do.
