General Tips - Fix Drive letter for your External Hard Disk

When we connect external hard disk, it will be given with next available alphabet. It is quite often that the alphabet will be changed. We have to map the shortcuts/PST files every time the alphabet is changed.

To fix this, we can fix alphabet for a hard disk. Choose an alphabet way out in disk alphabets. With this what ever the USB port we connect the drive, the same alphabet will be assigned. Below are the steps for the same.

1. Go to Disk Management: Right click on My Computer, select Manage, on left panel select Disk Management. (Or Run command: diskmgmt.msc)
2. Right click the device and select Change Device Letter and Paths. Click Button: Change and assign an alphabet way out in the Disk Drives Alphabets (I have chosen K).

Hope this helps.
For Some more tips on external hard disk follow URL: http://lifehacker.com/5624331/top-10-external-hard-drive-tricks

Compareit - Powerful tool to compare files

Compareit is very powerful tool to compare data. Its free and can download it from internet. Some of the links where we can download it form are given below.

http://www.grigsoft.com/wincmp3.htm
http://download.cnet.com/Compare-It/3000-2248_4-10832602.html

MailMerge - Simple reporting in MS Office

We can use MS Office feature called MailMerge to generate simple reports. We can prepare template in Word, link data from Excel sheet. Follow below links for the procedure.

http://office.microsoft.com/en-us/word-help/CH010062628.aspx
http://mistupid.com/technical/mailmerge/

Access the Menu Security page (PeopleTools, Portal, View Menu Security)

Path: Main Menu > PeopleTools > Portal > View Menu Security


Use this page to view a list of folders or content references to which a user ID, role, or permission list has access. View Menu Folder Structure and View Menu Item Detail in the same path as above are also useful.

Tables

To find all the Oracle Database Tables: SELECT * FROM TAB;
To find all the PS AppDesigner Tables: SELECT * FROM PSRECDEFN;

To Migrate Audit Records/Settings

When a record is migrated to other instance (ex: DEV to STG) whose audit settings are changed, destination instance audit will not work properly. To avoid this situation, we have to manually update the audit record in destination instance and save.

If we have too many records, the above procedure is not suggestible. instead, we copy data from below tables from source instance to destination instance. we can use DMS for that. (Please test it first before implementing for all the records)


SELECT * FROM SYSADM.PSRECFIELD WHERE RECNAME = 'PSOPRDEFN';
SELECT * FROM SYSADM.PSRECDEFN WHERE RECNAME = 'PSOPRDEFN';

PeopleSoft Blog

http://ps.mytechspeak.com/