Papercut Print Logger Free edition - Log Distiller ASP page

Quote:

---

Originally Posted by Geoff

Check your permissions. It sounds like the script doesn't have write access to the folder.

---

fixed

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???

Quote:

---

Originally Posted by gibbo_ap

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 do already have code sorted that can sort the dataset on one row but given that the dataset needs to be converted to a stream object and then back to a recordset to enable streaming it runs quite slowly. As such if your code does it dynamicly it could be a vast improvement on the solution that is currently in my beta code.

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?

tia

BoX

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."

Thanks dimast

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?

Best Regadrs

Quote:

---

Originally Posted by SYNACK

This is quite useful to gather data but requires a lot of manual labour to convert this raw data into usable 'evidence'

---

Not if you use pivot tables in Excel.

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:

Sub CommaReplace

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("C:\Inetpub\Admin\dest.csv", ForReading)

strText = objFile.ReadAll
objFile.Close
strNewText = Replace(strText, ",", ";")

Set objFile = objFSO.OpenTextFile("C:\Inetpub\Admin\dest.csv", ForWriting)
objFile.WriteLine strNewText
objFile.Close

End Sub

Thanks everybody.

In the previous message ( ; ) became (;)

What i meant was that i replaced ( , ) with ( ; )

Best regards

@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.

Quote:

---

Originally Posted by SYNACK

@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.

---

Ignore my last post on this, IIS on x64 windows server has a 32bit mode that makes this work perfectly again, I'll look to make a new install guide that covers installation on 2008 and 2008 R2 servers shortly.

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!

Thanks
Dimas

As promised, if a little delayed the 2008/R2 guide is here: