Replacing SharePoint 2010 Content Editor WebPart Links

This console app is to replace those hard-coded URLs inside content editor web parts. In previous post we showed how to extend https://proudctionServer application to https://stagingServer, but some URLs inside the content editor web parts in https://stagingServer are still pointing to https://productionServer. This console will replace them as desired staging URLs.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebPartPages;
using Microsoft.SharePoint.Administration;

namespace ContentEditorWPLinkUpdate
{
    /// <summary>
    /// This console application is to replace hard-coded links inside ContentEditorWebPart.
    /// e.g.
    /// <a href="https://productionServer/news/abcd">abcd news</a>
    /// will be replaced by:
    /// <a href="/news/abcd">abcd news</a>
    /// Run the executable directly or run it with optional parameters:
    /// Cmd:\>ContentEditorWPLinkUpdate [originalLink] [newLink]
    /// </summary>
    class Program
    {
        readonly static string webApplication = "https://productionServer/";
        static string oldUrl = "https://productionServer/";
        static string newUrl = "/";         
        static string hrefLinkTeReplaced = string.Format("href=\"{0}", oldUrl);
        static string srcLinkToBeReplaced = string.Format("src=\"{0}", oldUrl);

        static void Main(string[] args)
        {
            if (args.Length > 0)
            {
                oldUrl = args[0].Trim().TrimEnd(new char[] { '/' }) + "/";
                hrefLinkTeReplaced = string.Format("href=\"{0}", oldUrl);
                srcLinkToBeReplaced = string.Format("src=\"{0}", oldUrl);
                if (args.Length > 1)
                    newUrl = args[1].Trim().TrimEnd(new char[] { '/' }) + "/";
            }

            Console.WriteLine("Replacing URL {0} by {1} for content editor WebParts...", oldUrl, newUrl);

            SPWebApplication webApp = SPWebApplication.Lookup(new Uri(webApplication));

            foreach (SPSite siteCollection in webApp.Sites)
            {
                Console.WriteLine("Updating Site collection: " + siteCollection.Url);

                foreach (SPWeb web in siteCollection.AllWebs)
                {
                    UpdateWebRootFolderFiles(web);
                    UpdatePagesFiles(web);
                    web.Close();
                }

                siteCollection.Close();
            }

            Console.WriteLine("Content Editor WebPart links update completed!");
        }

        /// <summary>
        /// Update URL in content editor WebPart
        /// </summary>
        static void UpdateContentEditorWebPart(SPLimitedWebPartManager wpManager, ContentEditorWebPart contentEditor)
        {
            string origContent = contentEditor.Content.InnerText;
            if (origContent.Contains(hrefLinkTeReplaced) || origContent.Contains(srcLinkToBeReplaced))
            {
                XmlDocument xmlDoc = new XmlDocument();
                XmlElement xmlElement = xmlDoc.CreateElement("HtmlContent");
                xmlElement.InnerText = origContent.Replace(hrefLinkTeReplaced, "href=\"" + newUrl).Replace(srcLinkToBeReplaced, "src=\"" + newUrl);
                contentEditor.Content = xmlElement;
                wpManager.SaveChanges(contentEditor);
            }
        }

        /// <summary>
        /// Update files in sites' root folder
        /// </summary>
        static void UpdateWebRootFolderFiles(SPWeb web)
        {
            using (web)
            {
                // Loop through all files in root folder
                if (web.RootFolder.Files != null)
                {
                    foreach (SPFile webRootFile in web.RootFolder.Files)
                    {
                        try
                        {
                            if (webRootFile.Url.ToLower().EndsWith(".aspx"))
                            {
                                using (SPLimitedWebPartManager wpManager = webRootFile.GetLimitedWebPartManager(PersonalizationScope.Shared))
                                {
                                    foreach (System.Web.UI.WebControls.WebParts.WebPart webPart in wpManager.WebParts)
                                    {
                                        if (webPart != null && webPart.GetType().ToString().Contains("ContentEditorWebPart"))
                                        {
                                            ContentEditorWebPart contentEditor = (ContentEditorWebPart)webPart;
                                            UpdateContentEditorWebPart(wpManager, contentEditor);
                                        }
                                    }
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine(string.Format("Error occurs when updating {0} : {1}", webRootFile.ServerRelativeUrl, ex.Message));
                        }
                    }
                }
            }
        }

        /// <summary>
        /// Update Publishing pages
        /// </summary>
        static void UpdatePagesFiles(SPWeb web)
        {
            SPList list = web.Lists.TryGetList("Pages");
            if (list == null)
                return;

            SPFile page = null;
            foreach (SPListItem listItem in list.Items)
            {
                if (!listItem.Url.ToLower().EndsWith(".aspx"))
                    continue;
                try
                {
                    page = web.GetFile(web.Url + "/" + listItem.Url);
                    bool needToUpdate = false;
                    using (SPLimitedWebPartManager wpManager = page.GetLimitedWebPartManager(PersonalizationScope.Shared))
                    {
                        foreach (System.Web.UI.WebControls.WebParts.WebPart webPart in wpManager.WebParts)
                        {
                            if (webPart.GetType().ToString().Contains("ContentEditorWebPart"))
                            {
                                ContentEditorWebPart contentEditor = (ContentEditorWebPart)webPart;

                                string content = contentEditor.Content.InnerText;
                                if (content.Contains(hrefLinkTeReplaced) || content.Contains(srcLinkToBeReplaced))
                                {
                                    needToUpdate = true;
                                }
                            }
                        }
                    }
                    if (needToUpdate)
                    {
                        if (page.CheckOutType != SPFile.SPCheckOutType.None)
                            page.UndoCheckOut();
                        page.CheckOut();

                        string webPartTitles = string.Empty;
                        using (SPLimitedWebPartManager wpManager = page.GetLimitedWebPartManager(PersonalizationScope.Shared))
                        {
                            foreach (System.Web.UI.WebControls.WebParts.WebPart webPart in wpManager.WebParts)
                            {
                                if (webPart != null && webPart.GetType().ToString().Contains("ContentEditorWebPart"))
                                {
                                    ContentEditorWebPart contentEditor = (ContentEditorWebPart)webPart;
                                    UpdateContentEditorWebPart(wpManager, contentEditor);
                                }
                            }
                        }

                        page.CheckIn("Replace hard-coded URL for content editor web part:" + webPartTitles);
                        page.Publish("Replace hard-coded URL for content editor web part:" + webPartTitles);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(string.Format("Error occurs when updating {0} : {1}", page.ServerRelativeUrl, ex.Message));
                }
            }
        }
    }
}