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...
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.
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.