Ask Question
Help Others
Home

Blogs

FTP File from Windows to Unix Server

Thu, 01/17/2008 - 10:25pm — Lepa

Here is how you can FTP a file from your windows client machine to a Unix server box.

Open the command line by going to Start > Run and type cmd.

You should see something link this:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\compshack>

Now, navigate to the location of the file you would like to FTP. Mine is located under c:\temp\
cd c:\temp

Lets type the ftp command:
ftp database_name

Check What Record Has Your Fields

Tue, 01/15/2008 - 11:54pm — Lepa

This is another quick SQL snippet that I find useful. When would you use it?
Well, you forgot a certain record name, but you know that the record has EMPLID, NAME, EMPL_REC fields on it.
You can query the database to find out what records have the fields you are looking for.

SELECT RECNAME, COUNT(FIELDNAME)
FROM PSRECFIELDALL
WHERE FIELDNAME IN ('EMPLID', 'NAME', 'EMPL_RCD')
GROUP BY RECNAME
HAVING COUNT(FIELDNAME) = 3;

Get all Components Under a Certain Portal Folder

Tue, 01/15/2008 - 11:44pm — Lepa

Use this SQL snippet to return all components plus sub-folders (if any) under a specific portal folder.

For example, lets say you have a folder called "Workforce Admin". Under Job Information, you have a sub-folder called "Job Information" and few components.

Run the SQL against the Workforce Admin folder and you should get a row for the sub-folder, and a row for each of the components.

-- Get all sub-folders and components under a certain folder name --
SELECT PORTAL_NAME,
   PORTAL_PRNTOBJNAME AS FOLDER,
   PORTAL_OBJNAME AS CONTENT_REFRENCE,

Visual Basic Macro to Delete Blank Rows

Mon, 01/14/2008 - 12:07am — Lepa

Users love "copy & past" from one excel document to another. This however can result in having some empty rows in the document and could cause some major headache if you are trying to generate a .txt file and upload it for processing.

One way around this is to create an excel macro that will delete blank rows once the user generates the .txt file.

Here is the code snippet:

'Deletes blank rows before creating the TAB delimited file
    Dim R As Long
    Dim C As Range
    Dim Rng As Range

    On Error GoTo EndMacro
    Application.ScreenUpdating = False

PeopleSoft PeopleTools Meta-Tables

Sun, 01/13/2008 - 7:29pm — Lepa

THE CONTENT OF THIS PAGE HAS BEEN MOVED TO A NEW WIKI STYLE PAGE.

Component, Content Reference, and Menu

Fri, 01/11/2008 - 10:20pm — Lepa

Ok, so we all know that a component needs to be attached to a menu before you are able to register it to the portal structure. Once a component is registered using Application Designer, then a content reference is created and your component will be available under the folder and path you specified during the registration process.

Absolute Value and Date Functions

Thu, 01/10/2008 - 11:43pm — Lepa

Here is a quick PeopleCode snippet to check the difference between two dates.

&date = Abs(Days365(&yourDate, %Date));

Use the Abs PeopleCode function to return a decimal value equal to the absolute value. This is very useful if you are validating that a date must be within X days before or X days after sysdate.
/* notice since we are using the Abs function, we don't need to code for &date < 90 */
IF &date > 90 Then
   /*your error message*/
End-IF;

Oracle Group By ROLLUP

Tue, 01/08/2008 - 1:28am — Lepa

It would be safe to assume that most if not all of us are familiar with Oracle "Group By" clause. You can however use the ROLLUP function to enhance the grouping actions performed within your queries.

Lets take a look at a fairly complex Group By example and then re-write it using the Group By ROLLUP.

Move or Hide Portal Search Box

Mon, 01/07/2008 - 10:04pm — Lepa

Part of our upgrade requirement is to hide the search box on the navigation menu as we are not using it. It must be easy to do, right? Well yes and no. Yes, if you know where to go, and No, if you don't. It will just take some time to dig around to find the right place to turn it off (Hide it).

To hide the search box navigate to:
Root >> PeopleTools >> Portal >> General Settings. Locate the second box on the page and there you should see a check box that says "Display search in navigation". Uncheck it, clear cache and sign back in. Voila, search box is gone.

Search Strings REGEXP_SUBSTR

Mon, 01/07/2008 - 12:47am — Lepa

As of Oracle 10g, the SUBSTR has been enhanced to support searches for regular expressions. The new function is named REGEXP_SUBSTR. You can use the new function to perform advanced searches against a string.

Syntax:

REGEXP_SUBSTR(source_string, pattern
                            [,position
                               [, occurrence
                                   [, match_parameter]
                               ]
                             ]
                            )
Where:
source_string: is the text to search within