E.2 Determining the Navigation Collection Names

Before you can determine the Navigation Collection names, you should understand the naming conventions for Navigation Collections objects.

Any collections (along with all related attributes—for example, labels, descriptions, icons, sequencing) can be copied/upgraded using PeopleSoft Application Designer.

The Navigation Collections objects are portal registry structures that are automatically generated by the Navigation Collection utility. These registry structures follow the required naming conventions. It is difficult to distinguish individual collection registry objects by the object name alone, due to the nature of the automatic generation.

The following lists the collection objects and how you can distinguish between them:

  • <pppp> — This is a two character database prefix, with a maximum of four allowed. For example, PA, HC, EP, CR, and PF.

    This value is stored on the Portal Utilities System Option page, but is updated to ADMN on shipped databases.

  • <collection name> — The entered name for the collection upon creation.

    The label can be changed. The first entry saved is used for the object name and cannot be changed.

  • <unique suffix> — If the object name already exists in the current portal registry definition, a numeric suffix is appended to make it unique.

  • <datetimestamp> — The creation system date-time at time to the second, as a string: yyyymmddhhmmss.

  • <random number> — A ten digit random number, suffixed for additional uniqueness.

The following table lists the registry structure, naming convention, reference type, and an example:

Registry Structure Naming Convention Reference Type Example

Collection

<pppp>_<collection name>_<unique suffix>

F

EO_TEST_COLLECTION

Folder

<pppp>_F<datetimestamp><random number>

F

EO_F200304251641564103213599

Content

<pppp>_S<datetimestamp><random number>

C

EO _S200305061202344545121616

Published Navigation Page

<pppp>_SC_SP_<collection name>

C

EO _SC_SP_TEST_COLLECTION

Published Pagelet Wizard Pagelet

<pppp> _<collection name>_HMPG

None

EO_TEST_COLLECTION _HMPG

Published Navigation Collection Pagelet

<pppp>_SC_ PGT_<collection name>

None

EO_SC_PGT_ TEST_COLLECTION

In addition, Navigation Collections can be defined with images that overwrite the default images. These images use the naming convention PS_FN_<image identifier>.

Navigation Collections are stored in the common parent folder CO_NAVIGATION_COLLECTIONS in the portal registry.

To determine the Navigation Collection names:

  1. Use a SQL query tool to access the content provider database.

  2. Run the following SQL query to retrieve the Navigation Collection names.

    The listed values under the column PORTAL_OBJNAME are the Navigation Collection names. The PORTAL_NAME is where the Navigation Collection resides.

    Replace the string <PREFIX> with the prefix used on delivered content provider’s portal registry structures, for example, HC, EP, CR, PF. 

    SELECT PORTAL_NAME, PORTAL_OBJNAME FROM PSPRSMDEFN 
WHERE PORTAL_PRNTOBJNAME = 'CO_NAVIGATION_COLLECTIONS' 
AND PORTAL_REFTYPE = 'F' 
AND PORTAL_OBJNAME LIKE '<PREFIX>%'