Knowledge Base ArticlesHere is a list of all articles
A warning about %page and Component Interface
10 steps to follow when coding using a CI.
Some updated information on REST API support
A new run control record proposal
A complete example of providing a REST web service in PeopleSoft.
A look at the “Max Concurrent” process definition property
Exploring the PSPTLOGINAUDIT PeopleTools Table
Two methods to determine what Application Designer Projects are different between databases. This is useful prior to a refresh.
This article looks at the PeopleSoft Campus Solutions “List of Values” (SCC_GET_LOV) web service which a third party can pull setup data out of PeopleSoft. It is helpful for integrations.
How to programmatically access related fields in PeopleCode.
How to add custom images to a portal CREF
An example looking at CS Course Catalog Component Interface to use the Component Interface Find Method.
An example of the perils of using Global Variables in your Application Classes
Global variables are evil!
A simple script to insert roles into a user via SQL.
I schedule a process to run at 9 pm but it did not run until 2 am? Why?
When you are writing code against a Component Interface API, there is an important boolean property on the CI called EditHistoryItems.
Copy like named fields between two diffent records.
An open source project that creates Office XML files from SQR.
An example of how to create a PDF file using PeopleCode and the Query API.
An overview of an audit subrecord you should have on all your custom records.
What Criteria should lead to the use of CI?
An explaination of search records for self-service components.
Documentation for our datadumper application package.
A look at how the PeopleTools integration broker delay processing works.
How to delete user favorites
A quick code fix to allow for row deletions in excelToCI.
An alternative to appmsgpurgeall.dms for one service operation.
Some thoughts on effective design
Some code examples of using java within PeopleCode.
A few tips on how effectively customize a page with PeopleCode
Some tips on how to organize your PeopleCode better.
Some PeopleCode examples to run operations system commands from PeopleCode and get the output.
Have you ever seen the PeopleCode @ operator and wondered when and why you would use it?
Pros and cons of different storage options.
This sql should find component interfaces that a specific user does not have.
Here is query that will find those missing missing pagelets.
Here is a quick way to find where a component shows up in the portal navigation for a given component.
Have you ever wanted to find a table that had specific combination of fields on it?
This query should find unused permission lists that could be deleted.
Some SQL that will show you active service operations
Here is a quick tip to make a portal Content Reference (CREF) open in a new window.
We will explore how to run integration broker code as another user.
When integrating with 3rd Party applications the question often comes up can the PeopleTools integration broker handle http from post data either sending or receiving. The short answer is no.
An example python script that posts to the PeopleSoft Integration broker HTTP connector.
The Application Messaging / Integration Broker is a complicated PeopleSoft module and can be very confusing if you don’t know what to look for.
Ways to bypass a PeopleSoft search record
Here is a sample PeopleCodecode snippet to cancel a process request.
There are times when coding with Component Interface that you need a different search record that the one defined on the component.
This will show you how you can easily do a FULLSYNC of a table from one PeopleSoft database to another with mostly setup and a small amount of generic code.
A common problem for SQR and application engine developers is how to make files generated in SQR and Application Engine accessible to the end user(s).
Introduction to the CHG_DataDumper Application Class used for logging.
A warning in 8.53 JSON parsing limitations.
A newly discovered JSON parsing PeopleCode Class in 8.55.11
A new custom solution to convert JSON to XML in PeopleSoft. It makes parsing JSON in PeopleCode easier.
We documented some limitations with Component Interface that are useful to publish.
How you can link between two PeopleSoft components using an “a” HTML tag.
Sample SQL to generate a list of component based URL acceccsible by a permission list.
Do you want to give your users readable formatted messages and instructions?
A DMS script to migrate managed content data between databases.
Some things I love and hate about PeopleTools development
A new 8.55 feature that may reduce the amount of custom PeopleCode.
An example method of parsing cookies in an integration broker handler.
This script will extract password as an update statement to be moved to another database.
A summary of the PeopleCode events that do not fire in Component Interface.
PeopleCode email REGEX Function
An example usage of a daemon Application Engine
Resources for Learning PeopleSoft Fluid UI.
RESTListeningConnector not returning RESTful faults.
Some guidelines on different types of PeopleSoft Cache.
A look at a strange issue/bug/limitation of calling a REST based service from PeopleSoft.
List of Key PeopleTools Tables
Having problems with remote call and component interface?
Some notes and warnings about the Anonymous node configuration.
How to remove MS Word smart quotes that get turned into upside down question marks.
A simple code example to rename or move a file in PeopleCode.
Using the REST Reporting Web Services to get a JSON response
Using the REST Reporting Web Services in PeopleSoft to run a query.
Reset a user’s password via the back end.
A quick hack to resolve 15,30 error messages.
How to run Dynamic SQL in PeopleCode
Using the Reporting Web Services in PeopleSoft to run a query.
Some ruby code showing how to extract data from PeopleSoft over HTTP.
A summary of SAML authentication software for PeopleSoft PeopleSoft.
A PeopleCode example of using sftp to transfer a file.
An issue with ScrollSort and Component Interface.
Should you create a new CI definition if one already exists?
If you are using the current date in SQL, you are probably setting yourself up for a disaster.
Should you expose a CI Definition as a web service?
Some indications of when you should be using CI.
Some options and thoughts on sending email from PeopleSoft/PeopleTools
Some thoughts on what PeopleTools is good and bad at.
Pros and cons of using temp tables.
I think the Page Activate PeopleCode event is evil.
We have been getting a lot of requests for an Integration Broker training video targeted at developers.
An example python script that post a syncronous message to the PeopleSoft Integration broker HTTP connector and gets a response.
An example of my simple Unit Test page that has saved me hours of development time.
A look at the PSACCESSLOG security table.
An overview of the PeopleSoft Component object model.
Some pros and cons for bolt-ons versus customization
Key Peoplecode events to use
This article will explain Message Queue partitioning in PeopleTools Integration Broker.
A look into the who, what, when, where, why of local integration broker service operations.
Understanding the PeopleCode current context functions: getrow(), getrowset(), and getfield()
An Explanation of the differences and limitations of FULLSYNC and SYNC PeopleSoft Service Operations.
ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOG) violated
How to update query record references from the back-end.
Some code examples of using Apache httpClient from PeopleCode (bypassing Integration Broker)
A look at using OnRouteSend Combined with PeopleCode
A walk-thru for using excel to CI to call the DELETE_USER_PROFILE component interface.
This article contains some discussion around using record objects and function parameters.
Advantages of using Record Objects to do inserts
Here is a quick code snippet to show how to use SQLExec to pull data into a record object not using the key fields of the record.
Some examples of how to redirect user to specific pages at login.
An example of using “switchuser” to change user context in subscription PeopleCode.
A look at FULLSYNC chunking rules
Some thoughts on excluding PSFT Auth token to simplify security for Web Services
For PeopleTools 8.51 and lower the answer is No.
PeopleCode example to get word count using java regular expressions