With the Domain lister and the line "analyze a month's worth of log files in one run by using "sys10*.txt" instead of "sys1001.txt","
We can run both and have daily stats as well. I can using access manually import the data into a table. (theirs some broken test in the first three line but their not likely to match any query) What I need is a way to import .txts space delimited into an access Table Automatically. Any Ideas or examples? Pete -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Scott Phelps Sent: Tuesday, November 27, 2001 11:26 AM To: [EMAIL PROTECTED] Subject: RE: [IMail Forum] LOGS What I really want is something that will run through my logs on a daily basis, and export the data contained within to some usable format within MS-SQL (or pick your DB). I generate logs that are too large for "live" stats from the log files. I've been thinking about creating something that would troll through my logs every night after the switch doing some sort of useful conversion, but right now paying customers get priority. Just think, with a usable data format in a SQL compliant DB you could make a fast easy ASP web interface that could show you everything you wanted to know. $o?`?o$o,,,,o$o?`?o$oo$o?`?o$o$o?`?o$o,,,,o$o?`?o$oo$o?`?o$o splehP ttocS rotartsinimdA smetsyS TN secivreS tenretnI renroKbeW moc.renrokbew@pttocs moc.renrokbew.www $a="@ARGV";while($a){$a=~s/(.$)//;$b=$b.$1;}print "$b\n"; $o?`?o$o,,,,o$o?`?o$oo$o?`?o$o$o?`?o$o,,,,o$o?`?o$oo$o?`?o$o -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 11:11 AM To: [EMAIL PROTECTED] Subject: RE: [IMail Forum] LOGS Scott Thats gona save some time for sure, thanks. Any Ideas on importing the info into a access data base? pete -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of R. Scott Perry Sent: Tuesday, November 27, 2001 9:15 AM To: [EMAIL PROTECTED] Subject: RE: [IMail Forum] LOGS > Also I have used the small script domainlister and a bat file > that zips >through all the logs with out having to specify each at the command line >(big time save) However after that it is still one legible .txt file for >each log and an import into excel take dreadfully long. FYI, the Domain Lister program can analyze a month's worth of log files in one run by using "sys10*.txt" instead of "sys1001.txt", for example. -Scott --- Declude: Anti-virus, Anti-spam and Anti-hijacking solutions for IMail. http://www.declude.com Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
