Skip to main content

Steps to migrate from other CMS to Sitecore

Here are few easy steps to migrate the data from other CMS to Sitecore

1. Get the detail of CMS from where to migrate in Sitecore

2. Export the articles or items in xml format. Generally all CMS gives this option to export it in xml file format

3. Read the xml tags one by one to get all related details (code given is just for reference)




//Get all files under specific directory
string[] files = Directory.GetFiles(path);

List<ArticleData> articleList = new List<ArticleData>();

//Read each file one by one
foreach (string filePath in files)
{
    XmlDocument xmlDoc = new XmlDocument();
    xmlDoc.Load(filePath);             

    ArticleData article = new ArticleData();
    article.FileName = filePath.Substring(path.Length + 1, (filePath.Length - (path.Length + 1)));

    XmlNodeList list = xmlDoc.SelectNodes("record/item[@name='it_article_title']");               
    article.Title = list[0].InnerText;

    XmlNodeList list1 = xmlDoc.SelectNodes("record/item[@name='it_publication_date']");               
    article.Date = list1[0].InnerText;

    XmlNodeList list2 = xmlDoc.SelectNodes("record/item[@name='it_author']");               
    article.Author = list2[0].InnerText;     

    XmlNodeList list4 = xmlDoc.SelectNodes("record/item[@name='it_summary']");               
    article.Summary = list4[0].InnerText;
   
    XmlNodeList list6 = xmlDoc.SelectNodes("record/item[@name='it_image_file_name']");               
    article.Thumbnail = list6[0].InnerText;

    articleList.Add(article);

}
           

4. Create template in Sitecore including all required fields

5. Take reference of below mentioned code to create item in Sitecore and fill the values in it


Database masterDb = Sitecore.Configuration.Factory.GetDatabase("master");

//Get the Item under which you want to import all items . 
//Here ID of that item is passed under which all items will be imported.
Item activeItem = masterDb.GetItem(new ID("1CD389F0-E0C7-4D22-A39D-0C5BD2A1251D"));                
//For Editing an Item in Sitecore, Security should be disabled else you have to create user //with required permission and write logic to authenticate it
                using (new Sitecore.SecurityModel.SecurityDisabler())
                {  
                    Item newItem = activeItem.Add(article.FileName, template);
                    newItem.Editing.BeginEdit();
                    newItem.Fields["Title"].Value = article.Title;
                    newItem.Fields["Body"].Value = article.Text;
                    
                    DateTime dt = new DateTime();
                    DateTime.TryParse(article.Date, out dt);
                    newItem.Fields["Article Date"].Value = Sitecore.DateUtil.ToIsoDate(dt);

                    newItem.Fields["Image"].Value = article.Image;
                    newItem.Editing.EndEdit();
                }


6. Run the code and check, Item should be created in Sitecore

~~~~~~~~~~~~~~~Happy Coding !!~~~~~~~~~~~~~~

Comments

Popular posts from this blog

AJAX Progrraming

Ajax , shorthand for Asynchronous JavaScript and XML , is a web development technique for creating interactive web applications. The intent is to make web pages feel more responsive by exchanging small amounts of data with the server behind the scenes, so that the entire web page does not have to be reloaded each time the user requests a change. This is meant to increase the web page's interactivity, speed, and usability. The Ajax technique uses a combination of: XHTML (or HTML) and CSS, for marking up and styling information. The DOM accessed with a client-side scripting language, especially JavaScript and JScript, to dynamically display and interact with the information presented. The XMLHttpRequest object is used to exchange data asynchronously with the web server. In some Ajax frameworks and in certain situations, an IFrame object is used instead of the XMLHttpRequest object to exchange data with the web server, and in other implementations, dynamically added tags may be used. ...

Nutch crawler and integration with Solr

Before moving ahead with this article, I assume you have Solr installed and running. If you would like to install Solr on windows, mac or via docker, please read Setup a Solr instance . There are several ways to install nutch which you can read from Nutch tutorial , however I have written this article for those who would like to install nutch using docker. I tried finding help on google but could not find any help for nutch installation using docker and spent good amount of time fixing issues specific to it. Therefore I have written this article to help and save time of other developers. Install nutch using docker- 1. Pull docker image of nutch using below command,      > docker pull apache/nutch 2. Once image is pulled, run the container,      > docker run -t -i -d --name nutchcontainer apache/nutch /bin/bash 3. You should be able to enter in the container and see bash prompt,      > bash-5.1#  Let's setup few important setting...

Could not load file or assembly 'Microsoft.Web.Infrastructure'

Could not load file or assembly 'Microsoft.Web.Infrastructure, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. What 'Micorosoft.Web.Infrastructure' does? This dll lets HTTP modules register at run time. Solution to above problem: Copy 'Micorosoft.Web.Infrastructure' dll in bin folder of your project and this problem should be resolved. If you have .Net framework installed on machine, this dll should be present on it. You can search for this dll and copy it in your active project folder.   Alternatively,  you can install this dll using nuget package manager PM> Install-Package Microsoft.Web.Infrastructure -Version 1.0.0 Happy coding!!