============================================= B U G G I T R E A D M E ============================================= VER 2.20, BLD 4 - BUG FIX LIST ------------------------------ - Fixed email bug report. Was referencing wrong report name after I changed the report naming convention. - Changed BUG_UpgradePatch.mdb to use separate subroutines for each new release's SQL Update code. Eventually would have hit size limit for lines in a module, so broke down. VER 2.20, BLD 3a - BUG FIX LIST ------------------------------ - Added new summary report with estimated time to fix listed. - Fixed Usage Report to use MAX() and not LAST() function. Situations arise where the LAST() function does not work. - Report Wizard buttons "Cancel" and "Finish" were renamed to "Close" and "Run Report". - Fixed significant bug found by many users where reports not run because temp query built as data source for report had incorrect name (TCM's name instead of Buggit's after pulled code over). VER 2.20, BLD 2 - BUG FIX LIST ------------------------------ - Fixed bug where could not log on to database. Turns out I accidentally swapped in wrong field name at last minute, and used the value of Admin for LoginID and for EmailName, so bug did not show up in my tests. VER 2.20, BLD 1 - BUG FIX LIST ------------------------------ - Date constraints at filters sucked. You were forced to pick specific or literal dates that you then had to change every time you ran a report week after week. The new date constraints start off at the top of the drop down with Now(), Now() - 7 days, and so on to give you the ability to build filters that will not change because the date parameter is built in (no longer have to use a literal, unless you want too). - Bugs now support attachments. You can put attachments into an attachments directory under the database directory on your server. If you do not, and you have sufficient priveleges, Buggit will create the folder automatically when you first assign an attachment. Attachments can be anything from JPGs to BMPs to Word DOCs and XLS files. Be conscientious though about not saving every single error as a bitmap lest you run out of drive space. - Now there are 7 UDC (User Defined Controls) drop down / text box fields to use instead of just three. - New report based on Bug List Detailed also shows all of the user defined text and flag field data. - Renamed several of the reports for better clarity. - Reports now sort better, specifically summary bug list now sorts first by location, and second by Bug ID. - Event log is now text file, not table in DB. - Help file now in its own directory, not cluttering the main app directory. - Added View Source Code button for those who do not already know the close windows, F11 to show database trick. - Edited control tip text on controls of main form. - Moved tbl_Reports from linked table in BUG_Data.mdb to local table in BUG_App.mdb. Also changed name to REF_Reports. - At Wizard form, Tab key now cycles just in the fields, not through pages on the forms. - Thanks to Lynn Hogarth for suggesting that when you are viewing the features tab, new bugs be defaulted to feature, and vice versa with the bugs tab. - Thanks to Alan Simkins for finding bug that now fixed where toggling between grid and form view would lose your record position and reset to record (bug) #1 at the top of the list. - Thanks to Alan Simkins for finding and pointing out a large design bug. If you enter several bugs, then assign to a person, then delete that person in the Edit Persons dialog, all the bugs are gone. This is due to a cascading delete relationship between the Bug table and the REF_Person table. Rather than altering the relationship, my fix was to put a blaring message on the Edit Person dialog telling users not to delete persons. - Thanks to Richard Cook for pointing out that the BUG_Loader.mdb fails on NT because the MS-Access path is not wrapped in quotes. - A user requested ability to easily copy bug data to different bug tracking systems and test case management software. Fix was a new button (Copy Bug to Notepad) that does as its name suggests. Only resides in the Bug Details window, and not the gridsheet view. - Chuck Roberts requested an add and delete button on the Bug Details form - now added. Also added a new bug button too. - Chuck Roberts suggested that when a new bug is opened, the focus (cursor) should jump to the title field - good suggestion, now implemented. - Altered behavior at Change of Status field so no longer changed Assigned To to Closed. Leaves assigned to last person to whom assigned (typ. the tester who regresses the bug). - Ensure all forms have Data -> Record Locking property set to "No Locking" to avoid contention at 4-5 concurrent users. Now, problems are rare. - Fixed endless error loop when not connected to a database. It was some modal or popup property setting or something like that (shoot, shoulda written it down). - If you login as someone not yet added to table REF_Person, bug used to throw you out of app, now returns you more gracefully to login form again. - Fixed New Project Cancel bug (used to crash if user hit Cancel when asked for first run of app). - Fixed longstanding design error where get error 71 Disk Not found when PropertiesLookup cannot find specified file. - Removed all If Is Nothing and just issue a Set = nothing. VER 2.10, BLD 1 - BUG FIX LIST ------------------------------ - Removed bug where Print or Email report would fatally error out. Turns out that "Docmd.Close acForm, Me.Name" was erroneous because form Me was not what app assumed. Also, fix to different bug below removed this line of code altogether. - All wizards now no longer have Min/Max buttons. They were not resizable as it was, just forgot to remove those buttons earlier. - Report Wizard now remains active and visible after every report. - User can print preview a report, maximize the preview window, then upon closing the preview window, the report wizard will snap to its standard size (not remain maximized as per Access 'bug' where maximize one MDI child and maximize them all.) VER 2.09, BLD 2 - NEW FEATURES / BUG FIX LIST --------------------------------------------- - Added back in check for no Locations / users in respective REF tables. Now, when first run Buggit, user is warned to enter data in these forms, and the forms are loaded up. - Setup now uses icon at desktop and shortcuts menu. - At bug entry form, now if form is dirty (data has been changed but not saved), user is prompted to confirm that when s/he presses escape, they really do intend to undo the changes they entered in. Good request from Toly K. - Jan K. found bug when click "Save Event Log" button at Event Log form. Fix was to save error log with same path and filename as current app mdb, just replace the extension with .err. VER 2.09, BLD 1 - NEW FEATURES / BUG FIX LIST --------------------------------------------- - Changed around the way filter buttons work. Now, the Mine, Deferred, and Change Order buttons can be selected in conjunction with the Open, Resolved, Closed buttons. The Mine/Deferred/Change Order buttons are all AND'd together, meaning that for a bug to be displayed, these criteria must be met. The Open/Resolved/Closed buttons are OR'd together meaning that bugs can match one of the criteria, but does not have to match all. - Fixed bug in filter buttons on main screen so that Open will list 'Open' and 'Reopen' status bugs. Reopen was a new value in a recent release, but neglected to give filter option. - Fixed standard filters so any filter containing 'Open' also contains 'Reopen'. Fixed one filter that did not properly contain a Status filter for all non-closed bugs (was returning Sev.1 and Sev.2 for every bug, but should have been non-closed bugs). - Added filter name to reports right above Where criteria. Thanks for suggestion MFrancen. - Did standard upgrade stuff: new help file, upgrade patch, bumped version number, etc. - Fixed website url to point to new website at http://www.pb-sys.com/. Fixed all email references to point to mailto:buggit@pb-sys.com. - Fixed copyright to 1999,2000. - Prevent minimize on main form. Else bug blew up app because resize values were wrong. - Main main form start at 0,0 in case user last left screen maximized so will fit when restart. VER 2.08, BLD 1 - NEW FEATURES / BUG FIX LIST --------------------------------------------- - Major new feature is that the bug entry grid/form is now resizable. Just drag the border to re-size to suit your needs. - Removed the old Switchboard form. Now all operations occur from the Bug Entry form and a new menu with some additional toolbar buttons. - Fixed small bug where non-admin users could still click the Edit Reference table buttons from the bug entry form. Now, must be an admin user to change the reference tables. Same applies for the menu bar items. However, still have not put code in the form unload, project startup parameters, etc. to lock users out...users can still get at the tables and source code easily (by design). - Default logon and password is now Admin (I used to be lazy and just left my matpie login in place...now I will try to remember to change that every build). - Revised the Help file (it was getting out-dated). - MDI subform for Bug Entry now has a caption which indicates the path to the database project file to which it is pointing. - Heh, heh: added comment to Help->About form something to the effect of "even though this is freeware, if you really like it send $ here...". - Fixed bug where Buggit was 'crashing' when first load up...was due to me flipping a PopUp property so that the form covered the form below which user needed to respond to (Open Project / New Project / Cancel). - Changed all forms to thin border instead of dialog (looks better). Exception is Bug Entry form which is re-sizable. - Project Summary Report, Weekly Bugs Found graph now is no longer limited to nine weeks. It is also no longer a bar chart, but an XY (line) plot. - Added New Project, and Open Project buttons to toolbar. Really quick and easy to administer project databases now (if you are an admin user...else disabled). - Fixed close button. Had not noticed that I was using a big ugly icon that was clipped off. Now icon fits on button. - Fixed page footer on Usage Report. Now has standard footer text. VER 2.07, BLD 1 - BUG FIX LIST ------------------------------ - Bug on Windows NT4 machines where BUG_Loader.mdb would not properly load the BUG_App.mdb file. Turned out needed to wrap the path in quotes before shelling out and executing it. Same bug in Buggit app too. Special thanks to Mike Whittaker for finding this bug and sending me the fix. - Modified "REF_Status" and "REG_Severity" tables on BUG_Data.mdb template file only (impact future projects not current projects). The change = addition of new status = "Reopen" and new severity codes "5: Watch - Unable to reproduce the error" and "6: Nice to Have - Feature". User in the field (Tadd) suggested this change and I liked it. - Added combo box lookup at Project Database selection. New table "tbl_ProjectDatabasePath" remembers every *new* BUG_Data.mdb database that you pick. This makes it much easier to click and change project databases rather than using the [...] button to go search all over your network for different projects (by the way, I recommend getting a file server and placing all of your multiple bug databases in a central BUGGIT folder with project data folders off of that...also make the file server into a Tool Server with testing scripts, docs, freeware/shareware, etc. loaded there for easy access). - Added new report "Archived Bug List Summary Report" which does not use filters in the Wizard, but does list all bugs that have been archived. Report came from user (Tadd). - Added new report "Version Notes" which lists bug titles, grouped by Version Number (see new feature below). If user sets Version Number when closing bugs, then this report gives a nice list of bugs closed per build. Thanks Tadd. - Changed usage on Version/Build Number field so that (as before) initial bug entry grabs latest build number, AND NOW, when user sets Status to "Closed", the Build # field gets stamped again with the latest Build # (lookup Max Build # recorded). This is useful because now the Build Number field can be used on the Version Notes report (be sure to set a filter of Status = "Closed" so that you get just the closed bugs in each version grouping). - Re-arranged Admin submenu buttons so looks nicer. VER 2.06, BLD 5 - BUG FIX LIST ------------------------------ - Somehow, in the rush to get Build 4 out, one of the bug fixes accidentally did not get saved, or got overwritten or something. Anyway, the User Defined drop-down boxes work now (I had to remove the NOT flag again as indicated below). How embarrassing. VER 2.06, BLD 4 - BUG FIX LIST ------------------------------ - Removed Access splash screen at load-up. - Removed Access menu bar commands through-out application. For users who want to access the source code, either load up the BUG_App.mdb while depressing the shift-key, or press F11 to pop-up the database window and the database menu bar. - Fixed bug where could not use the User Defined drop- down boxes. I foolishly used a NOT bFlag for the Locked property, when what I intended was to omit the NOT flag (kind of like too many double negatives, I was thinking enabled, but locked is the opposite). - Fixed bug where application shut down if error occured during email bug operation. Now, just returns to the edit bug form. VER 2.06, BLD 3 - BUG FIX LIST ------------------------------ - Fixed embarassing bug introduced last build five days ago. When I changed all of the REF_Table edit forms, I missed renaming one load form event. Result was that when user first runs app and creates a brand new project database, got an warning indicating that need to add locations before editing bugs. Then proceeded to error out rather than popup the Location edit form. Fixed now. - Fixed minor bug where User ID label was not properly moved when screen was resized at Data Entry form. VER 2.06, BLD 2 - NEW FEATURE / BUG FIX LIST -------------------------------------------- - Added ability to resize the screen (given constraints of Access that is). Now a button to allow users to click and toggle between 640x480, 800x600, 1024x768, and 1280x1024 exists. This is only available on the Bug Edit Form(s) - Fixed bug where email bug would fail if user added new user but forgot to assign an email address to that user (or the item [Prompt]). Now, even if blank, will email. - Bugs in window are now always ordered in ascending order. Turns out one user made a copy database, then it appeared bugs could not be added...but upon further investigation it was because the sort order did not exist in the form. - Re-worked the ugly Bug Entry Form (not grid) so that fields are more uniformly positioned (at expense of scrolling off-screen on 640x480 displays). - BIG improvement. Added trigger buttons to the end of many fields in the Bug Entry Form so that now you can quickly and efficiently edit the contents of all drop-down boxes (what options are displayed). This makes maintenance a snap. I should probably go back and make that an admin only feature, but until requested I will leave it as is. - Changed Description field in Bug Entry Form so now click either Clear, Default, or Notes button to clear the field, enter the default template, or add notes/comments to the field. - Added form to startup so that if a database is not found, the system will prompt users to either make a new Bug database, re-point to an existing database, or exit. This is much clearer than the series of message boxes the app used to use. VER 2.05, BLD 11 - BUG FIX LIST ------------------------------- - At bug entry form view, Issue Details button can be clicked to automatically log the date, time, user ID, and a comment block to the Issue Details. - At bug entry form view, new bugs had error at default Version Number lookup. It now grabs the maximum Version Number from database as the default. - At bug entry form or table view, when first opened the form it had bugs and features listed. Now, just lists the bugs only and depresses the bug tab. VER 2.05, BLD 10 - NEW FEATURE LIST ----------------------------------- - The Issue Entry Form now allows for two types of issues: Bugs or Features. A Bug is an error in the program under test. A Feature is a new item that a project manager wants added. Identifying issues as either bugs or features will enable you to build more meaningful filters and reports. - Buggit is now a freeware product. All references to shareware/trustware have been removed from the application. There is no longer a request for $10 licensing fee. - Fixed a bug at Report Wizard where after adding a new filter, it was not visible until the next time you re-opened the Report Wizard form. Needed to refresh the combo box following closure of the Filter Dialog. - Added additional commenting to code to make it more readable. - Created an auto-update database upgrade patch ('BUG_UpgradePatch.mdb'). You can manually run this patch against all of your old Buggit V2.00-Bld52 project databases; or you can just run the new build of Buggit to automatically run the patch against the current project database. This patch adds and removes fields from Bug and Bug Archive; sets default values for the new fields, and reset a tbl_Properties Property Value (FrontEndVersion). Moving forward, this patch will be a critical component for future upgrades to the database structure. It will automatically synchronize any previous build up to the latest build. - Removed global variable flag for error handling on or off now it is always on. - Reset tab order on all forms. - Rebuilt Help File in Word (later saved as HTML), linking in all pictures rather than embedding them. This retains the image (gif) file names rather than stamping the ugly (image1, image2, etc.) notation. - Rebuilt Help File so that new features are depicted in the screen shots (Bug vs. Feature was the most visible new feature on screen shots). - Reports used to print the wrong filter information on the bottom of the report (about ¾ of reports had this bug). Fixed now so that filter has correct information displayed. - Report filter no longer prints ugly spaces between paranthesis. - Fixed bug in Filter dialog where changing filter name popped up error and stopped the change. Now, anytime lost focus on Filter Name, filter goes to filter details. This bypasses the Access bug above where parent form link field changes, but child field was not automatically changing. - Reset all forms to the proper caption. A few forms used to have bogus captions. - Added filter button 'All' to the Edit Issue form. Makes it easier to quickly view all bugs/features. Also, defaulted bug view to this All button instead of to view only 'Mine'.