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

image

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)

image

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.
Export
Import