Import CSV(excel) file to SharePoint list

Here the import the more than documents to add the lists using the Power Shell  Commands.

1.we have to add the title of the list  and body of contents and expire date.its like this

and save as .csv format.

2.After that using this code in Notepad

Add-PsSnapin Microsoft.SharePoint.Powershell –ErrorAction SilentlyContinue

$csv = Import-Csv 'csv file path'

$web = Get-SPWeb -identity "Domin Name"

$list = $web.Lists["ListName"]

foreach ($row in $csv) {

$item = $list.Items.Add();

$item["Title"] =$row.Title

$item["Body"] =$row.Body

$item["Expires"] =$row.Expires

$item.Update()

}

Write-Host "Finished! Press enter key to exit." -ForegroundColor Green

Read-Host

and save as filename.ps1 format.
3.finally exect that file

Automatically created the contents on the particular list.

Adding and Deploying SharePoint 2010 Solution with using PowerShell

PowerShell command are,

Backup a Site Collection with PowerShell command

Backup-SPSite -Identity http://myserver -Path "c:\......bak"

Restore a Site Collection with PowerShell command

Restore-SPSite -Identity http://myserver -Path "c:\........bak"

Note: To restore site collection you’ll use the following command. Use –Force if you want to overwrite the existing site collection

WSP Solutions in PowerShell

Add-SPSolution “D:\Deploy\MySharePointSolution.wsp“

Install-SPSolution –Identity MySharePointSolution.wsp –WebApplication http://myspwebapp –GACDeployment

If you would like to add the solution as sandboxed, you would use the Install-SPUserSolution command instead. To upgrade a solution, we specify which solution is to be updated and with which new solution file:

Update-SPSolution –Identity MySharePointSolution.wsp –LiteralPath 

“D:\Deploy\MySharePointSolution.wsp” –GacDeployment

To retract and remove a solution, we use the following commands:

Uninstall-SPSolution –Identity MySharePointSolution.wsp –WebApplication http://myspwebapp

Remove-SPSolution–Identity MySharePointSolution.wsp