Tag: add

I found this script and it works very well. But I need it to verify if the list item exists first and make an update if so. Otherwise, add the list item as new. At this time, just keep adding them.

Can anyone help me modify the script so that it first checks the list item by SiteID and updates it if it finds it? Otherwise, add it as new. I found this link where it could be done, but I need help to do the same with my script. update SPList using csv through Powershell

if((Get-PSSnapin "Microsoft.SharePoint.PowerShell") -eq $null)
{
      Add-PSSnapin Microsoft.SharePoint.PowerShell
}

function Get-UsefulWebsitesFromSql                        
{                          
    #Connect to the database                        
    $conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=mySQLServer;Initial Catalog=myDB;User ID=username;Password=******")                        
    Write-Progress -Id 1 -ParentId 0 -Activity "Importing Data From SQL into SharePoint" -PercentComplete (1) -Status "Opening Connection to the SQL Server";                        
    $conn.Open();                        
    try                        
    {                                  
        #Execute the query                        
        Write-Progress -Id 1 -ParentId 0 -Activity "Importing Data From SQL into SharePoint" -PercentComplete (2) -Status "Querying SQL Server";                           
        $query = "select * from dbo.dimSite where ContractID = 'I-000124'"                        
        $dap = new-object System.Data.SqlClient.SqlDataAdapter($query,$conn);                        
        $dt = new-object System.Data.DataTable;                        
        $dap.Fill($dt);                                    
        $w = Get-SPWeb https://mysecurus/dev1;                        
        $list = $w.Lists("dimSite List");                           
        $listTitle = $list.Title;                        
        $pi = $dt.Rows.Count;                              
        $pci = 1;                                       
        $itemsAdded = 0;                               

        Write-Progress -Id 1 -ParentId 0 -Activity "Importing Data From SQL into SharePoint" -PercentComplete (25/($pi+45)*100) -Status "Importing ($pi) items into SharePoint.";                              

        foreach($r in $dt.Rows)                        
        {                                    
            Write-Progress -Id 1 -ParentId 0 -Activity "Importing Data From SQL into SharePoint" -PercentComplete (($pci+25)/($pi+45)*100) -Status "Importing ($pi) items into SharePoint.";                        
            Write-Progress -Id 2 -ParentId 1 -Activity "Adding new items to $listTitle" -PercentComplete ($pci/$pi*100) -Status "Importing item $pci into SharePoint.";                        
            $pci++;                        
            $i = $list.Items.Add();                        
            try                        
            {                        
                $itemsAdded++;                        
                #Set the Title                        
                $i("Title") = $r("SiteNm"); 
                #Set the SiteID
                $i("SiteID") = $r("SiteID"); 
                #Set the ContractID
                $i("ContractID") = $r("ContractID"); 
                #Save changes to the item                        
                $i.Update();                        
                Write-Host ((String)::Format("Added item: '{0}',",$r("SiteNm"))) -ForegroundColor Green;                        
            }                        
            catch (System.Exception){                        
                Write-Host ((String)::Format(" Error adding item. Item {0} has been skipped. Error: {1}. ",$r("SiteNm"),$_)) -ForegroundColor Red -BackgroundColor White;                        
                continue;                          
            }                          
        }                              
        Write-Progress -Id 1 -ParentId 0 -Activity "Importing Data From SQL into SharePoint" -PercentComplete (80) -Status "Closing SQL Connection.";                              
        Write-Host ((String)::Format("Finished importing items into the list. Imported {0} items. ",$itemsAdded)) -ForegroundColor Blue -BackgroundColor White;                        
        Write-Progress -Id 1 -ParentId 0 -Activity "Importing Data From SQL into SharePoint" -PercentComplete (90) -Status "Finished importing ($pi) items into SharePoint.";                        
        $w.Dispose();                        
    }                        
    catch (System.Exception){                        
        Write-Host ((String)::Format("Error: {0} ",$_)) -ForegroundColor Red -BackgroundColor White;                           
        Write-Progress -Id 1 -ParentId 0 -Activity "Importing Data From SQL into SharePoint" -PercentComplete (100) -Status "An error occurred.";                               
    }                        
    finally{                        
        $conn.Close();                         
    }                                  
}                        
#Call the function                        
Get-UsefulWebsitesFromSql;

Thanks for the help!