Version History

Changes In CaseDetective 1.3.4

Released 2007-12-13

• Bug Fix: Error while creating indexs on the Attachment, Cases or CaseEvents table.
• In some rare cases CaseDetective could not create indexes on it's cache database due to non-unique data in a primary key, this has now been fixed.
• Bug Fix: The previous change (1.3.3) for the above bug fix introduced some database incompatibilities.
• In order to fix the problem across all supported database types, CaseDetective now requires MySQL 5.0+ as opposed to MySQL 4.0+. MS Access and SQL Server 2000+ are still supported as usual.
• Bug Fix: Mac OS X 10.5 (Leopard) compatibility.
• Updated tools and some third party libraries for better Mac OS X 10.5 (Leopard) compatibility.
• Bug Fix: Support FogBugz 6.0 for non-administrators.
• CaseDetective now supports changes made to the FogBugz 6.0 database schema for permissions, non-administrators can now see their cases!
• Bug Fix: Improved permissions adherence.
• Some changes were made to better support permissions, summary filters now correctly miss projects etc that a user does not have permission to see in FogBugz (4, 5 & 6).

PLEASE NOTE: This does not mean CaseDetective fully supports FogBugz 6.0, it just means you may be able to use the "classic" filters in FogBugz 6.0 with CaseDetective 1.3.x, you will not be able to use the new search based filters introduced with FogBugz 6.0. Full support for FogBugz 6.0 and it's new search based filters will arrive in CaseDetective 2.0 and CaseDetective On Demand by early 2008.

Changes In CaseDetective 1.3.3

Released 2007-12-07

• Bug Fix: Error while creating indexs on the Attachment, Cases or CaseEvents table.
• In some rare cases CaseDetective could not create indexes on it's cache database due to non-unique data in a primary key, this has now been fixed.

Changes In CaseDetective 1.3.2

Released 2007-10-18

• Bug Fix: NilObjectException when selecting different field to graph.
• In some rare cases selecting the Release or Priority column could cause a NilObjectException, this has now been fixed.
• Bug Fix: Support for new FogBugz 6.0 password format.
• When a new user is created in FogBugz 6.0 or a password is changed a new format is used to encrypt and store the password. This new format is now supported.
  
  PLEASE NOTE: This does not mean CaseDetective fully supports FogBugz 6.0, it just means you may be able to use the "classic" filters in FogBugz 6.0 with CaseDetective 1.3.x, but unfortunately due to database changes in FogBugz 6 most users are unlikely to be able to use CaseDetective 1.3.x. Full support for FogBugz 6.0 and it's new search based filters will arrive in CaseDetective 2.0 and CaseDetective On Demand by early 2008.

Changes In CaseDetective 1.3.1

Released 2007-05-08

• 6178: Save As dialog not showing after options window when creating extract or PDF report.
• The default file name suggested by CaseDetective now replaces anything not alpha-numeric or a space with a hyphen.
• 6575: Connect to MS Access databases in read only mode.
• All ODBC connections are now explicitly read-only to stop possible locking problems with FogBugz.

Changes In CaseDetective 1.3.0

Released 2007-02-21

• 3426: Better offline usage.
• CaseDetective now uses local data on startup without needing to refresh data from the main FogBugz database.
  Automatic refresh of data from the main FogBugz database on startup can now be turned off from the Startup tab of the Preferences window.
• 3762: Refresh progress display improvements.
• Full and normal refreshes now use a modal dialog to show refresh progress rather than using the entire main window which some users found disconcerting.
• 3872: Multipart/mime encoded email support.
• Multipart/mime encoded email now supported for preview, PDF export and printing.
• 5633: Custom field filter improvements.
• Now ensures a wild-card is used on the Custom Fields (Computer/Version) whether specified in the filter or not.
  This ensures filters work in the same way regardless of the FogBugz database type.
