Feb 16 2012

User Profile Issues

 

Symptom

Issues with the User Profile on Share Point:

•    Active User Profile being deleted from SharePoint

•    My Site being scheduled for deletion

•    Manager receiving email saying “The My Site of [user] is scheduled for deletion…”

Cause

For some reason (could be connectivity issue), a user profile is missing from the last import. When it is missing, it will be marked as “deleted from AD”.

This is where the My Site Clean Up Job come into play.

For each “deleted” profile, it will do the following:

This process is unsafe because it could lead to deletion of active user profiles and my sites.

Resolution

To address these issues we need to

  • Disable the My Site Clean Up Job stop the deletion and alerting manager process
    • Navigate to SharePoint Central Admin\Monitoring\Review job definitions
    • Look for My Site Cleanup Job and disable the job
  • Notify SharePoint admin when a user profile is missing from the last import/marked as deleted.
    • SharePoint marks a user profile as deleted by flagging the bDeleted field to true in the UserProfile_Full table in the User Profile Service Application_ProfileDB[GUID] database.
    • Create SRSS reports to report on the bDeleted rows
    • Add a subscription to the reports for SharePoint admin

    • Manually check and clean up the inactive profiles

If the user is actually disabled, review their My Site pages and profiles.

      You may want to permanently delete the profiles and My Site pages:

      • Navigate to Central Admin\Application Management\User Profile Service Application
      • Click on Manage User Profile under People
      • Select Profile Missing from Import as the View. Enter the name of the user and hit Find

      • To delete My Site, click on the Manage Personal Site

If user has created a personal site, this will take you to the site. From there you can delete the site.

      • To delete a profile, select Delete from the dropdown menu item

Ref:

Jan 29 2012

SharePoint 2010 calculated column and hyperlink (no workflows or scripts needed)

Often you will get a requirement like this:

Create a calculated column which concatenate the url text with an existing column value.

This seems to be an easy task, except one thing: SharePoint doest not render hyperlink in calculated column by default.

For example, I have a list with 2 columns: Search term and Google Search. Google Search is a calculated column with this formula

Now, this is what I will get by default:

There are a few ways to fix this problem. Usually people will recommend you to create a Hyperlink column instead and create a workflow to update the Hyperlink value (http://social.technet.microsoft.com/Forums/ar/sharepoint2010customization/thread/32d32e47-3256-4806-8775-c250b6243038) . Or, you can place a script on the page that loop through the HTML nodes and replace the unfriendly html tags with a hyperlink as described here http://practicalsharepoint.blogspot.com/2011/10/dynamic-hyperlinks-in-calculated.html.

But today, I’m going to show you how to trick SharePoint into displaying the hyperlink, and it is going to be very easy.

1. Modify the calculated column and change the returned data type from Single line of text to Number/Currency/Date and Times. Click OK.

2. Go back to the list and be amazed 🙂

This will also work when you’d like to achieve the same thing with the image tag <img>.

Jan 27 2012

How to add Adobe PDF to FAST Advanced Search result type drop down list

By default, Fast Search Advanced Search does not include Adobe PDF on the Result type filter.

So, to add a new result type for Adobe PDF, please follow the following steps:

  • Edit the Advance Search page

  • Edit the Advanced Search Box web part

  • Expand Properties

  • Click the button next to the Properties textbox and copy the text to an XML Editor (for easy editing)

  • In the XML Editor, add the following before the ResultTypes closing tag

<ResultType DisplayName=”Adobe PDF” Name=”acrobatpdf”>

<KeywordQuery>FileExtension=”pdf”</KeywordQuery>

<PropertyRef Name=”Author” />

<PropertyRef Name=”DocComments”/>

<PropertyRef Name=”Description” />

<PropertyRef Name=”DocKeywords”/>

<PropertyRef Name=”FileName” />

<PropertyRef Name=”Size” />

<PropertyRef Name=”DocSubject”/>

<PropertyRef Name=”Path” />

<PropertyRef Name=”Write” />

<PropertyRef Name=”CreatedBy” />

<PropertyRef Name=”ModifiedBy” />

<PropertyRef Name=”Title”/>

</ResultType>

  • Copy the changes back into the SharePoint Advance Search Box Properties Text Editor, and click OK.

  • Click OK on the Advance Search Box Panel

  • Click Save & Close to save the changes to the page

  • Check the Result Type drop down list and make sure Adobe PDF is in the list.

Jan 27 2012

Missing FAST Search keywords, site promotion and demotion, user context from Site Collection Administration

Symptoms

When you go to Site Settings, the following items are missing from the Site Collection Administration:

  • FAST Search keywords
  • FAST Search site promotion and demotion
  • FAST Search user context

Cause

This usually happens when you add FAST Search to an existing SharePoint 2010 farm.

The feature that activates these functions may not enable for the site collection.

Resolution

Run the following command on the SharePoint server in Powershell as Administrator (replace [SiteURL] with the actual URL):

Enable-SPFeature -id “5EAC763D-FBF5-4d6f-A76B-EDED7DD7B0A5” -Url  [SiteURL]

Jan 27 2012

How to install and configure Adobe IFilter For SharePoint Search

These are the instructions to set up SharePoint to crawl and display pdfs in the results:

  • Download the ifilter msi file from http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025
  • Unzip the downloaded file and ensure the msi file is in a folder of your choice
  • Find an icon for PDF and save it as ICPDF.gif to the same folder
  • Create a new text file called ifilter-install.txt in the same folder and paste the following

# Enter the following variable…

$searchSSAName = “Search Service Application Name” #Enter the name of the Search Service Application here

Write-Host “Loading SharePoint 2010 PowerShell cmdlets – Global”

Add-PsSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue

$ParentDirectory = Split-Path $pwd -parent

cmd.exe /C “$ParentDirectory\PDFFilter64installer.msi /passive”

write-host $ParentDirectory

copy-item “$ParentDirectory\ICPDF.gif” -Destination “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES\”

$pngmappingkey = ‘ <Mapping Key=”png” Value=”icpng.gif”/>’

$pdfmappingkey = ‘ <Mapping Key=”pdf” Value=”ICPDF.gif”/>’

$dociconxmlpath = “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML”

$dociconxmlentry = “$pngmappingkey`r`n$pdfmappingkey”

(get-content $dociconxmlpath\DOCICON.XML) | foreach-object {$_ -replace “$pngmappingkey”, “$dociconxmlentry”} | set-content $dociconxmlpath\DOCICON.XML

New-Item -path “HKLM:\SOFTWARE\Microsoft\Office Server\14.0\Search\Setup\ContentIndexCommon\Filters\Extension\.pdf” -erroraction SilentlyContinue

New-ItemProperty “HKLM:\SOFTWARE\Microsoft\Office Server\14.0\Search\Setup\ContentIndexCommon\Filters\Extension\.pdf” -Name “(Default)” -PropertyType string -value “{E8978DA6-047F-4E3D-9C78-CDBE46041603}” -erroraction SilentlyContinue

$searchapp = Get-SPEnterpriseSearchServiceApplication $searchSSAName -erroraction SilentlyContinue

$searchapp | New-SPEnterpriseSearchCrawlExtension “pdf” -erroraction SilentlyContinue

cmd.exe /C iisreset

net stop “SharePoint Server Search 14”

net start “SharePoint Server Search 14”

  • Open the ifilter-install.txt file and enter the $searchSSAName variable. This should be the exact name of the Search Service Application.
  • Rename the attached ifilter-install.txt to ifilter.ps1
  • Run the ps1 file on SP front-ends…