+ Post New Thread
Page 4 of 5 FirstFirst 12345 LastLast
Results 46 to 60 of 67
Coding Thread, Papercut Print Logger Free edition - Log Distiller ASP page in Coding and Web Development; Originally Posted by Geoff Check your permissions. It sounds like the script doesn't have write access to the folder. fixed ...
  1. #46
    gibbo_ap's Avatar
    Join Date
    Nov 2007
    Location
    Staffs, UK
    Posts
    937
    Thank Post
    233
    Thanked 81 Times in 64 Posts
    Rep Power
    36
    Quote Originally Posted by Geoff View Post
    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

  2. #47
    gibbo_ap's Avatar
    Join Date
    Nov 2007
    Location
    Staffs, UK
    Posts
    937
    Thank Post
    233
    Thanked 81 Times in 64 Posts
    Rep Power
    36
    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???

  3. #48

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,034
    Thank Post
    852
    Thanked 2,662 Times in 2,260 Posts
    Blog Entries
    9
    Rep Power
    766
    Quote Originally Posted by gibbo_ap View Post
    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.

  4. #49
    box_l's Avatar
    Join Date
    May 2007
    Location
    Herefordshire
    Posts
    427
    Thank Post
    68
    Thanked 90 Times in 75 Posts
    Rep Power
    61
    hi, and thanks for this!

    can you explain how i get it to show the document names?

    tia

    BoX

  5. #50

    Join Date
    Oct 2007
    Location
    Cambridgeshire, UK
    Posts
    306
    Thank Post
    58
    Thanked 23 Times in 20 Posts
    Rep Power
    17
    Any updates? Just about to look into implementing this and wondered whether you had a later version before giving it a whirl.

  6. #51

    LeMarchand's Avatar
    Join Date
    Jan 2008
    Location
    The deepest pits of hell
    Posts
    2,162
    Thank Post
    301
    Thanked 331 Times in 235 Posts
    Rep Power
    141
    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)

  7. #52

    Join Date
    May 2009
    Posts
    103
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    11
    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

  8. #53

    Join Date
    Mar 2010
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Error

    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

  9. #54
    RingOfFlame's Avatar
    Join Date
    Nov 2009
    Posts
    192
    Thank Post
    101
    Thanked 69 Times in 42 Posts
    Rep Power
    36
    Quote Originally Posted by SYNACK View Post
    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.

  10. #55

    Join Date
    Mar 2010
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

    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.

  11. #56

    Join Date
    Mar 2010
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

    In the previous message ( ; ) became (

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

    Best regards

  12. #57

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,034
    Thank Post
    852
    Thanked 2,662 Times in 2,260 Posts
    Blog Entries
    9
    Rep Power
    766
    @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.

  13. #58

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,034
    Thank Post
    852
    Thanked 2,662 Times in 2,260 Posts
    Blog Entries
    9
    Rep Power
    766
    Quote Originally Posted by SYNACK View Post
    @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.

  14. 2 Thanks to SYNACK:

    ba9ag (27th April 2010), Gonk (20th April 2010)

  15. #59

    Join Date
    May 2009
    Posts
    103
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    11
    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

  16. #60

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,034
    Thank Post
    852
    Thanked 2,662 Times in 2,260 Posts
    Blog Entries
    9
    Rep Power
    766
    As promised, if a little delayed the 2008/R2 guide is here:

SHARE:
+ Post New Thread
Page 4 of 5 FirstFirst 12345 LastLast

Similar Threads

  1. Papercut Print Logging Software
    By Mr_M_Cox in forum Network and Classroom Management
    Replies: 4
    Last Post: 7th April 2011, 11:33 AM
  2. ASP.NET in event log
    By kerrymoralee9280 in forum Windows
    Replies: 4
    Last Post: 6th May 2008, 12:49 PM
  3. Papercut Logger, any horror stories.
    By K.C.Leblanc in forum Network and Classroom Management
    Replies: 7
    Last Post: 19th March 2008, 05:53 PM
  4. Papercut print monitoring.
    By maniac in forum How do you do....it?
    Replies: 1
    Last Post: 9th March 2007, 01:52 PM
  5. Query Active Directory through asp page
    By KarlGoddard in forum Web Development
    Replies: 19
    Last Post: 22nd February 2006, 12:15 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •