Oracle CRM On Demand Desktop Customization Guide > Adding Custom Objects to Oracle CRM On Demand Desktop >

Adding Custom Objects to DB FACADE Storage

If you are adding an object to DB FACADE storage, then the syntax to add the object is simpler than the syntax for Microsoft Outlook storage because you do not require the <form> element, and the number of <field> child elements is less as shown in the following template.

For more information on Microsoft Outlook and DB FACADE storage, see About Microsoft Outlook and DB FACADE Storage.

Before You Begin

Review the chapter on customization in Oracle CRM On Demand Desktop Administration Guide.

Example Template for Adding an Object to DB FACADE Storage

See the following template:

<type ... >
<field ... />
<field ... />
<field ... />
</type>

Completing this procedure results in the following XML code in the od_basic_mapping.xml file:

<type id="Internal_Product" icon="type_image:Service Request:16">
<field id ="SRNumber">
<type>
<simple type="string"/>
</type>
</field>
<field id="AccountId">
<type>
<simple type="binary"/>
</type>
</field>
<field id="AccountName">
<type>
<simple type="string"/>
</type>
</field>
<field id="ContactId">
<type>
<simple type="binary"/>
</type>
</field>
<field id="Area">
<type>
<simple type="string"/>
</type>
</field>
<field id="Cause">
<type>
<simple type="string"/>
</type>
</field>
<field id="Type">
<type>
<simple type="string"/>
</type>
</field>
<field id="Source">
<type>
<simple type="string"/>
</type>
</field>
<field id="CurrencyCode">
<type>
<simple type="string"/>
</type>
</field>
<field id="Priority">
<type>
<simple type="string"/>
</type>
</field>
<field id="Status">
<type>
<simple type="string"/>
</type>
</field>
<field id="OwnerId">
<type>
<simple type="binary"/>
</type>
</field>
<field id="Subject">
<type>
<simple type="string"/>
</type> </field>
<field id="StatusContact">
<type>
<simple type="string"/>
</type>
</field>
<field id="StatusAccount">
<type>
<simple type="string"/>
</type>
</field>
</type>

NOTE:  DB FACADE storage objects cannot have <multiwriter> functionality, which is why some fields are omitted in the sample code. Objects stored in DB FACADE storage do not require the ObjectState and SuppressFileAs fields.

To add a custom object to DB FACADE storage

1. Define the attributes of the <type> element in the od_basic_mapping.xml file as described in the following table.

   Attribute Name	Attribute Value	Attribute Description
   id	Service Request	The unique ID of this object type in Oracle CRM On Demand Desktop. Set this attribute to the same value specified for the TypeId attribute of the <object> element in od_meta_info.xml. NOTE:  The name you assign to an object in od_meta_info.xml must be used for the object's name in the od_basic_mapping.xml file.
   icon	type_image:Service Request:16	This attribute defines the icon that is displayed for this type of object, for example, on a form caption, in Microsoft Outlook views, and so on. Set the value of this attribute to a resource key of an image file, for example, a PNG file, 16 x 16 pixels, to be used and defined in any Oracle CRM On Demand Desktop resource file.

2. Define the attribute of the <field> element in od_basic_mapping.xml as described in the following table.

   Attribute Name	Attribute Value	Attribute Description
   id	Service Request	The unique ID of this field within an object type.

3. Define the attribute of the <simple> element in the od_basic_mapping.xml file as described in the following table.

   Attribute Name	Attribute Value	Attribute Description
   type	string binary integer double foreign_key boolean	The unique ID of this field within an object type.