I used to be able to run a number of diferent log analyzers to decifer the log now the format changed and I can't figure out how to do it.
can someone tell me how to set analyzer or give me a hint as to what windows based program can do this.
here is a sample line of my log file
"141.203.95.58" "XY8932" "[01/Jun/2002:00:00:43 +0000]" "GET" "/usr/local/www/data/mysite.com/users/me/web/popup.php" "?f=1" "HTTP/1.1" "200" "729" "-" "Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)"
how to analyze log
Moderator: General Moderators
The main thing is to make sure the imported fields are delimited by space, not by comma.
Here's how it's done in Access 7.0 (it might be different in Access 2000):
Here's how it's done in Access 7.0 (it might be different in Access 2000):
- 1. Create a new database (or load an existing one)
2. Select the "Tables" tab (it may already be selected)
3. Click "New"
4. Select "Import Table" and press OK
5. On "Files of type," select "Text files"
6. Open the desired text file
[The "Text Import Wizard" should now come up]
7. Click "Advanced"
8. For "Field Delimiter" select {space}
9. For "Text Qualifier" select " (a quotation mark)
10. Click "OK"
11. Click "Finish"
thats nice!
Thats nice I never thought to use MS Aceess
Just a thought--
You mentioned at the beginning of your post:
I suggest that you study the original format to see what the correct format is, and then with MS Access, try to match the pattern by exporting the table.
Does that Make Sense?
You mentioned at the beginning of your post:
If you export the table from Access, you might be able to get it in the original format that the analyzer programs can recognize. You may need to alter a few settings though (such as setting the delimiter to be a "tab" character, or changing the "Text Qualifier" to something else), and then delete the headings that Access puts at the top of the exported file, if necessary.I used to be able to run a number of diferent log analyzers to decifer the log now the format changed and I can't figure out how to do it.
I suggest that you study the original format to see what the correct format is, and then with MS Access, try to match the pattern by exporting the table.
Does that Make Sense?