I have been asked to create a WebFOCUS report against an application log file. I doubt that this is possible.

I think I would need to set up a process to create and update a table using the contents of the log file. Then configure a synonym for the new table, etc.

Any comments or suggestions about the feasibility of this approach will be appreciated.

Thanks

This message has been edited. Last edited by: <Emily McAllister>,

Do you know what the application log file looks like? If you can identify each column in the log file, you can create a synonym (master file) for it and report off of it. Unfortunately, most log files aren't really well structured so that's what makes the process a lot more labor intensive.

The simplest way to read a log file is to use a master file that has a single field in it to read each row, then you can break it up with DEFINES, etc.

If it is structured, then a more complex master can be created.

e.g.

EX -LINES * EDAPUT MASTER,LOG,CV,FILE
FILENAME=LOG, SUFFIX=FIX,$
SEGNAME=LOG, $
  FIELD=LINE ,ALIAS=  ,A255 ,A255 ,$
EDAPUT*

EX -LINES * EDAPUT FOCTEMP,LOG,CV,FILE
The Quick Brown Focus Jumped Over The Lazy SQL
EDAPUT*

FILEDEF LOG DISK log.ftm

-RUN

TABLE FILE LOG
PRINT *
END

Thanks BabakNYC and Waz,

I used Waz's guidelines.

I created a synonym using the text editor

Synonym Name: LogTest

FILENAME=ErrorLogTest, SUFFIX=FIX,$
SEGNAME=ErrorLogTest, $
FIELD=LINE ,ALIAS= ,A255 ,A255 ,$

I placed the ErrorLogTest log file in the baseapp folder as ErrorLogTest.ftm

I created a procedure:

FILEDEF LogTest DISK baseapp/ErrorLogTest.ftm
-RUN
TABLE FILE LogTest
PRINT *
END

I can run the procedure and it shows every line in the ErrorLogTest.ftm file. So now I need to find a way to filter ErrorLogTest.ftm so that when my procedure runs it only shows the errors that I am looking for.

If you can load the file into either a CSV or Excel file, you can then add it to WF as a synonym using the new / upload feature In the Master File folder.

I haven't tested it in an FTM but you could try setting a FILTER in the master file that tests if LINE has the word error in it.
FILTER ERR_TEST=LINE CONTAINS 'Error'; $

then have a WHERE ERR_TEST EQ 1;

in your focexec.

That worked perfectly Babak. Thanks for that.

I will look into the Master File upload feature, had not heard of that before.

Thanks, problem solved.

Take a look in Creating Reporting Applications With Developer Studio > Creating a Reporting Application > Uploading Data Files

Babak,
How do you add multiple conditions to that FILTER statement? Can you use AND, OR?

Looks like you can. I just tried this filter in car file and got what I expected.

FILTER TEST=COUNTRY CONTAINS 'ENG' OR COUNTRY NE 'FRANCE'; $

Thanks,

I found that this works in the FEX to do multiple conditions on the filter

WHERE ERR_TEST EQ 1;
WHERE LINE CONTAINS '10/29/2015';

What I need to do now is find out how to replace 10/29/2015 with today's date and time.

I would think you'd just setup a define like such:

DT_TODAY/MDYY='&DATEMDYY';

Then within your WHERE clause replace '10/29/2015' with DT_TODAY.

-Joe

quote:

WHERE LINE CONTAINS '10/29/2015';

Take a look at &DATEDMYY.

WHERE LINE CONTAINS '&DATEDMYY';

Really wanted to click a LIKE button then