Tuesday, October 27, 2015

Screen recording softwares

I have used some of the screen capturing tools and i would like to share my experience.

1. ActivePresenter V5.5.2: I suggest using this app. One setback with this tool is, when we have to delete a range, all the individual element has to be separately deleted. i.e. video range has to be separately selected followed by microphone audio and system audio.
2. Icecream Screen Recorder: in free version, it wont allow to record more than 10 mins of video. editing is not user friendly.
3. BB FlashBack Express Recorder: It is not user friendly. i don't prefer to use this.
4. ezvid: Strangely, it wont allow to trim audio. and keeps appending to existing despite we trim video. better not to use this tool.

There are other tools suggested by my friends like: movavi and camstudio. I have not personally used it, but you can give a shot.

Happy recording. 

Friday, September 12, 2014

Useful blogs

Seems to be useful blog

PeopleSoft Blog on HRMS Key Concepts:
http://peoplesoftconcept.blogspot.sg/


Oracle PeopleSoft HCM for YOU:
http://peoplesofthrms.blogspot.sg/

Wednesday, December 4, 2013

Convert Picture to Text

Use below website to convert Picture to Text

http://www.free-ocr.com/

Or

upload to google drive with option: Convert image to text.

Wednesday, November 28, 2012

Customize Notepad++ for color coding

Follow steps given in below link

http://workingscripts.com/2009/06/notepad-peoplecode-sqr/


Thursday, August 2, 2012

Problem with MsgGetExplainText function


We use MsgGetExplainText() to get the message from message catalog explain text part to display as a error or message or warning.

In PT8.49 onwards, the function is returning the text twice. for example if the text is "show me as a error message", the output will be like

show me as a error message
show me as a error message

To get rid of this bug, we need to clear the second message which is in the buffer.
use it as below.

&error= MsgGetExplainText(28000,12,"Message not found");
&novalue=MsgGetExplainText(99999,1,"");/* 99999,1 should not have any text*/
error (&error);

or this way.

&error= MsgGetExplainText(28000,12,"Message not found");
&error=MsgGetExplainText(99999,1,&error);/* 99999,1 should not have any text*/
error (&error);

Hope it will be useful for you.

Wednesday, July 18, 2012

PeopleSoft Auditing

Record Auditing:

select
    RECNAME,
    RECDESCR,
    AUDITRECNAME,
    case when bitand(RECUSE,1) > 0 then 'Y' else 'N' END AUDIT_ADD,
    case when bitand(RECUSE,2) > 0 then 'Y' else 'N' END AUDIT_CHANGE,
    case when bitand(RECUSE,4) > 0 then 'Y' else 'N' END AUDIT_DELETE,
    case when bitand(RECUSE,8) > 0 then 'Y' else 'N' END AUDIT_SELECTIVE
from PSRECDEFN
WHERE AUDITRECNAME != ' '
ORDER BY RECNAME;

Record Field Auditing:

select
    F.RECNAME,
    F.FIELDNUM,
    F.FIELDNAME,
    F.USEEDIT,
    case when bitand(F.USEEDIT,8) > 0 then 'Y' else 'N' end AUDIT_FIELD_ADD,
    case when bitand(F.USEEDIT,128) > 0 then 'Y' else 'N' end AUDIT_FIELD_CHANGE,
    case when bitand(F.USEEDIT,1024) > 0 then 'Y' else 'N' end AUDIT_FIELD_DELETE
from
    PSRECFIELD F
where
    F.FIELDNAME = (
        select
            case when (
                bitand(USEEDIT,8) > 0 or
                bitand(USEEDIT,128) > 0 or
                bitand(USEEDIT,1024) > 0
            ) then FIELDNAME else '' end as FIELD_AUDITED
        from PSRECFIELD
        where RECNAME = F.RECNAME
        and FIELDNAME = F.FIELDNAME
    )
order by F.RECNAME, F.FIELDNUM;

Refer to: http://peoplesoft.wikidot.com/what-is-audited
and to: http://xtrahot.chili-mango.net/uploaded_images/USEEDIT%20Flags-799884.jpg