Adding New Repository and Creating Relationship

You can extend the data model, for example, PRODUCT by adding a new repository, and creating a relationship between PRODUCT and the repository.

You can extend the data model, for example, PRODUCT by adding a new repository, and creating a relationship between PRODUCT and the repository.

To extend the Fulfillment Catalog data model, modify the following files:

File Name Location Description
Productmodelattribute.properties <JBOSS_HOME> / modules / com / tibco / fulfillmentcatalog / main / acprop.jar This file contains the list of all attribute names (column) required to generate product model.
mpfromcatalogitemtobulkproductmodelv1.xsl MQ_COMMON_DIR/

<ENTNAME>/maps

This is a stylesheet file, which generates product model according to the required structure.
wfin26bulkmodelpublisherv1.xml MQ_COMMON_DIR/

<ENTNAME>/workflow

Edit this file to add relationship name.

To extend the Fulfillment Catalog data model and add new repository, perform the following steps:

Procedure

  1. Create the new EXTENSION repository.
  2. Create an attribute for it, for instance, EXTENSIONID and EXTENSIONDESC. To add a new attribute in the product model, in the product repository, perform the following steps:
    1. Go to the <JBOSS_HOME>/modules/com/tibco/fulfillmentcatalog/main/ directory.
    2. Extract acprop.jar.
    3. Using any text editor, open the productmodelattibute.properties file located at <JBOSS_HOME>/modules/com/tibco/fulfillmentcatalog/main/acprop.jar.
    4. Create relationship between PRODUCT and EXTENSION, for instance, ProductHasExtension.
    5. At the end of the productmodelattibute.properties file, add column name, EXTESIONID in the existing attribute list.
      Note: Shut down the sever before you save the file.
      Sample Product Model Attribute Properties 2
  3. Create the jar file, acprop.jar once again.
  4. Add relationship name, ProductHasExtension in the wfin26bulkmodelpublisherv1.xml file for the following activities:
    1. ProductModelSubset
    2. ProcessProductSubsetData
  5. Modify the map file mpfromcatalogitemtobulkproductmodelv1.xsl to include the new attribute in the product model. The following snippet shows the sample map file. 
    <xsl:for-each select="./ChildItems/ChildItem[REL_NAME ='ProductHasExtension']">
              <ns0:characteristics>
                <ns0:name>
                  <xsl:value-of select="./CEXTESIONID"/>
                </ns0:name>
                <ns0:description>
                  <xsl:value-of select="./CEXTESIONDESC"/>
                </ns0:description>
               </ns0:characteristics>
            </xsl:for-each>
  6. Create a record in PRODUCT and EXTENSION repositories with relationship between them.
  7. Start JBOSS server.
  8. Publish Product model.