PT Log File to Database Parser

[Phatkone]

Hi All

i got sick of sifting through log files so I made this console app that will read and parse them to a database for you.
Database is simply:

- ID (INT) Identity,
- Checksum (NVARCHAR), Checksum of entry used to prevent duplicates
- Type (NVARCHAR), Log type (admin, debug, server, aging etc etc)
- Timestamp (DATETIME), log entry time
- Msg (NVARCHAR), Log message

First run will prompt you for database connection info, database and table names,
It will then create the tables in the chosen database.
It will also create logparser.ini which will hold those settings along with timeout and overwrite
set overwrite to "true" if you wish it to delete the files once they have been processed (it will only delete if it successfully processes the entire file.
This helps reduce run time of the task and saves storage space.
be default this is set to false.
timeout is the time in minutes between each passing, default is 5 minutes.

You must be registered to see links

I find this useful cause then logs can be audited through a web interface tool and its much quicker than trying to process over the files every time.

I hope its of use to others

 

[SheenBR]

Why didnt you edit the source code to already save as database records?

 

[Phatkone]

Why didnt you edit the source code to already save as database records?

some of us aren't using the source code :glare:

 

[SheenBR]

I see. Well, if you want to improve your knoledge, you can always create a dll to override that specific method and make it work for every server.
Nonetheless, very good initiative

 

[Phatkone]

yea when life isnt so chaotic I want to build DLL's out of the source for logging and items etc, (much the way vormav did writefield)

butttt with a kid on the way i think i wont get much time