Mystery Solved – Crawled Properties in SharePoint (Part 4)


We’ve gone through quite a bit of details covering crawled properties including an overview, deep dive into what makes up crawled properties, and detail on the Basic and Mail categories. This post will cover the Crawled Property Category called “Office”.


Crawled Properties View – Office


The Office category includes gathering metadata from Microsoft Word documents, Microsoft Excel spreadsheets, Microsoft PowerPoint slides, etc.


Crawled Property Category - Office


The following table provides details about each of the crawled properties in the Basic category based on a test environment. The table is sorted by Property Set ID, or GUID, then by Name and includes the following columns:


Name – The name of the crawled property


Represented in Crawled Properties View – The name of the crawled property in the Crawled Properties View


Property Name – A description of what the property is


PROPSET – The GUID or Property Set ID


Property Set Description – A description of the property set for which this is a member


Variant Type – The variant type of the property


Variant Type Description – A description of the variant type


Mapped To – A listing of which managed property(ies) this crawled property is mapped to


Indexed – Indicates whether this property is included in the index from an “out of the box” installation.


 


 


NOTE: Your environment may have more or less crawled properties based on the content being crawled. 














































































































































































































































































































































































































































































































































NAME:


Represented in Crawled Properties View


Property Name


PROPSET


Property Set Description


Variant Type


Variant Type Description


Mapped To


Index


2


Office:2(Text)


Category (i.e. memo, proposal, etc)


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


31


Text


Yes


3


n/a


Document Presentation Format (i.e. 35mm, printer, video, etc)


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


31


Text


5


Office:5(Integer)


Document Line Count


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


20


Integer


6


Office:6(Integer)


Document Paragraph Count


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


20


Integer


7


n/a


Slide Count


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


20


Integer


8


n/a


Document Note Count


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


20


Integer


9


n/a


Hidden Slide Count


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


20


Integer


10


n/a


Multimedia Clip Count


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


20


Integer


11


Office:11(Yes/No)


Scale (set to True (-1) when scaling of thumbnail)


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


11


Yes/No


12


Office:12(Binary Data)


Heading Pair (internal property indicating the grouping of different document parts and the number of items in each group)


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


4108


Binary Data


13


Office:13(Text)


partTitles (DocParts) (names of document parts)


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


31


Text


14


Office:14(Text)


Document Manager


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


31


Text


Yes


15


Office:15(Text)


Company or Publisher


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


31


Text


Yes


16


Office:16(Yes/No)


Links Dirty


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


11


Yes/No


17


Office:17(Integer)


CCH with Spaces (number of characters including spaces)


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


20


Integer


18


Office:18(Text)


GUID (no longer used)


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


0


Text


Yes


19


Office:19(Yes/No)


Shared Doc


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


11


Yes/No


22


Office:22(Yes/No)


Hyperlinks Changed


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


11


Yes/No


23


Office:23(Integer)


Version


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


20


Integer


26


Office:26(Text)


Content Type


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


31


Text


Yes


27


Office:27(Text)


Content Status


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


0


Text


28


Office:28(Text)


Language


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


0


Text


29


Office:29(Text)


Document Version


d5cdd502-2e9c-101b-9397-08002b2cf9ae


Document Summary Information


0


Text


2


Office:2(Text)


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


3


Office:3(Text)


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


4


Office:4(Text)


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


_PID_HLINKS


_PID_HLINKS(Binary Data)


Document hyperlink references


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


65


Binary Data


_SharedFileIndex


_SharedFileIndex(Text)


Site ID of the document workspace


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


_SourceUrl


_SourceUrl(Text)


Address of the Source Workspace Library


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


ContentType


ContentType(Text)


Content Type


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


ContentTypeId


ContentTypeId(Text)


Content Type ID


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


PROP_MULTVAL_PP


PROP_MULTVAL_PP(Text)


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


PROP_MULTVAL_QQ


PROP_MULTVAL_QQ(Text)


d5cdd505-2e9c-101b-9397-08002b2cf9ae


User Defined Properties


31


Text


Yes


2


Office:2(Text)


Title


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


3


Office:3(Text)


Subject


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


DocSubject(Text)


Yes


4


Office:4(Text)


Author


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


Author(Text)


5


Office:5(Text)


Keywords


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


DocKeywords(Text)


6


Office:6(Text)


Description (or Comments)


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


Description(Text), DocKeywords(Text)


Yes


7


Office:7(Text)


Template


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


Yes


8


Office:8(Text)


Last Author


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


Yes


9


Office:9(Text)


Doc Revision Number


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


Yes


9


n/a


Doc Revision Number (variant)


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


0


Text


10


Office:10(Date and Time)


Edit Time Date/Time


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


64


Date and Time


11


Office:11(Date and Time)


Last Printed


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


0


Text


12


Office:12(Date and Time)


Content Created Date/Time


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


64


Date and Time


Created(Date and Time)


13


Office:13(Date and Time)


Last Saved Date/Time


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


64


Date and Time


14


Office:14(Integer)


Page Count


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


20


Integer


15


Office:15(Integer)


Word Count


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


20


Integer


16


Office:16(Integer)


Character Count


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


20


Integer


18


Office:18(Text)


Application Name


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


31


Text


19


Office:19(Integer)


Document Security


f29f85e0-4ff9-1068-ab91-08002b27b3d9


Summary Information


20


Integer

Comments (1)

  1. Josep says:

    Hi,

    I have a column called "Policy" and I created a managed property that was mapping the crawled property ows_Policy(text).

    I realized that there was another crawled property called 'Policy(text)' and I also created a managed property to check what content was returning on it. This crawled property only returns values when the document indexed is an office document but not a pdf and the crawled property is in the office category.

    Do you know why could this crawled property be in the office category and why is only returning values with the office documents and not pdfs?

    thanks