Freezerworks Unlimited Information

• Import. Freezer locations were not created or modified correctly when the import file contained multiple freezers having different numbers of subdivisions e.g., Freezer 1 contained Shelf, Box Position, whereas Freezer 2 contained Shelf, Box, Row, Column). Such an import is now allowed.
• Import. A Modify import to add new aliquots to existing Sample records incorrectly filtered out aliquots that did not contain a Freezer Name, and created aliquots that could only be viewed by the Admin user. This import is now allowed, and freezer security functions correctly.
• Import. In certain isolated cases, an import to Modify aliquot fields incorrectly modified some fields and left other fields blank rather than adding new data.
• Search Aliquots. Aliquot searches were slow due to (1) verification of calculated User Defined Fields (UDFs) and (2) freezer security settings.
• Batch Update Samples. UDFs associated with Aliquots were updated during a Batch Update of Sample UDFs.
• Explore Freezers. Deleted aliquots were displayed in Explore Freezers. Deleted aliquots are now filtered out, and are no longer displayed.
• System Admin - User Preferences. In the Client/Server version, each User account can be configured to automatically logoff after a designated period of inactivity. The Auto Logout preference did not account for lengthy processes such as imports or batch updates. It now checks for such processes, and will not disconnect the client.

Version 4.0.22
General Release
August 21, 2009

Error Corrections

• Batch Entry.  In some cases, auto-incrementing values generated through Batch Entry are not displaying properly in Samples record.
• Batch Entry.  Program error occurred at the Print Bar Code Labels step after creating samples/aliquots in Batch Entry.
• List Deleted Samples/Aliquots.  The lists were blank despite records having been deleted from the database.
• Import.  Program error displays when user cancels out of an interactive auto-assign import.
• Import.  Freezer Next Assignable Position is incorrectly shown as full during an interactive auto-assign import, however it is used to assign the aliquots.  Additionally, in certain limited cases, a duplicate Next Assignable Position was not caught, resulting in 2 Aliquots being assigned the same position.

Version 4.0.21

August 10, 2009

• Batch Entry.  Blank User Defined Field records for the Batch Entry key field were created.  This caused the UDF to not display in some data viewing screens, most notably Explore Freezers.

Version 4.0.20

July 17, 2009

Modifications to Testing Module

• Print Test Reports.  Search for Samples where data entry is complete, then print one Test Report per page for each Sample.  Allows "batch" printing of Test Reports rather than requiring user to view each Sample one at a time to print the report.  Note: It might be necessary to move the Footer section up higher on the report template in order to print one page per report, otherwise an extra, blank page might print for each Sample.
• Export.  Export the results of a specific Test rather than all tests for each Sample. (Advanced Search using Table to Search=TestsOrdered)

Error Corrections

• Sample Types.  When modifying an existing Sample Type, or adding a new Sample Type, the following error appears: "Trying to save non-unique data to a unique field.  Record cannot be saved."
• Samples List View.  The Samples List View displays incorrect values in the Number of Aliquots fields.
• Shipping.  Added aliquots to a shipping file, but they were not listed when viewing the shipping file.
• Print Bar Code Labels.  Intermec printer delay too slow between each label.
• Upgrade. Corrected the data upgrade method to move the value in "Number of Aliquots with Positions" (which was the old "# of Aliquots" field) to the "Total Number of Aliquots" field when no aliquot locations exist.
• User Defined Fields.  An infinite loop in Default Values code caused the program to hang when modifying an existing default value.
• User Defined Fields.  Deleting a value caused the remaining values to be out of sync, and multiple ranges were not allowed in Default Values.
•  Modify uniqueness check on aliquot freezer position, to avoid rare sporadic assignment of duplicate positions
• Editing data using the List Views resulted in erroneous Audit Trail data

Testing Module

• Print Results Reports.  Test Results are not printing in the order that Tests have been placed onto the Assign Tests tab within Configure Test Reports.
• Configure Tests.  Need to be able to remove a Reflex Test or change it to None.
• Order Tests.  Ordering tests in Page 1 changes or erases tests that have already been ordered on Page 2.
• Enter Results.  When performing duplicate data entry, the first entry can be seen while performing the second entry, thereby defeating the purpose of duplicate data entry.
• View Test Results.  Test Parameters are not listed on the Results tab of a Sample record in the same order they were configured.

Version 4.0.19

May 1, 2009

Limited Release

• Move Samples.  Runtime error (program error) when moving aliquots from one freezer to another.  Runtime error occurred at line number 20. Method: List_itemsetexpanded.  The destination string is smaller then the source.

Version 4.0.18

April 9, 2009

Limited Release

• When saving a record, an error message indicates that duplicate data exists for a Unique UDF.  The data is incorrectly saved after clearing the error message. 

