Documenting an Install

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2009/01/22/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.

Loading Data with Excel

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2009/01/21/loading-data-with-excel/

Today, I came across a great link for loading data into an Oracle database with Microsoft Excel.  I may need to try to convert that to loading into SQL Server soon, and so, I wanted to make sure that I captured the link for later.

Step By Step Virtual PS Install: Database Creation

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2009/01/21/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.

Step by Step PS Install: Load the Database

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2009/01/13/step-by-step-ps-install-load-the-database/

This is a continuation of my virtual PeopleSoft installation.  In this step, we will run Data Mover to load the database.  To see the complete list of steps, click here.

jQuery and PeopleSoft

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2009/01/12/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

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2009/01/12/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.

Updated Resources

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2009/01/10/updated-resources/

Tahiti Views just reported that Oracle  has just put up the official PeopleBooks on their website.

The Internet Resources page now includes the official PeopleBooks:

https://psst0101.wordpress.com/resources-on-the-internetresources-on-the-internet/