Thursday, May 17, 2012

Profile Import Issues - Helpful Blog

Pictures weren't importing into SharePoint and I found this blog post to have some unique insights
http://blogs.technet.com/b/harmeetw/archive/2011/09/10/importing-thumbnail-photos-from-ad-active-directory-into-sharepoint-2010.aspx

This is an extract from the end of the blog:

Troubleshooting:

How to find if an image for a user has been imported in Sync DB
Select sAMAccountName,SPS_MV_OctetString_PictureURL from MMS_Metaverse Where SAMAccountName like '%UserName%'

How to find if an image for a user has been imported in Profile DB
Select NTname,PictureURL from UserProfile_full where NTName like ‘%UserName%’

We first import images from AD into Sync DB and then populate it into the Profile DB. By default images do not auto populate in Profile DB,we need to run the following CMDlet

Update-SPProfilePhotoStore -CreateThumbnailsForImportedPhotos 1 -MySiteHostLocation http://mysite

Image type issues
Best way to troubleshoot this issue is by creating a simple JPG file from MSPaint and then upload it to the Active Directory, if this comes through then you will need to check out the file types or the size issues.

No comments:

Post a Comment