Papercut Print Logger Free edition - Log Distiller ASP page
Given the limited budgets in schools it can be difficult to get funds for certain things like print logging. Thankfully the people at PaperCut have for a while had a free version of their print logging software that can be aquired here:
PaperCut - Print Logger - a free print job logger for Windows.
This is quite useful to gather data but requires a lot of manual labour to convert this raw data into usable 'evidence' to justify the full product in order to keep a check on paper mad teachers and students. To make this process more easy I created a small and very rough ASP page which will take the raw monthly CSV logs and convert them into a table showing how much each user has printed to each printer for a time period that you specify.
It is a simple ASP page and just needs to be put in an IIS site on the server which houses the Papercut software. It is controlled by editing four simple constants at the top of the ASP file.
Each time the page is run it will check to see if the summary is older than the timeout in minutes and if it is it will recreate it with the updated logs from the PaperCut folder.
Const SiteFolder = "C:\Inetpub\Admin" 'Folder where the summary csv file is stored
Const PrintLogsFolder = "c:\Program Files\PaperCut Print Logger\logs\csv\monthly" 'Folder where the papercut print logger csv files are stored
Const SummaryCSVName = "dest.csv" 'name of the CSV file that will hold the concatinated logs
Const MaxSummaryCsvAge = 30 'The maximum age in minutes of the Summary file before it is recreated
When you first load the page it will create a list will all of the avalible log data and the earliest and latest dates will be shown in the filter boxes at the top. To limit the summary to the dates that you want simply enter the dates that you want into the filter boxes and click filter.
This code is rough but has been very helpful in proving a point to some of the staff and hopefully it can help others. It works best in Internet Explorer as that is the only one that allows for the rotation of the printer names to save width on the top row. CSS has been used so that it looks alright and is easy to change the appearance of it.
Latest Version: PrintUsage00_2.rar
Latest Modded Version: PrintUsage Modded
Windows 2003 Install Guide: 2003 PDF Guide
Windows 2008/R2 Install Guide: 2008/R2 PDF Guide
PrintUsage Distiller Updated and Uploaded
Added, summaries per printer per paper type and also papertype per teacher.
Originally Posted by Edu-IT
I have updated the codeing as best as I could while still retaining the lightweicht CSV database driver. I have tweaked the layout a bit to make it look better and have also added in some error handling in case you end up without any data for the period you selected. It can now also do a report on a single day as it now takes the end time as 23:59 rather that 0:00 as it was doing before. Still have not able to add the sorting feature due to the driver but I am still looking into it.
The screenshot and new downloads can be found in the first post here: EDIT Or not I can't seem to edit it, Grr, will add to this post instead and hopefully a mod or admin can give me permission to change my own post some time later.
EDIT2: Uploaded :)