Coveo Knowledge Base – Information Article – 060329-1

CES4-060329-1: Metadata for SharePoint References

The information in this technical note applies to:

Coveo Enterprise Search 4

Summary

This document contains complementary information for "Manage SharePoint References" article of Administration Tool's help.

Sharepoint Site, Portal and Area metadata
Sharepoint AreaListing metadata
Sharepoint Site Item metadata
Sharepoint List metadata
Sharepoint ListeItem metadata
Sharepoint ListItemAttachment metadata
Coveo metadata summary
Site MetaData


 
  Sharepoint Site, Portal and Area metadata
 
  Meta name Apply to Type Example Description  
  AllowAnonymousAccess Site, Portal and Area Boolean   Gets a Boolean value that specifies whether anonymous access is allowed for the site.  
  AnonymousViewListItems Site, Portal and Area Boolean   Gets or sets the level of access for anonymous users on the site  
  AppearanceDate Portal and Area only DateTime 2000-01-01 01:00:00 Gets or sets the date on which the area appears. This is not a security feature and does not affect the search behavior  
  AreaID Portal and Area only String 0f6b8442-1a69-4fe8-93d8-9c3d69d52c01 Gets the unique identifier of the area  
  AreaName Portal and Area only String Home Gets the name of the Area  
  Author Site, Portal and Area String domain\JohnSmith Gets a user object representing the user who created the Web site.  
  Bool1 Portal and Area only Boolean   A user-defined property that accepts a Boolean value.  
  Bool2 Portal and Area only Boolean   A user-defined property that accepts a Boolean value.  
  Bool3 Portal and Area only Boolean   A user-defined property that accepts a Boolean value.  
  coveo_AuthorID Site, Portal and Area Int32 1 The site author ID  
  coveo_AuthorLoginName Site, Portal and Area String domain\JohnSmith The site author login name  
  coveo_AuthorName Site, Portal and Area String John Smith The site author name  
  coveo_IsContainer Site, Portal and Area Int32 1 Whether or not the item is a container (always '1')  
  coveo_IsPersonalSite Personal Sites only Int32 1 Whether or not the site is a personal site  
  coveo_IsTopLevelSite Site, Portal and Area Int32 1 Whether or not the site is a top level site  
  coveo_ParentGUIDs Site, Portal and Area String 9c3d69d52c01 The site parent GUIDs  
  coveo_SiteID Site, Portal and Area String 9c3d69d52c01 The truncated site GUID  
  coveo_SiteName Site, Portal and Area String My Site Name The site name  
  coveo_SiteURI Site, Portal and Area String http://server/sites/MySite/MySubSite/ The site absolute URI (may NOT be empty)  
  coveo_Type Site, Portal and Area String Site, Portal or Area The sharepoint item type  
  CreationDate Portal and Area only DateTime 2000-01-01 01:00:00 Gets the date on which the area was created.  
  Datetime1 Portal and Area only DateTime 2000-01-01 01:00:00 A user-defined property that accepts a DateTime value  
  Depth Portal and Area only Int32 0 Gets the level of subareas  
  Description Site, Portal and Area String This is the description… Gets or sets the description for the site.  
  ExpirationDate Portal and Area only DateTime 2000-01-01 01:00:00 Gets or sets the date on which the area expires.  
  ExternalSecurity Site, Portal and Area Boolean    
  HonorOrder Portal and Area only Boolean   Gets or sets a value indicating whether the order is alphabetic or numeric.  
  InheritedSecurity Site, Portal and Area Boolean   Whether or not the securty are inherited from the parent site ?  
  InheritUrl Portal and Area only Int32 3 Gets or sets a value indicating the page on which the area is shown.  
  Int1 Portal and Area only Int32 -1 A user-defined property that accepts an Int32 value  
  Int2 Portal and Area only Int32 -1 A user-defined property that accepts an Int32 value  
  Int3 Portal and Area only Int32 -1 A user-defined property that accepts an Int32 value  
  IsBucketWeb Site, Portal and Area Boolean   Whether or not the site is a bucket site (C1, C2, etc) ?  
  IsPublicNav Portal and Area only Boolean   Gets or sets a value indicating whether the navigation bar is cached. This is a performance feature.  
  Language Site, Portal and Area Int32 1033 Gets the LCID for the language used on the site.  
  LargeIconUrl Portal and Area only String   Gets or sets the URL.  
  LastModified Site, Portal and Area DateTime 2000-01-01 01:00:00 Gets the date and time that an item was last modified in the site.  
  LastModifiedForceRecrawl Site, Portal and Area DateTime 2000-01-01 01:00:00  
  ListingCount Portal and Area only Int32 0 Gets the number of listings. DOES NOT WORK!!!  
  Navigation Portal and Area only String Show Gets or sets this area to appear on the UI.  
  NText1 Portal and Area only String   A user-defined property that accepts a String value  
  NVarChar1 Portal and Area only String   A user-defined property that accepts a String value  
  NVarChar2 Portal and Area only String   A user-defined property that accepts a String value  
  NVarChar3 Portal and Area only String   A user-defined property that accepts a String value  
  NVarChar4 Portal and Area only String   A user-defined property that accepts a String value  
  Order Portal and Area only Int32 0 Gets or sets the order of the area listing among the subareas.  
  Owner Portal and Area only String   Gets or sets the owner of the area.  
  OwnerEmail Portal and Area only String   Gets or sets the e-mail address of the area owner  
  OwnerGuid Portal and Area only String 00000000-0000-0000-0000-000000000000 Gets or sets the GUID of the area owner  
  OwnerPicture Portal and Area only String   Gets or sets the address of the picture  
  ParentID Portal and Area only String 00000000-0000-0000-0000-000000000000 Gets or sets the parent ID  
  Permissions Site, Portal and Area String <permissions>…</permissions> The site permissions XML stream  
  PortalURL Site, Portal and Area String / The site portal URL  
  SmallIconUrl Portal and Area only String   Gets or sets the URL of the small icon  
  SmallSite Site, Portal and Area Boolean    
  System Portal and Area only Boolean   Gets a value indicating whether the area is a system area, which cannot be deleted  
  Title Site, Portal and Area String Team Web Site Gets or sets the title for the Web site.  
  UrlNavigation Portal and Area only String /default.aspx Gets the URL  
  UrlOverride Portal and Area only String   Gets or sets the override URL  
  UsedInAutocat Site, Portal and Area Boolean    
  UserProfile_AboutMe Personal Sites only String <div class=ms-WPBody>Cool!</div> The user description  
  UserProfile_AccountName Personal Sites only String domain\JohnSmith The user account name  
  UserProfile_Assistant Personal Sites only String Assistant The user assistant  
  UserProfile_CellPhone Personal Sites only String CellPhone The user cell phone  
  UserProfile_Department Personal Sites only String Department The user department  
  UserProfile_DirectReports Personal Sites only String DirectReports The user to whom to report to  
  UserProfile_Fax Personal Sites only String Fax The user fax  
  UserProfile_FirstName Personal Sites only String John The user first name  
  UserProfile_GUID Personal Sites only String bc4b3204-43b1-49da-b490-c687b17c7c79 The user profile GUID  
  UserProfile_HomePhone Personal Sites only String HomePhone The user home phone  
  UserProfile_LastName Personal Sites only String Smith The user last name  
  UserProfile_Manager Personal Sites only String Manager The user manager  
  UserProfile_Office Personal Sites only String Quebec City The user office  
  UserProfile_PersonalSpace Personal Sites only String /personal/JohnSmith/ The user site URL  
  UserProfile_PictureURL Personal Sites only String http://JohnSmith/Picture.jpg The user picture URL  
  UserProfile_PreferredName Personal Sites only String John Smith The user name  
  UserProfile_PublicSiteRedirect Personal Sites only String PublicSiteRedirect The user site to redirect to  
  UserProfile_QuickLinks Personal Sites only String QuickLinks The user quick links  
  UserProfile_Title Personal Sites only String Title The user title  
  UserProfile_UserName Personal Sites only String JohnSmith The user user name  
  UserProfile_UserProfile_GUID Personal Sites only String bc4b3204-43b1-49da-b490-c687b17c7c79 The user profile GUID  
  UserProfile_WebSite Personal Sites only String WebSite The user web site  
  UserProfile_WorkEmail Personal Sites only String JohnSmith@domain.com The user email  
  UserProfile_WorkPhone Personal Sites only String (555) 555-5555 The user phone  
  ValidSecurityInfo Site, Portal and Area Boolean    
  WebID Site, Portal and Area String {9F3C0D8C-6565-4933-BDF9-D5EC5DB7530E} Gets the GUID for the site.  
  WebUrl Portal and Area only String / Gets the Web URL  


