sunnybrad
asked on
From logfile to comma delimited format
Hi All:
I have to write a transformation program that takes the log file and creates a comma seprated file from it. These log files parse source code and check for certain strings that point to the fact that some outside vendor's module is being used.
For example:
/votest/test_test/SOL4/jdk /lib/font. properties .ja:4:#Cop yright(C) 1998-98 test Corp.
The first entry </votest/test_test/SOL4/jd k/lib/font .propertie s.ja>is the path of the included file
The second entry <4>is the Line number.
The third entry is the extra information on which the string we were looking for were found.
Now from these we have to create:
Suppiler Name
Suppier's Component
Component Version
Our Project in which component used
Our Product in which component used
Our Version
Open source or not
If license license number
Comments
Let me know how to write this transformation engine. Give me code format. Give me an efficient and solid format.
Let me know if I have to use Databases to retrieve information.
Let me know how these kinds of transformation work is generally done.
Best Regards
sunnybrad
I have to write a transformation program that takes the log file and creates a comma seprated file from it. These log files parse source code and check for certain strings that point to the fact that some outside vendor's module is being used.
For example:
/votest/test_test/SOL4/jdk
The first entry </votest/test_test/SOL4/jd
The second entry <4>is the Line number.
The third entry is the extra information on which the string we were looking for were found.
Now from these we have to create:
Suppiler Name
Suppier's Component
Component Version
Our Project in which component used
Our Product in which component used
Our Version
Open source or not
If license license number
Comments
Let me know how to write this transformation engine. Give me code format. Give me an efficient and solid format.
Let me know if I have to use Databases to retrieve information.
Let me know how these kinds of transformation work is generally done.
Best Regards
sunnybrad
ASKER
Dear Tintin:
Maybe from the file thats parsed out from the source we can find the above information.
It depends on the design. We can design it such that there could be database entry for the
for each file that is found. The information not there can be in the database.
Let me know if a text file would be better.
This is essentially design question just now. Let me know how to approach this solution.
Best Regards
sunnybrad
Maybe from the file thats parsed out from the source we can find the above information.
It depends on the design. We can design it such that there could be database entry for the
for each file that is found. The information not there can be in the database.
Let me know if a text file would be better.
This is essentially design question just now. Let me know how to approach this solution.
Best Regards
sunnybrad
I'm confused.
Are you currently parsing the source?
Do you have real data that you can show?
Are you currently parsing the source?
Do you have real data that you can show?
ASKER
Hi Tintin:
The source is currently being parsed. The output from that looks like the example I gave above:
/votest/test_test/SOL4/jdk /lib/font. properties .ja:4:#Cop yright(C) 1998-98 test Corp.
This all I have in a log file. There are multiple files like this. From this I have to trigger all the information which I require either through a database or file. Let me know a efficient approach to this problem.
Best Regards
sunnybrad
The source is currently being parsed. The output from that looks like the example I gave above:
/votest/test_test/SOL4/jdk
This all I have in a log file. There are multiple files like this. From this I have to trigger all the information which I require either through a database or file. Let me know a efficient approach to this problem.
Best Regards
sunnybrad
ASKER
Hi Tintin:
Let me know if you need more information.
Regards
sunnybrad
Let me know if you need more information.
Regards
sunnybrad
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The way I will approach this is to have datafiles, associating filenamre e.g.font.properties.ja to supplier name supplier component etc. The our project name will also come from the dir you are currently in. Sorry you did not had this information. I was looking for specaluative answers, you forced me to think !!.
Best Regards
sunnybrad
Best Regards
sunnybrad
Suppiler Name
Suppier's Component
Component Version
Our Project in which component used
Our Product in which component used
Our Version
Open source or not
If license license number
Comments
I certainly can't see how you would determine most of the this based on the information you've given.