Convert a 2007 SharePoint template to 2010

The other day I had to migrate a few SharePoint 2007 lists to a 2010 site. However, when I tried to do so, I received a message stating that my templates were not supported. Luckily, I found a fix.

Hopefully, this can help others. 

1. Download the 2007 list template to a local folder
2. Rename the .STP to .CAB
3. Open the .CAB 
4. Extract the .CABs manifest.xml to a local folder
5. Open the xml in Notepad
6. Search for  ProductVersion. This it will be 3
7. Change it to 4
8. Save your change.
9. Now Repackage the manifest.xml into your .CAB
• This can be done by going to your Start menu and selecting Run
• Enter cmd
• Then entering the following Syntax: makecab.exe {folder}\manifest.xml {folder}\{template-name}.cab Example: makecab H:\myfolder\manifest.xml H:\myfolder\2007template.cab
10. If you donot receive a error message go back into the folder where the .CAB is saved.
11. Open the folder and review the manifest to make sure the Product version 4 has saved within the xml.
12. If correct, close the file and change the cabinet's extension from .CAB back to .STP
13. Upload it into your SharePoint 2010 list template library. 

Now it should work.

Source: http://tom-dw.blogspot.com/2010/06/importing-sharepoint-2007-list.html

SharePoint Export to Excel via a Link

I recently had a client that did not want to use the "out of the box"  export to Excel feature in SharePoint.  Instead, they desired a link that could be added anywhere on a page, capable of also providing this functionality.


Step 1:

First, I had to find the guid of  the list and view that they wanted to export to Excel. To do this, I went to their SharePoint site's specific list and view, selected modify this view, and then copied the url from the "edit view" page.

Step 2:

I  pasted the url into Notepad and removed everything except  for the list and view guid (highlighted in yellow below). http://Mysharepointsite/examplesubsite/_layouts/ViewEdit.aspx?List=18c5120f%2Db6be%2D4836%2Dbc6c%2D88d3a7e42aa8&View=%7B5C4DB341%2D0AFA%2D460E%2D9FA4%2D0383CC723FF2%7D

Step 3:

I added a content editor web part (CEWP)on the page they desired their link. 

Step 4:

Finally, I edited the content editor's HTML source and entered the following:

<a href="http://Mysharepointsite/examplesubsite/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=18c5120f%2Db6be%2D4836%2Dbc6c%2D88d3a7e42aa8&View=%7B5C4DB341%2D0AFA%2D460E%2D9FA4%2D0383CC723FF2%7D&CacheControl=1">Export Report to Excel</a>

Here is a another example:

Just replace the yellow highlighted areas with your site's information

<a href="http://yoursiteurl/yoursubsite/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[listguid]View=[viewguid]&CacheControl=1">Export Report to Excel</a>

Please note, I have found that users must have Microsoft Excel 2007 or later for this to work to export. They must also use Internet Explorer or Firefox as their web browser.


My source: http://weblogs.asp.net/wkriebel/archive/2005/08/22/LinkToExportToSpreadsheet.aspx

Changing a SharePoint list url

I hate to see % signs  in a  url and to prevent this, I try to create my urls without spacing. Doing so not only provides a clean address but also a quick and easy way for me to remember them.

However, what do I do if I accidently use spaces and end up with a list url containing % signs? 

If I have been granted "full control" to the site, I open Sharepoint Designer!

1. Once in Designer, open the site that the url belongs to 
2.  Select "All files" located within the left hand of Designer, under "site objects"
3. Select the  "lists" folder
4. Right click the list that I would like to change
5. Select "rename"
6. Type the new name and press enter

My source: http://social.technet.microsoft.com/forums/en-US/sharepointgeneralprevious/thread/03d0aba0-9533-4237-8459-2f3a8e2a03e0