Copy List from 2007 to 2010

I’m recreating a site in SharePoint 2010 and didn’t want to create each List and Library.

I tried exporting a List from SharePoint 2007, then import into SharePoint 2010. No go.
SharePoint 2010 doesn’t like .STP files.

I opened MS Access 2010, imported my SharePoint 2007 List, then created a new List in my SharePoint 2010 site using imported 2007 List.

Like this:
In Access 2010
External Data tab
In the Import and Link section, click on More, then click on SharePoint List.
Choose the Import the source data…. option.
With your new table open, look in the Export section of External Data tab.
Click on More, click on SharePoint List, when the Export – SharePoint Site box opens, enter your destination URL and List name.
Click OK.

You should now have your List duplicated to your SharePoint 2010 site.

My Site Emails Not Sending

In SharePoint 2010 I noticed I wasn’t receiving updates when people posted stuff on my MySite.

Turns out, my Active Directory Sync is not working, and my email account was not being populated in my User Profile.

Fix it!

Central Administration –> Manage User Profiles
Find the person having the issue.
Update the email address.
Cruise over to the mysite, post a note, look in your inbox for an email.

the language of this installation package is not supported by your system

When trying to install SharePoint Designer 2010 on my PC, I ran into an error saying Designer 2007 was installed on the box.

The problem was, I had SharePoint Designer 2007 installed, and it’s a 32-bit install. When I tried to uninstalled Designer 2007 I was getting this error:

The language of this installation package is not supported by your system

No matter what google-related-fix I tried, I couldn’t uninstall it.

What I did to fix things:
Installed Office 2007
Installed Designer 2007

Uninstalled Desinger 2007
Uninstalled Office 2007

Then I was able to install SharePoint Designer 2010.

Get Content Database Size

In SharePoint 2010 or 2007 I wasn’t able to find the size of the Content Databases.  For some reason I thought it was displayed in Central Administration, wrong.

Log into one of your SharePoint servers.
Open PowerShell and paste the below code into the PowerShell window.
Run.

[Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | out-null
$prop_Name = [Microsoft.SharePoint.Administration.SPContentDatabase].GetProperty("Name")
$prop_DiskSizeRequired = [Microsoft.SharePoint.Administration.SPContentDatabase].GetProperty("DiskSizeRequired")
$prop_Sites = [Microsoft.SharePoint.Administration.SPContentDatabase].GetProperty("Sites")
[Microsoft.SharePoint.Administration.SPFarm]::Local.Services |? {
$_.GetType().FullName -eq "Microsoft.SharePoint.Administration.SPWebService"
} |% {
$_.WebApplications |% {
$_.Name
$_.ContentDatabases |% {
$prop_Name.GetValue($_, $null)
$prop_DiskSizeRequired.GetValue($_, $null) / 1GB
}
}
}

The output will be:
Web App
Content Database Name
Content Database Size in Gigs.

You can change the output displayed size to MB by updating:
$prop_DiskSizeRequired.GetValue($_, $null) / 1GB
$prop_DiskSizeRequired.GetValue($_, $null) / 1MB

The parameter is incorrect

From one day to the next my Crawl Log went to all *%&%&$.

On every item that was being crawled, a message of The parameter is incorrect was being returned.

I was shocked that this fixed it, but it did!

Central Administration > Operations > Services on Server > Office SharePoint Server

Search Service Settings

I updated the Contact E-mail Address with a new email address, entered the Farm Search Service Account password, and clicked OK.

Fired off a Crawl, and everything was back to normal.

 

office sharepoint server search stopping

Recently had the Office SharePoint Server Search service get stuck in a Stopping status.

Central Administration > Operations > Services on Server

Things I tried that DID NOT work:
1. Rebooting the server.
2. taskkill.exe /F /IM mssearch.exe /T
3. Disable the Office SharePoint Server Search Service
Reboot
Start the Office SharePoint Server Search Service

What DID WORK:
Logged into the server using one of the Farm Admin accounts.
Ran this command: stsadm.exe -o osearch -action start

This stuck on Stopping issue appears to be a common problem. Some people can resolve the issue by rebooting the server, while others have to run the SharePoint config wizard. Hope my quick fix helps.