CF log files into a database?

[Guest]

Just curious if this is possible... In IIS you can push the server log files into a database, which is unbelievably super helpful. What would be just as super is if CF log files (exception,application,mail, server,scheduler,etc) could do the same. Think how helpful this would be! Is this possible?

While I'm thinking about this I'm thinking of CFFile... sounds like some work but I wonder if it's doable. Or maybe there's a customtag to do it...

[Guest]

CFFILE is not meant to process large files, like log files. In CF8, use the FileNnnn() functions (FileOpen(), FileRead(), FileWrite(), FileClose(), etc.) They are extremely effieient. Read the log, format each record and write the record. Then bulk load the new file into your database.

[Guest]

Bummer. I'm still at 7.02 and no plans to upgrade in the near future.

There has to be a somewhat efficient way to get these logs into a db. Maybe not use CF at all, what about an import into MSSQL with DTS on a schedule? I've been playing around with an Access table locally and importing the application, scheduler and exception logs. The application & scheduler imports nicely but the format of the exception is horrible.

[ToBeNamedLater]

However, here's a free CFX that will give you easy access to large text files.

And here is a log file analyzer tool from MS.

Some combination of those two should get you there.

[Guest]

The Log Parser looks slick, I'll take a look thanks.