Welcome to asterlan. A collection of application reports, test scripts and customizations.
This utility clones peoplesoft databases without human intervention. It can copy the whole database, just the data, or just the PeopleTools tables. It uses the mvspss.dms to tell which databases are peopletools tables and which are data tables. It adjusts security to give developers and business analysts access to more things in the new database than they had the original database and changes all email address to a dummy email. You can get a copy of production every week without troubling your DBAs. Oracle only.3
This is an interface between Campus Solutions and the CMIS class scheduling system. It takes Academic Advisement into account when reporting Optional and Mandatory courses.
Salesforce’s ascent and Siebel’s demise has long been seen as a classic tale of the little guy triumphing over the giant. The facts are quite different..
UK Universities present degrees to students individually at graduation ceremonies. The students are called up in a particular order and handed their degree certificates. This is in contrast to the US, where students graduate as a group and are not mentioned by name. By default, PeopleSoft only supports US style group graduations. This customization identifies potential graduates, invites them to enroll for a graduation ceremony, charges them graduation fees, schedules them into a ceremony and prints their degree certificates.8
This is a system for deployment of PeopleSoft code and moving objects from development environments to test and production. You can have any number of steps and environments between development and production. It comes with basic approval process that you can use to control who can approve and migrate projects from environment to environment. It also actually does the migrations. It runs a vbscript program that calls Application Designer from the command line with the parameters necessary to copy projects from one database to another. You can configure those parameters however you like. Unfortunately, you need a Windows process scheduler for this part since you can’t run application designer on Unix (what about Wine? That’s another story). It takes a backup of objects in to target database before it does the migration, and builds tables or views that need rebuilding in the target database. It can be set to stop if it encounters warnings in the migration log files. You can run it manually or schedule it to only do migrations at a particular time.9
A good, detailed explanation, but not for the faint hearted. It involves a lot of messing about with jar files at the Unix command line. It doesn't say much anything about setting up Single Sign On in the first place.
How to performance test a PeopleSoft HR system using JMeter, an open source performance testing tool.8
This BI Publisher report lists the objects in a PeopleSoft project. If you have put comments in the object properties, it extracts them and includes them in the project documentation. It does not document the project's PeopleCode events in the documentation.8
If people type in their address in your system, you should provide a postcode look up. This is a widget that lets users enter a post code, then gives then a relatively short list of addresses in that postcode. This saves them typing, and importantly, gives you much cleaner address data. Most users will use the widget instead of typing their addresses freehand. The contrast between an address table in a system with postcode lookup and one with freeform addresses is astonishing. To do this, you need some sort of database that gives you a list of addresses in each postcode. In the UK, this comes in the form of a flat file called a Postcode Address File (PAF). Royal Mail will charge you £14,000 a year for this file of essentially public information. Fortunately, you can get this data for nothing from a number of sources: Google, 192.com or geonames.org. This project shows you how to use the latter to create a postcode lookup facility in PeopleSoft.10
This customization lets you accept credit card payments through Student self service using Worldpay as the payment processor.8
Before you download, upload something just as cool. If you don’t have anything cool, post two dull, but worthy, things.