Project

Projects

NOTE - Use your Browsers BACK Button to return to prior page or CLICK here.

TD75PROJ.SQR - Project Item Listing and Extract

Use this utility to extract object details in your project. A report listing is produced with variable headings by object type as well as a pipe-delimited ascii text file you can import into Excel. This is useful in avoiding duplicate entries into Object Tracking Spreadsheets used at many installations.

Click on the dinosaur to download the TD75PROJ.SQR Project Extract program. Below you will find sample output and a description of the user prompts.

Projects in Application Designer

Here is a 'compressed' view of the project PPLTOOLS... You can see the individual object types in the Upgrade Folder tab... totals for each object type are displayed in the Project Workspace along with the total object count (in this case 5094 total objects in the PPLTOOLS project... Many clients require developers to maintain an additional spreadsheet with each object change... this is basicly duplicating each entry already assigned to the project itself! Let's use the TD75PROJ SQR utility to produce an object listing and a file to import into Excel.

Project Listing Sample 1 - Translate Objects


Report ID:  TD75PROJ         PROJECT ITEM LISTING

  Project:  PPLTOOLS
================================================================================
  Object Type        Fieldname          Fieldvalue   Language Code   Effdt
================================================================================

  Translate          AE_ABEND_ACTION    A            ENG - English   1900-01-01
  Translate          AE_ABEND_ACTION    B            ENG - English   1900-01-01
  Translate          AE_ABEND_ACTION    I            ENG - English   1900-01-01

  <snip>

 Object Count:      638

================================================================================
PeopleSoft Project Listing     by Tony DeLia     tdelia@erols.com

Project Listing Sample 2 - PeopleCode Objects


Report ID:  TD75PROJ         PROJECT ITEM LISTING

  Project:  PPLTOOLS
================================================================================
  Object Type         Record Name    Field Name      Program Type
================================================================================

  Record PeopleCode   AEAPPLVW       AE_APPLID       11 - SearchInit
  Record PeopleCode   AEAPPLVW       AE_APPLID       12 - SearchSave
  Record PeopleCode   AEAPPLVW       AE_SECTION      11 - SearchInit

  <snip>

 Object Count:      887

================================================================================
PeopleSoft Project Listing     by Tony DeLia     tdelia@erols.com

Project Listing Sample 3 - Process Type Objects


Report ID:  TD75PROJ         PROJECT ITEM LISTING

  Project:  PPLTOOLS
================================================================================
  Object Type        Process Type         Operating System      Database Type
================================================================================

  Process Type       Application Engine   1 - NT/Win95 Client   0 - DB2/MVS
  Process Type       Application Engine   1 - NT/Win95 Client   1 - SQLBase
  Process Type       Application Engine   1 - NT/Win95 Client   2 - Oracle

  <snip>

 Object Count:      253

================================================================================
PeopleSoft Project Listing     by Tony DeLia     tdelia@erols.com

Project Listing Sample 4 - End of Report Summary


Report ID:  TD75PROJ         PROJECT ITEM LISTING

  Project:  PPLTOOLS
================================================================================
  Object Type                        Object Count
================================================================================

  Record                                      741
  Index                                       131
  Field                                     1,810
  Translate                                   638
  Panel                                       239
  Menu                                         20
  PanelGroup                                  133
  Record PeopleCode                           887
  Query                                       100
  Tree Structure                                1
  Tree                                          2
  Access Group                                 32
  Color                                         6
  Style                                         1
  Business Process Map                          1
  Business Process                              2
  Activity                                     13
  Role                                         10
  Process Definition                           61
  Process Server                                5
  Process Type                                253
  Process Job                                   7
  Process Recurrence                            1

  Project Total:                            5,094

================================================================================
PeopleSoft Project Listing     by Tony DeLia     tdelia@erols.com

Extract Sample - After importing into Excel and formatting

User Prompts

Enter Project Name:

Enter your Project Name (that's it)....

The output path/filename is: '{FILEPREFIX}' || 'TD75PROJ.TXT'

Feedback

I would appreciate any feedback you may have on this site. Send mail to tdelia@erols.com or click on the Octopus.

Technical difficulties?

Please report any technical difficulties you may encounter to the address above OR click on the Octopus. Thanks.

NOTE - Use your Browsers BACK Button to return to prior page.

Tony DeLia - Updated February 2, 2000