Monday, September 16, 2013

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 !!~~~~~~~~~~~~~~