KeriaCoder | powershell scripting

Add-PSSnapin Microsoft.SharePoint.PowerShell
}
# define web application where list is located
$web = Get-SPWeb http://contoso/ 
$list = $web.lists["List Name"]
$cnt = 0
 
# define csv document path
foreach($i in Import-CSV 'E:\Scripts\Excel\ImportFromCSV.csv') 
{
$new = $list.Items.Add()
$new[“Title”] = $i.'Title'
$new.Update()
$cnt++
}
"Added " + $cnt.ToString() + " records."
"Data successfully imported. Press any key to continue…"
$null = $Host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")

Add-PSSnapin Microsoft.SharePoint.PowerShell

}

# define web application where list is located

$web = Get-SPWeb http://contoso/

$list = $web.lists["List Name"]

$cnt = 0

# define csv document path

foreach($i in Import-CSV 'E:\Scripts\Excel\ImportFromCSV.csv')

{

$new = $list.Items.Add()

$new[“Title”] = $i.'Title'

$new.Update()

$cnt++

}

"Added " + $cnt.ToString() + " records."

"Data successfully imported. Press any key to continue…"

$null = $Host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")

Please take note that this code must be run on the same server where the web application is with authenticated privilege.

Posts

[Powershell] – Import to Sharepoint List from CSV

Latest Update

Recent Comments

Categories

Archives

Keria Coder (00208351-W)