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

Popular posts from this blog

Cannot alter the login 'sa', because it does not exist or you do not have permission.

Working on projects, it can happen that 'sa' account gets locked. If it is on local machine OR development boxes, onus would be on you to fix it. If scripts and SQL steps are not working, this might help you fixing the issue.

Steps to unlock 'sa' account and resetting the password.

1. Open SQL Server Configuration Manager

2. Select SQL Server Services -> 'SQL Server' service.
3. Right click on 'SQL Server' service and click on "Startup Parameters". For 2008, server "Startup Parameters" are inside Advanced tab.


4. Add '-m' in startup parameters as shown above and click on 'Add'. This will put SQL server into 'Single User Mode' and local admin will have 'Super User' rights. For 2008, server you have to add ':-m' in the last of the existing query.
5. Save the settings and Restart the service.
6. Now open the SQL Server Management Studio and connect to database using 'Windows Authentication&…

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

Sitecore - Moving items from web to master

In most of the cases, generally you create items in master database and publish to web/production data. However, sometimes few items are in web database and not in master. Reason can be anything, like you might have deleted it in master but did not publish the parent item or due to some other reason.

If you are thinking, you will create package from web and deploy it in master, that will not work. :-) When you create package from master, it installs the items in master only and same is the case with web.

Right and easy way to do is Transfer the item. Yes, you read it right. There is a provision in Sitecore to transfer the items from one database to another.

Select the item which you want to transfer from one database to another. Right click on it and then select Copying. Click on Transfer. see screenshot



Once you click on Transfer, it opens up a popup box. Click 'Next'. see screenshot

After clicking on next, you have to choose the database where you would like to transfer the…