ERP Associates, Inc.

Solutions for People and their Software

PeopleSoft Corner Blog

Ideas, Tips and Techniques for PeopleSoft Enterprise

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:  

 

 


Crunch Time

Posted by: Brent Martin in Announcements [A]

Tagged in: Untagged 

Brent Martin

I apologize if I'm behind on answering comments or making new posts.  It's crunch time on my project and everyone on the project including me is working dilligently to make a November 1 go-live.  I'm sure we'll make it, but until then we have issues to fix and a production environment to prep.

Talk to you when I get a break! 

-Brent 


Back to Top