• 5638: Mac OS X Universal Binary.
• Now a Universal Binary to run natively on PowerPC and Intel Macs.
• 6022: KeyNotFoundException in GetSettings error.
• Fixed very rare "KeyNotFoundException in GetSettings" error.
• 6060: Smoother scrolling of preview pane.
• The preview pane now scrolls much more smoothly.
• 6061: Preview pane on Mac version blanking out (to grey) on startup.
• The Mac version would occasionally show a blank preview pane on startup, this has been fixed.

Changes In CaseDetective 1.2.0

Released 2006-09-28

• 4994: Dual to single monitor problems.
• If CaseDetective is closed while on a second monitor, and then opened when there is now only one monitor, the main window will re-position onto the main window with a default size (or maximized if that was the last state).
• 5025: Can not copy graph to (MS Office) clipboard if text already on it.
• The graph and preview panes now properly copy to the clipboard even when MS Office has text on the clipboard already.
• 5027: Error when preview pane too large to fit in memory.
• The preview pane will be blank if the case has too much detail to be displayed in available memory.

Changes In CaseDetective 1.2.0 (RC2)

Released 2006-09-18

• 4869: PDF options window has confusing title of "Print Options".
• PDF Options window now has correct title.
• 4952: eSellerateEngine.dll causing crash.
• Updated eSellerate library to latest version.

Changes In CaseDetective 1.2.0 (RC1)

Released 2006-09-12

• 23: Print cases.
• It is now possible to print the current list of cases, or just the current case (right click preview and select from menu).
• 4106: Crash when trying to save extract file with same name as file opened in another application.
• Errors when trying to write to the extract file will result in a message being shown.
• 4191: Data not returned from FixFor table (no cases visible)
• Fixed bug brought on by MySQL 5 making "Release" a reserved keyword.
• 4192: Initial sync taking very long time.
• Notes, emails and attachments are now synchronized to the local cache in the background rather than during the initial sync. This allows a much faster initial sync without sacrificing the benefit of having the case notes, emails and attachments eventually available for view.
• 4229: File Save As window not displaying on extract from some filter views.
• The File Save As window is now displayed correctly.
• 4329: MS SQL Server and MS Access connections without ODBC DSN on Windows
• There is now no need to create an ODBC Data Source Name (DSN) in Windows for MS SQL Server or MS Access databases.
• 4330: Support direct connections to MySQL 4.1+
• CaseDetective can now connect to MySQL versions 4.0.x, 4.1.x and 5.x directly (no need for ODBC).
• 4332: Filters using search criteria in custom fields fixed.
• Filters that use the "*" wild-card character in the custom fields (default names Version and Computer) now work properly in CaseDetective.
• 4731: PCT images not displayed in preview pane.
• PCT suffixed images are now properly displayed in the preview pane.
• 4800: Save to PDF.
• It is now possible to save the current list of cases to PDF, or just the current case (right click preview and select from menu).
• 4813: Check For Update and Buy functions just opening website (Mac OS X).
• Mac OS X eSellerate resources properly re-integrated.

Changes In CaseDetective 1.1.3

Released 2006-06-07

• Case 3940: Crash when UNKNOWN column specified in View Options.
• Crash fixed when an UNKNOWN column is specified in a Filter's View Options.
  UNKNOWN columns are an artifact of a problem in CaseDetective 1.0 and should disappear once view options adjusted once more.

Changes In CaseDetective 1.1.2

Released 2006-06-06

• Case 3929: Attachments need to be synchronized before Bugs and BugEvents.
• Attachments are now sync'd before Bugs and BugEvents for referential consistency (broken in 1.1.1).

Changes In CaseDetective 1.1.1

Released 2006-06-06

• 3914: Database connection problems ("Dialog Failed" error message).
• The database connection problems that some users were experiencing should now be fixed.
• 3919: Double spaced lines in Preview Pane Release Notes.
• Preview Pane now displays Release Notes properly.

Changes In CaseDetective 1.1

Released 2006-05-31

