After confirming with our AD Administrator that departmentNumber was indeed the right name, I then began to do some research and came across this excellent article which contains a Powershell script to map the missing attributes.
The first thing you’ll want to do is go ahead and create your new property within the User Profile Service, and just choose any of the available attributes. In my example here we’ll be modifying a new property I created named DepartmentID.
Next, create a new file on your server named mapattributes.ps1, and paste the following into it. Update $url, $spsProperty, $fimProperty, and $connectionName to match your environment. Note that for $spsProperty you need to include the actual name of the property;not the display name.
$url = http://webserver:0924 #URL of your Central Admin site.
$spsProperty = “DepartmentID” #Internal name of the SharePoint user profile property
$fimProperty = “departmentNumber” #Name of the attribute in FIM/LDAP source
$connectionName = “sun” #Name of the SharePoint synchronization connection
$site = Get-SPSite $url
if ($site)
{Write-Host “Successfully obtained site reference!”}
else
{Write-Host “Failed to obtain site reference”}
$serviceContext = Get-SPServiceContext($site)
if ($serviceContext)
{Write-Host “Successfully obtained service context!”}
else
{Write-Host “Failed to obtain service context”}
$upManager = new-object Microsoft.Office.Server.UserProfiles.UserProfileConfigManager($serviceContext)
if ($upManager)
{Write-Host “Successfully obtained user profile manager!”}
else
{Write-Host “Failed to obtain user profile manager”}
$synchConnection = $upManager.ConnectionManager[$connectionName]
if ($synchConnection)
{Write-Host “Successfully obtained synchronization connection!”}
else
{Write-Host “Failed to obtain user synchronization connection!”}
Write-Host “Adding the attribute mapping…”
$synchConnection.PropertyMapping.AddNewMapping([Microsoft.Office.Server.UserProfiles.ProfileType]::User, $spsProperty, $fimProperty)
Write-Host “Done!”
Open a SharePoint 2010 Management Shell, and navigate to the mapAttributes script that you just saved. To run the file, type .\mapAttributes.ps1 and hit enter. After a few minutes the script should complete:
Now go back into your User Property mappings, and you’ll see that it is now mapped to the correct attribute.
Finally, run a full user profile import and your property should now be correctly synchronized.
