Migrating Navigation Collections and Pagelets November 4, 2008
Posted by Duncan in PeopleTools, PIA.trackback
Following on from yesterday’s post on creating and publishing a Navigation Collection, now you’ve created one you’ll want to migrate it around between environments. There are a few steps to this.
Migrate Navigation Collection with App Desginer
First, you need to identify which are the correct Navigation Collection Content References to add to your App Designer project.
Run the following SQL to get the PORTAL_OBJNAME of your Navigation Collection:
select * from PSPRSMDEFN
where portal_name='EMPLOYEE'
and portal_prntobjname='CO_NAVIGATION_COLLECTIONS';
Now we need to find the PORTAL_OBJNAMES of every link within your collection. Run the same SQL, but replace the Parent Object with the name of your Navigation Collection (the PORTAL_OBJNAME from the first SQL).
This should give you a list, many of which will look like this:
ADMN_S200810276523143947898702
Within App Designer add both your Navigation Collection and the links/folders within it:
(If there are too many too enter manually you could always insert directly into PSPROJECTITEM.)
You’ll also want to add your User Homepage (for each Oprid that is using it) so that the homepage layout gets copied between environments too. This will save you from having to manually select the collection in every PIA.
Migrating the Pagelet
So now you’ve migrated the Navigation Collection, before you log in to check we also need to migrate the Pagelet.
Within the PIA navigate to PeopleTools > Portal > Pagelet Wizard > Export/Import Pagelets. This page helps you to create the Data Mover scripts you’ll need.
Select the checkbox next to your Pagelet, then press ‘Generate Scripts’. These should be run in Data Mover to export and import your pagelet through your environments.
Once this is done you’ll need to bounce the Application Server, then you’ll be able to log into your target environment and check your migrated pagelet.
Comments
Sorry comments are closed for this entry
The PeopleSoft Tipster Blog 
I followed these instructions and all folders, pagelet setup has moved between environments. However, I created a custom folder under the Root, Portal Objects, Pagelets structure. I moved this Folder structure as well. So everything looked like it moved, but doesn’t show up under Structure and Content. Clear Web cache perhaps?
Time-saving tip for inserting a Navigation Collection into a project: if you select ‘Include Children’, Application Designer will include the ‘ADMN_S12345689123456789’ objects automatically.
Thanks for the detail instructions…..worked as expected
Very usefull information. Thanks for posting it.
Thanks a lot for the info…
very useful
Works perfectly. I was able to save this into an App Designer project and easily migrate my pagelets whenever I add things to them. Thank you!
You know, one caveat that we have found in migrating the homepage CREF is that sometimes (well, usually since we are always toying with our dev instances) pagelets exist in non-production that do not exist in production; test pagelets for example.
These pagelets get a record with the homepage CREF, but when migrated, the CREF will throw an error since some of the pagelets available on the tab content page do not have crefs in production.
Migrating homepage CREFs are probably best to add to the project once in your staging instance — where all the pagelets are identical.
-Michael.
Thanks a lot. I was stuck at migrating the pagelets. This site solved the problem.