Other Tools

Topics:

Other Tools

Updating Shipment Vial IDs

The Update Ship Vial ID tool in a Data Entry Add batch editor is used to re-link vials in the batch which have been transferred from a Shipment batch. When a shipment vial is transferred to Data Entry, a unique identifying ID is assigned to link the two in the Shipment Vial ID field. Sometimes this link can be broken, for instance if the data entry row is removed from the batch.

A Level 2 warning will be displayed if the Current Label or BSI ID value for a row in Data Entry matches an uncommitted vial in a Shipment batch and a link via the Shipment Vial ID does not exist.

  • A system preference is available to change this warning to an error, preventing users from committing the data without resolving the error.

To update the Shipment Vial ID:

  1. First, the Shipment Vial ID warning or error must be displayed in the error table.
  2. Highlight the vials with this error or warning applied to them.
  3. Select Update Ship Vial ID from the Tools menu.
  4. The Updating Data dialog will open, displaying the number of rows which can have this action performed on them out of the total number of highlighted rows.
  5. Select Yes to continue, or select No to cancel the operation.

Compare Data in Editors

The data in two data entry batches can be compared without committing the batches by using the Compare data in editors tool.  Before this tool can be accurately used, several conditions must be met:

  1. The editors for both batches must be open.

  2. Both editors must have the same number of rows and columns.

  3. All columns must be visible.

  4. The columns must be displayed in the same order.

  5. The tables must be sorted in the same order.

Once these conditions have been met, selecting Compare data in editors from the Tools menu in one of the batches will compare the data in both editors.  Any discrepancies between the batches will be displayed as errors in the editor.

Example: Dr. Banner needs to add 500 new specimens to BSI for his study on the lasting effects of intense anger on the brain. He uses Mass Change and Change Values to all known data on these specimens. After entering the data, he is concerned that he may have made a mistake, so he creates a second batch using the same information and uses the Compare Data in Editors tool. As a result, Dr. Banner realizes that he entered an erroneous material type for 5 of his specimens, which he can now correct.

Compare Data with Shipment Batch

From the Data Entry Editor, the current data can be compared to the data in the corresponding Shipment. The corresponding shipment is the one whose Shipment ID matches the Date Entry Batch Shipment ID. Only vials sent from the Shipment to that Data Entry batch (have a Shipment Vial ID) will be included. Access this tool from the editor’s Tools menu.

A System Preference is available to automatically run this tool when the Commit button is selected.

Export Batch to a Text File

From the Data Entry Editor, a batch can be exported to a comma-delimited text file. The first line of the file contains the Batch ID.  The next line contains Data Entry Editor column headings separated by commas.  The remaining lines of the file contain specimen data separated by commas.

To export a batch:

  1. Open the batch in View mode or Edit mode. The Data Entry Editor will open.

  2. Highlight Export to text file on the File menu.  A Save dialog will open.

  3. Use the Save dialog to select a location and name for the text file that will be created.

  4. Press the Save button.