Readsoft User's Forum
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
dpalmer926

New Member
Registered:
Posts: 1
Reply with quote  #1 
Hello,

There are 3 ReadSoft Oracle DB tables that seem to track statistics related to the main functional processes before data is transferred to SAP, and 1 additional DB table that captures Transfer Job statistics.

The data in these tables could be useful for understanding cycle times to process invoices, rejection reasons, field errors, identification rates, etc... before reaching SAP.
Also, not all of this data would be available in the SAP Process Director DB tables.
Our business wants visibility to this.

The DB tables are:
INVOICEDEFINITIONSTATISTICS
VERIFYJOBSTATISTICS
INTERPRETJOBSTATISTICS
TRANSFERJOBSTATISTICS

In our configuration only the 1st DB table has data.
Is there a way to turn-on capturing of statistics for the other processes and DB tables?
Has anyone here ever looked at the data in these DB tables?

Examining the table column names it seems the information would be useful for reporting on ReadSoft processes and where bottlenecks may lie.

Thanks


0
BLY

Member
Registered:
Posts: 18
Reply with quote  #2 
Hello,

I am looking forward any experience on this topic !
4 years ago when Readsoft implementation project started in my company, Readsoft France consulting developped a customized table for us and a program to feed it to create reporting data : number of invoices in Manager, Number of invoices transfered.
So No I doubt there is a way to capture easilly data, but I so muche would like to be wrong ....

PJ
0
ganieljohn

New Member
Registered:
Posts: 8
Reply with quote  #3 
Hi Everyone,

I also have a similar requirement. Basically, we want to keep track of how many invoices go through Scan and Collector.
The Statistics function found in Manager only gives me the current day stats. We are looking to have a report for monthly data.

BR,
Ganiel
0
ganieljohn

New Member
Registered:
Posts: 8
Reply with quote  #4 
I found that the option to activate the statistics of Scan module is deactivated. Any idea on how to activate this?

The Save Statistics option is activated in the General Options, but is deactivated under Scan.
2016-03-01 08_51_50-FAL Desktop - Readsoft - Citrix Receiver.png 

2016-03-01 08_51_43-FAL Desktop - Readsoft - Citrix Receiver.png 


0
cherylc

Moderator
Registered:
Posts: 162
Reply with quote  #5 
Hi

My you-beaut simple way of solving, at zero cost [biggrin] , at least some of the above requirements would be to increase the retention of the Process Log to 31 days (Manager > Administration > Maintenance > DBM > Process Log).  Then increase the duration of the Process Log timeout in the eiglobal file.  For example, to 300 (5 minutes).

Then on the 1st of each month I would manually dump the data from the Process Log into Excel and perform my analysis. I think if you do a ctrl+A, ctrl+C and then paste into Excel it will copy across.

Would that work?


Cheers


__________________
Cheryl
LinkedIn: https://au.linkedin.com/in/cherylc-651471a0
0
cherylc

Moderator
Registered:
Posts: 162
Reply with quote  #6 
Another option would be to use your XML process log file on your Readsoft server.  Have a look in your log files in your global path (or you can see the path where it is stored in Manager > Administration > Maintenance > DBM > Process Log). This contains all of the deleted Process Log entries older than your specified retention period.

If you take this file and split it into years (or whatever your license period is) then the file on the server will only contain your current data.  So take out the old data and stick in a file called say ProcessLog_2015.xml.  The data in the ProcessLog.XML file + the Process Log in Manager is the total of all your entries for the current year. 

If your process log retention period is 10 days, then check the XML log on the 10th day of the month.  At least you will have a history for the entire year up until the 1st day of the month.  If the 10 day delay is too great, then reduce the duration of the retention period, bearing in mind Accounts Payable use of the Process log.

__________________
Cheryl
LinkedIn: https://au.linkedin.com/in/cherylc-651471a0
0
ganieljohn

New Member
Registered:
Posts: 8
Reply with quote  #7 
Good Day Cheryl,

It worked, checked the process log and found that the messages indicate the source of each message. Now I'll just have to find a way to convert the xml view into a user friendly view. Many thanks as always [biggrin] have a great weekend ahead.

BR
Ganiel
0
cherylc

Moderator
Registered:
Posts: 162
Reply with quote  #8 
Hi Ganiel
That's great news. 
One thing I realised when looking at this query is that the Process Log file gets too large.  I think it would be good practice to rename the file on the server each year (say put a yearly task in your calendar).  When you rename the file on the server, Invoices will automatically create a new process log file on the server.  So there should be one Process Log file per year rather than a continuous one.  This should make reporting easier.

The other thing I wondered is whether a change of file extension in Manager > Maintenance, etc will change the format of the file and make it easier to open in Excel.  So I am in the process of testing whether a .txt extension will work..... hopefully.

Wishing you a great weekend too.  As usual, I will be off somewhere on my bike [smile]
Cheers

__________________
Cheryl
LinkedIn: https://au.linkedin.com/in/cherylc-651471a0
0
cherylc

Moderator
Registered:
Posts: 162
Reply with quote  #9 
Hi Ganiel,
Take 2, txt does not work. 

Using a 5-8 System and a xml file, open with Excel and choose Read-only workbook: 
[image]

Then I filtered out the blanks on Column F called /Invoice/DocID/#agg

Column A provides how many invoices have been interpreted (note 6 in this example).  The second row and Column M tells me the source.  Filter on relevant sources in column M.
 sample process log.png 

sources process log.png 


The Process Log in our 5-7 system would not open however the file can be edited in Notepad ++ to remove any inconsistencies in the XML tags.

Kind regards





__________________
Cheryl
LinkedIn: https://au.linkedin.com/in/cherylc-651471a0
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.



Follow @readsoftuser