Welcome!

.NET Authors: Elizabeth White, ChandraShekar Dattatreya, Trevor Parsons, Peter Silva, Yeshim Deniz

Blog Feed Post

No metadata? No problem! Custom entity extraction in SharePoint 2013

Every organization wants better search results.  However, few have actually spent the time to create file plans, content types, and managed properties to make it happen.  SharePoint 2013 has a feature called entity extraction though that can actually infer values by comparing what it finds in the body of the document to a dictionary.  This feature is Entity Extraction.  If you are familiar with FAST Search for SharePoint or FAST ESP, you know that entity extraction is nothing new.  What it does is gives you the power to infer the values of managed properties in search without having metadata in your site columns.  FS4SP and SharePoint 2013 come with an extraction dictionaries for company names out-of-the-box.  This means when it crawls it will search the contents of the body of your documents and if it recognizes any companies it knows, you can then search and refine on it.  However, the true value comes when you create your own.  SharePoint 2013 makes it really easy to create these custom dictionaries. 

Let me give you a few more examples to help you really understand the significance.  Most companies have a concept of a department or business unit.  We can create a dictionary with all of the company’s departments such as Accounting, Human Resources, IT, Operations, etc.  With entity extraction, if it finds a document and somewhere the text “Human Resources Organization Chart” is found, it then sets the value of the managed property to Human Resources.  Now, when the user does an advanced search and says “show me all Human Resources documents”, that result comes back with more confidence.  By using the extraction dictionary, we get better results that just using a regular keyword search.  Now you may be wondering that’s nothing special, but we can also add other terms, for example, I could add “HR”, and “Benefits” to that dictionary as well and map them to the Human Resources department.  Once I have a property defined like this, I can combine it with others as well.  This will let us issue queries like “show me all documents from Human Resources with a document type of Policy”. 

As another example, you could pre-load SharePoint with a dictionary of product names.  For those of you in the energy industry, you could pre-populate it with a list of wells or names of leases.  Are you starting to see the significance?  In previous versions of SharePoint, we had to set site columns in our document libraries to capture these values either from the user or programmatically.  Now with the right dictionary, we can assume the values with a reasonable degree of confidence.

Alright, enough explanation, let’s see this in action and hopefully it will make sense.  MSDN has a great post on this but I found and error in it so that is why I am writing this post (plus I know you all like screenshots).  For my example, I have a bunch of PowerPoint documents about SharePoint 2013 on my site.  I’ve created a custom entity extraction dictionary that will help me refine these documents by feature in SharePoint (i.e.: Apps, Business Intelligence, Search, Social, etc). 

Before you build your dictionary file though, you need to decide on what type of extraction to use.  You can choose whether you want it to match a word or just part of it.  You can also specify whether it needs to match exactly.  The MSDN article summarizes this well, but here’s a quick recap of your choices.

  • Word Extraction – case-insentive, word has to match, limited to 5 dictionaries
  • Word Part Extraction – case-insensitive, only part of a word has to match, limited to 5 dictionaries
  • Word Exact Extraction – case-sensitive, word has to match, limited to 1 dictionary
  • Word Part Exact Extraction – case-sensitive, only part of a word has to match, limited to 1 dictionary

For today’s example, I am going to use Word Part Extraction as it gives you some of the most flexibility.  You might want to use Word Exact Extraction for extracting IDs from a document.  For example, you could use it to extract part numbers or invoice numbers.  Those aren’t something you would typically want to refine on but you may want to query on them.  FAST Search for SharePoint only provided case-sensitive extraction.  This made the feature less useful as you had to accommodate all possible varieties of case combinations in your dictionary file.

To get started, we need to create a dictionary file. I started with notepad and I also edited with Excel some.  The format is simple “Key,Display form”.  The key is what it matches and the Display form is what gets displayed in the refiner.  Although the Display form is optional, you want to include it as it allows you to control the exact way the text looks in the refiner (including case sensitivity).  Here’s the dictionary file I created.

Key,Display form

bcs,Business Connectivity Services

Business Connectivity Services,Business Connectivity Services

wcm,Web Content Management

Web Content Management,Web Content Management

bi,Business Intelligence

Business Intelligence,Business Intelligence

ecm,Electronic Content Management

Electronic Content Management,Electronic Content Management

Apps,Apps

Analytics,Analytics

Development,Development

Service Application,Service Application

Excel Services,Excel Services

Office Web Apps,Office Web Apps

owa,Office Web Apps

wac,Office Web Apps

PerformancePoint,Business Intelligence

Search,Search

Social,Social

My Sites,My Sites

Communities,Social

Visio Services,Visio Services

Workflow,Workflow

