Categories
Peoplecode PeopleTools

Sortable Image Column in PeopleTools Grid

A quick tip if you want to allow users to sort on an Image column in a PeopleTools grid. Typically this is used in RAG (Red Amber Green) type traffic light images for KPI/target values. The tip is simple but effective:

Don’t use an Image column type – use an HTMLAREA and embed a hidden value into a HTML comment in the column followed by a link to the image you want to display.

Given a HTML area linked to RECORD.MY_FIELD on the grid, use RowInit PeopleCode to construct the HTML like this:

RECORD.MY_FIELD.Value = '<!--' | {the_value_to_sort_on} | '-->' | "<img src='%Image(MY_IMAGE)'>";

where the “value to sort on” could be a literal or a RECORD.FIELD.Value reference or indeed any calculated value. Just make sure the values you assign reflect the collating sequence you want for the images.

Oh … you might want to centre the image in the column using a DIV

<div style=”text-align: center;”>

… the img tag above

</div>

Enjoy.

Categories
Administration Windows

Using SC to stop remote services

I generally use PSExec from the Sysinternals Suite, but here is another approach if you are not allowed to install external tools or it is blocked by (say) a virus checker:

Use sc.exe to achieve the same end result e.g.

1
2
3
4
5
6
7
8
9
10
11
12
13

REM
REM Establish IPC connection so we are authenticated with the remote machine
REM
net use \\remote\IPC$ /user:local-username-on-remote-machine remote-user-password 
REM 
REM Use system console (sc.exe) command line tool to STOP or START services on remote machine
REM Note: The service name needs to match the one shown in services on the remote machine
REM
sc \\remote stop service-name 
REM
REM Delete the IPC credentials
REM
net use \\remote\IPC$ /delete

This is particularly useful in larger PeopleSoft installs where you have installed the Web servers/App servers/Process Schedulers as NT services. You did do that didn’t you? 🙂

Note: This came from a posting somewhere else on the web – I am not claiming it is my idea!

Categories
Linux OpenSUSE VirtualBox

OpenSUSE and VirtualBox

If you get errors installing OpenSUSE as a VirtualBox guest, check the memory allocated. By default VirtualBox will allocate 512MB of RAM to the VM – you need more to install OpenSUSE e.g.

OpenSUSE_VirtualBox

Note: This was an install of 13.2 with KDE

 

Categories
Humour Peoplesoft Workday

Why PeopleSoft and Workday Succeed

Maddies Fund

’nuff said? People with pets make better companies. Discuss!

Categories
Peoplesoft PeopleTools SES

SES Crawl Stuck in Launching? …. the “fix” ….

In the SES database execute these SQLs:

1
2
3
4
5

EXEC eq_adm.use_instance('eq_inst');
 
SELECT cs_id, cs_state, cs_name FROM eq$crawler_sched WHERE cs_state LIKE 'LAUNCH%';
 
UPDATE eq$crawler_sched SET cs_state='SCHEDULED' WHERE cs_id = <cs_id found above>;

 

Categories
Humour Rants

Cyclists

<rant>

You don’t pay road tax (well for the bike at least)

You aren’t insured

Surely you could at least obey traffic lights? They do apply to you “entitled” sods too you know!

</rant>

OK .. I know some of you **might** be insured. But I seriously doubt your insurance covers running a red light! 🙂

Categories
Configuration Peoplesoft Performance SQL Server

Trace Flag 4136 and PeopleSoft

Trace flag 4136 effectively adds an OPTION(OPTIMIZE FOR UNKNOWN) to all SQL statements. This has the effect of making the optimizer ignore histogram statistics in generating execution plans.

If you have extremely skewed data distributions this can actually result in a much better execution plan – it essentially gives the impression of more “consistent” performance by ensuring that you don’t end up with an execution plan suited to only one subset of your data. But it will not necessarily be the best execution plan you could manage,

Continue reading “Trace Flag 4136 and PeopleSoft”
Categories
CRM Peoplecode Peoplesoft PeopleTools

PeopleSoft CRM 9.1 Case Corruption from My Cases Pagelet

There is a nasty bug in PeopleSoft CRM 9.1 that can lead to case data being overwritten by data from another case.

Just open two different cases from the My Cases pagelet. Each opens in a new window but they have identical URLs apart from the CASE_ID. The effect of this is that changes made to one case result in the component globals such as CASE_ID being overwritten on the second tab. If that tab is then saved, then incorrect data is written back to the database. Insidious little bug.

Continue reading “PeopleSoft CRM 9.1 Case Corruption from My Cases Pagelet”
Categories
Peoplesoft PeopleTools Upgrade

PeopleTools Upgrade to 8.53.20

I have just completed a PeopleTools upgrade from 8.52.10 to 8.53.20 on a production CRM 9.1 MP5 system. Everything went very smoothly but it was a very intense weekend due to the size of the production stack and the need to ensure all the configurations were correct. The environment to be upgraded comprise:

  • 4 web-only servers on Windows 2008 R2 each with a single PIA
  • 8 application servers on Windows 2008 R2 running 7 application server domains, 3 process schedulers, 1 dedicated PUB/SUB domain and 1 shared search server.
  • 1 clustered SQL Server 2008 R2 database

Things to watch out for on the upgrade, and some techniques I used to speed/simplify the process:

Continue reading “PeopleTools Upgrade to 8.53.20”
Categories
BI Publisher Configuration Peoplesoft Tools

BI Publisher fix for XLSX Cell Merging Problem in PeopleSoft

Under PeopleTools 8.53 the default Excel output format for BI Publisher reports is now native XLSX rather than “MHTML” as in previous releases. This has a number of advantages such as a much smaller output file size due to it being a real Excel format and not HTML :-).

The change to this format by default also has some interesting issues with cells and cell merging that are fixed in a BI Publisher patch. The description of the bug is:

Continue reading “BI Publisher fix for XLSX Cell Merging Problem in PeopleSoft”