61 Microsoft SharePoint Systems: Default Mapping Specifications

The default mapping framework in the Content Integration Platform enables publishing from SharePoint libraries on selected sites.

Thischapter contains the following sections:

61.1 Overview

The default mapping framework in the Content Integration Platform enables publishing from SharePoint libraries on selected sites, as long as the publishable content is based on the following default SharePoint constructs: Content types Document , Folder , and Picture; and attributes File Size , contentAttr , contentURL , Date Picture Taken , Description , Keywords , Picture Height , and Picture Width.

The mapping framework supplies the following default components:

  • The SharePoint flex family, pre-configured to match the content types and attributes listed above.

  • A mappings.xml file, in which content types and attributes (listed above) are mapped to assets in the SharePoint flex family:

    • The Folder type is mapped to a flex parent definition asset named sp_folder.

    • The Document type is mapped to a flex definition asset named sp_document.

    • The Picture type is mapped to a flex definition asset named sp_picture.

    • Attributes are mapped to flex assets of type SharePoint Attribute.

    The mappings are coded in mappings.xml in Section 61.2, "Default mappings.xml," and summarized in Table 61-1, "SharePoint Default Data and Flex Family Analogs".

Once the mapping is established, folders of type Folder (and their contents) can be published:

  • Folders are published as flex parent assets to the SharePoint Folder asset type.

  • Documents and pictures are published as flex assets to the SharePoint Document asset type.

During publishing, the Content Integration Platform refers to the mappings.xml file to determine the types of content to publish (sp folder, sp document, and sp picture). The folder that is named in the publish command is the starting point of the publication process. The folder is published as a flex parent asset of type SharePoint Folder, along with all the subfolders, documents, and puctures it contains.

To reproduce the folder's structure (subfolders, documents, and pictures), the Content Integration Platform refers to path information:

  • If subfolders exist, the Content Integration Platform chains their corresponding SharePoint Folder assets to reproduce the hierarchy.

  • Documents, treated as SharePoint Document assets, are placed under their respective SharePoint Folder parent assets.

  • Pictures, treated as SharePoint Picture assets, are placed under their respective SharePoint Folder parent assets.

Figure 61-1 Mapping the Document Type to WebCenter Sites' SharePoint Flex Family

Description of Figure 61-1 follows
Description of ''Figure 61-1 Mapping the Document Type to WebCenter Sites' SharePoint Flex Family''

Figure 61-2 Mapping the Document Type to WebCenter Sites' SharePoint Flex Family

Description of Figure 61-2 follows
Description of ''Figure 61-2 Mapping the Document Type to WebCenter Sites' SharePoint Flex Family''

Note:

The Picture content type is mapped similarly to the Document content type:

sourceid takes the value Picture

targetid takes the value SharePoint_Document;sp_picture

For more information, see Section 61.2, "Default mappings.xml."

61.2 Default mappings.xml

The default mappings.xml file, located in the Content Integration Agent, maps SharePoint schema to WebCenter Sites' SharePoint flex family. The mapping is uniquely identified by the ID as shown in the code below. Parameters for the <assettype-mapping> and <descriptor-mapping> tags are defined in Section 58.2.2.1, "Tags and Parameters for Mapping Microsoft SharePoint Data to Oracle WebCenter Sites."

<mappings>
  <!-- MS SharePoint to CS -->
  <mapping id="sharepoint2cs">
    <assettype-mapping sourceid="Item" targetid="" id="sp_item">
      <descriptor-mapping sourceid="Title" targetid="title" />
    </assettype-mapping>
    <assettype-mapping sourceid="Document" 
               targetid="SharePoint_Document;sp_document" id="sp_document" 
               extends="sp_item">
      <descriptor-mapping sourceid="File Size" targetid="file_size" />
      <descriptor-mapping sourceid="contentAttr" targetid="file" type="static" />
      <descriptor-mapping sourceid="contentURL" targetid="contentURL" 
               type="dynamic" />
    </assettype-mapping>
    <assettype-mapping sourceid="Folder" targetid="SharePoint_Folder;sp_folder"
               id="sp_folder" extends="sp_item" />
    <assettype-mapping sourceid="Picture" 
               targetid="SharePoint_Document;sp_picture" id="sp_picture"   
               extends="sp_document">
      <descriptor-mapping sourceid="Date Picture Taken" targetid="date_taken" />
      <descriptor-mapping sourceid="Description" targetid="description" />
      <descriptor-mapping sourceid="Keywords" targetid="keywords" />
      <descriptor-mapping sourceid="Picture Height" targetid="picture_height" />
      <descriptor-mapping sourceid="Picture Width" targetid="picture_width" />
    </assettype-mapping>
  </mapping>
</mappings>

61.3 SharePoint Flex Family Specifications

Table 61-1, "SharePoint Default Data and Flex Family Analogs" summarizes the default mapping of SharePoint schema to WebCenter Sites' SharePoint flex family. For customized implementations, you can either re-use the flex family or create your own.

Table 61-1 SharePoint Default Data and Flex Family Analogs

Type of Data SharePoint Default Data Maps To: Flex Asset Type Maps To: Flex Family Member Description Assets of This Type Are Created By

Schema

Attribute

Attributes:

For documents:

File Size

contentAttr

contentURL

For pictures:

Date Picture Taken

Description

Keywords

Picture Height

Picture Width

SharePoint Attribute

Stores attribute instances: Foot 1 a

For documents:

file_size

file

contentURL

For pictures:

date_taken

description

keywords

picture_height

picture_width

Flex Attribute

This flex asset type stores attributes for documents and pictures.

WebCenter Sites Administrator

Schema

Folder Content Type

Folder

SharePoint Parent Definition

Stores parent definition instance: Foot 2 

sp_folder

Flex Parent Definition

This flex asset type stores parent definition instances.

WebCenter Sites Administrator

Schema

Document Content Type

Document

SharePoint Child Definition

Stores child definition instance: Foot 3 

sp_document

Flex (Child) Definition

This flex asset type stores child definition instances.

WebCenter Sites Administrator

Schema

Picture Content Type

Picture

SharePoint Child Definition

Stores child definition instance: Foot 4 

sp_picture

      

Content

Published Folders

Folders of content type Folder

SharePoint Folder

Stores flex parent assets

(of type sp_folder and any other type)

Flex Parent

This flex asset type stores folder assets.

Content Integration Platform

Content

Published Documents

Documents of content type Document

Published Pictures

Pictures of content type Picture

SharePoint Document

Stores flex (child) assets of type sp_document and sp_picture, and any other type.

Flex (Child) Asset

This flex asset type stores document assets and picture assets.

For an example, see Figure 61-1.

Content Integration Platform

Footnote 1 "Instance" means "asset." "Instance" is used only to help differentiate metadata (instances) frompublished content (assets).

Footnote 2 "Instance" means "asset." "Instance" is used only to help differentiate metadata (instances) frompublished content (assets).

Footnote 3 "Instance" means "asset." "Instance" is used only to help differentiate metadata (instances) frompublished content (assets).

Footnote 4 "Instance" means "asset." "Instance" is used only to help differentiate metadata (instances) frompublished content (assets).