Monday, September 8, 2014

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