Read Csv File and Update SharePoint List via PowerShell
clear
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}
# String Constants
$path_csv_read = "C:\Users\maliks\Desktop\ExportCsv\Items - Status.csv";
$list_name = "Internal Team Site Requests";
$spweb_name = "https://test/sites/82411";
$csv_objects= Import-Csv $path_csv_read
$web = Get-SPWeb $spweb_name;
$list = (Get-SPWeb $spweb_name).Lists.TryGetList($list_name);
foreach($row in $csv_objects){
$item_object = $list.Items.GetItemById($row.ID);
$item_object["Site Status"] = $row."Site Status";
$item_object["Status Description"] = $row.'Status Description';
$item_object["URL Team Site"] = $row."URL Team Site";
$item_object.Update();
}
$web.Dispose();
Remove-Item $path_csv_read
No comments:
Post a Comment