AreaListing MetaData


 
  Sharepoint AreaListing metadata
 
  Meta name Type Example Description  
  AppearanceDate DateTime 2000-01-01 01:00:00 Gets or sets the date on which the area listing appears.  
  AreaID String 0f6b8442-1a69-4fe8-93d8-9c3d69d52c01 Gets or sets the identifier of the area.  
  BestBet Boolean   Gets a value indicating whether the listing is a Best Bet.  
  Bool1 Boolean   This property is user-defined.  
  Bool2 Boolean   This property is user-defined.  
  Bool3 Boolean   This property is user-defined.  
  coveo_AreaListingExternalURL String http://www.coveo.com An external URL for the Area listing  
  coveo_AuthorID Int32 1 The area listing author ID  
  coveo_AuthorLoginName String domain\JohnSmith The area listing author login name  
  coveo_AuthorName String John Smith The area listing author name  
  coveo_ParentGUIDs String 9c3d69d52c01 The ares listing parent GUIDs  
  coveo_SiteID String 9c3d69d52c01 The truncated site GUID  
  coveo_SiteName String My Site Name The site name  
  coveo_SiteURI String http://server/sites/MySite/MySubSite/ The site absolute URI (may NOT be empty)  
  coveo_Type String AreaListing The sharepoint item type (always 'AreaListing')  
  CreationDate DateTime 2000-01-01 01:00:00 Gets the date on which the listing was created.  
  Datetime1 DateTime 2000-01-01 01:00:00 This property is a user-defined property that accepts a DateTime value.  
  Description String   Gets or sets the description of the listing.  
  ExpirationDate DateTime 2000-01-01 01:00:00 Gets or sets the date on which the listing expires.  
  GroupID Int32 0 Gets the group ID.  
  Int1 Int32 -1 This property is user-defined.  
  Int2 Int32 -1 This property is user-defined.  
  Int3 Int32 -1 This property is user-defined.  
  LargeIconUrl String   Gets or sets the URL of the large icon.  
  LastModified DateTime 2000-01-01 01:00:00 Gets the date on which the listing was last modified.  
  LastModifiedBy String domain\JohnSmith Gets the name of the user who last modified the listing.  
  ListingID String b1802070-edb0-486a-9d49-caa489b67cc6 Gets the unique identifier.  
  NText1 String   This property is user-defined.  
  NVarChar1 String   This property is user-defined.  
  NVarChar2 String   This property is user-defined.  
  NVarChar3 String   This property is user-defined.  
  NVarChar4 String   This property is user-defined.  
  Order Int32 0 Gets or sets the order.  
  PersonEmail String   Gets or sets the e-mail address of the person.  
  PersonGuid String 00000000-0000-0000-0000-000000000000 Gets or sets the SID of the person.  
  PersonPreferredName String   Gets or sets the preferred name of the person.  
  SmallIconUrl String   Gets or sets the URL of the small icon.  
  Status String Approved Gets or sets the status of the listing (Approved, Archived, Pending or Rejected)  
  Title String This is the area listing title Gets or sets the title of the listing.  
  Type String ExternalUrl Gets or sets the type of the listing (ExternalUrl, Keyword, News, Person, Site or TeamSite)  
  url String http://www.coveo.com Gets or sets the URL of the listing.  


SiteItem MetaData


 
  Sharepoint Site Item metadata
 
  Meta name Type Example Description  
  coveo_AuthorID Int32 1 The site author ID  
  coveo_AuthorLoginName String domain\JohnSmith The site author login name  
  coveo_AuthorName String John Smith The site author name  
  coveo_ParentGUIDs String 9c3d69d52c01 The site parent GUIDs  
  coveo_SiteID String 9c3d69d52c01 The truncated site GUID  
  coveo_SiteName String My Site Name The site name  
  coveo_SiteURI String http://server/sites/MySite/MySubSite/ The site absolute URI (may NOT be empty)  
  coveo_Type String SiteItem The sharepoint item type (always 'SiteItem')  


List MetaData


 
  Sharepoint List metadata
 
  Meta name Meta Type List Type Example Description  
  AdvanceHijri Int32 All 0 Gets or sets the number of days to extend or reduce the current month in Hijri calendars.  
  AllowDeletion Boolean All   Gets a Boolean value that indicates whether the list can be deleted.  
  AllowMultiResponses Boolean All   Gets or sets a Boolean value that specifies whether users are allowed multiple responses to the survey.  
  AnonymousPermMask Int32 All 0 Gets or sets the permissions for anonyomous users of the list.  
  Author Int32 All 1 Gets the user who created the list.  
  BaseType Int32 All 1 Gets the base type for the list.  
  CalendarType Int32 All 1 Gets or sets the calendar type used in Windows SharePoint Services based on the locale of the server.  
  coveo_AuthorID Int32 All 1 The list author ID  
  coveo_AuthorLoginName String All domain\JohnSmith The list author login name  
  coveo_AuthorName String All John Smith The list author name  
  coveo_IsContainer Int32 All 1 Whether or not the item is a container (always '1')  
  coveo_ListBaseType String All DocumentLibrary The sharepoint list base type  
  coveo_ListName String All xDocumentLibrary The list name (same as Title field)  
  coveo_ListType String All Contacts The sharepoint list type  
  coveo_ParentGUIDs String All 9c3d69d52c01 The list parent GUIDs  
  coveo_RelativeListURI String All MyList/ The list relative URI (may NOT be empty)  
  coveo_SiteID String All 9c3d69d52c01 The truncated site GUID  
  coveo_SiteName String All My Site Name The site name  
  coveo_SiteURI String All http://server/sites/MySite/MySubSite/ The site absolute URI (may NOT be empty)  
  coveo_SurveyQuestions String Survey only Ghana The survey questions  
  coveo_Type String All List The sharepoint item type (always 'List')  
  Created DateTime All 2000-01-01 01:00:00 Gets the creation date and time for the list.  
  DefaultViewUrl String All /sites/MetaData/xDocumentLibrary/Forms/AllItems.aspx Gets the URL for the default view of the list.  
  Description String All Dominican Republic Gets or sets the description for the list.  
  Direction String All none Gets or sets the direction of the reading order for the list.  
  DocTemplateUrl String All /sites/MetaData/xDocumentLibrary/Forms/template.doc Gets the URL for template documents.  
  EmailInsertsFolder String All   Gets or sets the path for the public folder that contains the e-mail items inserted in the document library.  
  EnableAttachments Boolean All   Gets or sets a Boolean value that specifies whether attachments can be added to items in the list.  
  EnableModeration Boolean All   Gets or sets a Boolean value that specifies whether Content Approval is enabled for the list.  
  EnableVersioning Boolean All   Gets or sets a Boolean value that specifies whether versioning is enabled for the document library.  
  EventSinkAssembly String All   Gets or sets the strong name of a file in the Global Assembly Cache (GAC) that provides an event handler for document library events.  
  EventSinkClass String All   Gets or sets the fully qualified name of a class that defines an event handler for document library events.  
  EventSinkData String All   Gets or sets an arbitrary string of properties for use by an event handler for document library events.  
  Flags Int32 All 4224  
  Hidden Boolean All   Gets or sets a Boolean value that specifies whether the list is hidden.  
  ID GUID (String) All {F8EABE48-1765-4CF1-99A5-2036A86D2C65} Gets the GUID that identifies the list in the database.  
  ImageUrl String All /_layouts/images/itdl.gif Gets the URL for the icon that represents the list.  
  ItemCount Int32 All 1 Gets the number of items in the list.  
  Language Int32 All 1033 Gets the language used on the virtual server.  
  LastDeleted DateTime All 2000-01-01 01:00:00 Gets the date and time that an item in the list was last deleted.  
  Locale Int32 All 1033 Gets the locale identifier (LCID).  
  Modified DateTime All 2000-01-01 01:00:00 Gets the date and time that an item, field, or property of the list was last modified.  
  MultipleDataList Boolean All   Gets or sets a Boolean value that specifies whether the list in a Meeting Workspace site contains data for multiple meeting instances within the site.  
  Name GUID (String) All {F8EABE48-1765-4CF1-99A5-2036A86D2C65} Gets the GUID that identifies the list in the database.  
  Ordered Boolean All   Gets or sets a Boolean value that specifies whether the option to allow users to reorder items in the list is available on the Edit View page for the list.  
  Presence Boolean All    
  ReadSecurity Int32 All 1 Gets or sets the Read security setting for the list.  
  RootFolder String All   Gets the folder that contains all the files used in working with the list.  
  ServerTemplate Int32 All 101 The list server tamplate  
  ShowUser Boolean All   Gets or sets a Boolean value that specifies whether names of users are shown in the results of the survey.  
  SortOrder Int32 All 2070 The list sort order  
  ThumbnailSize Int32 All 160 The list thumbnail size  
  Time24 Boolean All   Gets or sets a Boolean value that specifies whether to use a 24-hour time format in representing the hours of the day.  
  TimeZone Int32 All 480 Gets the time zone used on the virtual server.  
  Title String All xDocumentLibrary Gets or sets the displayed title for the list.  
  Version Int32 All 0 Gets the version number of the list.  
  WebImageHeight Int32 All 640 The list web image height  
  WebImageWidth Int32 All 480 The list web image width  
  WriteSecurity Int32 All 1 Gets or sets the Write security setting for the list.  


ListItem MetaData


 
  Sharepoint ListeItem metadata
 
  Meta Name List BaseType Document Library Custom Issues Discussion Board Survey Example Description  
  List Type Document Library Form Library List Template Catalog Picture Library Web Part Catalog Web Template Catalog Workspace Pages Agenda Announcements Attendees Contacts Custom Custom Grid Data Source Decisions Events Links Meeting Series Objectives Site Directory Tasks Text Box Things To Bring Unknown Issues Discussion Board Survey  
                                                               
  coveo_AllCustomMetaData string x x x x x x x x x x x x x x x x x x x x x x x x x x x Honduras Argentina  
  coveo_AuthorID i4 x x x x x x x x x x x x x x x x x x x x x x x x x x x 1 The list item author ID
  coveo_AuthorLoginName string x x x x x x x x x x x x x x x x x x x x x x x x x x x domain\JohnSmith The list item author login name
  coveo_AuthorName string x x x x x x x x x x x x x x x x x x x x x x x x x x x John Smith The list item author name
  coveo_ContactName string                     x                                 LastName, FirstName The name to display for a Contact list item
  coveo_ContactWebPageURL string                     x                                 http://Albania The URL of a Contact list item.
  coveo_ContactWebPageURLDescription string                     x                                 Algeria The URL's description of a Contact list item.
  coveo_LinkURL string                                 x                     http://Albania The URL of a Links list item.
  coveo_LinkURLDescription string                                 x                     Algeria The URL's description of a Links list item.
  coveo_ListBaseType string x x x x x x x x x x x x x x x x x x x x x x x x x x x DocumentLibrary The sharepoint list base type
  coveo_ListItemID i4 x x x x x x x x x x x x x x x x x x x x x x x x x x x 4 The list item ID
  coveo_ListName string x x x x x x x x x x x x x x x x x x x x x x x x x x x xDocumentLibrary The name of the list in which the item is contained.
  coveo_ListType string x x x x x x x x x x x x x x x x x x x x x x x x x x x Contacts The sharepoint list type
  coveo_ParentGUIDs string x x x x x x x x x x x x x x x x x x x x x x x x x x x 9c3d69d52c01 The list item parent GUIDs
  coveo_RelativeListURI string x x x x x x x x x x x x x x x x x x x x x x x x x x x MyList/ The list relative URI (may NOT be empty)
  coveo_SiteID string x x x x x x x x x x x x x x x x x x x x x x x x x x x My Site Nane The site name
  coveo_SiteName string x x x x x x x x x x x x x x x x x x x x x x x x x x x 9c3d69d52c01 The truncated site GUID
  coveo_SiteURI string x x x x x x x x x x x x x x x x x x x x x x x x x x x http://server/sites/MySite/MySubSite/ The site absolute URI (may NOT be empty)
  coveo_SurveyQuestions string                                                     x Ghana The questions of Surveys items.Note: All questions of a Surveys type list are concatenated into a single string
