Month: January 2009

Documenting an Install

I have been recommended to document a PeopleSoft installation by printing out the installation notes and writing down in the margins what I did and what problems I ran into.  I think that is a great idea.

But, what if I could convert the installation notes into Microsoft Word or Open Office so that I could take my notes directly in the document.  The advantage is that I would have something I could search through for reference or in case of problems.  Also, I could easily include screen shots and such.

The problem is that I haven’t found a way to convert the PDF.  Here is a link that I tried, it and might help you if you have a smaller PDF.  I think the installation notes are too large.  It didn’t work for me.  Let me know if you get it to work.

I am exploring some other options, too.

Please let me know if you have any other ideas for PDFs or for installation documentation.

Step By Step Virtual PS Install: Database Creation

This is a continuation of my virtual PeopleSoft installation.  In this step, we will create the database in an already installed Oracle Database system.  So, this assumes that the Oracle Database software is already installed.  Loading the PeopleTools data will be covered in the next step.  To see the complete list of steps, click here.

Read More

jQuery and PeopleSoft

I came across this link talking about storing Javascript libraries in PeopleTools to use with PeopleSoft applications.  The interesting part is that I have been able to get it working by storing jQuery in an HTML definition.  Application Designer did give me an error about it being too big, but it went ahead and saved it.  Everything seems to work fine so far, and I haven’t had a need to look for another fix.

The solution to save the library in the message catalog sounds  great, but the big problem with Message Catalogs is that they can’t be exported to a file.

Resources

Serve thoseJavaScript Libraries Quickly… and Safely

Query Tool that includes Meta-SQL

Once I learned about SQL Developer, I switched from using Toad as my Query Tool.   If I were to improve one thing though, it would be that the query tool understand Meta-SQL.  Now, if I copy SQL from PeopleSoft, say from an Application Engine, I have to remove all of the Meta-SQL tags that PeopleTools understands before I can run it.  Then, I have to replace them before copying back to PeopleTools.

I have thought about trying to write an extension for SQL Developer.  Does anyone know of any documentation about writing extensions or plug-ins for SQL Developer?  This might be a place to start.  Another route I have thought about is an open source tool called Squirrel SQL hosted on Source Forge.  It looks like it has a way to write plug-ins or extensions, but I haven’t been able to get it to connect to any of my databases yet.  To be fair, I haven’t given it a thorough run-through yet.

If you have any ideas or information, please let me know.