PeopleSoft Update Manager Dashboard (PUM Dashboard)

The Update Manager Dashboard provides a central location for all update tasks. The dashboard provides analytics for PUM (PeopleSoft Update Manager) that assist in determining your current level of maintenance. The various pivot grids provided on the dashboard, provide access into the maintenance logs and bug information for each database uploaded to the PeopleSoft Update Image.

While there is no question that it is a very useful feature specially the About PeopleSoft Image page which allows you  to display information about the PeopleSoft Image.

Select selectPeopleTools, then selectLifecycle Tools, then selectUpdate Manager Dashboard, then selectUpdate Manager Utilities, then selectAbout PeopleSoft Image

The interface is somewhat lacking specially as drilling down to the pre/post requisite bugs requires multiple click. The same process can easily be achieve via excel and macro. Below is the comparison between the excel macro and the About Update Image utilities

Windows insider Experience

image

Enrolled myself to the windows insider program and was able to take the new Microsoft OS for a spin. Initially tested the release on Oracle Virtual box, installation went smoothly.

I then  decided to jump the gun and upgrade my windows 8.1 on my acer iconia w700 to windows 10 release, installation was a success but errors were encountered left and right, a bit expected and waited for a new build to be released.

Proceed with the upgrade of windows 8.1 to windows 10 mobile on my lumia 920. Corrupted my OS, have to plugin to my PC to perform recovery. Was able to recover and install, my lumia 920 is now running windows 10 preview.

A new windows 10 build was released, upgraded my windows 10 VM first. Seen a lot of improvement. Upgraded my w700, Encountered a boot loop issue. I have to reformat my w700 and reinstall windows 8.1 then upgrade to windows 10 build. This time the upgrade works and a more stable windows 10 runs smoothly on my w700. Impressed with the UI and the performance.

Signup for the August 29 windows 10 release on my asus laptop.the same laptop which host my Windows 10 VM.

Dday, August 29. Downloaded windows 8.1 upgrade on my PC which took about an hour or so. After the download and install. Windows 10 start downloading and was able to upgrade my asus from windows 8.1 to 10

Still testing, my setup are as follows:

1. Windows 10 preview on Oracle virtual box 5, guest OS on asus gaming laptop

2. Windows 10 home on ASUS gaming laptop

3. Windows 10 professional on my afer iconia w700 touch

4. Windows 10 mobile preview on my Lumina 920

System integration

Like many enterprise application. Many companies are very much liberal in the installation and deployment guide that they normally published specially for products requiring large scale installations and integrations. After all, it is hard to account for multiple scenarios that can take place on the implementing side of the fence. Due dilligence should be made and fingers cross the approach you’ve chosen works! At the end of the day, you can’t test every possible scenario anyway.

Oracle VM virtual box 5

Back in the days dual booting OS is a “in” thing. Yes i belong to that generation. I’ve been playing around with virtual machine for quite sometime using Oracle VM. It’s open source and free for those who like to play around with virtualization, OSes and networking. To date i have around 9 VMs configure in the machine i’m using

Version 5 were recently released and can be downloaded on the following url: https://www.virtualbox.org/

Declutter your Desktop/Workstation

1. search for duplicate files that can be deleted

you can download from this free resource

http://download.cnet.com/1770-20_4-0.html?query=duplicate+files&platformSelect=Windows&tag=srch&searchtype=downloads&filterName=platform%3DWindows&filter=platform%3DWindows

2. start organizing related media audio, video, docs, etc.
some useful file managing software

http://download.cnet.com/1770-20_4-0.html?query=file+rename&platformSelect=Windows&tag=srch&searchtype=downloads&filterName=platform%3DWindows&filter=platform%3DWindows

3. check your hard drive using the CHKDSK utility

4. defragmet your hard drive

Nvision: Unsupported FileFormat 

The change in the filename extension of microsoft excel from .xls to .xlsx resulted into issue with when peoplesoft nvision. If your setup is now using the new office version, you might have encontered the following error message:

An OpenXml error occured. Microsoft Excel 2003 Format Layouts are not supported. Unsupported FileFormat

Ofcourse if it’s just for a single layout, you can simply open the layout in excel and use the “save as” functionality. But what if you are using hundreds of nvision layout for your peoplesoft nvision? You might find the process time consuming. Here’s the steps to perform mass conversion of your layout:

1. Download and install Microsoft OMPM here http://www.microsoft.com/en-us/download/details.aspx?id=21888

2. perform mass rename of the layout file (.xnv). Go to the nvision layout directory and run the following command in the command line

ren *.xnv *.xls

3. On your OMPM installation, go to ..\OMPM\TOOLS

4. Open ofc.ini and edit the following section, where fldr is the layout directory

 

[FoldersToConvert]

; The Converter will attempt to convert all supported files in the specified folders

; (do not include if specifying FileListFolder)

;fldr=C:\Documents and Settings\Administrator\My Documents

;fldr=\\server\share\docs

 

5. under ofc.ini, the DestinationPathTemplate=*1\*2\*3\Converted is the location of the converted files

6. after saving ofc.ini, execute OFC.exe via command line.

7. The files under Converted directory will now have the following filenames:

            .xlsx for regular nvision template

            .xlxm for nvision template with macro

8. perform the mass rename again

            ren *.xlsx *.xnv

            ren *.xlsm *.xnv

9. Congratulation, you have a layout that is not Supported file Format

You can follow the same steps to mass convert other office document as well e.g .doc to .docx