Posts Tagged ‘2010’

How do I – Add a Search Keyword and visual Best Bet in SharePoint 2010?

Written by Cornelius J. van Dyk on . Posted in How Do I...

If you have content that you wish to raise in the search results for users, you could do that by adding Search Keywords and Best Bets to the site collection in question as follows: 1. Start by navigating to the home page of the site in question. 2. Click “Site Actions” at the top left of the home page. 3. On the dropdown menu, click “Site Settings” image[23] 4. On the Site Settings page, under the Site Collection Administration section, click “Search keywords” image[26] 5. On the Search Keywords page, you’ll see all the defined keywords for the site collection. 6. Click “Add Keyword” to begin the process of adding a new keyword. image[29] 7. In our example, we have a Word document named “Site Inspection Checklist” that we wish to add to best bets. 8. In the Keyword Phrase we enter the search term “Site Inspection Checklist” 9. In the Synonyms we can add phrases that users may use to search for this document. In our example, we used “Inspection Checklist”, “Inspection Check List” and “Site Inspection Check List”. You can add as many as you want, all separated by a semi colon. image[32] 10. Now click the “Add Best Bet” link to add the Best Bet for this item. 11. Start by adding the URL of the target item. 12. Next add the Title of the item and description and then click “OK” to add the Best Bet. image[35] 13. The Best Bet is now listed on the Keywords page. 14. Continue by filling out other details and then clicking “OK” to complete the process. image[38] 15. Now you can test Search on the target site and the newly added Keywords and Best Bet should surface to the top in the search results.



SharePoint 2010 – Boundaries and Limits

Written by Cornelius J. van Dyk on . Posted in Blog

Discovered this one with one of my clients today.

Error Message:  This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

Cause:  SharePoint 2010 lists limit the number of fields that can be displayed in a list view.  In this case, it was a 2007 list that was upgraded to 2010.  The list worked just fine in 2007, but failed to render with this error in 2010.  It turned out the list view contained 100+ fields.  The 2010 limit is 80.

Fix:  None

Workaround:  Split the view into two views, the first view containing the core data and the first half of the extra fields and the second view containing the core data and the rest of the extra fields.



How do I – Create a recursive escalation workflow in SharePoint using Visio 2010 Premium

Written by Cornelius J. van Dyk on . Posted in How Do I...

One of my attendees to my Human Workflow with Visio 2010 and SharePoint Designer 2010 session in Las Vegas recently, emailed me with an interesting question.  Eric was looking to recursively check if a CSR ticket was resolved and then resend the email until it was completed.  After responding to Eric with my recommendation on how to address his specific needs, I started thinking about escalation workflows in SharePoint.  Escalation is always interesting and usually more complex to implement that most people expect when trying it for the first time.  So I modified my model I generated for Eric and grew it into an escalation workflow for a fictitious company.

If you’ve ever tried doing something similar, you probably found out quickly that SharePoint won’t allow you to create a circular relationship in the workflow back to itself.  This fact alone had drive many people to more advanced workflow tools like Sourcecode’s K2[blackpearl].  We do not however, have to establish a visible circular relationship in the workflow.  Here is my design:


You will note the following:

  1. EscalationCount – This is a metadata field that we add to the form data which keeps track of how many times we’ve escalated.
  2. The workflow terminates after incrementing the EscalationCount value.
  3. Our workflow is published with settings that restarts the workflow if any values in the active item changes.  THIS IS THE IMPORTANT SETTING TO REMEMBER!!!

This is how this workflow would function:

  1. When the workflow first starts, we will have an EscalationCount value of 0.  Checking this value would force it down the first row of the workflow path.
  2. An email is sent to the CSR
  3. The workflow dehydrates (goes to sleep) for 7 days. 
  4. When it wakes up, it checks if the task is complete.  It should be noted that this check can be anything you want it to be, as long as it signifies that the work has been completed.  If after 7 days the work is found to have been completed, the workflow ends normally.  If however the work isn’t complete, the EscalationCount is incremented at #25.  Because the workflow is configured to restart itself upon change, incrementing the count will restart the workflow from the top thus creating the circular relationship we need.
  5. Check that EscalationCount is 1.
  6. Look up the CSR’s manager.
  7. Send an email to both parties.
  8. Dehydrate for 2 days.
  9. Check if task is completed.  If not completed, increment EscalationCount again.
  10. Check that EscalationCount is 2.
  11. Look up the manager’s manager.  In this case we called it the Department Manager.
  12. Send an email to all three.
  13. Dehydrate for 1 day.
  14. Check if task is completed.  If not completed, increment EscalationCount again.
  15. Check that EscalationCount is 3.
  16. Look up the Department Manager’s manager, in our case, the CIO.
  17. Send and email to all four.
  18. Dehydrate for 1 day.
  19. Check if task is completed.  If not completed, increment EscalationCount again.
  20. Check if EscalationCount is 4 or more.
  21. Look up the CIO’s manager, the CEO.
  22. Send and email to all 5.  (Honestly, if the workflow ever makes it to here, this company should NOT be in business!!!)
  23. Dehydrate for 1 day.
  24. Check if task is completed.  If not completed, increment EscalationCount again.

At this point, the workflow will continue to send email to all 5 people on a daily basis.  That’ll continue until the task is completed, or (more likely) the workflow is removed from the list altogether.

So that’s how we do recursive escalation workflow using Visio 2010 Premium.  From here you simply export the workflow to SharePoint Designer 2010 and implement it on your target list.