Wednesday, February 15, 2012

SharePoint Formulas and Functions

While working with a SharePoint List, I wanted to add couple of Columns with Formulas and I came across the below url from Microsoft.

Formulas are equations that perform calculations on values in a list. A formula starts with an equal sign (=).”

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. For example, the ROUND function rounds off a number in the Cost column.”

Friday, February 3, 2012

Export and Import a SharePoint List

This was a requirement one of my clients faced few days back. So I thought of writing blog post on it so anybody can refer to it when needed Smile .

Exporting a SharePoint List can be done with the OOB feature given in SharePoint Central Administration.

Central Administration >> Backup and Restore >> Export a site or list


In the above image you can see…
1. You can backup a site
2. You can backup a list
3. It supports of exporting with full security
4. Exporting with the item versioning (Major / Minor / Both / Current)


OK fine exporting can be done through the UI. How about Importing? Time to move on to PowerShell. Prior to that let’s see how to achieve the Exporting through PowerShell.

Export-SPWeb “http://spdev:4422/netassist/” –ItemUrl “Lists/Students” –Path “C":\SharePoint Backup\StudentsList.cmp”

Now the Importing.. (I’ve used a SubSite “network” for the clarity)

PS C:\Users\SPAdmin> Import-SPWeb “http://spdev4422/netassist/network/” -Path "
C:\SharePoint Backup\StudentsList.cmp"

For more info read the TechNet Articles.