Welcome to TechNet Blogs Sign in | Join | Help

Editing a Document in SharePoint Opens as Read-Only

I have worked with a few customers that have run across an issue when they want to edit documents from a SharePoint site, they will only open as read-only. Some machines will only open documents from a SharePoint document library as Read-Only while other machines, logged on as the same user, allow the user to open the documents for editing. The same procedure is used on both machines where you select the drop-down arrow and choose “Edit in Excel” (or Word or PowerPoint). All permissions have been verified as correct.

TROUBLESHOOTING

1)     Download ProMon.exe from http://live.sysinternals.com. You have the choice to either run it from sysinternals or download it and run on your machine.

2)     Make sure procmon.exe is running on a "good" and "bad" machine then reproduce the issue on the “good” machine and the “bad” machine

3)     Once the issue is reproduced, save the files as CSV files using names such as good.csv and bad.csv.

4)     Download Beyond Compare from http://www.download.com/Beyond-Compare/3000-2248_4-10577526.html to your local machine

5)     Open the two CSV ProcMon files in Beyond Compare and look for any “ACCESS DENIED” messages similar to these that were on the “bad” machine

a)     1:03:00 PM EXCEL.EXE:7796 OPEN j:\apps_pub\msop2k40\msopkg\PROGRA~1\COMMON~1\System\OLEDB~1\MSDAURL.DLL ACCESS DENIED DOMAIN\username

b)    1:03:00 PM EXCEL.EXE:7796 OPEN J:\apps_pub\msop2k40\msopkg\PROGRA~1\COMMON~1\System\OLEDB~1\MSDAURL.DLL ACCESS DENIED DOMAIN\username

c)     1:03:00 PM EXCEL.EXE:7796 OPEN J:\apps_pub\msop2k40\msopkg\PROGRA~1\COMMON~1\System\OLEDB~1\MSDAURL.DLL ACCESS DENIED DOMAIN\username

d)    1:03:00 PM EXCEL.EXE:7796 OPEN J:\apps_pub\msop2k40\msopkg\PROGRA~1\COMMON~1\System\OLEDB~1\MSDAURL.DLL ACCESS DENIED DOMAIN\username

e)     1:03:00 PM procexp.exe:5564 QUERY INFORMATION I:\documents\Excel\ SUCCESS FileBasicInformation

f)     1:03:00 PM EXCEL.EXE:7796 OPEN J:\apps_pub\msop2k40\msopkg\PROGRA~1\COMMON~1\System\OLEDB~1\MSDAURL.DLL ACCESS DENIED DOMAIN\username

6)     Open the RegMon files to see what’s missing on the “bad” machine as compared to the “good” machine

a)     You’ll want to concentrate mostly on the following Registry entries

i)      FF151822-B0BF-11D1-A80D-000000000000

ii)     MSDAURL.Binder.1

iii)     MSDAURL.Binder

RESOLUTION
On the “bad” machine, if you have ACCESS DENIED on MSDAURL.DLL from ProcMon and the Registry entries are missing, then we need to add the Registry keys on the “bad” machine.

1)     Copy and paste the text under CLSID_FIX to notepad and save the file as CLSID_FIX.reg

2)     Double-click the CLSID_FIX.reg file to install the keys

3)     From a command prompt, re-register these dll’s

a)     Regsvr32.exe “c:\program files\common files\system\OLE DB\MSDAURL.DLL”

b)    Regsvr32.exe “c:\program files\common files\system\OLE DB\MSDAIPP.DLL”

4)     Reboot the machine


CLSID_FIX

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}]
@="Microsoft OLE DB Root Binder for Internet Publishing"

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}\InprocServer32]
@="C:\\Program Files\\Common Files\\system\\ole db\\oledb32.dll"
"ThreadingModel"="Both"

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}\OLE DB Binder]
@="Microsoft OLE DB Root Binder"

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}\ProgID]
@="MSDAURL.Binder.1"

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}\VersionIndependentProgID]
@="MSDAURL.Binder"

[HKEY_CLASSES_ROOT\MSDAURL.Binder.1]
@="Microsoft OLE DB Root Binder for Internet Publishing"

[HKEY_CLASSES_ROOT\MSDAURL.Binder.1\CLSID]
@="{FF151822-B0BF-11D1-A80D-000000000000}"

[HKEY_CLASSES_ROOT\MSDAURL.Binder]
@="Microsoft OLE DB Root Binder for Internet Publishing"

[HKEY_CLASSES_ROOT\MSDAURL.Binder\CLSID]
@="{FF151822-B0BF-11D1-A80D-000000000000}"

[HKEY_CLASSES_ROOT\MSDAURL.Binder\CurVer]
@="MSDAURL.Binder.1"

Mystery Solved - Crawled Properties in SharePoint (Part 7)

Up to this point, we have gone through the details of the following Crawled Property Categories: 

  • Overview
  • Basic Category
  • Office Category
  • People Category
  • SharePoint Category
  • Mail Category

This post will cover the details of the Web Category of Crawled Properties.

Crawled Properties View – Web

The Web Crawled Property Category contains metadata of the page(s) such as the code page, anchor text, when a page expires, description, etc. The majority of crawled properties in this category are self-explanatory.

Crawled Property Category - Web

 

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

Web:2(Text)

href

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

Path(Text)

Yes

3

Web:3(Text)

HTML Heading 1

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

4

Web:4(Text)

HTML Heading 2

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

5

Web:5(Text)

HTML Heading 3

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

6

Web:6(Text)

HTML Heading 4

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

7

Web:7(Text)

HTML Heading 5

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

8

Web:8(Text)

HTML Heading 6

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

IMG.ALT

IMG.ALT(Text)

Alternate Text for Image

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

INPUT.ALT

INPUT.ALT(Text)

Alternate Text for Image

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

31

Text

SELECT

SELECT(Text)

Drop Down List

70eb7a10-55d9-11cf-b75b-00aa0051fe20

HTML Information

32799

Binary Data

Yes

2

Web:2(Integer)

Detected Language

c82bf596-b831-11d0-b733-00aa00a1ebd2

NetLib Info

19

Integer

3

Web:3(Text)

HTML Comment

c82bf596-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

4

Web:4(Integer)

Code Page

c82bf596-b831-11d0-b733-00aa00a1ebd2

NetLib Info

19

Integer

NLCodePage(Integer)

A.ENDANCHOR

A.ENDANCHOR(Text)

End Anchor Text

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

A.HREF

A.HREF(Text)

HTML Link

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

APPLET.CODE

APPLET.CODE(Text)

Applet Code

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

APPLET.CODEBASE

APPLET.CODEBASE(Text)

Directory path of applet class

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

AREA.HREF

AREA.HREF(Text)

HTML Area Reference

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

BASE.HREF

BASE.HREF(Text)

HTML Link to only web pages

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

Yes

BGSOUND.SRC

BGSOUND.SRC(Text)

Background Sound

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

BODY.BACKGROUND

BODY.BACKGROUND(Text)

Backgound color/image of page

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

EMBED.SRC

EMBED.SRC(Text)

Embeded source in page

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

FRAME.SRC

FRAME.SRC(Text)

Source of frame in page

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

GENERATOR

GENERATOR(Text)

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

IFRAME.SRC

IFRAME.SRC(Text)

URL of page in iFrame

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

IMG.DYNSRC

IMG.DYNSRC(Text)

Dymanic Source of media Image

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

IMG.SRC

IMG.SRC(Text)

Source of image

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

INPUT.SRC

INPUT.SRC(Text)

URL of image to display

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

LINK.HREF

LINK.HREF(Text)

URL of linked web resource

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

LINK.OFFICECHILD

LINK.OFFICECHILD(Text)

URL of child links

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

LINK.OFFICECHILDLIST

LINK.OFFICECHILDLIST(Text)

URLs of child lists

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

LINK.STYLESHEET

LINK.STYLESHEET(Text)

URL of linked style sheet

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

META.URL

META.URL(Text)

URL metadata

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

OBJECT.CODE

OBJECT.CODE(Text)

URL of file containing compiled Java Class

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

OBJECT.CODEBASE

OBJECT.CODEBASE(Text)

URL of the component

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

SCRIPT

SCRIPT(Text)

Script for the page

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

STYLE

STYLE(Text)

Settings of inline styles for an element

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

TABLE.BACKGROUND

TABLE.BACKGROUND(Text)

Color/image of table background

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

TD.BACKGROUND

TD.BACKGROUND(Text)

Background color/image of drop down list

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

TH.BACKGROUND

TH.BACKGROUND(Text)

Background of table header

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

TR.BACKGROUND

TR.BACKGROUND(Text)

Background of table row

c82bf597-b831-11d0-b733-00aa00a1ebd2

NetLib Info

31

Text

COLLABORATIONSERVER

COLLABORATIONSERVER(Text)

Meta name of SharePoint Team Web Site

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

CONTENT-TYPE

CONTENT-TYPE(Text)

Content Type

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

DESCRIPTION

DESCRIPTION(Text)

Description

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

Description(Text)

Yes

EXPIRES

EXPIRES(Text)

Expire

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

GENERATOR

GENERATOR(Text)

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

HELPAWSKEYWORD

HELPAWSKEYWORD(Text)

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

Yes

PROGID

PROGID(Text)

Program ID

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

ROBOTS

ROBOTS(Text)

Robots

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

TOPIC

TOPIC(Text)

Topic

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1

HTML Meta Info

31

Text

Yes

 

There are five categories left of which we have not covered:

Business Data

Internal

Notes

Tiff

XML

When I gather more information on the above Crawled Property Categories, I'll update this blog. I sure hope you've enjoyed this series of technical drill down into the crawled properties in Microsoft Office SharePoint Server 2007

Crawled Properties in SharePoint-Part (Part 5) - Mystery Solved

For some reason, I couldn't continue with my same title format so I changed it around a bit. In this post, we'll discover the details of the crawled properties in the "People" category.

 

Crawled Properties View – People

People search in SharePoint provides a robust set of crawled properties that can you to find just about anyone anywhere. Not only can you search on their name, department, manager, etc, but customization of the People Search enables you to search on their interests, which SharePoint groups a person belongs to, skills, and more. When profiles are imported from Active Directory, LDAP, or other sources, this information is automatically populated in their MySite information and available for searching.

 

Crawled Property Category - People

 

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

ADGuid

ADGuid(Binary Data)

00110329-0000-0110-c000-000000111146

People Profile Information

65

Binary Data

ADGuid(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:AboutMe

People:AboutMe(Text)

About Me

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

AboutMe(Text), Description(Text), HighConfidenceDisplayProperty8(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:AccountName

People:AccountName(Text)

Account Name

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

AccountName(Text), HighConfidenceMatching(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:Assistant

People:Assistant(Text)

Assistant

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

Assistant(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:CellPhone

People:CellPhone(Text)

Cell Phone

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

MobilePhone(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:Department

People:Department(Text)

Department

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

Department(Text), HighConfidenceDisplayProperty3(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:Fax

People:Fax(Text)

Fax

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

Fax(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:FirstName

People:FirstName(Text)

First Name

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

FirstName(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:HomePhone

People:HomePhone(Text)

Home Phone

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HomePhone(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:LastName

People:LastName(Text)

Last Name

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

LastName(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:Manager

People:Manager(Text)

Manager

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

Manager(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:Office

People:Office(Text)

Office

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceDisplayProperty4(Text), HighConfidenceDisplayProperty7(Text), OfficeNumber(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:PersonalSpace

People:PersonalSpace(Text)

Personal Space

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

PersonalSpace(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:PictureURL

People:PictureURL(Text)

Picture URL

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceImageURL(Text), PictureURL(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:PreferredName

People:PreferredName(Text)

Preferred Name

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceDisplayProperty5(Text), HighConfidenceMatching(Text), PreferredName(Text), Title(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:PublicSiteRedirect

People:PublicSiteRedirect(Text)

Public Site Redirect

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

PublicSiteRedirect(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:QuickLinks

People:QuickLinks(Text)

Quick Links

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

Memberships(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:SID

People:SID(Binary Data)

SID

00110329-0000-0110-c000-000000111146

People Profile Information

65

Binary Data

SID(Binary Data)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-Birthday

People:SPS-Birthday(Date and Time)

Birthday

00110329-0000-0110-c000-000000111146

People Profile Information

64

Date and Time

Birthday(Date and Time)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-DataSource

People:SPS-DataSource(Text)

Data Source

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

DataSource(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-Dotted-line

People:SPS-Dotted-line(Text)

Dotted Line

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

DottedLine(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-HireDate

People:SPS-HireDate(Date and Time)

Hire Date

00110329-0000-0110-c000-000000111146

People Profile Information

64

Date and Time

HireDate(Date and Time)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-Interests

People:SPS-Interests(Text)

Interests

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

Interests(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-Memberof

People:SPS-Memberof(Text)

Member Of

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

MemberOf(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-MySiteWizard

People:SPS-MySiteWizard(Yes/No)

My Site Wizard

00110329-0000-0110-c000-000000111146

People Profile Information

11

Yes/No

MysiteWizard(Yes/No)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-PastProjects

People:SPS-PastProjects(Text)

Past Projects

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

PastProjects(Text)

Yes

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-Peers

People:SPS-Peers(Text)

Peers

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

Peers(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-ProxyAddresses

People:SPS-ProxyAddresses(Text)

Proxy Addresses

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

ProxyAddresses(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-Responsibility

People:SPS-Responsibility(Text)

Responsibility

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceDisplayProperty9(Text), Responsibilities(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-School

People:SPS-School(Text)

School

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

Schools(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-SipAddress

People:SPS-SipAddress(Text)

Sip Address

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

SipAddress(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:SPS-Skills

People:SPS-Skills(Text)

Skills

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceDisplayProperty10(Text), Skills(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:Title

People:Title(Text)

Title

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceDisplayProperty1(Text), HighConfidenceDisplayProperty6(Text), JobTitle(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:UserName

People:UserName(Text)

User Name

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceMatching(Text), UserName(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:UserProfile_GUID

People:UserProfile_GUID(Text)

User Profile GUID

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

UserProfile_GUID(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:WebSite

People:WebSite(Text)

Web Site

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

WebSite(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:WorkEmail

People:WorkEmail(Text)

Work Email

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceDisplayProperty11(Text), HighConfidenceMatching(Text), WorkEmail(Text)

urn:schemas-microsoft-com:sharepoint:portal:profile:WorkPhone

People:WorkPhone(Text)

Work Phone

00110329-0000-0110-c000-000000111146

People Profile Information

31

Text

HighConfidenceDisplayProperty2(Text), WorkPhone(Text)

Mystery Solved - Crawled Properties in SharePoint (Part 6)

We have already covered quite a bit of crawled properties in SharePoint in Posts 1-5 but there still a few more categories to go through. This post will cover the crawled property category called "SharePoint".

Crawled Properties View – SharePoint

The SharePoint Crawled Property category contains probably the largest set of crawled properties of any category. A crawled property will automatically be created for each and every content type, column name, etc.  Automatically generated crawled properties in this category begin with “ows” as shown in the following table.

 

Crawled Property Category - SharePoint

 

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

DAV:contentclass

DAV:contentclass(Text)

Content Class

00020329-0000-0000-c000-000000000046

Characterization

31

Text

contentclass(Text), HighConfidenceResultType(Text)

DAV:iscollection

DAV:iscollection(Yes/No)

Is this part of a collection

00020329-0000-0000-c000-000000000046

Characterization

11

Yes/No

urn:schemas.microsoft.com:sharepoint:portal:isdocument

SharePoint:isdocument(Integer)

Is Document

00020329-0000-0000-c000-000000000046

Characterization

20

Integer

IsDocument(Integer)

urn:schemas-microsoft-com:publishing:PluggableSecurityTrimmerId

SharePoint:PluggableSecurityTrimmerId(Integer)

Security Trimming

00020329-0000-0000-c000-000000000046

Characterization

3

Integer

ChangeID

ChangeID(Text)

Change ID

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

CRC

CRC(Integer)

CRC

00130329-0000-0130-c000-000000131346

SharePoint Properties

20

Integer

ObjectID

ObjectID(Text)

Object ID

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows__CheckinComment

ows__CheckinComment(Text)

Version comments

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows__ModerationStatus

ows_ModerationStatus(Integer)

Moderation Status (Workflows)

00130329-0000-0130-c000-000000131346

SharePoint Properties

20

Integer

ows__UIVersionString

ows__UIVersionString(Text)

Version value

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Assigned_x0020_To

ows_Assigned_x0020_To(Text)

Assigned To

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

AssignedTo(Text)

Yes

ows_AssignedTo

ows_AssignedTo(Text)

Assigned To

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

AssignedTo(Text)

Yes

ows_AuthorUserId

ows_AuthorUserId(Text)

Author's User ID

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_AutoUpdate

ows_AutoUpdate(Yes/No)

Auto Update

00130329-0000-0130-c000-000000131346

SharePoint Properties

11

Yes/No

ows_AutoUpdate

ows_AutoUpdate(Yes/No)

Auto Update

00130329-0000-0130-c000-000000131346

SharePoint Properties

11

Yes/No

ows_BaseName

ows_BaseName(Text)

Document Title

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Body

ows_Body(Text)

Body of document

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_BodyAndMore

ows_BodyAndMore(Text)

Body of document

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Category

ows_Category(Text)

Document Category

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Cell_x0020_Phone

ows_Cell_x0020_Phone(Text)

Cell Phone Number

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

MobilePhone(Text)

Yes

ows_CellPhone

ows_CellPhone(Text)

Cell Phone Number

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

MobilePhone(Text)

Yes

ows_Comments

ows_Comments(Text)

Comments

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_Company

ows_Company(Text)

Company

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_ConnectionType

ows_ConnectionType(Text)

Connection Type

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_ContentType

ows_ContentType(Text)

Content Type

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Created

ows_Created(Text)

Created Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Created_x0020_By

ows_Created_x0020_By(Text)

Created By

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_Created_x0020_Date

ows_Created_x0020_Date(Text)

Created Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_DataSource

ows_DataSource(Text)

Data Source

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_Department

ows_Department(Text)

Department

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_Description

ows_Description(Text)

Description

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_DiscussionLastUpdated

ows_DiscussionLastUpdated(Date and Time)

Discussion Last Updated

00130329-0000-0130-c000-000000131346

SharePoint Properties

64

Date and Time

ows_DiscussionTitle

ows_DiscussionTitle(Text)

Discussion Title

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_DocIcon

ows_Docicon(Text)

Document Icon

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_Edit

ows_Edit(Text)

Edit

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_EMail

ows_Email(Text)

E-mail

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_EMail_x0020_

ows_Email_x0020_(Text)

E-mail

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_EncodedAbsThumbnailUrl

ows_EncodedAbsThumbnailUrl(Text)

Encoded Thumbnail URL

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_End_Anchor

ows_End_Anchor(Text)

End Anchor

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_End_x0020_Date

ows_End_x0020_Date(Text)

End Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_End_x0020_Date

ows_End_x0020_Date(Date and Time)

End Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

64

Date and Time

ows_EndDate

ows_EndDate(Text)

End Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_EndDate

ows_EndDate(Date and Time)

End Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

64

Date and Time

ows_EventDate

ows_EventDate(Date and Time)

Event Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

64

Date and Time

ows_Expires

ows_Expires(Date and Time)

Expires

00130329-0000-0130-c000-000000131346

SharePoint Properties

64

Date and Time

ows_File_x0020_Type

ows_File_x0020_Type(Text)

File Type

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_FileDirRef

ows_FileDirRef(Text)

File Directory Reference

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_FileLeafRef

ows_FileLeafReference(Text)

File Leaf Reference

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_FileRef

ows_FileRef(Text)

File Reference

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_FileSizeDisplay

ows_FileSizeDisplay(Text)

File Size Display

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_FileType

ows_FileType(Text)

File Type

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_First_x0020_Name

ows_First_x0020_Name(Text)

First Name

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_FirstName

ows_FirstName(Text)

First Name

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_fRecurrence

ows_fRecurrence(Integer)

Recurrence

00130329-0000-0130-c000-000000131346

SharePoint Properties

20

Integer

ows_Full_x0020_Name

ows_Full_x0020_Name(Text)

Full Name

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_FullName

ows_FullName(Text)

Full Name

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_Goal

ows_Goal(Integer)

Goal (part of KPI)

00130329-0000-0130-c000-000000131346

SharePoint Properties

5

Integer

ows_GoalFromWorkBook

ows_GoalFromWorkBook(Yes/No)

Goal from Workbook (part of KPI)

00130329-0000-0130-c000-000000131346

SharePoint Properties

11

Yes/No

ows_Home_x0020_Phone

ows_Home_x0020_Phone(Text)

Home Phone Number

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

HomePhone(Text)

Yes

ows_HomePhone

ows_HomePhone(Text)

Home Phone Number

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

HomePhone(Text)

Yes

ows_ID

ows_ID(Integer)

ID

00130329-0000-0130-c000-000000131346

SharePoint Properties

20

Integer

ows_Image_x0020_CreateDate

ows_Image_x0020_CreateDate(Text)

Date image created

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Image_x0020_CreateDate

ows_Image_x0020_CreateDate(Date and Time)

Date image created

00130329-0000-0130-c000-000000131346

SharePoint Properties

64

Date and Time

DatePictureTaken(Date and Time)

ows_Image_x0020_CreateDate

ows_Image_x0020_CreateDate(Text)

Image Create Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Image_x0020_CreateDate

ows_Image_x0020_CreateDate(Date and Time)

Image Create Date

00130329-0000-0130-c000-000000131346

SharePoint Properties

64

Date and Time

DatePictureTaken(Date and Time)

ows_ImageCreateDate

ows_ImageCreateDate(Text)

Date image created

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_ImageHeight

ows_ImageHeight(Integer)

Height of image

00130329-0000-0130-c000-000000131346

SharePoint Properties

20

Integer

PictureHeight(Integer)

ows_ImageSize

ows_ImageSize(Integer)

Size of image

00130329-0000-0130-c000-000000131346

SharePoint Properties

20

Integer

PictureSize(Integer)

ows_ImageSize

ows_ImageSize(Text)

Image Size

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_ImageThumbnailDisplay

ows_ImageThumbnailDisplay(Text)

Image Thumbnail Display

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_ImageWidth

ows_ImageWidth

Width of Image

00130329-0000-0130-c000-000000131346

SharePoint Properties

20

Integer

PictureWidth(Integer)

ows_IsEmptyList

ows_IsEmptyList(Yes/No)

Is the list empty?

00130329-0000-0130-c000-000000131346

SharePoint Properties

11

Yes/No

ows_isItem

ows_isItem(Yes/No)

Is this an item?

00130329-0000-0130-c000-000000131346

SharePoint Properties

11

Yes/No

ows_Issue_x0020_Status

ows_Issue_x0020_Status(Text)

Issue Status

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Status(Text)

Yes

ows_ItemChildCount

ows_ItemChildCount(Trext)

Item Child Count

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_ItemURL

ows_ItemURL(Text)

Item URL

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Job_x0020_Title

ows_Job_x0020_Title(Text)

Job Title

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

JobTitle(Text)

Yes

ows_JobTitle

ows_JobTitle(Text)

Job Title

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

JobTitle(Text)

Yes

ows_Keywords

ows_Keywords(Text)

Keywords

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Keywords(Text)

Yes

ows_KpiDescription

ows_KpiDescription(Text)

KPI Description

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

Yes

ows_Last_x0020_Modified

ows_Last_x0020_Modified(Text)

Last Modified

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

ows_Last_x0020_Name

ows_Last_x0020_Name(Text)

Last Name

00130329-0000-0130-c000-000000131346

SharePoint Properties

31

Text

LastName(Text)

Yes

ows_LastName

ows_LastName(Text)