The next step is to use the PowerShell command, Import-SPEnterpriseSearchCustomExtractionDictionary.  The documentation on this page is correct which is how I found the solution to my problem.  The first step is to get a reference to the Search Service Application using Get-SPEnterpriseSearchServiceApplication.  Then for our import command, we pass the service application, the Filename, and the DictionaryName.  Here’s where the complexity comes in.  The Filename requires a UNC path.  That means something like \\servername\path\file.csv.  It won’t take a relative path.  The next tricky part is where I found an issue in the documentation.  I wanted to use the Word Part extraction, it has the case of the word “WordPart” incorrect in the dictionary name.  If you do specify the DictionaryName wrong, it will not work.  Here are the list of valid values which correspond to the extraction types we talked about above.

  • Microsoft.UserDictionaries.EntityExtraction.Custom.Word.n [where n = 1,2,3,4 or 5]
  • Microsoft.UserDictionaries.EntityExtraction.Custom.ExactWord.1
  • Microsoft.UserDictionaries.EntityExtraction.Custom.WordPart.n [where n = 1,2,3,4 or 5]
  • Microsoft.UserDictionaries.EntityExtraction.Custom.ExactWordPart.1

For the non-exact entries, you need to specify a value at the end (1 – 5) which specifies which extraction dictionary it uses.  In the case below, I did number 2 since I already messed up number 1 by specifying the dictionary name incorrectly. :)

$searchApp = Get-SPEnterpriseSearchServiceApplication

Import-SPEnterpriseSearchCustomExtractionDictionary –SearchApplication $searchApp –Filename \\server\c$\folder\WordPartExtraction.csv –DictionaryName Microsoft.UserDictionaries.EntityExtraction.Custom.WordPart.2

When you run the commands, it will look like this.  I put the above in a script file for convenience.

SearchImportCustomEntityExtractorPowerShell

The next part I believe is a little different than the way you did it with FAST Search for SharePoint.  What you need to do is tell search which managed properties to perform entity extraction.  Effectively, what we are doing here is telling search to look at the body of the document and see if anything in there matches items in the dictionary.  To do this, go to your Search Service Application –> Search Schema and edit the property named body

ManagedPropertiesBody

Scroll to the bottom and you will see the Custom entity extraction section.  Now, we just need to check the box next to the dictionary we want to use.  In my case, it is Word Part Extraction – Custom2.  If you have multiple dictionaries you may select them here.  Save the managed property after you make your selection.

ManagedPropertyCustomEntityExtraction

After you save, you need to start a full crawl on your content source, typically Local SharePoint sites

When this finishes, we can now begin to use our new extracted entities in our search center.  The first thing we want to do is add this new extraction to the Refinement web part so that users can refine results by SharePoint feature.  Go to your Search Center and issue a query that is going to get you some results that you know you can refine on.  In my case, I typed the word SharePoint since I knew all of my documents were related to that.  Once you get search results, edit the page.  Then on the left side, edit the Refinement web part.  Now, click the Choose Refiners button. 

RefinementWebPartProperties

This page will list all managed properties marked for refinement.  What’s really nice is that when you click on a managed property, it gives you a preview of the available refiners.

CustomEntityExtractionRefinerProperties

In the list of available refiners, I select WordPartCustomRefiner2.  Below, you see a list of Sample values and the number of times it found a match.  To configure the property, select it and click the Add button.  I also added this new refiner up to the top since I want users to see it first.

CustomEntityExtractionRefinerProperties2

Now, I gave it a Display name and you have the option to choose a different Display template as well as how it is sorted.  You can actually customize how the refiner is rendered on the page with the display template too but that’s outside of the scope of today’s post.  At the bottom of the page there is also a Preview button.  Click on it and you will see what your search results look like before you even save the page.

CustonEntityExtractionRefinementPreview

If you’re happy with the way the refiners look, save the page, check it in, and publish it.  Now issue a query.  I am going to use the same one from before.

CustomEntityExtractionSearchResultsDefault

As you can see, we now see a list of the SharePoint features that we specified in our dictionary.  Let’s try a few refiners.  Let’s start by selecting Electronic Content Management.  I do know that should it read Enterprise, but it was after midnight when I started working on this. :)

CustomEntityExtractionSearchResultsECM

Notice, that in the results, that Word Document 3 comes back and you see “ECM” in it.  That’s the only text in the document and it matched it to that feature since we defined it in the dictionary.  Now let’s try Business Connectivity Services.

CustomEntityExtractionSearchResultsBCS

It returns several slide decks this time because it mentions it in the Intro deck, the BCS deck, UPS, etc.  I’m not sue how Visio Services made a hit to it, but maybe there is something new I need to learn. :)

You can also select multiple refiners.  In this case, I selected Apps and Web Content Management.

CustomEntityExtractionSearchResultsCombined

By now, I am hoping you are seeing the power of entity extraction.  It gives you a new level of classification on documents and the users never had to tag anything manually at all. 

