Custom Tools

Have you ever needed a process or tool that will make analysis easier?

Over the years, while designing interfaces, reports, new subsystems and modifying existing subsystems, we have developed a library of custom routines that increase our productivity to a very high degree.  These routines will help shorten the timeline during new implementations, upgrades, security structure design, conversions and new interface design.

Did you know Vendor Maintenance could touch up to 8,000 Objects?

Have you ever added a customization to Vendor Maintenance, and don’t know where else you have to look?  Have you ever wanted to expand a delivered PeopleSoft field and spent the next week finding all the objects this one small change could impact and have to insert them one at a time into a Project?  Have you ever wanted a faster way to compute statistics on your 100GB database?  Have you ever wanted to compare a 7.5 Production query to Demo 7.5?  Have you ever wanted a SQL formatter that actually handled just about every type of convoluted way Application Engine stores it?

A small list of assorted tools we have developed over the years:

• APPENGRPT.SQR – Routine to report an Application Engine routine by execution path (starts from MAIN ) and resolves the Meta SQL.
• APPENGCMP.SQR – Routine to compare 7.x Application Engine processes.
• SPLITTER.SQR – Splits out long running SQL scripts, runs and monitors progress.  Great for Upgrades.
• COBOLSQLCMP.SQR – Routine to compare 7.x COBOL SQL statements.
• QUERYCMP.SQR – Routine to compare 7.x Query objects.
• IMPANCOMP.SQR – Impact Analysis Project Build by Component (includes PeopleCode).
• IMPANRECFLD.SQR – Impact Analysis Project Build by Record and/or Field (includes PeopleCode, COBOL's and SQR's).
• ANALYZE.SQR – Utility to Compute Statistics on Oracle (very fast).
• NAMES.SQR – Process to convert all Names in HRMS or Financials.
• BAJA_CONVERTER - The most comprehensive data conversion utility you can find.
• PROJECT_ANALYSIS.SQR – Process to report a PeopleSoft Project to Excel (useful for analyzing customization level).
• SETTABLE.SQR – Process to Sync PSDDLRECPARM with Oracle and create a project for alter command or just plain auditing.
• SETINDEX.SQR – Process to Sync PSDDLIDXPARM with Oracle and create a project for alter command or just plain auditing.

Ask us about other tools developed by people who have experienced the madness:

• SQR TREE - Routine written by Wayne Ivory to provide a GUI process for for SQR (Excellent Tool).
• SQR Analyzer – Routine written by Tony Delia to provide a process flow of an SQR routine.
• COBOL Analyzer - Routine written by Tony Delia to provide a process flow of a COBOL routine.
• Application Engine Analyzer - Routine written by Tony Delia to provide a process flow of a 7.x Application Engine routine.

Ask us about these WINEDIT scripts that provide valuable functionality to your development environment.

• CHANGE.MAC – WIL script to change your code by line (and/or column) range.
• CNVTABS.MAC – WIL script to convert all TABS to spaces.
• STRIP.MAC – WIL script to strip trailing spaces.
• DOWNSHIFT.MAC – WIL script to downshift all SQR & SQL keywords.
• SENTENCE_SHIFT.MAC – Sentence shifts all SQR procedure names and variables.
• TRACE.MAC – WIL script to add Tracing and Breakpoint logic to any SQR.
• GREP.MAC – WIL script for very powerful searching.
• FORMAT_SQL.MAC – WIL script to format any SQL to a readable format (Oracle/SQL Server).
• SQR_TOOLS.MAC – WIL script to format SQR’s.
• PGM_ANALYZER.MAC - WIL script to analyze an SQR (or COBOL) for Tables and Variables.
• EXPLODE.MAC - WIL script to explode an SQR (or COBOL).
• EXTRACT.MAC - WIL script to read code and extract the line by search value.
• ALTERSCRIPT.MAC - WIL script to parse a PeopleSoft Alter script (Oracle) and make it faster.
• DISTRIBUTE.MAC - WIL  script designed to distribute projects across multiple PS instances.

Need a tool?  Think you have an impossible task?  Ever come up with an idea that would really add value to your productivity?  Give us a shot at it, because we like the challenge.  Ask us about creating a tool for your business.  Please contact us for further information about our PeopleSoft and Editing tool capabilities.