-------------------------------------------------------- Release Notes for DrugPak v 5.3.41028 28 October, 2004 -------------------------------------------------------- 1. Introduction -------------------------------------------------------- This text is stored in a file called UPDATE.TXT. It will be installed into the program directory, so you can read or print it at your convenience. These release notes are provided to help you learn about changes to the software that have occurred too late to include in the on-line manual and help systems. Review the Contents section (next) to see if any of the Release Notes may be of interest to you. -------------------------------------------------------- 2. Contents -------------------------------------------------------- 1. Introduction (prior section) 2. Contents (this section) 3. Instructions for New Users 4. Important Notes for Current Users 5. Enhancements 6. Fixes in the CD release 7. Known Issues 8. Post-CD Fixes and Enhancements -------------------------------------------------------- 3. Instructions for New Users -------------------------------------------------------- This fully-functional software can be installed for a risk- free 30-day trial period. Please call us at 800-321-7826 if you have any questions. You can test the system with live data. If you purchase the software, you will be given a registration key to unlock the software for permanent use. You will not need to reinstall anything or re-enter any data. If you would like to evaluate DrugPak in a multi-user environment, you can install the software on your network. The recommended installation path is ...\scanlon\dp50. To set up an additional workstation to run DrugPak, follow these steps: 1) From your Start menu select Run. 2) In the "Run" window, click the "Browse" button. 3) In the "Browse" window, browse the network to locate the DP50 program directory. Click WKINST.EXE so that it is highlighted, then click the "Open" button. 4) In the "Run" window, click the "OK" button to run WKINST.EXE. 5) The workstation setup program will run. Follow the on- screen instructions to finish configuring the workstation. When running the software, press F1 at any time to instantly view a pertinent topic from the help system. A printable User's Manual in MS Word format will be installed with the software. You can access additional help features via the Help menu in the program, or via "Start |Programs | DrugPak 50 | Help" menu. If you are installing from our CD, you can also learn more about the software by watching the "Introduction" presentation. Call us at 1-800-321-7826 to schedule a complete walkthrough of the software. -------------------------------------------------------- 4. Important notices for current users ------------------------------------------------------- This version of DrugPak uses an updated version of the Advantage Database Engine. Each workstation will need to run the workstation setup program to install the updated drivers. This process is simple: a) Start the DrugPak software. You will be notified that you need to install the updated drivers. Click YES to the prompt. b) DrugPak will close and the latest Workstation Setup program will run. Follow the on-screen prompts to complete the install. c) You may need to reboot your computer when this process is complete. ***DrugPak Client/Server Users*** Before installing DrugPak 5.3, you must first update your Advantage Database Server to the latest version (6.2), if you have not already done so. If you are already running DrugPak 5.2, then your Advantage Database Server is already up to date. If not, please contact DrugPak technical support for assistance. -------------------------------------------------------- 5. Enhancements -------------------------------------------------------- NEW RANDOM SELECTION EXPERT New entry fields have been added to the Random Selection Profiles on the Selection Rates page. These fields allow you to specify the frequency of random selections, so that the program can automatically calculate when a selection is "due." A Reports tab has been added to the Random Selection Profiles, allowing you to specify random selection audit trail report settings for each profile. If you do not wish to specify settings for each profile, you can enter default report settings by selecting Randoms|Audit Trail Default Options from the main menu. A new random selection expert has been added, making it possible to perform random selections for multiple companies at one time. The expert uses the new random frequency fields on the Random Selection Profiles screen to determine when a random selection is due for a particular profile. The program will start calculating due dates for random selections AFTER the first time a random selection is performed for a particular profile. You must set up the selection frequency for your profiles prior to performing a random, or due dates will not be calculated. To enable the new random selection expert, select Preferences|User Preferences and navigate to the Main Module|General Options page. A new checkbox, labeled "Use New Selection Expert" will enable or disable the new expert. AUTO-INCREMENT COMPANY ID Added a new option in Global Settings|Main Module|Company Options to allow auto-increment of the company ID when new companies are added: "Auto-Increment Company ID." WORKSTATION PREFERENCES are now USER PREFERENCES Changed Workstation Preferences to User Preferences. Settings that were stored for a particluar workstation are now being stored by user ID. That means if a user logs in as him/herself at another workstation, his/her settings will be preserved. If you would like separate settings for each user, make sure that each user is logging in to DrugPak with a unique User ID. A special process will occur when a user logs into DP53 for the first time, copying the settings stored on the workstation and assigning them to the logged-in user. If everyone in your office logs in as the MASTER user, then everyone will be sharing the same settings. To separate these settings, you should create user accounts for each user. 1) Start DP53 for the first time, and log in as the MASTER user. The current workstation's settings will be saved under the MASTER user account. 2) From the file menu, choose Users. Add User records for each separate user in your office. 3) Allow each other user to log into the system at their own workstation using their new user name. The first time they log in, their workstation settings will be saved under their own user account. UNIFIED SETTINGS DIALOGS FOR ALL MODULES Changed the Global Settings and User Preferences screens so that the settings for all modules can be accessed from a single screen. A tree on the left-hand side of the screen lets you choose the module and settings category. VIRTUAL LETTERHEAD Added new "Virtual Letterhead" screen to "Preferences | Global Settings | Main Module". This new screen allows you to select a graphic image to use as letterhead, and allows you to select which reports will print using the letterhead graphic. NEW MIS REPORT The MIS report has been updated to reflect the new DOT "single form" approach. The new MIS report will look for "SHY BLADDER" and "SHY LUNG" in the result letter notes, and group these results in the appropriate column on the MIS report. The new MIS report will allow a negative-dilute result to be excluded from the report when followed up by a second test. Any negative dilute result can be excluded by setting the disposition to "SRT" (Scheduled Re-test). MISCELLANEOUS Added option to "Tools|Advanced|Update Participant Names / Alpha Sort" that allows stripping of initial spaces from participant names. Added option to "Preferences|Global Settings|Main Module|Incomplete Test Options" to allow reporting of missing CCF date for DOT and non-DOT results. Added option to "Preferences|Global Settings|Main Module|Result Options" to automatically generate a batch ID when a new test is being added. This saves the user from having to right-click or double-click the batch ID field to generate a new batch ID. Moved the "Disable Client/Server Mode" and "Share data with other programs" checkboxes from the General Options page to a new Advanced Options page in "Preferences|Global Settings|Main Module." Updated descriptive names for all tables and fields. Improved the performance (start-up time) for all Find screens. In all "Find" screens, "Yes" or "No" is now being displayed instead of "True" or "False." Added a keyboard shortcut to "Show all of this participant's results": Shift-Ctrl-I. Updated Help files. Export to MRO has been updated to support the following field definitions. All existing installations of Scanlon Associates Delimited layout will need to be manually updated as well to support these new data fields. Contact technical support for assistance. Record Pos. Name Format ------ ----- ------------------ ---------- O 28 COC Received Date MM/DD/CCYY O 29 Dilute T/F (blank=unknown) O 30 Substituted T/F (blank=unknown) O 31 Adulterant Free Text (10 chars) For slower networks / WANs: when the network administrator has chosen to make a copy of the application on the local machine, DrugPak will now also look for a local copy of the REPORTS folder. If the desired report can be found locally, then the local copy will be used, rather than the network copy. Added report of profiles due for random selection -------------------------------------------------------- 6. Fixes in the CD-Release -------------------------------------------------------- Fixed bug in which the "preview in window" setting was not being saved on the Program Statistics screen. Fixed bug in which the correct consortium was not being found from "View/Edit Consortium" on the random selection profiles screen. Fixed bug in Advanced Export, in which commas were being exported for all fields, and not just the ones selected to be exported. Fixed bug in which it was possible to create duplicate random selection profile names by editing the profile name. Fixed bug in which the alpha sort value was being incorrectly calculated for participants whose first names ended in "van." Fixed bug in which the "Never mark participants include in random" checkbox was not causing the Apply button to become activated in the global settings. Fixed bug in which leading spaces were not being removed from the participant name on import. Fixed bug in which the hourglass mouse cursor was still being shown after results were purged. Fixed bug in which a change to the MRO name in "Preferences |Global Settings |Main Module | Result Options" was not causing the Apply button to become active. Widened the Test Status field for alcohol results, so that the entire status (for "Stage 2 Positive (>.04)") can be seen. Made Dilute and Substituted checkboxes on the Results screen mutually exclusive. Prevent entry of a COC date that is before the collection date or after the system date. Fixed bug in which "Copy to clipboard" on the contacts page was not functioning. Fixed bug in which the column order in the "Show all this participant's results" screen was not being rememebered. Fixed bug in Advanced Reporting screen in which selecting the "Formulas" button multiple times produced an error. Fixed error when printing the Summary of Drug Testing report. -------------------------------------------------------- 7. Known Issues -------------------------------------------------------- You can keep up-to-date with the latest version of DrugPak by visiting our Update page on the web: http://drugpak.com/update -------------------------------------------------------- 8. Post-CD Fixes and Enhancements -------------------------------------------------------- 12/23/2003 -- Modified the Copy Result routine to "recycle" the database record when the user opts to "delete" the original result. This way the any images associated with the original result will remain associated with it. -- Modified the DOT MIS Data Collection Form report to show the site (company or home base) address. 1/2/2004 -- Restored missing toolbar images -- Corrected letterhead settings for the result letter report and the short driver listing -- Fixed work area problems in new random selection expert 1/5/2004 -- Restored broken lookup links 1/6/2004 -- Corrected Box II(A) and II(C) calculations for consortia on the MIS report. 1/7/2004 -- Added "Average each profile separately" checkbox to MIS report 1/8/2004 -- Fixed a problem in the FUP Test schedule that prevented printing for two FUP tests for the same person scheduled on the same day. Only the first scheduled test would print. -- Fixed a problem in the FUP Test Schedule database that prevented the PREC_ID field from being recorded. -- Updated the Random Selection Certification Letter (VOUCHER.RPT) to respect the Virtual Letterhead suppression settings. Also added support for the virtual letterhead "Underlay return address" option, and improved spacing between the From address and To address for use with #9 double window envelopes. -- Fixed problem in which all home bases were being shown in the participant screen dropdown instead of just the home bases for the participant's company -- Fixed problem in which the participant filter was not being used when computing totals on the MIS report. 1/9/2004 -- Modified the "Instant Audit" and "Incomplete Test Results Report" to NOT report an exception if the COC Received date is missing from Alcohol tests. 1/13/2004 -- Added regulation changes to DOT MIS report. Also added several totaling options for consortia. 1/14/2004 -- Allow sorting of MIS report based on name or code -- Allow entry of "prepared by" name and phone on MIS report -- Corrected problem on MIS report where sections III and IV could be blank. -- Corrected a problem in which the DOT MIS report was not counting alcohol tests which did not have MRO Verification dates. The report will now include Alcohol tests if the collection date is within the range. -- Modified the MIS report to print in SITE NAME order. When grouped by participant, it will be printed in participant first-name order. 1/16/2004 -- Fixed problem in which MIS report was printing an extra blank page 1/21/2004 -- Updated Result Letter report to prevent the RED coloration from appearing, because of printing problems on some printers. -- Added more comprehensive exception reporting to the MIS report. 1/26/2004 -- Fixed a problem in Global Settings which prevented the "DP Live | Remote Administrations | RA IPs" from being saved. -- Added new options to MIS report: "Do not calculate section II(A) and II(C) totals" and "Restrict RND tests to batches included in section II). 1/29/2004 -- Added MRO access flag to users file. 1/30/2004 -- Added database upgrade to repair participant file indices. 2/2/2004 -- Corrected problem on Lab Usage report, where the Fax number was always incorrect. 2/24/2004 -- Centered profile report settings dialog on screen -- Profiles which use their own audit trail report settings can now be reverted to the default settings with the "Use default options" button on the Reports tab of the Random Selection Profiles screen. When the default options are used for a profile, the random selection experts now give the user a choice either to modify the default settings or to create profile-specific settings. The "new" expert now displays which report settings are used for each profile. -- The "prompt to print on letterhead" global settings are now being obeyed during audit trail printing -- The new random selection expert now prints alternate notification letters properly. -- Code and Contact entries were allowing spaces in the "Code" field. This is now prevented. -- If a test is cancelled, DrugPak no longer warns about missing COC date. -- Selecting an alternate failed to enter a prec_id or rrec_id. This has been repaired -- Profile names are now printed correctly on all proof lists and audit trail reports -- "Obey alternate list grouping" option has been removed when printing Notification Letters for alternates. Now the alternate list grouping is always obeyed when printing notification letters for alternates. -- "Would you like to lookup a batch?" option when Selecting an -Alternate can now be re-enabled via the Optional Prompts user preferences. -- If "Prompt to print on letterhead" is checked, reports now suppress the business address. -- Home base codes were allowing entry of spaces. This is no longer permitted. 3/5/2004 -- Fixed participant filter error in MIS report 3/10/2004 -- Error 5016 when copying result to another participant, if the participant already has a result with the same Batch ID, has been fixed. -- Company short form report was not keeping company together across a page break. -- Updated the Export to MRO dialog - Added support for using the Translation Engine. No standard layouts are available at this time. Assistance with this feature is subject to custom programming charges. - The "Use Preferred Layout" checkbox has been replaced with a drop-down list with the following options: Simple Delimited File "Preferred" MRO Management Delimited Format Use Translation Engine When "Simple Delimited File" is chosen, then an additional page appears in the dialog: "Field Sequence." The Field Sequence page allows you to create different output formats and save them to a file. These output formats are saved in the Common directory with a *.MXF extension. ORIGINAL.MXF comes pre-installed with this release of DrugPak, and will output fields in the same order as they did in version 5.2. Added "Carriage Return Replacement Text" and "Line Feed Replacement Text" settings to the Simple Delimited File options. These settings provide alternative text to output when memo fields contain carriage return (#13) or line-feed (#10) characters. Leave these fields blank to simply replace these characters with a single-space. 3/12/2004 -- Fixed a problem in which it was possible for a random selection profile to have a duplicate PROFILE_ID number. -- Fixed a problem in the Export to MRO dialog in which the "Simple Delimited File" settings file name would not be displayed after clicking the Load button. 3/17/2004 -- Added the ability to reprint the random selection audit trail for multiple batches at one time. Batches are selected using a range of selection dates, and checkboxes are available to turn printing on or off. Report settings for each batch are set using the settings for the corresponding random selection profile, so make sure that these settings are correct before reprinting the audit trail. Just as in the new random selection expert, the selected audit trails will be sent directly to the printer. To use this feature, select "Reprint selection audit trail" from the Randoms menu, and choose the "Multiple batches" option. 04/01/2004 -- Fixed a problem in which incorrect report options could be presented when reprinting the random selection audit trail 04/09/2004 -- Update for new version of Document Manager 04/13/2004 -- Fixed a problem in which selecting an alternate did not update the home base in the tests table. 04/28/2004 -- Fixed a problem for users upgrading from DrugPak v5.2, SQL error "Field PREC_ID does not exist." -- Upgraded the Lab Usage Report and Collection Site Usage Report. -- Added ability to sub-group by company. -- Added ability to print totals only, suppressing test type sub-groups, (short form only). 04/30/2004 -- Fixed a bug in the Participant Import PIM file interpreter. When importing NON-DELIMITED data files, the wrong checkbox settings would be returned. There was no problem when loading .PIM files for DELIMITED files. 05/04/2004 -- Solved an error in "dqQuery" when trying to delete a record, if the latest release of Document Manager is installed. -- Fixed a problem in the Global Settings dialog wherein the wrong options page would be displayed when selecting an options page from the list. 05/05/2004 -- Adds Database Upgrade to level 89, adding enhanced fields to the Collection Site file. Reports have not yet been updated to support the new fields. 05/10/2004 -- Adds Database Upgrade to level 90, adding additional enhanced fields to the Collection Site file. Reports have not yet been updated to support the new fields. 5/17/2004 -- Updated the random selection statistics reports to exclude "Test not Performed" statuses from the "Completed" tally, in accordance with CFR 40.207(b). 5/24/2004 -- Added new options for Random Selection Profiles: On the Participants tab of the Random Selection Profiles screen, the Home Base, Occupation, and Pool Group lists have a new "All" check-box. To include all Home Bases in a profile's random selection, check the "All" check-box above the list. When you add a new Home Base in DrugPak, it will automatically be included in that profile's random pool. Previously, profiles that included all Home Bases had to be updated manually when a new Home Base was added to DrugPak. The new "All" check-boxes work the same way for Occupations and Pool Groups. The Home Base, Occupation and Pool Group lists now allow blank codes to be explicitly included in or excluded from the random pool. Previously, participants with no assigned Home Base were only included in the pool when the "Home Bases Selected" list either included all Home Bases or was empty. To include blank Home Bases, move the "*BLANK" code to the "Home Bases Selected" list (the "*BLANK" code will always be displayed at the top of the list). This new option works the same way for Occupations and Pool Groups. To implement this new option, a database upgrade will be performed. The upgrade will add the "*BLANK" code when the current list is empty, and will set the "All" option for lists that currently contain all codes. Put simply, DrugPak's behavior will not change from the current settings. -- A new option has been added for Result Letters. The MRO signature image can be printed on all letters, on no letters, or only on letters for negative results. To use this option, select "Always," "Never," or "Negatives" for "Print MRO Signature" on the Results Letters screen (Reports | Results Letters on the DrugPak main menu). The option will be set initially to "Never." 5/26/2004 -- Linked Document Manager documents were not being found when a test record is posted. 5/28/2004 Fixed Document Manager item on the Modules menu to run the newest Document Manager version (5.3.40528). Before this update, Modules|Document Manager caused an older version (5.3.40315 or before) to run. 6/03/2004 Fixed a "list index out of bounds [1]" error that occurred when attempting to link a Document Manager document. 6/24/2003 Updates data for compatibility with new Document Manager feature, allowing links to multiple tables. 6/29/2003 Updates data in the Collection site file to increase size of some fields. 6/30/2004 MRO name and panels fields were inaccessible on the random selection profiles window. 7/1/2004 Modified database upgrade (level 101) to supply more status information, and to skip moving ikeycat records to ikeycatlinks when the IKCAT_TBL field does not exist in ikeycat. This avoids possible upgrade problems for customers who were using Document Manager during the May-June 2004 beta period. 7/2/2004 Added more status dialog feedback when performing the database upgrade for levels 96 and 97. 9/1/2004 Added activity tracking to track when a DrugPak user changes a result record's task_id on the results page. 9/14/2004 Corrected misspelling in Letter to Prospective Employee. 9/21/2004 Fixed error 5005/527 in Random Selection Parameters report. 9/22/2004 Updated Random Selection Parameters proof list and audit trail reports to solve "Error 5005: The supplied buffer was insufficient for the information returned. The data may have been truncated" when printing these reports with many thousands of companies in the list. Now the reports use subreports to present the data. 10/1/2004 Added process to remove invalid characters from home base codes, occupation codes, and pool group codes when importing participants data. The only valid codes are: A through Z, 0 through 9, underscore (_), and hyphen (-). 10/1/2004 Previously the file path length of the *.CSV file to be used when importing participant data was limited to 80 characters. That limit has been removed. 10/8/2004 Added feature to help prevent companies from being mistakenly set to inactive. When a user turns off a the Active check box, and posts the record, the user will be warned, and asked to type YES (in all caps), to verify that the does, in fact, want to de-activate this company. Once the user types YES, then the user can post the record. 10/13/2004 Added process to insert the Record Added Date (R_ADDED) after a result data for an random (RND) test is entered. 10/25/2004 The Copy Result tool did not update the last test date for the destination participant. This has been rectified. A database upgrade was created to update the last test date for all participants who: A) currently have an empty last test date; and B) have an existing result with a collection date entered. 10/28/2004 Fixed bug that disallowed non-master users from executing "select" statements in the query executor.