ERP Associates, Inc.

Solutions for People and their Software

PeopleSoft Corner Blog

Ideas, Tips and Techniques for PeopleSoft Enterprise

Automate Your Testing with BadBoy

Posted by: Brent Martin in Utilities

Tagged in: Untagged 

Brent Martin

A few months ago I had an opportunity to do performance testing, but I didn’t have a commercial performance testing tool available.  Our users were way too busy to pound on the system until we got it tuned the way we liked, so I started looking for open source or cheap tools to help out.  I ended up getting to know a product called BadBoy (http://www.badboy.com.au) very well.

I haven’t written about BadBoy on this blog yet, but it certainly deserves some attention.  In a sense, it reminds me of what you could once do with SQA Robot and PeopleTools 7.x.  Essentially you can record a session, and play it back as a script.  Badboy isn’t open source, but it is free if you don’t install it on more than 5 workstations in your organization, and it’s cheap for everybody.  A 10 license pack is only $250 USD. 

There are several features that make it a very nice tool for PeopleSoft testing:

You can define variables that can later be used in a script.
2)      You can set variables based on a file input.
3)      You can check for specific text on a page (using Regular Expressions) and take action depending on the Regex Match. 
4)      You can loop until a specific condition is met.

I especially liked the Regular Expression matching features.  I had one script that ran a query, and applied AR payments to items depending on the results of that query.


Excel file production from SQR

Posted by: Brent Martin in Reporting

Tagged in: Untagged 

Brent Martin

Got this e-mail the other day and I thought I'd pass it along:

Hi Brent,

Several years ago while I was employed by Fastenal Company I wrote a set of procedures that enable you to write SYLK files from SQR.  These Excel files can contain a fair amount of formatting.  I think it will work with any version of SQR.  I believe we were running version 4.3 at the time of its creation.

The code is open source (thanks to Fastenal Company) and is available free at:

The Ray Ontko Company
http://www.ontko.com/sqr/sylk.html

Thanks,
Jim Womeldorf
http://greeniceenergystorage.blogspot.com/

 

I'm not sure how this is different from David Vandiver's Excel libraries , but it's always good to have options.  If you do want to write Excel files from SQR, you'll probably be interested in how to publish them to the report repository .











OpenWorld 2007 - Thursday

Posted by: Brent Martin in News

Tagged in: Untagged 

Brent Martin

There were no new press releases from Oracle today, and the only things I found in the blogosphere were wrap-up type entries. I did find a couple of interesting analysis about Fusion and where we're at.

Mark Crofton has a nice summary of what was said about Fusion applicaitons, as does Brian Sommer who goes into a little more detail.   Also check out The Feature's OpenWorld summary article.

OpenWorld 2007 - Wednesday

Posted by: Brent Martin in News

Tagged in: Untagged 

Brent Martin

There is lots of new information in the blogosphere coming from OpenWorld today.  Best I can tell, here's what's going on:

 


OpenWorld 2007 - Tuesday

Posted by: Brent Martin in News

Tagged in: Untagged 

Brent Martin

I'm still not in San Francisco at OpenWorld, but I'm trying to stay on top of recent OpenWorld news and announcements. There doesn't seem to be as many blogs updated as there were last night at this time.  It seems like Tuesday night was always the partners night to take clients out, so there are probably a lot of bloggers taking part in the festivities.  I'm sure if I were in San Francisco right now, I wouldn't be blogging.

Anwyay, here's what I've found so far:


OpenWorld 2007 - Monday

Posted by: Brent Martin in News

Tagged in: Untagged 

Brent Martin

I'm not actually at Oracle OpenWorld this year.  My project went live last week, and I was unable to convince my project manager that it was more important to attend a conference than to support the fledgling system. 

So I've been reading blogs trying to figure out what happened today.  Here's what I found: 


OpenWorld 2007 - Monday

Posted by: Brent Martin in News

Tagged in: Untagged 

Brent Martin

I'm not actually at Oracle Openworld this week.  Last week we went live with PeopleSoft, and I was unable to convince my project manager that it'd be OK if I went to San Francisco this week.  So I'm browsing the blogs in an attempt to figure out what I might be missing.  Here's what i've found for day Monday:

  

  


Check Out PeopleSoft Tipster

Posted by: Brent Martin in News

Tagged in: Untagged 

Brent Martin

If you haven't been to the PeopleSoft Tipster blog, you owe it to yourself to check it out.  Duncan Davies has some creative tips and techniques you won't find just anywhere, and his writing style makes them easy to understand and implement.   I learn something new every time I read his articles.


Countdown to Cutover

Posted by: Brent Martin in PeopleTools

Tagged in: Untagged 

Brent Martin

Had an interesting request from my project manager a while back.  He wanted a countdown timer that showed how long we had until cutover.  Here’s a screen shot of what I came up with:

 

Countdown Timer on Signon Page


Migrations - What can go wrong

Posted by: Brent Martin in PeopleTools

Tagged in: Untagged 

Brent Martin

Don't you hate it when you ask for a project to get migrated to Test, and it doesn't work there?  Then you do some research, and it's missing some critical PeopleCode or SQL and the users are getting big ugly errors and questioning the quality of your work.  Okay, maybe it's not always that dramatic, but it is always frustrating.

Here's some of the reasons things don't always get migrated and what you can do:  

 

 


Back to Top