Running a script to populate the System Title field (OpenPages)

You can use a script to populate the Title (System Fields:Title) field with values from another field. This task applies to IBM OpenPages and IBM OpenPages on Cloud.

Before you begin

About this task

After you enable the System Title field for an object type, you can use a script to populate the field with values from another field.

This task is optional.

Review the following notes before you run the script:
  • The script updates the Title field whether or not an object instance is locked.
  • For files (SOXDocument), the script updates the Title field whether or not the file is checked out.
  • If you want to use the Title field in Cognos® reports, you must regenerate the reporting framework after you enable the Title field for the object type.
  • In Cognos, the Name query item contains the ID (System Fields:Name) and the Title query item contains the Title (System Fields:Title).

    For example, for the Issue object type, the query items are called Issue Name and Issue Title.

Procedure

  1. If System Admin Mode is enabled, disable it.
  2. Get the required files:
    • system_title_field_copy.env – Sets the parameters for the script
    • system_title_field_copy.sh|.bat – Script that populates the Title field.
    The files are in the installation media in the following directories:
    • Db2®: /OP_<version>_Main/OP_<version>_Configuration/Database/DB2/UPGRADE_SCRIPTS
    • Oracle: /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/UPGRADE_SCRIPTS
  3. Modify the system_title_field_copy.env file to set the parameters for the script.

    Change the values after the equal sign. Do not make any other changes to the file.

    The file provides instructions on how to set the parameters.

    Note: Modify only the .env file. Do not modify the .sh, .bat, or .sql files.
  4. Run the script.

    Replace <op_db_password> with the password of the OpenPages database user.

    Linux® 
    ./system_title_field_copy.sh <op_db_password>
    Windows 
    system_title_field_copy.bat <op_db_password>