and separated by new lines.
  coveo_SurveyQuestionsAndResponses string                                                     x Ghana Greece The Surveys list questions and answers given to these questions. Note: The questions and answers of a Surveys type list are concatenated into a single
string and separated by new lines.
  coveo_SurveyResponses string                                                     x Greece The answers given to questions of a Surveys list. Note: The answers are concatenated into a single string and separated by new lines.
  coveo_Type string x x x x x x x x x x x x x x x x x x x x x x x x x x x ListItem The sharepoint item type (always 'ListItem')
 
 The remaining fields are available from MSDN article Field Tables for Default Lists
 


ListItemAttachment MetaData


 
  Sharepoint ListItemAttachment metadata
 
  Meta name Meta Type Example Description  
  coveo_ListBaseType String DocumentLibrary The sharepoint list base type  
  coveo_ListItemID Number 1 The list item ID  
  coveo_ListName String xDocumentLibrary The list name  
  coveo_ListType String Contacts The sharepoint list type  
  coveo_ParentGUIDs String 9c3d69d52c01 The list item attachment parent GUIDs  
  coveo_RelativeListURI String MyList/ The list relative URI (may NOT be empty)  
  coveo_SiteURI String http://server/sites/MySite/MySubSite/ The site absolute URI (may NOT be empty)  
  coveo_SiteID String My Site Name The truncated site GUID  
  coveo_SiteName String My Site Name The site name  
  coveo_Type String List The sharepoint item type (always 'List')  