Version 4.0.17

March 31, 2009

Limited Release

• Shipping.  Duplicate Shipping IDs were being assigned to separate shipments due to duplicate format names.

Version 4.0.16

March 26, 2009

Limited Release

• User Defined Fields.  A UDF named "Tube Qty" has a default value of 2. The number 2 is based upon the value of of another UDF called "Protocol".  (When Protocol=100, then Tube Qty=2).  A user updates a sample record, changes the Tube Qty from 2 to 3 and saves the record.  The new value of 3 is not saved; it defaults back to 2 when the sample record is viewed.
• Aliquot List View.  Displays the same Unique Aliquot ID multiple times.  Deleted records were included in the query; filter out the deleted records.
• User Defined Fields.  A UDF calculated field was defined as "Total Number of Aliquots" * 0.07.  It also had significant digits=2.  There were two problems here: 1) any real fields such as "Total Number of Aliquots" were not working because the Sample record was not being loaded, and 2) significant digit calculations were not working.
• Modify Aliquot.  If you change data in an aliquot field using the Modify List function AND the aliquot field is used in a UDF Count Field, the modifications do not get reflected in the Count field.  You have to open an aliquot entry screen that has the updated field in order to update the Count field.
• Security.  Aliquots in the same sample record are assigned to 2 freezers.  The group access levels are Freezer 1 = Modify, and Freezer 2 = Modify & Delete.  The user can delete the aliquot in Freezer 1 after highlighting the aliquot that's in Freezer 2.  This happens when the aliquots are listed on a page (tab) other than page one.
• Shipping.  Duplicate Shipping IDs were being assigned to separate shipments.  Freezerworks ran the Shipping ID process twice, incorrectly locking the first Shipment ID so that it could not be set as Inactive, thus allowing the same Shipping ID to be used.
• Testing Module. In order to Pickup, Complete or Enter Test Results, the user must have Modify & Delete permission at the Group level.
• Print Results Report.  Individual parameters in a Test are not printed in the order they were configured.

Version 4.0.15

March 18, 2009

Limited Release

• Print Bar Code Labels.  Brady MVP300 bar code printer.  The one second delay between each label print is not necessary.
• Search Samples. Subsequent searches display the results from a previous search.  Pressing <Enter> on the keyboard invoked the previous search whereas clicking <Enter> with the mouse correctly displayed the results of the current search. 
• Batch Entry.  A calculated UDF named "Aliquot ID" is defined as "Participant Number & Unique Aliquot ID".  A Batch Entry form is configured as "Scanning Key Field" = Participant Number.  When using this Batch Entry format, the "Aliquot ID" is not calculated until each individual aliquot is double-clicked.
• System Admin.  New menu option to remove the invisible characters Carriage Return, Line Feed, Carriage Return/Line Feed, Space or Tab from the beginning or end of a selected User Defined Field.

Version 4.0.14

March 6, 2009

General Release

• First release of 4.0x for Macintosh users.
• Allow user to change the display order of Samples fields in Configure Batch Entry.
• Prevent Batch Update options from use while viewing a Shipping file.
• Correct problems in search when using dates in DDMMMYYYY format.
• Correct runtime error occurring when calculated field is included on page 2 of Batch Entry format.
• Prevent deletion of Aliquots from List View when permission disallows.

Version 4.0.13

February 20, 2009

Error Corrections

• Corrected errors generating multiple levels of default values when using dropdown lists.
• Runtime error in Modify List screen with calculated fields.
• Runtime error attempting to delete a configured Aliquot setup in Batch Entry Configuration.
• Prevent saving invalid data in configured Aliquots in Batch Entry Configuration.
• Correct Possible Data Corruption Error displayed in Inventory List Views.
• QC Check Freezers - position 160 does not display correctly.
• Import format - aliquots fields are missing on existing format.
• Import - failed check on Unique Aliquot UDF did not prevent the import of the value.
• Import - removed options for "Abort" or "Report Error" on Duplicates; no longer used.
• Import - interactive auto-assign erroneously allowed user to assign multiple aliquots to same position
• List View - runtime error when a field of type Time is displayed
• List View - no display if the Notes field is included
• Move Samples - in a non-unique Freezer, all Aliquots with same Aliquot Number are moved when one is selected for move
• Label Printing - labels do not print in the order they are displayed
• Label Printing - Brady 300 MVP with 1 ml Portrait labels - fields are all left-justified
• Testing Module Results Report - Test Report date is blank
• Search by Scanned Fields - Aliquots not listed in the order they are scanned
• Simple Search - allow <Enter> to launch the search without forcing a click on the <OK> button
• Modify List of Aliquots from Samples Entry screen - tighten up data integrity checks
• User Defined Reports -- allow user to maximize screen size

Version 4.0 PC only

December 18, 2008

User Interface Improvements

• New reorganized menu structure
• Enhanced List Views that are faster, editable, and more configurable
• Recent Activity list available under File Menu
• Window positions remembered for each user
• Picture buttons to enhance usability
• Selectable background color
• Print Screen option available on all forms

Inventory List Views

• Print a list of the data currently displayed
• Export the data currently displayed
• Sort by an unlimited number of columns
• Delete Aliquots from the List View

Search Options

• Select List View format directly on search screen
• Search by comparing the values of two fields (e.g., field 1 is greater than field 2)
• Search for Samples that have a minimum number of Aliquots meeting the search criteria
• Schedule Searches to be performed at login, logout, or specified day and time
• Create a subset of searches called "My Searches"
• Search by Scanned Field maintains the order in which the Samples/Aliquots were scanned

User Defined Fields

• Set color formatting based on a range of values (e.g., set color red if value is <= zero)
• Set default values based on a range of values (e.g., set Qualitative Result "negative" if Quantitative Result is <= 1.5)
• Add "Current User" to the list of available Default Values
• Add "Current System Date" to the list of fields available when building a Calculated Field
• Add parentheses to the Operators column in Calculated Fields to allow building complex expressions
• Allow user to set the number of significant digits for Calculated Numeric Field
• Add user-enterable Tool Tips that will display when a user hovers over a field
• Create Count Field that will calculate the number of Aliquots in each Sample that meets a specified criteria
• Allow the Export and Import of selected User Defined Field configurations in XML format

Group Management

Provide a single interface to assign a group's security level access for:

• Freezer Security
• Owner Security
• Import Formats
• Export Formats
• Inventory List Views
• Entry Screens

Assigning Aliquots

• Allow user to auto-assign positions to a group of existing Aliquots on the Samples entry screen
• Edit list of Aliquots directly without double-clicking an individual Aliquot
• Display Aliquot Lineage as a tab on the Samples entry screen

Label Configuration

• Display label specifications and picture
• Assign label to print based on specific value(s) of selected field

Label Printing

• Add Zebra Z4M
• User modifiable printer settings to adjust for different ribbons, printers, label material

Import Sample Data

• Separate the data validation step so that user can view errors prior to importing the data
• Clearly differentiate types of Imports - Add Samples, Modify Samples, Add Samples with Aliquots, etc.
• Maintain searchable log of all Imports attempted including errors identified and summary data

Configuration Export and Import

Provide an XML Export and Import of specified configuration data:

• User Defined Fields
• Samples Entry Screens
• Inventory List Views
• Batch Entry Screens
• Import Formats

Batch Entry

• Allow unlimited number of Samples fields
• Allow 40 Aliquots fields
• Optionally assign unlimited number of key fields using an imported ASCII file

Version 3.1.09.1

February 28, 2008

Modification

• Compatible with Mac Leopard OSX 10.5. 

Version 3.1.08.1
February 26, 2008

Error Correction

• Problem exporting Aliquots.  Export file was blank.

Version 3.1.08
January 29, 2008

Error Correction

• Import did not create Aliquots correctly.  All aliquots created as Vial #1.

Version 3.1.05
December 7, 2007

Modifications

• Add Shipping Contacts table to contain shipping address information that can be included in Transaction and/or Shipping Manifest.

• Generate a unique shipment (tracking) number and record it with each Aliquot in a shipment.  Allow user to place this Shipment ID on the Aliquots form and to search by it.

• Generate a Globally Unique Sample ID and a Globally Unique Aliquot ID so that Samples and Aliquots shipped between users of Freezerworks will have truly unique identifiers. Allow user to place these fields on forms and to search by them.

• New date format DDMMMYYYY.

Version 3.1.03

October 24, 2007

Modification

• Remove the column for Critical Ranges on the printed Results report.  This will provide more room for the results to print.

Error Corrections

• Correct Freezer Security error wherein Aliquots in Freezers accessible to user were not available in Test Ordering.
• When printing a shipment location worksheet, only the first aliquots appears on the printout.
• Print Location Report generates a runtime error.
• Print Results Reports - adjust for A4.
• Record locking prevents Samples from being Picked Up.  Add in messaging to determine what is locking the Samples record.
• Print Results Reports - Quantitative Parameters are not printing in the defined Display Order.

Modifications

• Add Shipping Contacts table to contain shipping address information that can be included in a Transaction and/or Shipping Manifest.

• Generate a unique shipment (tracking) number and record it with each aliquot in a shipment.  Allow user to place this Shipment ID on the Aliquots form and to search by it.

