Search This Blog

Friday, May 24, 2013

Power shell- Picture Library update picture and custom Properties

Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue
 $webs =  Get-SPweb "http://dvnap-spdev01:8585"
 
 $ListName = "Country_Region"
Foreach ($oneweb in $webs.Webs)
{
write-host $oneweb

#Open Your List
$List = $oneweb.Lists[$ListName];
if ($List -ne $null)
{
$newitem= $list.items.Add();
$newitem["Title"]= "USA";
$newitem["Country"]= "USA";
$newitem["Region"]="AMERICAS";
$newitem.update();
}
else
{
 Write-Host "no customlist in this site ..."
}
}
Write-Host "Press any key to continue ..."
$x = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")
-----------------------------------------------------------------------------
Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue
 $webs =  get-spsite -webapplication "http://dvnap-spdev01:8585"
 $ListName = "Country_Region"
Foreach ($oneweb in $webs)
{
write-host $oneweb
#Open you web
$OpenWeb = $oneweb.OpenWeb();
#Open Your List
$List = $OpenWeb.Lists[$ListName];
if ($List -ne $null)
{
$newitem= $list.items.Add();
$newitem["Title"]= "USA";
$newitem["Country"]= "USA";
$newitem["Region"]="AMERICAS";
$newitem.update();
}
else
{
 Write-Host "no customlist in this site ..."
}
}
Write-Host "Press any key to continue ..."
$x = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")
---------------------------------------------------------------------------------------
// C:\Users\developer\Desktop\Photos (add ateast 1 image from path)
save it .ps1 file and execute(right click and run as poershell)
------------------------------------------------------------------------------------------------
Add-PSSnapin Microsoft.SharePoint.PowerShell
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
$SPSite = New-Object Microsoft.SharePoint.SPSite("http://external.com");
#Open you web
$OpenWeb = $SpSite.OpenWeb();
$number=100;
$docLibraryName = "ProfilePics"
$localFolderPath = "C:\Users\developer\Desktop\Photos"

$docLibrary = $OpenWeb.Lists[$docLibraryName]
$i=1
for (; $i -le $number; $i++)
{Write-Host  "Adding "$i

$files = ([System.IO.DirectoryInfo] (Get-Item $localFolderPath)).GetFiles() | ForEach-Object{
    $fileStream = ([System.IO.FileInfo] (Get-Item $_.FullName)).OpenRead()
    $contents = new-object byte[] $fileStream.Length
    $fileStream.Read($contents, 0, [int]$fileStream.Length);
    $fileStream.Close();
    write-host "Copying" $_.Name "to" $docLibrary.Title "in" $OpenWeb.Title "..."
    $folder = $docLibrary.RootFolder
    $spFile = $folder.Files.Add($folder.Url + "/" + $_.Name, $contents, $true)
    $spItem = $spFile.Item
$spItem["Name"]= "Nalco_mosesje"+$i.ToString()+"_MThumb";
$spItem["PicOwner"] = "Nalco\mosesje"+$i;
$spItem["PicOwnerEmail"] = "jegan.moses"+$i.ToString()+"@nalco.com";
$spItem.Update();
}

}

$OpenWeb.Dispose();
$SPSite.Dispose()                                                              
write-host "Library Item created successfully"
----another example(1 million item insert)--------------------------------------------------
=================================================================
// Set site url
$siteurl = “http://yourservername”
// get site obj
$mysite=new-object Microsoft.SharePoint.SPSite($siteurl)
// open root web
$spWeb = $mysite.OpenWeb()

// get test list obj
$spList = $spWeb.Lists["TestList"]
// Insert 1 million items
$i = 1001
do { Write-Host “Item – “$i
         $spitem = $spList.Items.Add()
         $spitem["Title"] = $i.tostring()
         $spitem.Update()
         $i++
}
while ($i -le 1000000)
===========================================================
save it .ps1 file and execute(right click and run as poershell)
Add-PSSnapin Microsoft.SharePoint.PowerShell
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
$SPSite = New-Object Microsoft.SharePoint.SPSite("http://dvnap-spdev01:8585");
#Open you web
$OpenWeb = $SpSite.OpenWeb();
$ListName = "Country_Region"
#Open Your List
$List = $OpenWeb.Lists[$ListName];

