PeopleSoft Tipster

This year the UKOUG PeopleSoft Conference has been split out from the Oracle Conference (last year it was in the same building, just on a difference floor).  We’ve also teamed up with the GPUG (the HCM Global Product User Group) so there’ll be an extra stream of content this year (HCM, Financials, Tech, Round tables and GPUG).

I’ve been for a few years running now and thoroughly enjoy it.  There’s always something new in the presentations (check out the agenda if you need convincing), it’s excellent for networking with fellow professionals, and there’s nothing like being able to coral some of the industry’s experts to answer a question or two from back at work.

Finally, there’s been a change of venue.  We normally have a contigent of overseas visitors, and seeing as it’s practically on the end of one of Heathrow’s runways it couldn’t be more convenient (just make sure you don’t bring swine flu with you!).

If you’re quick, the early-bird discount will save you a bit of money too …

Click here to register.

In a previous post I’ve spoken about the benefits of creating a custom Navigation Collection on your homepage.

(Note: this doesn’t need to be Enterprise Portal, this can be done in the HR/Financials/CRM/Student Admin application).

I also covered migrating your setup to other environments.  A step I neglected to mention is a common one, when colleagues enviously notice your productive new setup how do you easily apply it to their user profiles so they can benefit also?  Or perhaps you’re setting up a homepage to roll-out to the entire user community?

Here’s how you do it:

(more…)

Today I had the need to check something on an old Tools 8.18 / HR v8.3 environment that hadn’t been booted for many a year, and it was quite an eye opener.

The environment was hosted within an old VM, last touched in 2003 and it was fun to mess around and battle to get it booted.

Those of us that have been around for a few years will remember the old Tools 8.1x user interface with the breadcrumbs, but one of the surprises for me was how fast it runs on a modern laptop.  I gave it 1.5GB Ram and it absolutely flew!

(more…)

It can be a good idea to frequently take flat-file backups of your App Designer Projects, depending upon how reliable the infrastructure is at your site, and how frequently environments get refreshed from Production.  I’ve often thought “I wish that there was a shortcut for this procedure”, but have never done anything about it.

I recently chanced across the excellent PeopleSoft Wiki and noticed a batch file containing many command lines to control App Designer, including exporting projects to command line.

Now I’m not awfully keen on automating migration between environments (I like to run the compare reports and set the flags myself immediately before migration) but the exporting of projects caught my eye.

Using the same command line we can create a batch file that’ll loop through a list of projects and export them – one at a time – into a directory of your choosing.

Create a file in the same directory as the batch file with a list of the projects you wish to export (one on each line) named project_list.txt.  Then run the following batch file:
set pside=C:\Tools\bin\client\winx86\pside.exe
set export_path=C:\temp\exports\
set dbtype=ORACLE
set user=ddavies
set pwd=******
set srcdb=DEV
FOR /F %%a IN (project_list.txt) DO %pside% -HIDE -PJTF %%a -FP %export_path% -CT %dbtype% -CO %user% -CP %pwd% -CD %srcdb% -QUIET -AF 0 -DDL 1 -PPL 0 -CFD 0 -CFF 0 -LF %export_path%%%a.log
pause

Update: 2nd Feb
Anyone having the same issue as Jeff in the comments (where your project flags are set incorrectly and as a result the project gets copied, but not the objects) can set the flags via SQL.

UPDATE PSPROJECTITEM
SET COPYDONE = 0, TAKEACTION = 1
WHERE PROJECTNAME = ”;

One extra note, when you run the above SQL the results aren’t always immediately visible in App Designer. Sometimes I’ve had to shut it and re-open, and sometimes I’ve had to clear the cache also.

After seeing some of the slides and blog posts that followed Oracle Open World ‘08 I thought I’d put together a recap of what improvements Oracle are including in their next release.
(more…)

Have you stumbled across Stack Overflow yet?  It’s a great new website that fills a gap for the perfect place to post programming questions.

It is free, unlike Experts Exchange.

It isn’t rammed with adverts and link-spam, unlike PeopleSoftFans.

And it is a lot easier on the eye, more Web 2.0 and faster than IT Toolbox.

The site designers (including Joel Spolsky of Joel on Software fame and Jeff Atwood of Coding Horror), are themselves well known and respected individuals in the art of programming and UI design, and it shows.  It has lots of nice features, but I like being able to vote up answers and comments, so the better responses rise up the page.

It has only just come out of closed beta so there isn’t much on there for a niche like PeopleSoft yet, but once the answers start getting indexed by Google I imagine it’ll become the first stop for programming issues.  If we can get enough people treating this as ‘the site’ for PeopleSoft Q&A then I think we’d all be winners.

If you ask a question, make sure you tag it with ‘PeopleSoft’ so it’s wasy to find.

A nice spot to Grant Johnson of Amadensor for asking the first question.