Search This Blog

Friday 8 January 2010

Create a CSV of all WatchDirectory Events


Thomas asked if it is possible to have an overview of all events (detected files) from all his tasks. The Task History Viewer only shows you information of one task, it is currently not possible to see detected file information for all tasks on one window.

WatchDirectory stores all event information (detected files) in an SQLite database. Each task has its own history database. This post shows how you can create a CSV (comma separated values) file from the history of all your tasks.

Download the Scripts

Download the example scripts and tools (~0.5MB) and extract them to C:\listEvents. Make sure the "tmp" subdirectory is also created. The scripts write temporary files to this directory.

Configure the Scripts

The download contains 2 scripts:

  • listEvents.bat
    This script extracts the latest XXX events of all tasks
  • listEventsByDate.bat
    This script extracts the events of the last XXX days of all tasks

Please inspect the first few lines of those scripts and change them to reflect where you unzipped the download and the location of WatchDirectory's task directory.

How the Scripts Work

Both scripts enumerate all config files in the task directory and write SQL statements to a temporary file to copy event information to a temporary SQLite database. Once all data is copied, it queries the new database and exports the information to a CSV file. Once complete they start Excel to open the CSV.

No comments: