Lookup are not appearing in SharePoint 2013 after migrating from MOSS 2007

InfoPath alternatives for form designing SharePoint

In this post we will discuss how to solve the lookup column issue in SharePoint 2013. Recently we were migrating from MOSS 2007 to SharePoint 2013 using database upgrade approach. So we first move from MOSS 2007 to SharePoint 2010 and then from SharePoint 2010 to SharePoint 2013.

You may also read:
– Add Custom Web Part Properties in SharePoint 2013 Visual Web Part

– Enterprise Metadata and Keywords Settings in SharePoint 2013

– SharePoint Server 2016 features deprecated or removed

After the migration in one site, we see that one lookup column is appearing as blank in one of the list form when user trying to add one item to that particular list.

We verified the list and found out that the list is actually created by using an existing list template. And when we veified the list template (manifest.xml) file we saw that the Lookup list id has a different id in the SharePoint 2013 site. So it was not pulling the list items.

We modified the updated manifest.xml file in the list template with the updated list id and then uploaded this new modifed template and it works file.

To modify the list template file, first download the list template file which will be an extension of .stp. Then rename the file to .cab.

Then use use tool like 7-zip to unzip it and once the file is unziped you will see manifest.xml file. Open the file in the notepad and then Save the file.

Then use makecab.exe to convert the file to cab file like below:

makecab.exe F:\Users\Administrator\Desktop\MyTestListTemplate\manifest.xml F:\Users\Administrator\Desktop\MyTestListTemplate.cab

The above command will make the .cab file. Then rename the file to .stp from .cab.

Finally upload the .stp file to the list template gallery.

Hope this will be helpful.

Similar SharePoint 2013 Tutorials

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →

Leave a Reply