jump to navigation

Outputing ALL images from PS July 12, 2007

Posted by Duncan in PeopleSoft, PeopleTools, PIA, SQL.
comments closed

I was asked an unusual question yesterday and I thought I’d share it with you all.

The client wanted to view/extract all of the images held within PeopleSoft. My first reaction was that it couldn’t be done. As there are over 1000 images it’s not a task to be easily done manually. Also, only about 1/4 of the images are stored in the Web Server cache, so it’s not a task of just getting them from there.

So … how was it done?

All images page in PIA


Auto Login to PeopleSoft and App Designer July 4, 2007

Posted by Duncan in PeopleSoft, PeopleTools, PIA.
comments closed

You can set up shortcuts to auto-logon to the PeopleSoft PIA and/or App Designer.

I’m still in two minds whether to add this post or not, but there are some circumstances where this can save you a bit of time and I’m sure you’ll know when and where that is – for example, on a single user VM, or in a DEMO environment, or even in a DEV environment if it’s a small team.  It’s no different to having single sign-on enabled for PIA logon anyway. It shouldn’t need stating that these shortcuts should never be used in any environments where security is important, and under no circumstances anywhere near a Production environment!

App Designer:

Create a new shortcut and adapt the following line for your environment:

<pshome>\bin\client\winx86\pside.exe -CT <dbtype> -CD <dbname> -CO <oprid> -CP <pwd>


D:\pshome\bin\client\winx86\pside.exe -CT ORACLE -CD HR9DMO -CO PS -CP PS

It may help to alter the properties of the shortcut to run it maximised window, just to save clicking each time …

PeopleSoft PIA

The following works for some tools versions and not others. I’m sure it has worked in Tools 8.4x, but it doesn’t seem to work on Tools 8.48. If you get this working, let me know your Tools version and we’ll see if we can work out when they put a stop to it, or if it  works for you in Tools8.48 what I’m doing wrong.
http://<web-server>/psp/<site>/?cmd=login &userid=<userid>&pwd=<pwd>&disconnect=y


http://hrdmo/psp/HR9DMO/?cmd=login &userid=PS&pwd=PS&disconnect=y

Remove line breaks from URLs when pasting.  I don’t know what the ‘disconnect=y’ does.

Using the PIA Welcome Message June 13, 2007

Posted by Duncan in Administration, PeopleSoft, PIA, SQL.
comments closed

The PIA Welcome message, or Portal Greeting is a pretty simple piece of functionality, but I’ve not seen it used on a single client site. For those that haven’t seen it before, it looks like this:

Welcome Message example

The welcome message is stored on a per user basis, it is set using the ‘Personalize Content’ link on the Homepage, and it is stored in the table PSPRUHDEFN. If updated via SQL, it won’t appear instantly unless you either bounce the App Server (and clear the cache) or increment the versions in PSVERSION and PSLOCK. There is an (Oracle) sql script to update the message – so it appears instantly – at the foot of this post.

A more constructive use of the greeting would be to alter it slightly. Particularly during development and testing it would be useful to display the logged on user and the environment name. An extremely simple change to a Tools object (yes, I know, but it’s such a small change that the upgrade implications will be minimal) allows this.

Updated Portal Greeting

There are two steps, output the user/database in the greeting and make the message appear on every page, not just the Homepage.


Moving the Search Box April 24, 2007

Posted by Duncan in PeopleSoft, PIA.
comments closed

The other day I noticed a PeopleSoft environment with the Search box (the box that appears at the top of the left hand menu on the default home page) in the top right hand corner. It seems a far more logical place to have it

  1. it takes up no menu space
  2. it’s available in all components, not just from the home page

Default Position

Default Search Mox Position

Better Position

Improved Search Box Position

So the question is, how do you move it up there?

Where is that Component? March 20, 2007

Posted by Duncan in PIA.
comments closed

A fairly common scenario. You have a component name (or even a page name) but you don’t know the navigation path to find it in the PIA. Maybe you’re working on an area of PeopleSoft you haven’t used before, or perhaps it’s just somewhere you haven’t seen in a familiar module. Either way, you’ve got to find it.

There are a number of options.

The first – and probably the easiest – is to use the search box at the top of the left hand menu on the homepage (Tools 8.4x only). Just type the Component Name in there and it’ll display your page and show you the navigation steps. This relies on the ‘Build Registry Search Index’ process being run (PeopleTools > Portal > Build Registry Search Index).


The next alternative is using a piece of SQL to query the PRSMDEFN record to retrieve the path.