• 3763: Preview Pane: Copy
• You can copy the Preview Pane to the clipboard as an image by right clicking on it and picking "Copy" from the popup menu.
• 3773: Mouse scroll not working on Preview Pane.
• Mouse scroll wheel now works properly after clicking on the toolbar.
• 3774: Graph: Save As...
• You can save the graph as an image file by right clicking on it and picking "Save As..." from the popup menu.
• 3778: Mouse scroll not fast enough on Preview Pane.
• Mouse scroll wheel now works at same speed on Preview Pane and it's scrollbar.
• 3780: Preview Pane: Save As...
• You can save the Preview Pane as an image file by right clicking on it and picking "Save As..." from the popup menu.
• 3781: Graph: Copy
• You can copy the graph to the clipboard as an image by right clicking on it and picking "Copy" from the popup menu.
• 3817: "Save as type" field not being set in extract file Save As dialogue.
• Save as type now set properly.
• 3819: Status text not showing correct number of cases by category.
• The status text at the bottom of the window was not showing correct counts for each category, now fixed.
• 3861: Case events re-instated in Preview Pane on Windows.
• A recent fix in the REALbasic ODBC component has allowed re-instating of the viewing of case comments and emails in the Preview Pane.
  
  This reverses the removal of notes from CaseDetective on Windows in Case 3761.

Changes In CaseDetective 1.1b2 (private beta)

Released 2006-05-16

• 3753: Non-email comments and case event headers have double spaced lines.
• Extra (dos/windows) line endings removed to stop extra blank lines from appearing in case event header descriptions and non-email comments.
• 3754: User enabled logging to file to help debug performance and other problems.
• User can now use "Start writing to Debug Log" Help menu option to enable logging to a CaseDetective.log file on the desktop.
  Please use sparingly as performance will be impacted when used.
• 3760: Refresh status text flickering.
• The status text flickered with a blank window background showing through between status changes, this does not happen anymore.
• 3761: Crash on Windows when syncing bug events.
• Due to a problem with REALbasic retrieving ntext fields from MS SQL Server, no notes will be available in the preview pane on Windows.
  No workaround could be found, when the REALbasic ODBC plugin is fixed, notes will be made available again in the preview pane.

Changes In CaseDetective 1.1b1 (private beta)

Released 2006-05-05