• Generate a Globally Unique Sample ID and a Globally Unique Aliquot ID so that Samples and Aliquots shipped between users of Freezerworks will have truly unique identifiers.  Allow user to place these fields on forms and to search by them.

• New date format DDMMMYYYY.

Version 3.09
Release October 29, 2007

Error Correction - Import created all aliquots in the same sample as Aliquot #1.

Version 3.08
Release June 21, 2007

Error Corrections

• Web Services - If SSL is enabled in the SOAP Server, then Port 80 will not be open upon reboot on the Freezerworks Unlimited computer. This causes a communication error between FROST and Freezerworks Unlimited.

• Upgrade process - The upgrade to FUL 3.06 incorrectly recalculated any calculated fields that contain non-UDF Sample fields (e.g., Internal Bar Code ID, Sample Creation Date, Owner Name, etc.) as a building block.

• User Defined Field Data - If data was saved in a UDF that was previously configured with a Restricted Dropdown List AND this restricted list was not cleared AND this UDF was changed to "User Modifiable" at a later time, then the dropdown list is not correctly loaded when displaying a sample record. Due to this error, previously saved data looks like it has been deleted.

Modification

• Web Services - The GetSearchServiceFieldDetails search service has been modified to provide the following details about User Defined Fields: Length of string fields, minimum value for date and numeric fields, and values allowed in a string field. Developers who use this search service will need to update their code.

Version 3.07
Release May 17, 2007

Modification

• Additions to the SOAP Server to make development of SOAP clients easier.

Errors Corrected --

•Data file import - Unable to update some aliquots with new data. (E9051)

Version 3.06
Release April 11, 2007

Modification

• When the format of a calculated field is modified, change the content of all existing data.

Errors Corrected

• Batch Entry - The presence of two or more Date/Time fields prevents setting the radio buttons discretely for each. (E8746)

• Batch Entry -- Calculated Field in which one of the building block fields contains a parentheses caused a Syntax Error. (E8792)

• Print Bar Code Labels -- Brady 2-up labels not printing side-by-side if multiple copies are selected. (E8893)

Version 3.05
Release March 27, 2007

Custom Modification -

• Add Brady 2-up labels to the supported labels on the Brady MVP300 printer.

Version 3.04
Release March 14, 2007

• Error Corrected - User could not move Aliquots into the last Rack in each Shelf.  Specific to one user.

Version 3.03
Release March 13, 2007

Modification -

• Configure Brady MVP300 printer to use the 1" x 1" Thermatab markers labels.

Errors Corrected

• Reassign Sample Owner -- if the length of the user name was longer than 20 characters, a runtime error occurred.

• View Samples Audit Trail tab - intermittently receive syntax error regarding non-indexed field.

Version 3.02
Release February 20, 2007

Errors Corrected

Cross table searches sometimes produced erroneous data in the SOAP module.

Changes to Aliquot User Defined Fields not being saved in a small number of very specific cases.

2-up labels on Intermec printer not formatted correctly.

Accessing WSDL for SOAP searches generates an error.

Import creates duplicate Aliquot Number.

Version 3.0.01
Released January 19, 2007

Modification

Ability to use the Brady 300 MVP label printer for specific custom label.

Ability to use the Intermec 3240 for specific custom label.

Ability to import new label specs for the Zebra 2844.

Added individual permission settings for each item on the System Admin menu.

Added a User name and password to enable use of 4D tools

Errors Corrected

Creating a new database: the Error_Codes.txt file cannot be located.
System Admin: Registration Info phone numbers are being scrambled.

View Samples: Intermittent runtime error when viewing Aliquots.

Freezerworks Unlimited version 2.1.09.  June 27, 2006

Error Correction

Freezerworks Unlimited hangs (hourglass displays) when creating new samples if there is an Auto-incrementing, Alphanumeric User Defined Field on the Samples entry format. 

Version 2.1.08. June 13, 2006

Error Corrections:

SOAP Server Module

1. All security settings for Users and Groups were not activated.
2. Full address was not passed to the WSDL file.
3. Newly created User Defined Fields not available in real time. 
4. Security Issue allowed full access to the entire hard disk. 
5. Resource used in the WSDL was not correctly formed.
6. Upgrade method did not run unless user connected via Freezerworks Unlimited Client. 

User Defined Fields - Auto Generating Numbers occassionally generated duplicate values. 

Bar Code Label Printing - Error 5 "There is no table to which to apply the command".  Installing the bar code printers according to the instructions included with the update (Modification described below) will eliminate this error.     

Modification

Bar Code Label Printing - Allow Freezerworks to print to the Zebra 2742, Zebra 2844 and TEC B-572 printers that are connected to other computers on the LAN.  This can be used with both Standalone and Network Freezerworks Unlimited installations.