DFS Dream Task 4183
 |
John A. Bailo
heh! I do like data processing: capture, transformations, analysis, display, etc. It's what I do for a living.
Roy Culley on Thursday 04 May 2006 01:00 I imagine that the 60% re-write is intended to improve modularity. But you can't write...
I'm surprised Word took that long, though 8mb is a large text file.
rapskat After they do it by hand about 10 times, I get calls from people at my client offices requesting me to...
Are you going to have to automate this job? Post a section of the sendmail logs to cola (include the header rows if there are any), and I'll take a look and maybe can give you some pointers on automating at least parts of it with Access-VBA (if you think you need help).
There are a LOT of ways to tackle this job. The structure of the logs will dictate many decisions. If you make a copy of the logs and rename the extension to .csv or .txt or .asc, you can actually create links to the logs and read them in Access, as if you were looking at a table. Using some sample sendmail log entries I found here gave it a .csv extension, then created an Access link, like so as space-separated delimited. This may or may not work for the structure of your log files. It definitely won't be usable if your log files have multiple header rows.
But if you CAN use the data linked and split like that, you can copy-query the data to local tables in the Access db, and replace and export the cleaned data right out to text files, and ftp it or auto-generate an email.
If you can't link to the log files directly, or if the structure doesn't lend itself to linked table querying, you'll probably need to read the data in from copies of the logs.
That logreport link has this example record:
Jul 15 17:11:21 thor.foo.com sendmail22398: e6FFBLP22398: relay=jan(a)odin.foo.com 192.168.1.1
I'm sure a good perl-shell scripter could knock it out, too. Those languages are usually very efficient at text handling.
Depending on the file structure, you can import it directly into an existing table with a primary key already set, and it will eliminate dupes as it imports.
If you automate it right, the whole job - import the data, parse, replace, export, send emails - should take no more than a minute to run.
On Wed, 03 May 2006 19:18:21 -0400, DFS At least you're not beyond admitting the obvious. It's...
Keep hope alive!
Nobody who's honest can buttume OO Base is up to the standards of MS Access.
2006 21:11: I certainly don't have Office. I know how to use it, as I've used it at various employers in the past, but I certainly...