cus im on the server i did a search for iuser and added one from a different server, 2 excited its pay day to think :D
synack im thinking of adding some funky java script to sort the cols would i be wasting my time or have you or some one alread done this???
I have also seporated out the code and variables into seporate files so that any upgrades can be done with a simple file copy over the top of the old one rather than having to copy over the variables. I have been holding off releasing it till I get a chance to add in the support for the new pre-concatinated logs and also support for multiple data sources so that each print server (or client pc with shared printer) can report up to one place and all of the data can be concatinated, analysed and reported upon as a single large dataset.
There are other suprises to but I have been quite bogged down at work lately and had much less time for outside projects.
hi, and thanks for this!
can you explain how i get it to show the document names?
Any updates? Just about to look into implementing this and wondered whether you had a later version before giving it a whirl.
I'd been looking for a "friendlier" way to display the PPC info, and this works great! Thanks to SYNACK and JOrdan01070 for their work and Papercut for their generosity. The installation guide was so clear that I got it right first time!
If anybody is still working on improvements, some nice teacher-friendly pie charts showing usage would be good. (Otherwise I'll have to learn how to use pivot tables)
Does anyone know how to get this setup using Server 2008? I followed the great instructions provided before for Server 2003 and it runs no problems but I cant see how to set the option in 2008 as its all different. I have created the Virtual site and dropped the files in to the folder but cant see where you now set the following permissions:
"Tick the following permissions boxes; Read, Run Scripts, Write
and Browse then click Next and Finish at the final screen."
And how you do this part in 2008 IIS:
"Select the Directory Security Tab then click the Editů button
under Authentication and access control."
"Untick the Enable anonymous access box and then tick the
Integrated Windows Authentication box. Click Ok. And then Ok
again to save the changes to the PrintUsage properties."
I'm having the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
I've been googling and it seems that when doing :
dateSQL = "SELECT Min(Time) AS MinOfTime, Max(Time) AS MaxOfTime FROM " & SummaryCSVName & ";"
The script can't read the column names....
Did any of you had this issue?
Found the problem.
The csv file (dest.csv) was being generated with (,) spearating the values and not with (;).
This prevented the ADODB object from reading the field names from dest.csv.
I added a function to convert (,) to (;) in the dest.csv file after it being generated.
I leave it here, just in case someone else needs it:
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("C:\Inetpub\Admin\dest.csv", ForReading)
strText = objFile.ReadAll
strNewText = Replace(strText, ",", ";")
Set objFile = objFSO.OpenTextFile("C:\Inetpub\Admin\dest.csv", ForWriting)
In the previous message ( ; ) became (;)
What i meant was that i replaced ( , ) with ( ; )
@ba9ag - For the moment it is not able to be run on a 64bit server as the ODBC CSV driver that it relied upon is no longer present in 64bit operating systems. It is in my long term plans to build a .net version which will be both much faster and compatible with x64 but there is no ETA as yet.
@herege - Good to hear that you got it going in your environment and thank you for posting your additions for others that may have the same issue.
@RingOfFlame - The original incarnation of the papercut software required you to manually put together all of the log files from however many months first then filter and create the pivot tables each time for each report that you did. This script automated the process letting anyone, management in particular look at it at any time without needing skills in excel or access to the original log files. Please keep any input constructive so the thread is not pushed off topic.
Good stuff the guide for 2003 was really useful, couldnt work out how to do it myself for 2008 so will look forward to your guide!
As promised, if a little delayed the 2008/R2 guide is here: