![]() “Testing date” is just my original test sheet and I left it just for testing, this can be deleted.Ĭlick on Data then under “ Get External Data” Click on “ From Text” then browse for the Awstats file and then click on Import. I have left all sheets open, the Sheet called “Headings” is used to reference the month and the headings that Awstats uses for beginning and end of its data. Open the Speadsheet and select the sheet you want use along the tabs at the bottom. The files are of the form so should be relatively easy to find the month you want. Just FTP into your site and go to your tmp folder then the Awstats folder (I am assuming cPanel is used). ![]() So to get it to work you will need to download your Awstats text files for the months you need. I still have a bit to do with it but it works and does the job. Pull the info and be able to see it similar to Awstats but be able to have it looking like I want.Īfter a fair bit of trial and error I have come up with a spreadsheet that works for me and am happy to share it free of charge for anyone that might be interested in a starting point for their own project.Be able to have multiple months to select from.My criteria was relatively straightforward: I consider myself a bit handy with Excel so applied myself to the task. Spent time looking around the web for something that will do this and could really only find one program that would do what I want but you have to pay and then have to download an update every 3 months or so to keep it working. What I wanted was to be able to import the Awstats data into MS Excel and then use the Functions and Formulas built into excel to build my graphs etc. You can highlight the data and copy paste it but that only gives you what is represented on the website and not the underlying data that builds the page. There has never been an easy way to do this. I also like to put the data into MS Excel so I can view it better. If not there may have been a step missed, and you may need to go back through these instructions.Like many others I use Awstats for checking Website statistics. As long as you see the new visits you are set and ready to go. Now you should see all the visits to this site since you created the new log file. You can force AWStats to parse the log file by clicking the “ Update Now” link at the top of the page. The log files are not processed in real time, but rather on a set schedule. You need to process the log file into AWStats. Again, replace the domain entries with your actual domain name: The visit will not initially appear in this second URL. To see this you will need to go to the separate configuration for the secondary domain. Be sure to replace the domain entries with your actual domain names: You will notice this will have the old statistics, but will not have the new visit you just made to the secondary domain. You will then need to go to the AWStats web interface. To check what was just done, go to the site you just set this up for, so there is something in the access_log. There is nothing to restart here, so double check that everything was done properly. Once these changes have been made, save and upload (if you downloaded the file). In the file you will need to look for the line listing the log files, example below: To fix this, you will need to edit the /etc/nf file. ![]() While this might not seem like a problem, it will cause the log to grow to an unmanageable size, and it will also cause AWStats to not update properly and automatically. Now, one thing to keep in mind here is that this log is not set to rotate the same way the log for your primary domain is. This will start Apache logging the statistics for the additional domains you wanted. If you are working on your account via SSH you can just use the command ‘ apachectl graceful’, without the quotes. To do this you can use the Restart Account function of the Site Manager, which will reboot the entire account. Once the file has been uploaded you will need to restart Apache. Please note that you should always backup your original system files before making changes/overwrites. If you downloaded the nf file, you will need to upload it now, overwriting the existing file. Once these changes have been made you will need to save them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |