Read Log Files into a Capsule

Massimo Minato

Good morning

I have a personalized admin capsule where i do administrative jobs like load cubes data
and i would like to reads the logs file generate from the import into a screen.
do anyone has experience on that matter ?

 

A good example is the task manager screen where you can see e formated log with head columns

Unknown

Hi Massimo. Navigate to C:\Board\Dataset\Log and you will find files like this - HBMP_Standard_BI_Demo_201802.txt, where 'Standard_BI_Demo is my Database and 201802 is the month and year. HBMP always appears at the beginning. This file, when opened in Excel looks like this:

So, in this file you can isolate the data reader executions and load this into a BOARD capsule screen using another Data Reader, with a little bit of ETL to capture just the rows you need.  Does this help you?

Unknown

Apologies - I missed column A from my screenshot above.  So, in this case I am interested in those Action Codes marked 'FR'.  I don't have a glossary of all Action Codes, but maybe somebody else here can provide this.

Fabio Donatellis

Hi Massimo Minato,

All log files can be imported into a Board application, for analysis and statistics.

 

Here you will find a list of log files available BOARD LOGs in detail.

In the support area, you can find a sample application: Log Analyzer Application

 

Fabio