REV SCHEDULER® Extract text/strings from a UBE .pdf REV SCHEDULER® Extract text/strings from a UBE .pdf

As REV SCHEDULER can read a .pdf we thought that it would be good to be able to retrieve text from a .pdf.

In REV SCHEDULER we have the RJRTVPDF command that can do that.

The RJRTVPDF operates by navigating to the starting point in the .pdf text using the value in the /SCAN value and then retrieving the required text using the /NEXT value.

In this case we are looking to position to the text values of /SCAN='EQ=Batch Ty/Number'
which is to find the location of Batch Ty/Number
then to retrieve the value in /NEXT=*WORD02
which is the 2nd word after the location of the Batch Ty/Number

G 13480
*WORD1 *WORD2

The value will then be used to update the value of a User Variable (#USR) in this case #USR_LAST_GOOD_BNO.

That User Variable can then be used in:

•Messages, •Log Entries, •Alerts,
•Emails, •Dashboards, •Help Desk Tickets,
etc.,

GLPOST Output PDF

The Flowchart of this complete Scheduled Job looks like:

GLPOST Process Diagram

For a Good Batch the processing would look like:

The Script definition uses the Run Time E1 One World variables to resolve to the correct .pdf:

E:\Revsoft\Scheduler\Engine\rjrtvpdf.exe  
/DSN=Rev-01JDEDBENWB.SCH  
/PDF=C:\JDEdwards\E920\PrintQueue\#OWFUF2_#OWJOBN_PDF.pdf  
/SCAN='EQ=Batch Ty/Number'  
/SHOWTEXT=Y  
/MATCHCASE=N  
/NEXT=*WORD02  
/ENDWITH=*BLANK  
/USRVAR=USR_LAST_GOOD_BNO  

The run time E1 One World execution variable for this UBE look like:

GLPOST OneWorld Variables

This executes as:

E:\Revsoft\Scheduler\Engine\rjrtvpdf.exe  
/DSN=Rev-01JDEDBENWB.SCH  
/PDF=C:\JDEdwards\E920\PrintQueue\R09801_ZJDE0001_13673_PDF.pdf  
/SCAN='EQ=Batch Ty/Number'  
/SHOWTEXT=Y  
/MATCHCASE=N  
/NEXT=*WORD02  
/ENDWITH=*BLANK  
/USRVAR=USR_LAST_GOOD_BNO  

The Log shows the results for the Retrieve.

GLPOST Job Log

A Good Batch will execute the corresponding Scripts and Bypass the Bad Batch Scripts.

GLPOST Good Batches

For a Bad Batch the processing would look like:

The Script definition uses the Run Time E1 One World variables to resolve to the correct .pdf:

E:\Revsoft\Scheduler\Engine\rjrtvpdf.exe  
/DSN=Rev-01JDEDBENWB.SCH  
/PDF=C:\JDEdwards\E920\PrintQueue\#OWFUF2_#OWJOBN_PDF.pdf  
/SCAN='EQ=Batch Ty/Number'  
/SHOWTEXT=Y  
/MATCHCASE=N  
/NEXT=*WORD02  
/ENDWITH=*BLANK  
/USRVAR=USR_LAST_BAD_BNO  

The run time E1 One World execution variable for this UBE look like:

GLPOST OneWorld Variables

This executes as:

E:\Revsoft\Scheduler\Engine\rjrtvpdf.exe  
/DSN=Rev-01JDEDBENWB.SCH  
/PDF=C:\JDEdwards\E920\PrintQueue\R09801_ZJDE0001_13667_PDF.pdf  
/SCAN='EQ=Batch Ty/Number'  
/SHOWTEXT=Y  
/MATCHCASE=N  
/NEXT=*WORD02  
/ENDWITH=*BLANK  
/USRVAR=USR_LAST_BAD_BNO  

The Log shows the results for the Retrieve.

GLPOST Job Log

A Bad Batch will execute the corresponding Scripts and Bypass the Good Batch Scripts.

GLPOST Bad Batches

LEARN MORE