Quickly export multiple Projects November 17, 2008
Posted by Tipster in PeopleTools.1 comment so far
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
Perfect!
What’s coming in PeopleTools 8.50 November 10, 2008
Posted by Tipster in PeopleTools.1 comment so far
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…)
Migrating Navigation Collections and Pagelets November 4, 2008
Posted by Tipster in PIA, PeopleTools.add a comment
Following on from yesterday’s post on creating and publishing a Navigation Collection, now you’ve created one you’ll want to migrate it around between environments. There are a few steps to this. (more…)
Save time with a Custom Navigation Collection and Pagelet November 3, 2008
Posted by Tipster in PIA, PeopleTools.2 comments
Frequently when I’m working I find that I’m visiting the same areas within the system regularly, so to make my life easier I’ll often create a Pagelet based on a custom Navigation Collection containing my often used components. This greatly reduces the number of clicks required for day-to-day work and could be really useful for end users.
NB: Nothing shown here requires the Enterprise Portal product.
An example can be seen here:
PeopleSoft Timings Records October 14, 2008
Posted by Tipster in PeopleSoft, PeopleTools.add a comment
Have you ever wanted to retrieve timing information for a process only to find out the the purge has removed all trace from Process Monitor? Or have you ever wanted more granular information about which parts of an App Engine took the longest? Or maybe you’re not troubleshooting an individual process but want to establish a baseline for long-term performance gathering on your batch window to identify potential future issues.
There is an easy way to accomplish all of the above as PeopleSoft can (although it doesn’t by default) write some really useful data on processes to database records, all ready to be queried.
(more…)
StackOverflow - excellent new Q&A site October 1, 2008
Posted by Tipster in PeopleTools.1 comment so far
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.
Skills shortage? September 22, 2008
Posted by Tipster in Oracle, PeopleSoft.1 comment so far
Frank Scavo has a post covering an article from CIO magazine discussing the Oracle and SAP skills shortage.
He muses over a comment on the article concerning whether the skills shortage is independant of experience, or whether it’s only the more experienced end of the spectrum that has a shortage.
My first reaction is to agree with this. From the consultants I know here in the UK there are those that seem to skip from project to project, only having gaps in between where it’s by their own volition. Pondering this further though, are these the best consultants or just those that are better organised or with better networks?
It’s difficult to tell the difference, because the most experienced consultants are likely to have a wider network of contacts, and will have changed projects many times so will be well versed in the traps novices may fall foul of.
So which is it? I’d like to think it was the former. A talented and experienced consultant will always get work. However I fear it’s the latter as I’ve come across a few that have succeeded by being barely adequate developers but expert schmoozers.
And is the comment on the article correct? Is there a surplus of inexperienced consultants around, but a dearth of their experienced colleagues?
What are your experiences?
A couple of pieces of Fusion news September 4, 2008
Posted by Tipster in Fusion, Oracle.3 comments
I’ve decided to keep this blog for PeopleSoft related items and start a second (surprisingly titled Fusion Tipster) for Fusion related or more forward looking items. I imagine I’ll still post more frequently on this blog, at least until Fusion is released.
There are two pieces of content that I’ve come across in the last few days:
Firstly, there’s a mention for Floyd Teter who has seen Fusion Apps in the flesh.
Secondly, it seems that Oracle’s “Mr Fusion” has left the company.
Creating an entirely read-only user in PeopleSoft August 28, 2008
Posted by Tipster in Oracle, PeopleSoft, PeopleTools, SQL, Security.4 comments
On big projects it is quite likely that large numbers of developers have access to a many environments. Occasionally they can have access to environment which is quite important, for instance one that the customer is using for training or testing.
To reduce the likelihood of developers accidentally deleting some data that they shouldn’t it would be quite normal to remove their access to the environment altogether. However if they need access for troubleshooting purposes then (at least on projects I’ve seen) it’s quite normal for developers to be told “OK, you can have access, but be careful not to do anything destructive”. Occasionally - as with everything - things can go wrong. Either someone forgets which environment they’re in, or does something with unintended consequences. An alternative to the “just be careful” approach would be to create an entirely read-only user profile (i.e. one that has display only privileges to every component system-wide).
A read-only user profile is shown in screenshot below, where no fields are editable and the save button is inactivated:
Also, on Run Control pages the ‘Run’ button is inactive. It’s going to be pretty difficult to alter data in this environment.
Here’s how to do it quickly and easily …
Substringing and Oracle SQL - Basic Trick August 18, 2008
Posted by Tipster in Oracle, SQL.1 comment so far
This may well be something that you already know, but it was totally new to me. It was one of those magic moments where you stumble across something so elementary you wonder:
a) how you haven’t found out about it before
b) how much time it’ll save in the future
This is related to taking only a portion of a string using Oracle SQL, and in particular the right hand side of a string. In other programming languages I’ve been spoilt with the RIGHT(x,num_chars) command, which we don’t have in Oracle.
In the past I’ve made do using something like:
SUBSTR(<character_field>,length(<character_field>)-4,4)
if I wanted to take the 4 right-most characters from a string. This gets cumbersome pretty quickly when you have multiple substrings etc.
Today - to my delight - I discovered that you can include negative numbers and Oracle will count back from the right hand side. So this will take the 4 right-most characters from a string:
SUBSTR(<character_field>,-4)
