Problem:

WebBridge does not keep statistics on click-throughs, but only on views and click-throughs. This results in files that are too big to open in Excel. A lot of reptitious work is needed so that files coming from WebBridge are small enough to work with (i.e., manipulating multiple files with small report-date spans (e.g., monthly) rather than one file with a larger report date-span (e.g., semester).

Solution:

Andrew wrote a perl script that reads large text files, counts the zeros (views) and ones (click-throughs) for each resources, and outputs the information to a text file that can be opened in Excel. Currently this script is run via a command line in /Library/intranet/tech/log_file_script/

In the future, if other people need to access the functionality in a more user-friendly environment, we might consider a php script that will be accessible via a web browser. Before proceeding in that manner we would make sure Google Analytics wouldn't fill that need.

Procedures:

• Export the web statistics file.
• Move it into My Documents/Bates Work/Websites/Tech.
• Open Dreamweaver to the tech files.
• Open the split view (remote and local).
• Drag the local text file into the log_file_script folder.
• On abacus, in /Library/intranet/tech/log_file_script, enter:
  ./tally_and_output.pl [input file name]
• The script will run and return the output file.
• Back in Dreamwearver, drag the output file into the local Site-Tech folder.
• Open the file (in My Documents/Bates Work/Websites/Tech) in Excel and save in My Documents/Bates Work/Systems/WebBridge/Statistics.
• Delete the input and output files in Dreamweaver (local and remote).