Mystery Solved - Crawled Properties in SharePoint (Part 4)

Mystery Solved - Crawled Properties in SharePoint (Part 4)

  • Comments 1
  • Likes

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
  • 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

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment