Papercut Print Logger Free edition - Log Distiller ASP page

[LeMarchand]

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)

[ba9ag]

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

[herege]

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

[RingOfFlame]

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.

[herege]

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.

[herege]

In the previous message ( ; ) became (

 

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

 

Best regards

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

 

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

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

[ba9ag]

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

[SYNACK]

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

How to Guide for PrintUsage and IIS7 Setup on Windows 2008.pdf

[morlandini]

How?

On my papercut-print-logger.conf I see explaned only

IgnoredPrinters=

and

debug=

There are other configurable options?

What is the exact command syntax?

Congratulations for this excellent utility, but now feels the need of a good tutorial

[SYNACK]

How?

On my papercut-print-logger.conf I see explaned only

IgnoredPrinters=

and

debug=

There are other configurable options?

What is the exact command syntax?

Congratulations for this excellent utility, but now feels the need of a good tutorial

 

Are you trying to set it up? There are guides posted at the end of this post http://www.edugeek.net/forums/coding/29608-papercut-print-logger-free-edition-log-distiller-asp-page.html#post278959 to setup IIS on the server and to configure the page itself you edit the settings in the .ASP file that you decompress from the rar download.

 

You should not need to edit the papercut-print-logger.conf unless you are setting it up to put the log files on a different server which you need the newest version to do.

[morlandini]

I think I have wrong post ... I would respond to Papercut's message which said that you can move the csv log files to another folder.

I apologize for this.

 

Are you trying to set it up? There are guides posted at the end of this post http://www.edugeek.net/forums/coding/29608-papercut-print-logger-free-edition-log-distiller-asp-page.html#post278959 to setup IIS on the server and to configure the page itself you edit the settings in the .ASP file that you decompress from the rar download.

 

You should not need to edit the papercut-print-logger.conf unless you are setting it up to put the log files on a different server which you need the newest version to do.

[SYNACK]

I think I have wrong post ... I would respond to Papercut's message which said that you can move the csv log files to another folder.

I apologize for this.

 

Thats cool, are you using the latest version of the printlogger off the site. I the latest version should have a conf file like this:

###############################################################################
#
#    PaperCut Print Logger Configuration File ([url=http://www.papercut.com/]Software for print quota and print control management. Your print accounting and monitoring solution - PaperCut[/url])
#
###############################################################################

#
# Define a list of printers to ignore. The list is defined by a comma separated
# list of string values.  The PaperCut Print Logger system Service
# will need to be restated to pick up changes.
#   Default: none
#   Examples:  hplaserj,HP Color Laser,sci_lab,PdfPrinter
#
IgnorePrinters=
#
# CSV log files are by default written to [install-dir]/logs/csv .  This
# setting may be used to change this location.  By default, PaperCut Print
# Logger runs under the "SYSTEM" account and hence can only access local
# drives (for security reasons).  If this is set to a remote UNC path
# the PaperCut Print Logger service must be set to run under a user
# account that has rights to write to this remote directory. The target
# directory must exist.
#
#   Default:  [install-dir]/logs/csv
#   Examples: D:\logs   OR    [url="file://\\myserver\myshare\logs"]\\myserver\myshare\logs[/url]
#
CsvLogFilePath=
#
# Define if debug logging is enabled.
#   Default: off
#   Examples: on, development
#
debug=off

###############################################################################
#
# Do not modify below this line.
#
copyright=This program is Copyright (c) PaperCut Software 1999-2009. All Rights Reserved.

 

If your conf file does not look like this then you probably have an older version which did not yet have this feature included and will need to upgrade to the latest one to enable it.

[lucspe]

Hi herege,

 

Sorry to revive an old thread, but I had the exact same problem as you.

 

I've added your code and I call it right after ConcatinateLogs. Like this:

 

if ShouldRecreate( MaxSummaryCsvAge , SiteFolder & "\" & SummaryCSVName ) then CommaReplace

 

The CSV file is correctly updated with ";" as separators (I checked) but still, I get the error '80040e10' at line 132, that being now:

 

daters.Open dateSQL, strConn

 

Do you have any ideas on what it might be the cause?

 

Thanks a lot,

Luca

 

Found the problem.

 

The csv file (dest.csv) was being generated with (,) spearating the values and not with (.

 

[jonathon28]

For some reason, I am receiving the following error message. I have followed the guide for installing on Win2k8 r2.

 

HTTP Error 500.19 - Internal Server Error

The requested page cannot be accessed because the related configuration data for the page is invalid.

 

Any help appreciated.

 

Thanks.

[PaperCut]

For some reason, I am receiving the following error message. I have followed the guide for installing on Win2k8 r2.

 

HTTP Error 500.19 - Internal Server Error

The requested page cannot be accessed because the related configuration data for the page is invalid.

 

SYNACK is probably in the best position to advise here as it's an ASP/IIS related error. I've seen this before when the file permissions were not set correctly. Check the perms on the web files as a first step. Maybe open it up a little and see if it helps. This MS KB article covers a few other suggestions.

 

On a related note there is now a new release of the free PaperCut print logger. The main change is the cosmetic appearance (new look and feel). The work was done by the summer intern at PaperCut (yes it's summer down under!). Functionally it's the same and I've made sure that he did not change any of the printing history CSV file formats so SYNACK's scripts will still work.

 

Cheers,

 

Chris

Developer@PaperCut

[minature_hero]

For some reason, I am receiving the following error message. I have followed the guide for installing on Win2k8 r2.

 

HTTP Error 500.19 - Internal Server Error

The requested page cannot be accessed because the related configuration data for the page is invalid.

 

Any help appreciated.

 

Thanks.

I'm getting the same error on a RM CC4.5 server install (0x800700c1 - HTTP Error 500.19 - Internal Server Error). I've followed the instructions for installing on 3 vanilla servers at other schools (all working ok) but this one school has RM and I think some other web software installed that the RM software uses is intefering with things. When I google search it's something to do with the bitness (32 or 64) even though I've set it to 32bit in the app pool that is part of the instructions. Any ideas gratefully received. I've set it up in the default website on the RM server, so not in the RM site that is available in IIS.