<div>
The most straight-forward solution is to not have empty cells. 
 
But if that's not possible, then you either have to a) come up with different workflows for each error situation, i.e. what do I do when: 
&nbsp;1) displayname field is empty 
&nbsp;2) title field is empty 
&nbsp;3) department field is empty 
...etc., or b) handle them all in the same way, i.e. skip processing of the line (this is really what's happening now when you encounter an error).
</div>

<div>
Hi footech, 
 
Unfortunately &nbsp;some of the cells will always be empty. 
 
I would like it to skip the empty cell and move to the next, any suggestion how to do that? 
 
Regards,
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
 
I need to update around 1000 users from a csv, I have the script below which runs until it gets to an empty cell then I get an error, can anyone suggest away to stop the error? 
 
&nbsp; 

<pre><code class="code-10 nolinks" id="code-10-29066426-1">#Import AD Module 
Import-Module ActiveDirectory 

write-Host 'Starting to update AD Attributes.......' -NoNewline -ForegroundColor Yellow 
# Import CSV into variable $users 
 
$users = Import-Csv -Path C:\temp\users.csv 
# Loop through CSV and update users if the exist in CVS file 
 
foreach ($user in $users) { 
#Search in specified OU and Update existing attributes 
 Get-ADUser -Filter &quot;displayName -eq '$($user.displayName)'&quot; -Properties * -SearchBase &quot;OU=Users,DC=company,DC=local&quot; | 
 Set-ADUser -Title $($user.Title) -Department $($user.Department) -MobilePhone $($user.MobilePhone) -OfficePhone $($user.OfficePhone) -Office $($user.Office) -City $($user.City)
}

Write-Host 'done!' -ForegroundColor Green
</code></pre>
</div>
</div>

Hi,

I need to update around 1000 users from a csv, I have the script below which runs until it gets to an empty cell then I get an error, can anyone suggest away to stop the error?

 
(CODE)

update AD users from csv with blank cells

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.