$newitem= $list.items.Add();
$newitem["Title"]= "USA";
$newitem["Country"]= "USA";
$newitem["Region"]="AMERICAS";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "IN";
$newitem["Country"]= "India";
$newitem["Region"]="Asia-Pacific";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "CA";
$newitem["Country"]= "CANADA";
$newitem["Region"]="AMERICAS";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "BR";
$newitem["Country"]= "BRAZIL";
$newitem["Region"]="AMERICAS";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "AU";
$newitem["Country"]= "AUSTRALIA";
$newitem["Region"]="Asia-Pacific";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "AT";
$newitem["Country"]= "AUSTRIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "AZ";
$newitem["Country"]= "AZERBAIJAN";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "BY";
$newitem["Country"]= "BELARUS";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "BE";
$newitem["Country"]= "BELGIUM";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "BA";
$newitem["Country"]= "BOSNIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "BG";
$newitem["Country"]= "BULGARIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "CN";
$newitem["Country"]= "CHAINA";
$newitem["Region"]="Asia-Pacific";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "VN";
$newitem["Country"]= "VIETNAM";
$newitem["Region"]="Asia-Pacific";
$newitem.update();
$newitem= $list.items.Add();
$newitem["Title"]= "UZ";
$newitem["Country"]= "UZBEKISTAN";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "GB";
$newitem["Country"]= "UNITED KINGDOM";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "UA";
$newitem["Country"]= "UKRAINE";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "TR";
$newitem["Country"]= "TURKEY";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "TH";
$newitem["Country"]= "THAILAND";
$newitem["Region"]="ASIA-PACIFIC";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "TW";
$newitem["Country"]= "TAIWAN";
$newitem["Region"]="ASIA-PACIFIC";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "CH";
$newitem["Country"]= "SWITZERLAND";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "SE";
$newitem["Country"]= "SWEDEN";
$newitem["Region"]="EUROPE";
$newitem.update()

$newitem= $list.items.Add();
$newitem["Title"]= "ES";
$newitem["Country"]= "SPAIN";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "SI";
$newitem["Country"]= "SLOVENIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "SK";
$newitem["Country"]= "SLOVAKIA";
$newitem["Region"]="EUROPE";
$newitem.update();
$newitem["Title"]= "SG";
$newitem["Country"]= "SINGAPORE";
$newitem["Region"]="ASIA-PACIFIC";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "CS";
$newitem["Country"]= "SERBIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "RU";
$newitem["Country"]= "RUSSIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "RO";
$newitem["Country"]= "ROMANIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "PT";
$newitem["Country"]= "PORTUGAL";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "NO";
$newitem["Country"]= "NORWAY";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "NZ";
$newitem["Country"]= "NEW ZEALAND";
$newitem["Region"]="ASIA-PACIFIC";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "NL";
$newitem["Country"]= "NETHERLANDS";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "MK";
$newitem["Country"]= "MACEDONIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "LU";
$newitem["Country"]= "LUXEMBOURG";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "LT";
$newitem["Country"]= "LITHUANIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "LV";
$newitem["Country"]= "LATVIA";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "KR";
$newitem["Country"]= "KOREA";
$newitem["Region"]="ASIA-PACIFIC";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "KZ";
$newitem["Country"]= "KAZAKHASTAN";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "JP";
$newitem["Country"]= "JAPAN";
$newitem["Region"]="ASIA-PACIFIC";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "IT";
$newitem["Country"]= "ITALY";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "IE";
$newitem["Country"]= "IRELAND";
$newitem["Region"]="EUROPE";
$newitem.update();

$newitem= $list.items.Add();
$newitem["Title"]= "ID";
$newitem["Country"]= "INDONESIA";
$newitem["Region"]="ASIA-PACIFIC";
$newitem.update();

$OpenWeb.Dispose();
$SPSite.Dispose()                                                              
write-host "list Item created successfully" 

2 comments: