Anne Stenberg's Blog

Wednesday, January 28, 2009 12:33 PM

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"

Posted by Anne Stenberg | 0 Comments

Filed under: read-only, edit office document

Tuesday, November 25, 2008 5:13 PM

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

Posted by Anne Stenberg | 1 Comments

Filed under: MOSS, crawled properties, Sharepoint, category, web

Tuesday, November 25, 2008 4:57 PM

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

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)

Posted by Anne Stenberg | 0 Comments

Filed under: MOSS, crawled properties, search, people

Tuesday, November 25, 2008 12:34 PM

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

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)

Anne Stenberg's Blog

This Blog

Syndication

Search

Tags

Archives

Editing a Document in SharePoint Opens as Read-Only

TROUBLESHOOTING

Mystery Solved - Crawled Properties in SharePoint (Part 7)

Crawled Properties View – Web

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

Mystery Solved - Crawled Properties in SharePoint (Part 6)

Crawled Properties View – SharePoint