Hi,
I have couple of questions here.
We have a logfile in a UNIX server based on which we want to create a CR (CR Professional 11) report. Currently, we get the file FTP'ed and sent via email and we process this using a REXX script to eliminate unwated text and prepare a csv formatted script output file for CR to read from Windows XP folder to produce the final report.
We want to explore if it is possible to access / read the logfile from the UNIX server directly from Crystal Reports and create the report without the intermediate steps?
Also, the logfile has thousands of lines of data and each line has lots of unwated text. I show 4 sample lines from the file below.
All we want to use from the above lines is the date from the beginning of the line and the text that is enclosed in the curved brackets. Sample CR output will be something similar to the following: (The last number shown here is the count of each category displayed in descending order, which is already being done now).
Any suggestions on how the above can be done, if it is possible, would be greatly appreciated.
I have couple of questions here.
We have a logfile in a UNIX server based on which we want to create a CR (CR Professional 11) report. Currently, we get the file FTP'ed and sent via email and we process this using a REXX script to eliminate unwated text and prepare a csv formatted script output file for CR to read from Windows XP folder to produce the final report.
We want to explore if it is possible to access / read the logfile from the UNIX server directly from Crystal Reports and create the report without the intermediate steps?
Also, the logfile has thousands of lines of data and each line has lots of unwated text. I show 4 sample lines from the file below.
Code:
2006.10.09 01:20:22 [ExecuteThread: '16' for queue: 'weblogic.kernel.Default'] a.s.xxx.com [5] weblogic DocDeterminationEJB.keywordSearch NO KEYWORD MATCH: (Tooling) - FILTER: 3
2006.10.09 02:28:34 [ExecuteThread: '16' for queue: 'weblogic.kernel.Default'] a.s.xxx.com[5] weblogic DocDeterminationEJB.keywordSearch NO KEYWORD MATCH: (INSERTS) - FILTER: 2
2006.10.09 04:42:48 [ExecuteThread: '5' for queue: 'weblogic.kernel.Default'] a.s.xxx.com [5] weblogic DocDeterminationEJB.keywordSearch NO KEYWORD MATCH: (animal DNA) - FILTER: 2
2006.10.09 05:18:21 [ExecuteThread: '6' for queue: 'weblogic.kernel.Default'] a.s.xxx.com [5] weblogic DocDeterminationEJB.keywordSearch NO KEYWORD MATCH: (ibg) - FILTER: 3All we want to use from the above lines is the date from the beginning of the line and the text that is enclosed in the curved brackets. Sample CR output will be something similar to the following: (The last number shown here is the count of each category displayed in descending order, which is already being done now).
Code:
Date Category Count
2006.10.09 Tooling 20
2006.10.09 INSERTS 18
2006.10.09 animal DNA 16
2006.10.09 ibg 15Any suggestions on how the above can be done, if it is possible, would be greatly appreciated.