If you use APP ENGINE to report the data from the temp table /staging table on to CSV file using excel format, there is a known issue with fields that have leading zeros. For ex:You have a field of length 6 characters. If the field value is 002123, the excel file removes the leading zeros. But if the requirement is to preserve those leading zeros, we can do something like this.
Update the temp table right before you write out into a file.
The function increments a date field using the AddToDate function and sets a weekday field to the corresponding weekday. You can increment date value by year, month or day.
A function to facilitate the addition of a leading character to a field value. The function takes three parameters:
- &LEADCHAR: The character you want to append to your value.
- &FIELDZISE: The over all size of your value after appending your desired character.
- &FIELDVALUE: The value you want to append the character to.
Syntax
str: value to be passed to the function.
Example:
The example sets &VAL1 to 5.25 and &VAL2 to 500:
&VAL1 = Value("5.25");
&VAL2 = Value("500");
Check out the following post to convert a number variable type to a string type.
Syntax
Check out the following post to convert a string variable type to a number type.
I have code to auto-increment an alphanumeric field, using SQL calls. It is specific to a 4-character field, but can easily be adapted to different length fields.
Peoplesoft provides a function called as "DateTimeToLocalizedString" to change date from one format into another.
Following is syntax used to achiev this.
DateTimeToLocalizedString({datetime | date}, [Pattern])
Param1 : Variable of Date Datatype
Param2 : Date format which you want for example "dd/MM/yyyy".
If you have Param1 of type string then use function "DateValue" to convert that string to Date.
This code i have got Ittool box.com.
It is very useful. we usually have requirement when we want to hide some translate values from translate field on page for some business reason.
In this case we can use AddDropDownItem(),ClearDropDownItem().
The fact is that we need to use ClearDropDownItem() function first. so whatever values it had will be cleared out and then we will have to manually add values using AddDropDownItem().
Here is an example on the page activate PeopleCode.
A function to call UNIX and/or shell script from PeopleCode.
The Exec command has changed in PT8.4x so the above function will be:
There was a question asked on the forum on how to hid a subpage. There is no Peoplecode function to hide a subpage directly, BUT one way around that is putting the subpage in a group box and hid the group box instead. Hiding the group box will end up hiding your sub page.
Make sure to follow the following post, it will walk you through how to hide a group box on a page.
| Title | Under | Posted on |
|---|---|---|
| Regarding Error "SQR 6002) CANNOT OPEN THE PRINTER FILE: " in SQR | PeopleSoft Technical | 11/21/2008 - 1:17am |
| Pay calendar Setup | PeopleSoft Functional | 11/18/2008 - 5:30pm |
| Issue linking to Excel 2007 from PS HRMS 8.8 | PeopleSoft Technical | 11/17/2008 - 9:48am |
| Spreadsheet-Based Control System Analysis and Design | Programming | 11/11/2008 - 5:10am |