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.
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
- Anonymous
November 25, 2010
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