1 / 25

Update/Upgrade Strategies Tracking PeopleSoft Patches@UCF

Update/Upgrade Strategies Tracking PeopleSoft Patches@UCF. Panel on Update/Upgrade Strategies Session #5322 - Wednesday 9:15am Bradley Smith University of Central Floria. Tracking PeopleSoft Patches@UCF. Keep a Microsoft Access database that holds which patches we have applied and when

zola
Download Presentation

Update/Upgrade Strategies Tracking PeopleSoft Patches@UCF

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Update/Upgrade StrategiesTracking PeopleSoft Patches@UCF Panel on Update/Upgrade Strategies Session #5322 - Wednesday 9:15am Bradley Smith University of Central Floria

  2. Tracking PeopleSoft Patches@UCF • Keep a Microsoft Access database that holds which patches we have applied and when • Updated via saving PeopleSoft’s own web page and running a program that collects the needed information from that page and merging with Access database • Use a collection of programs to track COBOL, Datamover, SQR’s, and SQC’s files

  3. Tracking PeopleSoft Patches@UCF • Bundle many PeopleSoft Patches together. • Apply patches individually to DMO database • Insert Projects in to ‘BIG’ project. • Apply ‘BIG’ project to local databases

  4. Saving of Web Page via Netscape

  5. Saving of Web Page via IE5

  6. Converting Web Page To Import/Merge File

  7. AWK program

  8. Microsoft Access Database

  9. Run Access Macro to Import/Merege Data

  10. Results of Macro Run

  11. Patch Database - Patch Order

  12. Next Patch to Install

  13. Copy Clipboard to Search Box

  14. Select Resolution Information

  15. Save Patch files to Network Drive

  16. Create New Directory with Patch as Directory Name

  17. Save all files into that directory

  18. Save all files into that directory

  19. Directory List of Network Drive

  20. Support Programs to Track PeopleSoft Changes

  21. Example of how support program work

  22. Using RCS to view changes

  23. Using RCS to view changes

  24. Sofware Needed • Gnu AWK • RCS - Revision Control System, originally developed at Purdue on UNIX. I have a version which was ported to NT • WinRCS - Windows Interface to RCS • Microsoft Access • IE5/Netscape 4.6 • UCF locally written .BAT programs

  25. Where to get the software http://pegasus.cc.ucf.edu/~brad/HEUG2001 http://www.csuohio.edu/PSHEUG email: brad@mail.ucf.edu Panel on Update/Upgrade Strategies Session #5322 - Wednesday 9:15am Bradley Smith University of Central Floria

More Related