• 1877: Faster update of filter list.
• Summary and FogBugz filters are now created quicker.
• 3727: New and updated columns.
• The following new columns have been added:
  Priority Name: Must Fix,Fix If Time (or whatever you've set in FogBugz for each priority).
  Priority ID: Unique Priority number.
  Project Owner: Project's default user.
  Release Name: Release name without date as shown in FogBugz.
  Opened To Resolved (grouped): Weeks, days and hours between case being opened and resolved grouped by hours, days or weeks.
  Opened To Resolved (Working): Working days and hours between case being opened and resolved.
  Opened To Resolved (Working) - Hrs: Working hours between case being opened and resolved.
  Resolved To Closed (Grouped): Weeks, days and hours between case being resolved and closed grouped by hours, days and weeks.
  Resolved To Closed (Working): Working days and hours between case being resolved and closed.
  Resolved To Closed (Working) - Hrs: Working hours between case being resolved and closed.
  Opened To Closed (Grouped): Weeks, days and hours between case being opened and closed grouped by hours, days and weeks.
  Opened To Closed (Working): Working days and hours between case being opened and closed.
  Opened To Closed (Working) - Hrs: Working hours between case being opened and closed.
  
  The following column has been renamed:
  Re-Occurrences (was Occurrences): Number of times a bug has been re-submitted via bugzScout.
• 3341: FB5: Multiple attachments per case event.
• CaseDetective supports the new multiple attachments per edit feature of FogBugz 5.
• 911: Graphs and Charts in Overview panel.
• CaseDetective for FogBugz now has Graphs and Charts available in the new Overview panel.
  You can graph the following fields by Volume, Date Opened, Date Resolved, Date Closed and Date Last Updated:
  Category
  Project
  Area
  Release
  Priority
  Priority Name
  Status
  Open?
  Project Owner
  Re-Occurrences
  Customer Type
  Client
  Department
  Computer (or whatever renamed to)
  Version (or whatever renamed to)
  Correspondent
  Assigned To
  Last Updated By
  Opened By
  Resolved By
  Closed By
  Opened To Resolved (Grouped)
  Resolved To Closed (Grouped)
  Opened To Closed (Grouped)
  
  The Volume graphs are in the form of a bar graph, the date based graphs are of a line graph form.
• 1843: Overview panel.
• Overview panel displays graphs and recent activity for currently selected filter.
• 3333: Better crash reporting.
• More information is now sent to our bug reporting system when a crash occurs and the report is submitted, including a stack trace and environment information to help with debugging.
  The user can now see the error report about to be submitted too.
• 456: Preview Pane.
• Added simple preview pane that shows basic Case details similar to FogBugz, with Case events such as changes, comments and emails below. Case events can be displayed ordered by newest first or last.
  Pictures with extensions bmp, gif, jpeg, jpg, pict, png, tiff and tif as embedded email attachments or Case attachments are scaled down and shown in preview pane.
• 1878: Advanced tab of Preferences renamed to Startup.
• The Advanced tab of the Preferences window has been renamed to "Startup" as all settings on that tab are related to startup rather than being advanced in nature.
• 2465: Open cases by Area summary filter.
• Added "Open cases by Area" summary filter that shows all open cases by each unique Area name.
  The user may optionally drill down to each project/area combination as well.
• 312: Add Icons & Text, Icons Only and Text Only toolbar options to View menu.
• Added "Icons and text", "Small icons and text", "Icons", "Small icons" and "Text only" options to View menu.
• 1943: Only need one click to turn on reverse sort in view options.
• Clicking the Rev check box on a sort column will auto-select the associated Use check box as well, rather than needing the Use check box to be selected first.
• 3047: Remove unnecessary "Open cases by" on sub folders of main "Open cases by ..." filter folder.
• Removed unnecessary "Open cases by" on sub folders of main "Open cases by ..." filter folder.
  This reduces clutter in the Filters list.
• 3425: Last refreshed date.
• The date and time of the last refresh is shown below the filters list.
• 3424: Prompt for Full Refresh after Preferences saved.
• After saving the Preferences a prompt is shown to ask whether a Full Refresh, normal Refresh (recommended) or no refresh is required.
• 519: MS Access database Support.
• CaseDetective now supports MS Access databases through the standard Microsoft Windows ODBC driver or ActualTechnologies Mac ODBC driver.
• 1918: Add quotes to multi line fields in tab delimited extract.
• Excel still doesn't like multi line fields from tab delimited format (even it's own files), so it's best to use CSV for Release Notes etc.
• 1749: Working interval time improvements.
• Working time intervals are now calculated using the Working Schedule and Holidays entered into FogBugz. Working time intervals are no longer a simple (but confusing) ratio.
• 3728: Most columns can now be included in multi-column sort (View Options).
• All but the "Working" interval based columns can now be included in a multi-sort as specified in View Options.
  All fields can be sorted by when clicking a column heading.
• 3699: Work around potential date differences between FogBugz's Bug.dtResolved and Bug.dtClosed with BugEvent.dt
• Sometimes FogBugz does not set the exact same date and time on the Bug and BugEvent records during a resolve or close, so worked around this for when determining the last resolve or closed event.
• 3734: Preferences window hidden behind main window when opened on startup.
• In some cases the Preferences window was hidden behind the main window on startup and needing initial preferences set, the Preferences window is now brought to the front when opened.
• 1944: Version and Computer alternate names load properly at startup if available and other visible columns related fixes.
• If the initial filter on view had the Version or Computer columns visible but with different names, sometimes they were not recognized properly. This is now fixed.
  Also, when moving from one filter to another the default columns widths were not always correctly set if the filter had not ever been used before. This is now fixed.
• 1919: Show "Refresh" status after changing view options.
• The main window now displays a "Refreshing..." message and progress bar after View Options saved rather than looking as though nothing is happening.
• 1922: Use 2 decimal places for "Hrs" columns.
• Some of the "Hrs" fields were using the wrong format, now corrected to use 2 decimal places.

Changes In CaseDetective 1.0.1

Released 2005-11-24

• 1443: Update User Guide
• Minor updates to User Guide applied.
• 1444: Database and FogBugz fields not properly defined in Connection tab of Preferences.
• The Database and FogBugz specific fields in the connection tab of the Preferences window are now within their own labeled group boxes.
• 1454: Automatic check for update should fail quietly if no internet connection.
• Any errors in connecting to the internet are ignored during check for an update.
• 1367: Case list supports maximum of 63 visible columns but user can select more.
• All column selection list boxes now enforce 63 column limit.

Changes In CaseDetective 1.0

Released 2005-11-16

• 1032: Reset trial period to 30 days and usage back to zero for 1.0 release.
• All users get another 30 days of usage before trial runs out now that beta period is over.
• 1043: Save report options for each filter view and report type.
• Each time report options are set when creating a report they will be saved against the current filter and report type.
  The default report options are now to include headers, but exclude the pivot table count and date in file name options.
• 935: Improve help docs.
• Help docs are now in native "Compiled Microsoft HTML Help" and "Apple Help Doc" formats on Windows and Mac OS X respectively.
  Some content improvements and updates for v1.0.
• 950: Disable "Buy CaseDetective..." menu option when license is valid.
• "Buy CaseDetective..." menu option properly disabled when license already applied.
• 230: FB4SP1: Use custom field names from database.
• FB4SP1: Now using custom field names (a.k.a Version & Computer) as set in FogBugz server.
• 940: Orig Est, Curr Est, Elapsed and Remaining Hrs fields.
• Added unformatted "Hours" equivalent column for each interval based column.
• 1033: FB4SP1: Use new passwords setting from database.
• FB4SP1: Now picking up whether password is required from setting in FogBugz server.
  Only applies to basic authentication.
• 941: Time until Release field.
• Added Time Until Release column.
• 980: Add auto-update feature to check on launch for new versions.
• Automatic check for new version on first run of day, can be switched off from preferences.
• 1315: Move rarely used Preferences toolbar button to right hand side.
• Moved the Preferences toolbar button to the far right of toolbar to reduce confusion with often used buttons on left.
• 1156: Add option to show/not show splash window at startup
• Registered users can turn off the startup splash window.
• 1323: Display reason for not being able to save preferences
• Nice little message at the bottom of the window when preferences can not be saved due to missing or incorrectly format entries.
• 1322: Merge FogBugz and Database tabs in Preferences window
• FogBugz user details moved into "Connection" tab of preferences window.
• 1168: 'Save' Button not enabled
• When the database type is changed in the Preferences window and the required fields are all filled, Save button is now enabled rather than requiring a change in one of the fields first.
• 1264: Table names are case sensitive on Linux MySQL servers
• Made sure table names are used with the same capitalization that fogbugz uses.
• 1070: 0.5 Hrs showing as 0 Hrs.
• Fixed problem where hours fields from database were being interpreted as integers rather than decimals when retrieved.
• 1318: View Options and Report toolbar buttons being disabled incorrectly.
• View Options and Report buttons now re-enabled after a restore in a timely manner.
• 1351: Ensure Open Cases summaries don't include SPAM cases
• Cases already marked as SPAM (area type 3) are not used in determining Open Cases summaries filters.
• 817: Remember window size and position (Remember Maximize)
• Now remembers whether main window was maximized or not when last used on Windows and opens up in same state.
  Also remembers when window moved rather than just when resized.

Changes In CaseDetective Beta 3 (v0.9.3)

Released 2005-09-11

• Improved FogBugz login authentication to give better error descriptions when no match found.
• User interface is much more responsive while retrieving data from database.
• Added preliminary help system.
• Numerous small fixes and cosmetic changes.

Changes In CaseDetective Beta 2 (v0.9.2)

Released 2005-08-23

• FogBugz Login Authentication now performed via database only, no web logon required.
• Much more robust database access code with better error handling and problem descriptions.
• Added "View Options" toolbar button for quick access.
• Alternating colours in list boxes improves readability.
• Numerous small fixes and cosmetic changes.

CaseDetective Beta 1 (v0.9.1)

Released 2005-07-24

• Initial Release