Search This Blog

Tuesday, February 26, 2013

Dynamic Prompt


Dynamic Prompt Tables:

Nothing but getting list of values from a at runtime.
The angular brackets mentions that the record from which values are fetched is substituted runtime.

This is achieved using %EDITTABLE as the Edit table in the Record Field properties of the field which should show values.
%EDITTABLE is replaced with actual record at runtime.

Lets see some scenarios in which we can use Dynamic prompt.
1)  Depending on the type of User, say Employee should see data from one record and if it is manager, he should see the data from another record.
2) In a grid/page , where depending on the value of one field , the prompt values in another field changes.

Demonstration in next post.

Tuesday, February 19, 2013

XML Publisher Migration objects

The following definition types can be added to projects in Application Designer:
  • XMLP Data Src Defn.
  • XMLP File Defn.
  • XMLP Report Defn.
  • XMLP Template Defn.
If the data source for the XMLP report is PS Query or Connected Query, then the query or connected query definition should also be included in the project.

Source: Peopletools 8.50

XML Publisher named as BI publisher in 8.52
 Definition types
BIP DataSource Definitions
BIP File Definitions
BIP Report Definitions
BIP Template Definitions.

Source: Peopletools 8.52

Sunday, February 3, 2013

Calendar integration using ics file in PeopleSoft

To do this , you should have a basic knowledge of iscripts.

Steps to create an icalendar.

Create an HTMLobject which contains icalendar script. The icalendar file (extension: .ics) is accepted most of the calendar programs like outlook etc. It helps us to send the schedules/appointments/meetings/anniversaries etc.

The icalendar script is placed in an HTML object.
After that create an iscript which uses the HTML object to render icalendar functionality.

Below are the snapshots.
 

Below is the ics file output in outlook.

Once the event is saved , we can see the same in outlook calendar as shown below.
This completes the basic icalendar example. We can also modify the ical script to add alarms to alert us on the particular event etc.

Saturday, February 2, 2013

Iscripts Example



Iscripts by Example:

Create a derived work record which starts with WEBLIB_XXXXXXXX
Include a field ISCRIPT1 which holds the peoplecode function for Iscript as show below.

Record Definition: WEBLIB_HELOWRLD


The below script , echoes the value entered in the text box.

Function IScript_HelloWorld()
Below is the code placed in fieldformula




Security:
After you create a WEBLIB record, and your functions, you must add them just as you would add a page to an application.

Adding the WEBLIB record to permission list PTPT1000. Below is the snapshot.



Click on Edit to control the type of access to the functions.

Testing: Login to PIA and copy the below URL.


http://localhost:8000/psp/hr9stg/EMPLOYEE/HRMS/s/WEBLIB_HELOWRLD.ISCRIPT1.FieldFormula.IScript_HelloWorld

Note: You need to replace 8000 with webserver port and hr9stg with the domain name.

The below script , echoes the value entered in the text box.
 

This completes the creation and testing of iscript.

Note:  You might have observed that just like the content reference which has a URL , the iscript is also a URL.
So, just like the way we register component through App designer to make the link available to the user in PIA, similar way we can register for iscript as well.

Will discuss in detail on the registring iscript in another post. Below arrow shows the registration wizard for Iscript in App Designer.