Counting characters in a field July 24, 2007
Posted by Duncan in PeopleSoft, PeopleTools, PIA.comments closed
I saw a query earlier today on the IT Toolbox messageboard where someone asked if there was a way to restrict a user to a certain number of letters or characters within a Long Edit box. The poster didn’t want to wait until the user tabs out of the field to tell them their text was too long.
I’d seen someone accessing the value of a field from JavaScript within an HTML Area before, and although I couldn’t find the post (I believe it was on SparkPath, but could be wrong) it set me thinking.
One solution (there may be better answers, but this was my submission) was as follows:
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?
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>
eg.
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
eg.
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.
Outer Joins and Effdt June 26, 2007
Posted by Duncan in Oracle, PeopleSoft, PeopleTools, SQL.comments closed
I was asked by one of our Junior Consultants the best method of outer joining to a table containing Effdt (which you’d want to do a Max Effdt sub-query on).
I provided a solution, but after pondering the issue further I realised there are a number of ways to do this.
For those not familiar with the problem, an Outer Join is a specific SQL statement where all rows from the first table are returned even if no corresponding row in the second table is found. Values from the second table are shown where they exist, defaulting to null when they do not. The issue arises as the second table has an effdt column, which usually necessitates a sub query (to find the row with the greatest effdt less than a supplied as of date). This would be a sub-query, and you can’t outer-join to a subquery.
So, which is the best solution?
The PeopleSoft Tipster Blog 