Current User: Guest Login
Please consider registering


Lost Your Password?

Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Database compatability from Awstats monthly .txt log files converted to Excel or .xls

Reply to Post Add a New Topic
UserPost

3:08 pm
December 6, 2009


camminc

Member

posts 4

I am a little confused about the wording used on this forum. This freaks me out making it difficult for me to understand some things. I see phrases such as "Awstats to store Data Base file" or "move all the existing AWStats database files"? Are they referring to the .txt log files in the Awstats directory that are used with aws2xls to convert to Excel? Or are they talking about something else? A Data Base file is not a .txt file, such as in MS Access, so when this is said it really confuses me. A data base file in MS Access has an extension of .mdb or .mde or .accdb, etc. The same for other database programs. Otherwise, aws2xls is a very cool tool but it makes things a little difficult when one wants to convert this Excel file to a database such as MS Access, due to the multitude of sheets in the Excel file and the header names used. If the Excel file generated from the Awstats .txt log files were to have one sheet with all the data and the header names for each column different corresponding names it would be awesome to simply import the generated Excel file into a database. It takes alot of conversion to accomplish this with all the sheets and header names.

4:05 pm
December 6, 2009


Jean-Luc

Admin

posts 1125

Sorry for the wording confusion.

Although the AWStats data files are .txt files, they can be called database files. Wikipedia defines a database, as an integrated collection of logically related records or files consolidated into a common pool that provides data for one or more multiple uses .

The AWStats data files (awstats122009.your_site.txt, awstats112009.your_site.txt, awstats102009.your_site.txt,…) are not log files. In a computer system, log files are automatically generated and they contain sequential records of a service activity. It is usually timestamped. AWStats data files are very different. They are structured data files. They should not be confused with the web server log files. The web server log files are read by AWStats in order to generate its data files.

I made a note of your suggestion to include the option of generating an Excel file with just one sheet as you described. Thank you for your feedback.

Reply to Post

Reply to Topic:
Database compatability from Awstats monthly .txt log files converted to Excel or .xls

Guest Name (Required):

Guest Email (Required):

NOTE: New Posts are subject to administrator approval before being displayed

Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
2 + 3
   


About the InternetOfficer.com Forum

Forum Timezone: UTC 1

Most Users Ever Online: 302

Currently Online:
12 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 2
Forums: 9
Topics: 639
Posts: 2710

Membership:

There are 257 Members
There have been 304 Guests

There is 1 Admin
There is 1 Moderator

Top Posters:

cssfsu – 55
deepakgupta – 34
albert_newton – 30
cosminpana – 20
DTNMike – 19
ahtshun83 – 17

Recent New Members: raju, todd2taylor, sbdcunha, mansigill1987, ThomasDuh, ThomasKic

Administrators: Jean-Luc (1125 Posts)

Moderators: Jean-Luc (1125 Posts)