The PeopleSoft Tipster Blog

Looking back at how far we’ve come March 27, 2009

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…)

Quickly export multiple Projects November 17, 2008

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.

What’s coming in PeopleTools 8.50 November 10, 2008

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…)

StackOverflow – excellent new Q&A site October 1, 2008

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.