You can issue queries with these dictionaries as well too.  For example, if I want to search for anything tagged with Apps, I would issue the following query.

WordPartCustomRefiner2:"Apps"

CustomEntityExtractionSearchResultsQuery

I hope after reading this post, it has got you started thinking.  Most organizations have next to no metadata on their documents.  This isn’t a replacement for taking the time to classify your documents properly with site columns and content types.  Inferring metadata will never be as good as the users taking the time to classify the documents themselves.  However, it is a great stop-gap in dealing with all of that untagged content you have. 

I think this is one of the most significant feature in SharePoint 2013 that most people will probably never use.  :(  Take the time to set up a few dictionaries and you are going to get immediate value out of search and your users are going to notice.

Read the original blog entry...

More Stories By Corey Roth

Corey Roth, a SharePoint Server MVP, is a consultant at Hitachi Consulting specializing in SharePoint and Office 365 for clients in the energy sector. He has more than ten years of experience delivering solutions in the energy, travel, advertising and consumer electronics verticals.

Corey specializes in delivering ECM and search solutions to clients using SharePoint. Corey has always focused on rapid adoption of new Microsoft technologies including Visual Studio 2013, Office 365, and SharePoint.

He is a member of the .NET Mafia (www.dotnetmafia.com) where he blogs about the latest technology and SharePoint. He is dedicated to the community and speaks regularly at user groups and SharePoint Saturdays.

@ThingsExpo Stories
Connected devices and the Internet of Things are getting significant momentum in 2014. In his session at Internet of @ThingsExpo, Jim Hunter, Chief Scientist & Technology Evangelist at Greenwave Systems, examined three key elements that together will drive mass adoption of the IoT before the end of 2015. The first element is the recent advent of robust open source protocols (like AllJoyn and WebRTC) that facilitate M2M communication. The second is broad availability of flexible, cost-effective storage designed to handle the massive surge in back-end data in a world where timely analytics is e...
The Internet of Things will put IT to its ultimate test by creating infinite new opportunities to digitize products and services, generate and analyze new data to improve customer satisfaction, and discover new ways to gain a competitive advantage across nearly every industry. In order to help corporate business units to capitalize on the rapidly evolving IoT opportunities, IT must stand up to a new set of challenges. In his session at @ThingsExpo, Jeff Kaplan, Managing Director of THINKstrategies, will examine why IT must finally fulfill its role in support of its SBUs or face a new round of...
How do APIs and IoT relate? The answer is not as simple as merely adding an API on top of a dumb device, but rather about understanding the architectural patterns for implementing an IoT fabric. There are typically two or three trends: Exposing the device to a management framework Exposing that management framework to a business centric logic Exposing that business layer and data to end users. This last trend is the IoT stack, which involves a new shift in the separation of what stuff happens, where data lives and where the interface lies. For instance, it's a mix of architectural styles ...
We are reaching the end of the beginning with WebRTC, and real systems using this technology have begun to appear. One challenge that faces every WebRTC deployment (in some form or another) is identity management. For example, if you have an existing service – possibly built on a variety of different PaaS/SaaS offerings – and you want to add real-time communications you are faced with a challenge relating to user management, authentication, authorization, and validation. Service providers will want to use their existing identities, but these will have credentials already that are (hopefully) i...
Cultural, regulatory, environmental, political and economic (CREPE) conditions over the past decade are creating cross-industry solution spaces that require processes and technologies from both the Internet of Things (IoT), and Data Management and Analytics (DMA). These solution spaces are evolving into Sensor Analytics Ecosystems (SAE) that represent significant new opportunities for organizations of all types. Public Utilities throughout the world, providing electricity, natural gas and water, are pursuing SmartGrid initiatives that represent one of the more mature examples of SAE. We have s...
"Matrix is an ambitious open standard and implementation that's set up to break down the fragmentation problems that exist in IP messaging and VoIP communication," explained John Woolf, Technical Evangelist at Matrix, in this SYS-CON.tv interview at @ThingsExpo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
The Internet of Things will greatly expand the opportunities for data collection and new business models driven off of that data. In her session at @ThingsExpo, Esmeralda Swartz, CMO of MetraTech, discussed how for this to be effective you not only need to have infrastructure and operational models capable of utilizing this new phenomenon, but increasingly service providers will need to convince a skeptical public to participate. Get ready to show them the money!
One of the biggest challenges when developing connected devices is identifying user value and delivering it through successful user experiences. In his session at Internet of @ThingsExpo, Mike Kuniavsky, Principal Scientist, Innovation Services at PARC, described an IoT-specific approach to user experience design that combines approaches from interaction design, industrial design and service design to create experiences that go beyond simple connected gadgets to create lasting, multi-device experiences grounded in people's real needs and desires.
P2P RTC will impact the landscape of communications, shifting from traditional telephony style communications models to OTT (Over-The-Top) cloud assisted & PaaS (Platform as a Service) communication services. The P2P shift will impact many areas of our lives, from mobile communication, human interactive web services, RTC and telephony infrastructure, user federation, security and privacy implications, business costs, and scalability. In his session at @ThingsExpo, Robin Raymond, Chief Architect at Hookflash, will walk through the shifting landscape of traditional telephone and voice services ...
Scott Jenson leads a project called The Physical Web within the Chrome team at Google. Project members are working to take the scalability and openness of the web and use it to talk to the exponentially exploding range of smart devices. Nearly every company today working on the IoT comes up with the same basic solution: use my server and you'll be fine. But if we really believe there will be trillions of these devices, that just can't scale. We need a system that is open a scalable and by using the URL as a basic building block, we open this up and get the same resilience that the web enjoys.
The Internet of Things is tied together with a thin strand that is known as time. Coincidentally, at the core of nearly all data analytics is a timestamp. When working with time series data there are a few core principles that everyone should consider, especially across datasets where time is the common boundary. In his session at Internet of @ThingsExpo, Jim Scott, Director of Enterprise Strategy & Architecture at MapR Technologies, discussed single-value, geo-spatial, and log time series data. By focusing on enterprise applications and the data center, he will use OpenTSDB as an example t...
The Domain Name Service (DNS) is one of the most important components in networking infrastructure, enabling users and services to access applications by translating URLs (names) into IP addresses (numbers). Because every icon and URL and all embedded content on a website requires a DNS lookup loading complex sites necessitates hundreds of DNS queries. In addition, as more internet-enabled ‘Things' get connected, people will rely on DNS to name and find their fridges, toasters and toilets. According to a recent IDG Research Services Survey this rate of traffic will only grow. What's driving t...
Enthusiasm for the Internet of Things has reached an all-time high. In 2013 alone, venture capitalists spent more than $1 billion dollars investing in the IoT space. With "smart" appliances and devices, IoT covers wearable smart devices, cloud services to hardware companies. Nest, a Google company, detects temperatures inside homes and automatically adjusts it by tracking its user's habit. These technologies are quickly developing and with it come challenges such as bridging infrastructure gaps, abiding by privacy concerns and making the concept a reality. These challenges can't be addressed w...
Explosive growth in connected devices. Enormous amounts of data for collection and analysis. Critical use of data for split-second decision making and actionable information. All three are factors in making the Internet of Things a reality. Yet, any one factor would have an IT organization pondering its infrastructure strategy. How should your organization enhance its IT framework to enable an Internet of Things implementation? In his session at Internet of @ThingsExpo, James Kirkland, Chief Architect for the Internet of Things and Intelligent Systems at Red Hat, described how to revolutioniz...
Bit6 today issued a challenge to the technology community implementing Web Real Time Communication (WebRTC). To leap beyond WebRTC’s significant limitations and fully leverage its underlying value to accelerate innovation, application developers need to consider the entire communications ecosystem.
The definition of IoT is not new, in fact it’s been around for over a decade. What has changed is the public's awareness that the technology we use on a daily basis has caught up on the vision of an always on, always connected world. If you look into the details of what comprises the IoT, you’ll see that it includes everything from cloud computing, Big Data analytics, “Things,” Web communication, applications, network, storage, etc. It is essentially including everything connected online from hardware to software, or as we like to say, it’s an Internet of many different things. The difference ...
Cloud Expo 2014 TV commercials will feature @ThingsExpo, which was launched in June, 2014 at New York City's Javits Center as the largest 'Internet of Things' event in the world.
SYS-CON Events announced today that Windstream, a leading provider of advanced network and cloud communications, has been named “Silver Sponsor” of SYS-CON's 16th International Cloud Expo®, which will take place on June 9–11, 2015, at the Javits Center in New York, NY. Windstream (Nasdaq: WIN), a FORTUNE 500 and S&P 500 company, is a leading provider of advanced network communications, including cloud computing and managed services, to businesses nationwide. The company also offers broadband, phone and digital TV services to consumers primarily in rural areas.
"There is a natural synchronization between the business models, the IoT is there to support ,” explained Brendan O'Brien, Co-founder and Chief Architect of Aria Systems, in this SYS-CON.tv interview at the 15th International Cloud Expo®, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
The major cloud platforms defy a simple, side-by-side analysis. Each of the major IaaS public-cloud platforms offers their own unique strengths and functionality. Options for on-site private cloud are diverse as well, and must be designed and deployed while taking existing legacy architecture and infrastructure into account. Then the reality is that most enterprises are embarking on a hybrid cloud strategy and programs. In this Power Panel at 15th Cloud Expo (http://www.CloudComputingExpo.com), moderated by Ashar Baig, Research Director, Cloud, at Gigaom Research, Nate Gordon, Director of T...