Query PublishWave Logs in Excel

BCranstonBCranston Moderator Posts: 34 mod
edited March 2018 in Publishwave

Hi,

You can setup an ODBC connection to your PW logs in Excel. Here are the basics steps. (I am citing Excel 2010 below...)

  1. Download and install the appropriate SQLite Driver here. http://www.ch-werner.de/sqliteodbc/
  2. In a new sheet in Excel -> Data tab -> "From Other Sources" flyout -> "From Data Connection Wizard"...select "ODBC DSN" <Next>
  3. SQLite3 Datasource <Next>
  4. Browse to the log file \\<server name>\ProgramData\Synergis\PublishWave\logs.db <OK>
  5. Select the table you want to place. Repeat on a new sheet for each table as desired.

-Brian Cranston

Tagged:

Comments

  • marksmarks Member Posts: 6

    How do we trim or reset the logs.db file?

    Deleting this file will cause the PublishWave Server to have blank columns in the Job Details window

  • jtomejtome Member Posts: 25
    @BCranston
    Brian, what do you get from the pwave logs and what do you use it for?  Just about to put pwave into active use at our organization.
  • BCranstonBCranston Moderator Posts: 34 mod
    Hi,

    I use them to diagnose any issues.  Having the logs has been helpful in finding out if it is a certain user or isolated to one file or type of file.  Note that you'll have to configure the logs to save.  I keep mine forever.  Getting them into Excel makes them far easier to work with.

    -Brian
Sign In or Register to comment.