Scenario: you want to create a SharePoint list with “a lot” of items
Prerequisites:
– SharePoint 2010/2013
– SharePoint PowerShell
– an already created site collection within a webapp (e.g. http://sp:9090)
– an already created empty list (e.g. SharePoint test)
Run the following script to create “a lot” of items (e.g. 400000)
$site = Get-SPSite “http://sp:9090”
$web = $site.rootweb
$list = $web.Lists[“SharePoint test”]
$i = 1
do {
$newitem = $list.items.Add()
$newitem[“Title”] = “Client-” + $i.ToString().PadLeft(4, “0”);
$newitem.Update()
$i++
}
while ($i -le 400000)