Release Notes for DP Live v 5.3.40902 2 September, 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 which 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. Enhancements 4. Fixes 5. Known Issues 6. Post-CD Fixes and Enhancements -------------------------------------------------------- 3. Enhancements -------------------------------------------------------- RESULT LETTER UPDATES The Result Letter page was showing only the first letter of the result status ("N", "P", etc.) for each substance. Now it will spell out the word ("Negative", "Positive", etc.). The result letter has been redesigned to more closely approximate the (new) standard DP Result Letter, including fetching the Non-/DOT comments, and including adulterant/dilute/substituted/COC-Date/and Sample Type. The new Result Letter format now supports the standard DOT message and Non-DOT messages (for DOT and Non-DOT results, respectively, of course.) It is now possible to print multiple Result Letters at once. When printing, each result letter prints on a separate page. The latest versions of Internet Explorer, and Netscape are supported. a) "Result Letter Format" is now available on the "Custom Result List". b) When viewing "New Results," a special link is available at the top of the page to view all new Result Letters. These will appear in a new window. INTERFACE IMPROVEMENTS Marking results seen has new warning message. Now, when the user clicks the "Mark these results 'seen'", a confirmation window appears warning that the current results will be cleared. This is to give them a chance to cancel, if they (for example) have not yet printed the result letters. After clicking OK, the results are marked "Seen" and then the browser is redirected back to the Results options page. [All Pages] button at top of reports. This appears with the other report navigation tools, if the report is broken across multiple "pages" Changes were made to the style sheet to improve printing. Now the fonts you see in the browser will also be used when printing. Various items suppressed in print. Items like the main navigation menu, remote-administrative menu, and page navigation controls are suppressed when printing. This is accomplished with the updated DPSTYLE.CSS file segment: @media print { BODY { margin: 0px ; } .noprint { display: none ;} } TECHNICAL ENHANCEMENTS New special replacement tags have been added. <#TAG ...> For use after an <#IF. . .> command,because the <#VERTAIM> tag could not create standard HTML tags <#COMMENTON>,<#COMMENTOFF> For use after an <#IF. . .> command, for conditionally using larger blocks of HTML code. CASCADING STYLE SHEET CHANGES A general enhancement was made to the Cascading Style Sheet, to support the designed fonts in all printed reports. Previously all printed output was using the browser's default font. This was due to a faulty CSS link statement. media="screen" has been replaced with media="all" SEARCH FOR RESULTS BY SSN/ALPHA Results search by SSN/Alpha Sort has changed. Previously DP Live would take the first match found, and automatically show those results. Now DP Live will only automatically show the results if only one match is found. Otherwise, a list of matching participants will be displayed. *As a result of this change, if you have a Custom RESULTS.HTM skin file, then before installing this update you should copy the old PARTRESLOOKING.HTM and file from the DEFAULT folder into your custom skin folder. SORT ORDERS Various "Sort Order" lists have been edited to hide system indexes, showing only the indexes an end user will likely wish to use. COMPANY LIST Each line on the company list now has a "Make this the current company" link. This removes a few steps from changing the current company. Previously the user would have to click the "magnifier" button to view the company data input screen before changing the current company. HOME PAGE Now it says "Welcome, [User's first name]!" previously it said (dully), "You are logged in as user [USERID]". MISCELLANEOUS Major performance enhancements have been made when navigating large, multipage reports. -------------------------------------------------------- 4. Fixes -------------------------------------------------------- The following fixes resolved some issues introduced in DP Live v5.2. A bug was fixed in the DP Live Administrator, which caused the Last Name and First Name fields to be reversed. The fields have been switched around, and a special button placed between them to make it easy to switch them back (one-by-one). Remote Admin responses were not visible in Netscape, due to an HTML syntax error in the DPLIVE.DLL response. This has been fixed. -------------------------------------------------------- 5. 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/dp52 -------------------------------------------------------- 6. Post-CD Fixes and Enhancements -------------------------------------------------------- 12/30/2003 - Fixed a problem where data input forms would not load if the "FILE=" URL parameter included a "?" format wildcard. 1/1/2004 - Fixed a problem where the "Show all tables in security settings" checkbox was not being saved in Global Options. - Fixed a problem where the Global Options dialog was not defaulting to the correct page (DP Live Module) when opening Global Options from the DP Live Administrator. 1/13/2004 - Enhanced the IFDATAFIELD tag to support multiple conditions Example: <#ifdatafield tests.dot=true tests.dilute=true> 2/10/2004 - Updated the Result one-line form to provide a checkbox allowing the user to individually mark tests "seen". Previously it was only possible to mark all new results "seen" at one time, and there was no way to change a result back to "new" status. - Updated the Notification Letter form to more closely resemble the Notification Letter printed from DrugPak. - Fixed a problem where the online help pages would not load because the file help\help\[filename] does not exist. 2/12/2004 - Now the "Field Access" table list is rebuilt if "Show all tables" setting changed in Global Settings - Fixed a problem in Record Access settings, which prevented filters from displaying properly. You could enter filters, but they would disappear immediately. (However, DPLive would respect the filter you entered). - The Security Settings "Record Access" settings would not display the Modify/Insert/Delete file permission checkboxes settings. However, when you saved your changes, DPLive would respect the settings you chose. - 2/20/2004 - Fixed a problem where the database update log did not accurately identify the participant record being updated. - Re-instituted the auto-pack routine to pack the DP Live users file nightly. - Added a preference to "Global Settings | DP Live Module | Remote/Auto-Admin Options": Suspend Nightly From [time] To [time] Specify the time range during which you would like DP Live to be automatically suspended. You may wish to coordinate this time with your automatic data backup operations. If a visitor tries to access during this time period, then they will receive a message informing them that the database is being updated, and at what time the service is scheduled to resume. This time range does not need to overlap the auto-pack time. - Added full support for automatic SSN masking. Previously there were some locations where the software would not find the intended records if the entered an unpunctuated SSN (such as searching results by SSN). However, in other circumstances, unpunctuated SSNs would be converted into punctuated SSNs (such as during participant data entry). This inconsistency has been resolved. - Added a preference to "Global Settings | DP Live Module | Log ": Log participant updates to participant NOTES field. Turning this option ON will cause all participant modifications to be logged to the participant's NOTES field. More recent changes are logged at the top of the notes field. Following is a sample log: ************ 02/20/2004 3:06 PM - Modified by DP Live user DAVID Mod RANDSEL: False -> True Mod TERMINATED: True -> False Mod TERMDATE: 02/20/2004 -> ************ ************ 02/20/2004 3:00 PM - Modified by DP Live user DAVID Mod OCCUPATION: CDL -> NRV ************ ************ 02/20/2004 2:59 PM - Modified by DP Live user DAVID Mod ADD1: 123 My Street -> 123 May St. Add ADD2: Apartment 100-A Mod RANDSEL: True -> False Mod CITYSTZIP: Employee City, State, 111111 -> State College, PA 16801 Mod TERMINATED: False -> True ************ 2/23/2004 --Widened the ROSTER.HTM report so participant names and socials would not wrap lines. -- Fixed a problem in the log which caused the wrong record to be listed when recording database changes. 2/25/2004 Added file RESSEEN1.HTM to the distribution. 3/3/2004 --Fixed a bug on the Record Access Overrides in the User Accounts window: Filters defined in the Security Profile were not being displayed in the user's record. The "Filter Source" correctly indicated "Security Profile." Now the actual filter from the security profile will be displayed as well. 3/4/2004 --Fixed a bug which caused a DP Live user to use the Security Profile record (Add/Delete/Modify) settings if all of the checkboxes were marked OFF in the User record. In theory this could result in the user gaining permissions that the administrator did not intend to grant. This has been fixed. --Added a new option to "Global Settings | DP Live Module | DP Live Administrator options | Add user filters to security profile filters". Mark this checkbox ON if you would like the filters specified in the User Accounts database to have an additive effect with the security profile filters. Mark this checkbox OFF if you would like the filters specified in the User Accounts database to OVERRIDE (replace) filters specified in the security profile. 3/22/2004 --In order to support IIS, which often cannot access network folders due to security issues, DP Live now supports the use a local "mirror" folder. If the folder C:\SCANLON\DPMIRROR exists on the IIS server, then DP Live will look there for various supporting files. You will need to manually copy the affected files to pertinent directory in the local...\DPMIRROR\... folder. This includes: A) Skins in the folder ...\DPLIVE\SKINS and all sub-folders. B) Use of the a local work folder ...\DPLIVE\WORK for temp files. C) The following files from the...\COMMON subfolder: RA_IPS.TXT RLDOT.TXT RLNONDOT.TXT DBDEF.INI DPLMAILBCC.TXT. --Automatic "Profiler" logging will continue until the first request has successfully completed. Previously automatic profiling stopped after the initialization phase. --The pack and reindex process is now exception-trapped. Furthermore, the pack and reindex process will NOT run during the nightly-suspend period. If it is scheduled during the suspend period, then it will begin when the period is over. This is intended to resolve the problem of DP Live remaining suspended in the morning. --The process of updating ADS.INI has been exception trapped to avoid problems with IIS. --Added request duration display when in remote-admin mode. Otherwise request duration is stored as a comment tag at the tag 3/29/2004 -- Updated PARTICIPANTS.HTM to handle an issue where the IIS web server did not respect the legacy handling of the "Filter" fields in the Roster and Custom Participant List forms. Now a JavaScript onPost event handler is used to update the DOT, TERMINATED, and RANDSEL fields in those forms. -- Fixed a bug which resulted in an "invalid filter expression in table dbDrv" when listing results, if a filter existed on the Home Base table, but not on the Participants table. -- Modified the behavior of Home Base filters. Now, when a filter is applied to the Home Base file, a corresponding subfilter is automatically built on the Participants and Tests files, in order to improve performance. -- Fixed a database connection leak in the login process. -- Fixed the Remote Administration features as-accessed via the DP Live Administrator's TOOLS menu. Previously the remote administration password was not being included in every command line, causing some commands to fail. This has been resolved. 4/02/2004 -- Fixed the auto-suspend/auto-resume routine. Previously, after auto-suspending twice, the system would not successfully auto-resume again. This has been fixed. 4/13/2004 -- Improved performance when loading the Participants page. Sometimes this could take up to 12 seconds to load. This was due to the use of an <#INDEXLIST> tag; now a default list of indexes is provided (PARTIC_INDEXLIST.HTM), and this has improved performance. -- Generally improved performance by pre-caching all skin files in memory when variables are initialized. This reduces delays due to network traffic when processing all subsequent requests. However, now changes to your skins will not be automatically detected; if you make changes to your skin files, you must choose the "REFRESH" option from the DP Live Remote Administration menu, or from the DP Live Administrator "Tools" menu. -- Performance was improved by caching user-specific temp "files" (such as the various drop-down lists for data entry screens) in memory. Previously these files were stored in the ...dp50\dplive\work folder. -- Added support for filtering the various Participant and Result reports by Home Base. When filtering a report by home base, the home base name will appear in the report title area. In order to enable this feature, follow these steps: 1) Log into DP Live Administrator as the MASTER user 2) From the main menu choose "Preferences | Global Settings | DP Live Module | Custom Tags" 3) In the "Tag Name" field, enter SHOWHBFILTERLIST 4) In the "Replace With" field, enter Y 5) Click "Add/Update" 6) Click "Apply" 7) Close the Global Preferences dialog. 8) From the main menu, choose "Tools | Refresh DP Live" -- Added standard support for displaying home base information in the following reports: Results / One-Line Form Results / Pending Randoms Results / Find Result by Participant Participants / Roster Participants / One-Line Form In these instances, the home base column will not appear if the list is filtered by Home Base. The Home Base column is suppressed by default (due to space considerations). To enable the display of this column, follow these steps: In order to enable this feature, follow these steps: 1) Log into DP Live Administrator as the MASTER user 2) From the main menu choose "Preferences | Global Settings | DP Live Module | Custom Tags" 3) In the "Tag Name" field, enter SHOWHBCOL 4) In the "Replace With" field, enter Y 5) Click "Add/Update" 6) Click "Apply" 7) Close the Global Preferences dialog. 8) From the main menu, choose "Tools | Refresh DP Live" -- DP Live now supports links to the DLL root. For example: http://drugpak.3utilities.com/bin/dplive.dll If you create a link to .../dplive.dll without any trailing path info (such as \login), then DP Live will automatically either send you to the Home page or the Login page (depending on whether you are already logged in). This is handy if you accidentally close your browser while logged in; then if you go back to the corporate site (which then links you to .../dplive.dll ) then you will not have to log in again (if the auto logout time limit has not elapsed). 4/14/2004 -- Added the file RESFORMS.HTM. This file is dynamically loaded by the RESULTS.HTM page to offer control over the "Report Form" item displayed at various points in the "Results" page in DP Live. The default form styles are "One-line Format", "Brief Format", and "Long Format." By separating this object into a separate file, it makes it easier to customize the variety of form styles offered. 4/22/2004 -- Fixed a bug which prevented databases from closing when the system was either manually suspended or automatically suspended. This could prevent some backup systems from backing up the DrugPak data files. -- Modified the WebModule creation routine to prevent all data files from being opened automatically. This helps limit the usage of work areas in the Client/Server engine. -- Added a timeout period to automatically close all data files in DP Live after N minutes have passed (where N is the "Auto-Logout after N minutes of inactivity" setting in "Global Settings | DP Live Module | Remote/Auto-Admin"). -- Added new items to the Remote Admin menu: Variables: Shows almost all of the current software settings WebModules: Shows how many web modules have been created and how many open tables each one has. -- Fixed the problem where the remote admin cookie was not sticking. 4/23/2004 -- Fixed the "List index out of bounds" error when issuing the remote admin password on the command line (as happens when using remote admin features via the DP Live Administrator "Tools" menu). 5/4/2004 -- Solved problem on Collection Site listing: Error "dbCS: Field DESC not found" 5/14/2004 -- Fixed a bug which caused the list of Home Bases to remain unchanged when the user changed companies. Now when the user changes companies, the list of available Home Bases will be updated to show the current company's home bases. This bug was introduced on 4/14/2004. -- Fixed a bug which caused the participants page to display incorrectly when a company has no home bases -- Fixed a bug which caused the error "dbDrv: Could not perform this operation on a closed dataset" when clicking the "Add Participant" button. 05/18/2004 -- Fixed a bug which prevented the P_ADDED, P_MODIFIED, LAST_USER fields from being completed when adding or modifying a participant record. 05/20/2004 -- Added support for a special variable CloseDataLoopTable Setting this variable to Y will cause the DATALOOP process to output a closing tag at the end of the loop. This is very useful when used in conjuction with a "load once" type of report header, such as follows: <#IFNOTGETVAR DIDHEADER=Y><#LOAD file=A_HEADER_FILE.HTM> Then within the header file, include the header, and end the header file with the following tags: <#SETVAR DIDHEADER=Y> <#setvar CloseDataLoopTable=Y> 6/18/2004 -- Rebuilt the update installation program to include all skin files. 7/12/2004 -- Fixed a bug in which the "Request an Alternate" email would fail to send if the email account required a user name and password. 7/20/2004 -- Improved the stability of the "Webmodules" remote admin tool, when some webmodules failed to initialize. -- Now the profiler will become enabled every time a webmodule is created and will autodisable (if autoenabled) when it successfully delivers its first web page. 8/9/2004 -- Fixed a bug in which when the "max numbers of records per page" option caused a report to become divided into multiple pages, the last record of each page would not appear. -- Added the pool group file to the list of tables that can be filtered. Setting a filter on this table does NOT filter the participants table; it limits which pool groups are available in the "pick list" in the participant entry form. 9/2/2004 -- Made it easier for custom skins to specify what the available participant data entry forms are, by customizing the file "partentryformats.htm" file -- Modified the participant file update routine to prevent the "Auto-enter termination date" option from overriding an explicitly submitted termination date value. Previously, if the "Auto-enter termination date" option was turned ON, then if the DP Live user marked a participant TERMINATED then DP Live would force the Termination Date equal to the server's system date even if the user submitted another date in the form. This has been fixed. -- Added a special input field name *COMMENT* to allow a user to submit a one-line comment that will get appended to the participant notes field. Following is a sample implementation: -- Modified the wildcard character used to dynamically specify a file format. Previously the wildcard character "?" in a file= parameter would be substituted with the format= parameter. Now the wildcard character is "*".