aws2xls installation


The main features of the program, including several screen shots are presented in our main page about aws2xls, a Windows application that reads AWStats data files and converts their contents into the .xls file format used by Excel and OpenOffice.

Our program has been tested with several flavors of the popular Microsoft Windows operating systems. It is designed to be compatible with Microsoft Excel 97 and newer releases of Excel for Windows.

License terms

aws2xls and aws2xls/PRO are available from InternetOfficer SPRL. You may use these programs for the sole purpose of converting AWStats data files to files in the .xls format. You may not redistribute these programs.

These programs are distributed in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Purchase

Get your copy of aws2xls for only 14.99 euros (about US $ 16.30) ! aws2xls shows up to 1000 rows in each report, like AWStats does.

aws2xls/PRO shows up to 65000 rows in each report. It is priced at 99.00 euros. aws2xls/PRO is the best product to manage long lists of more than 1000 keywords, URL’s, referrers,…

Please read the license terms above before you order the software. If you do not agree with these terms, do not purchase or use the software.

If you agree with these terms, complete our order form.

Installation

aws2xls is extremely easy to install and use. After downloading the aws2xls.zip file to a convenient directory, uncompress the program and it will be ready to use.

Double click on the program name or icon to run it. This opens a DOS box that asks for the path to the AWStats data file that you want to export to Excel :

AWStats Excel 1

You can enter an absolute or a relative path to the selected AWStats data file.

The names of the AWStats data files are generally like this :
awstats022006.domain-name.com.txt
where 022006 shows the month and the year of the reported period and where domain-name.com is the domain name of the analyzed web site.

After you have entered the path, aws2xls will show the path to the Excel file it will create in the same directory as the AWStats data file and ask for a confirmation :

AWStats Excel 2

You have to enter “yes” or “y” to continue. aws2xls will read the AWStats data file and create the Excel file. When this is done, it will display a message confirming that the file has been created.

AWStats Excel 3

Press “Enter” to close the window.

The Excel file has been created.

Advanced Technical Details

The following limitations apply to this version :

– the number of lines of the AWStats data file may not exceed 2 000 000.

– the number of rows in a report is limited to 1000 in aws2xls and to 65000 in aws2xls/PRO. Note that all values in the AWStats data files are read and sorted, but only the 1000 (or 65000) most significant values are available in the report.

Changelog

aws2xls 0.07 and aws2xls/PRO 1.07 fix an “abnormal termination error” that occurred when a robot ID included the “[_+ ]” string.
aws2xls 0.08 and aws2xls/PRO 1.08 fix an “abnormal termination error” that occurred when the AWStats database file contained an invalid date/time field. The fix is available at no charge to users of a former release.
aws2xls 1.11 and aws2xls/PRO 1.11 support the “Downloads” section introduced in AWStats 7.0. Support of all GeoIP plugins has also been added.
aws2xls 1.12 and aws2xls/PRO 1.12: improved display of countries and regions in the “Domains/Countries” section and in the GeoIP City plugin section.
aws2xls 1.14 and aws2xls/PRO 1.14 support the modified OS and browser sections in AWStats 7.1.

Tech Support

For technical assistance, suggestions and comments, send an e-mail to
awstats@internetofficer.com

18 Responses to “aws2xls installation”

  1. CJ Allan says:

    This looks like a great and useful program!

    I downloaded it with no problem and copied it to a folder on my Desktop, and also copied a 100 line Awstats text file to the same folder.

    It appeared to run OK and said it had created an Excel file, and, indeed, it did create a file with an xls extension.

    However, Excel cannot open the file, and says that the file is corrupt.

    I’m using Win XP2 on a Dell Inspiron 8600, Excel 2003, English version, that comes with Office 2003.

    I am anxious to try it, and hope this is easily solved.

    Thanks,

    CJ

  2. Jean-Luc says:

    aws2xls does not convert the web server log files to Excel files. aws2xls converts AWStats data base files to Excel files. The AWStats data base files are generally called awstats042007.internetofficer.com.txt or something similar.

    I hope this clarifies the matter.

  3. Matt says:

    where do you find the data base files?

  4. Jean-Luc says:

    The AWStats data base files are in the data directory. The data directory is defined by the DirData tag in AWStats config file.

  5. Danny says:

    Do you need to have Excel installed on the server it is to convert rhe file? The program says it is unable to read the file. It is named awstats082007.www.rdiamondgroup.com.txt

  6. Jean-Luc says:

    Excel is not needed to convert the files.

    In most cases, this message means that aws2xls does not find the file, because the path to the file is not correct. When you only enter awstats082007.www.rdiamondgroup.com.txt, aws2xls looks for the file in its own directory.

    Please try again with the full path to the file. Example:
    d:\your_dir\subdirectory\awstats082007.www.rdiamondgroup.com.txt

  7. Danny says:

    Thanks, it worked – wasn’t paying close enough attention to the example in the instructions

  8. al says:

    I found the site from google. It looks like I’m a day late. Is there a newer eval?

  9. Jean-Luc says:

    Update done. Happy New Year !

  10. Lars says:

    Hi,

    I tried to use the aws2xls evaluation version, but it has expired on Februar 29. Can you upload a valid version?

    Thank You, Lars

  11. Jean-Luc says:

    The new evaluation version is available now.

  12. Enrico says:

    This tool is really useful.
    I wonder if there is the possibility to enter the path as a parameter from the command line…

    Question moved to our aws2xls forum: path as command line parameter.

  13. Robert Pyle says:

    Hi,

    We are very interested in this as we use AWStats for a number of our sites.

    When will the April 2009 version be available?

    Thanks,
    Bob

  14. Jean-Luc says:

    Available now ! Thank you for your interest.

  15. Robert Pyle says:

    Hi,

    Purchased the program the other day, works great. Would like to know if there is a way to call it with command line parameters, that is not in interactive mode. I have a number of reports that I want to run and would prefer to script it if possible.

    Thanks,
    Bob

  16. Jean-Luc says:

    Hi Bob,

    Good to hear that you like the program. Have a look at these threads in the forum:
       – aws2xls in batch
       – Path as command line parameter
    If you have more questions, feel free to open a new topic in the forum.

  17. aude says:

    I lost the program by changing of pc too late to download it now, what can I do now
    Thank you in advance for your help
    aude

  18. Jean-Luc says:

    Bonjour Aude,

    If you mean the eval version, the new one is now available for download. If you had a paid version, please send us an email for further help.


 

Leave a Reply

You must be logged in to post a comment.