The Strings Table

I have seen this in a couple of SQR reports and this will be a good tip for the developers.

What is this Strings Table?

The PeopleTools Strings table (STRINGS_TBL) stores textual strings used for language sensitive labels and other text in PS/nVision and SQRs to avoid hard-coding labels into the report files themselves. The use of strings rather than hard-coded text in reports enables translators to translate the report layout in the database without editing the report’s code itself.This enables you to run a single copy of a report in multiple languages, while avoiding the duplication of code and report logic.Each row in the Strings table keys each string to a STRING_ID, which is associated with one of two different string types:

• The short (RFT Short) or long (RFT Long) field description of the field.

The STRING_ID must equal the field name.

• A free-form text string.

In either case, when a report requests a string in a particular language, the system returns the translated string if a translation is available. If no translation exists, the base language string is returned.

The Strings table is also keyed by a PROGRAM_ID field, which enables you to classify strings into groups that are used in similar reports. PROGRAM_ID can refer to a specific SQR or PS/nVision report name, or it can be a mnemonic for a group of common strings that are shared between reports

Click the picture to expand

Find Object Navigation

Might be a good handy tip. Those who knows this feature already please excuse. Searching the navigation is easy with this feature. try it out.

Click the picture to expand

PeopleSoft Ping

Just another good weekend. Expected some more work today, however it did not happen. Then I thought of just playing around the instance and saw this utility. Never seen or heard before. However it seemed interesting and gave a search in PeopleBooks. The details are given below. Hope this might be a new information for you too. For those who have worked with this utility; please feel free to comment.

The PeopleSoft Ping utility collects timestamps by sending a specific page to different tiers of the PeopleSoft system, starting at the browser, then going to the web server, the application server, the database and back. The timestamps that are collected are total time elapsed for the round trip, and arrival and departure time at each of the tiers.

To use the PeopleSoft Ping feature, select PeopleTools, Utilities, PeopleSoft Ping.

Nice weekend!

Testing Web Service with SendMaster utility

It was in version 9.1 in which first I tried creating a Web Service to GET and POST the data. This was fairly an easy job coz in 9.1 we have delivered SOAP tester. We can use it right after Generating the SOAP template, which is under the Service Utilities.

Click to expand the picture

However while trying to help a colleague I found that in 9.0 the Invoke Service Operation button is not available and we brought up the Send Master Utility.

Now I want to write about how to test a WSDL in Send Master. See the screenshot below.

Click to expand the picture

The Service URL: It is the gateway URL.

In the Header box if it is not populating by itself; you have to type it out. But be sure that the SOAP action is correct. How to get that?

For getting the SOAP action, hit the wsdl on the browser and search for the soapAction.

Dynamic Page Title

One of my colleagues had a small requirement to change the page title dynamically. The example is the RUNCTL_ASOFDATE page in HRMS.