Coveo MetaData summary


 
  Coveo metadata summary
 
  Meta name Type Description SharePointItemType  
  Portal / Area Site AreaListing SiteItem List ListItem ListItem Attachment  
  coveo_AllCustomMetaData String All meta data strings values, except:
ows_Author
ows_Editor
ows_GUID
ows_LinkTitle
ows_LinkTitleNoMenu
ows_Title
ows__ModerationComments
          x    
  coveo_AreaListingExternalURL String An external URL for the Area listing     x          
  coveo_AreaRecursiveTitle String A recursive title for the Area x              
  coveo_AuthorID Number The item author ID x x x x x x    
  coveo_AuthorLoginName String The item author login name x x x x x x    
  coveo_AuthorName String The item author name x x x x x x    
  coveo_ContactName String The name to display for a Contact list item           x (Contacts)    
  coveo_ContactWebPageURL String The URL of a Contact list item.           x (Contacts)    
  coveo_ContactWebPageURLDescription String The URL's description of a Contact list item.           x (Contacts)    
  coveo_IsContainer Number Whether or not the item is a container (site, area or list) x x   x x      
  coveo_IsPersonalSite Number Whether or not the site is a personal site   x            
  coveo_IsTopLevelSite Number Whether or not the site is a top level site x x            
  coveo_LinkURL String The URL of a Links list item.           x (Links)    
  coveo_LinkURLDescription String The URL's description of a Links list item.           x (Links)    
  coveo_ListItemID Number The list item ID           x x  
  coveo_ListBaseType String The sharepoint list base type         x x x  
  coveo_ListName String The list name         x x x  
  coveo_ListType String The list type         x x x  
  coveo_ParentGUIDs String The item parent GUIDs x x x x x x x  
  coveo_RelativeListURI String The list relative URI (may NOT be empty)         x x x  
  coveo_SiteID String The truncated site GUID x x x x x x x  
  coveo_SiteName String The site name x x x x x x x  
  coveo_SiteURI String The site absolute URI (may NOT be empty) x x x x x x x  
  coveo_SurveyQuestions String The questions of Surveys items.Note: All questions of a Surveys type list are concatenated into a single string
and separated by new lines.
        x x (Survey)    
  coveo_SurveyQuestionsAndResponses String The Surveys list questions and answers given to these questions. Note: The questions and answers of a Surveys type list are concatenated into a single
string and separated by new lines.
          x (Survey)    
  coveo_SurveyResponses String The answers given to questions of a Surveys list. Note: The answers are concatenated into a single string and separated by new lines.           x (Survey)    
  coveo_Type String The item type x x x x x x x