Configuring uploads to content management system for case insensitive searches

Through the content management system integration, you can add new objects by using the out of the box-provided upload screens. These upload screens are part of External Content Reference attribute type, which can be added to a spec.

About this task

You can add an element to the data model (which would store uppercase values) and provide the mapping in the connector's custom property section.

After you specify the mapping, the right side element from the mapping is considered as the element used for storing the upper cased values and would be hidden from the user.

During an upload, the values for the left side of a custom map would be upper cased and would be assigned to the right side element and passed on for saving.

Consider an example where a content management system data model “book” has an author_name element. The data model “book” is also called an item class within the content management system.

Procedure

  1. Add an element to the model in the content management system server.
    For example, the database would store the upper cased string for the author_name element. The name in this case is author_name_up.
    Note: The name of the element is an example and is random and left up to the data modeling admin. The element name can be anything in which the data modeler prefers, however, you should provide a name that distinguishes the derived element as Product Master reserved elements so that it provides a hint to what element it is mapped to. For the example here, the recommended name is for holding uppercase of author_name is UPPER_OF_AUTHOR_NAME_RESERVED. Ensure that none of the element names are similar and that you are cautious when you map the derived elements with the Product Master reserved elements.
  2. Add a database index to the author_name_up element for faster searches.
    1. In the left pane navigation, expand the item class. Expand the Database Indexes node to display the node.
    2. Right-click the node and select Explore. The New Database Index window displays.
    3. Select the new attribute in the Available Attributes section and click Add.
    4. Provide an index name for your attribute index in the Name field.
      For example: author_name_up_idx
    5. Click OK.
  3. Add the new property to the Custom Properties Editor and assign it a property value in the Content Integrator admin client.
    1. Open the admin tool.
    2. Expand the connectors node and double-click the relevant connector to open the Properties Editor on the right.
    3. Click Custom Properties to open the Custom Properties Editor.
    4. Click Add to add the custom properties.
    5. Add the author_name property to the editor and assign it the author_name_up property value.
  4. Save your changes and restart the Content Integrator so that the new changes take effect.
  5. Start Product Master.
  6. Open the Add content management system window where only the left side where the key value pair is visible.
    1. Specify the file that you want to upload in the Source file field.
    2. Provide a value for the author_name field.
      For example, teSt1.
    3. Click Upload. The file is uploaded to the content management system with author_name and author_name_up completed.