E.9 Updating Pagelet Wizard Definition and Portal Name

The Pagelet Wizard definition stores the Navigation Collection name and portal name to determine which Navigation Collection to render. This information is stored in Pagelet Wizard data settings and parameters. The copied PeopleSoft content provider Pagelet Wizard definitions are likely defined to render from the portal where they were created. The portal name must be set to render out of the current portal, instead of the original portal name.

To update the Pagelet Wizard definition Navigation Collection portal name:

1. Use a SQL query and update tool to access the PeopleSoft Portal Solutions database.

2. Run the following SQL query statements to check the rows that you will be updating.

   Review the results to see that they match the Pagelet IDs in the generated export script.

   Replace the string <PREFIX> with the prefix used on delivered PeopleSoft Portal registry objects.

   For example, HC, EP, CR, PF.

    SELECT * FROM PS_PTPPB_DS_SETTGS 
   WHERE PTPPB_FIELDNAME = 'PortalName' 
   AND EXISTS 
   (SELECT 'X' FROM PS_PTPPB_DS_SETTGS A 
   WHERE A.PTPPB_PAGELET_ID = PS_PTPPB_DS_SETTGS.PTPPB_PAGELET_ID 
   AND A.PTPPB_FIELDNAME = 'scname' 
   AND A.PTPPB_VALUE LIKE '<PREFIX>%')
   
   
   SELECT * FROM PS_PTPPB_PGLT_PRMS
   WHERE PTPPB_FIELDNAME = 'PortalName' 
   AND EXISTS 
   (SELECT 'X' FROM PS_PTPPB_PGLT_PRMS A 
   WHERE A.PTPPB_PAGELET_ID = PS_PTPPB_PGLT_PRMS.PTPPB_PAGELET_ID 
   AND A.PTPPB_FIELDNAME = 'scname' 
   AND A.PTPPB_VALUE LIKE '<PREFIX>%')
   

3. Run the following SQL update statements to update the Pagelet Wizard data setting and parameter for the PortalName value.

   Replace the string <PREFIX> with the prefix that was used on the delivered PeopleSoft Portal registry objects.

   For example, HC, EP, CR, PF.

   UPDATE PS_PTPPB_DS_SETTGS 
   SET PTPPB_VALUE='LOCAL_PORTAL'
   WHERE PTPPB_FIELDNAME = 'PortalName' 
   AND EXISTS 
   (SELECT 'X' FROM PS_PTPPB_DS_SETTGS A 
   WHERE A.PTPPB_PAGELET_ID = PS_PTPPB_DS_SETTGS.PTPPB_PAGELET_ID 
   AND A.PTPPB_FIELDNAME = 'scname' 
   AND A.PTPPB_VALUE LIKE '<PREFIX>%')
   
   
   UPDATE PS_PTPPB_PGLT_PRMS
   SET PTPPB_VALUE='LOCAL_PORTAL'
   WHERE PTPPB_FIELDNAME = 'PortalName' 
   AND EXISTS 
   (SELECT 'X' FROM PS_PTPPB_PGLT_PRMS A 
   WHERE A.PTPPB_PAGELET_ID = PS_PTPPB_PGLT_PRMS.PTPPB_PAGELET_ID 
   AND A.PTPPB_FIELDNAME = 'scname' 
   AND A.PTPPB_VALUE LIKE '<PREFIX>%')