Message Catalogs

There is more than one way to migrate a Message Catalog definition.

The easiest way is via App Designer by inserting into a project:

But another way is by using data mover scripts.

Message Catalog data is stored in the following sql tables:

PSMSGSETDEFN

PSMSGCATDEFN 

PSMSGSETLANG

PSMSGCATLANG

Searching for Portal Registry Structures (CREFs)

One useful delivered component is the View Menu Item Detail.  With this you can search for a CREF if you know part of the Name or Label.  This component will tell you who can access the CREF, it's menu path and it's component.
Menu Path: 
Main Menu -- PeopleTools -- Portal -- View Menu Item Detail




Another way to search for CREF data is using the database.  The delivered PSPRSMDEFN table contains all sorts of data related to CREFs.

SQL Table:  PSPRSMDEFN

The PORTAL_REFTYPE field will always contain a value of 'C' for Content or 'F' for Folder.

If the URL type of the CREF is 'Peoplesoft Component'  the Component and Menu will be stored in the PORTAL_URI_SEG1 and PORTAL_URI_SEG2 fields, respectively.

If the URL type of the CREF is a Peoplesoft Script then the Record, Field and IScript name will be stored in the PORTAL_URI_SEG1, PORTAL_URI_SEG2 and PORTAL_URI_SEG4 fields respectively.

My First Blog Post