Updating Sample Portion Details from External Data

Overview

A sample portion's details can be updated by uploading its current location, single-capacity container type, sample handling action details and notes from a scanner or file. This allows for quick update of sample portions without having to enter the details manually.

Process

The data comprises the bar code, location code, single capacity code, sample handling code and notes. For example:

ABC.002.007|02_PREP|PACKET|STORAGE_60|Load from file 1
ABC.002.008|02_PREP|PACKET|STORAGE_60|Load from file 2
ABC.002.009|02_PREP|PACKET|STORAGE_60|Load from file 3

To bring in data from a scanner, the data collected by the scanner software is copied to the clipboard and pasted into a multi-line text area opened in the CCPRTN—Portion application, so that it can be edited before it is uploaded.

When an upload from a scanner or file is triggered, the system parses the text to extract the portion identifier and optional location, single-capacity container type, sample handling action and notes, as follows:

  • Portion data is delimited by a | (pipe) character, and consist of:
    • Portion identifier—Refer to the portion identifier. Leading zeros are removed from the parsed data before updating the portion.
    • Location Code—Optional. Changes to the location results in changes to relevant dates, users and any related sample preparation scheme's Workflow Status.
    • Single-capacity Container Type Code—Optional.
    • Sample Handling Code—Optional. Changes to the sample handling action results in changes to relevant dates, users and due dates.
    • Notes—Optional.
  • Each new line is a separate bar code entry.

For each bar code entry, where a sample portion matches the specified Job Name, Sample Name and Portion Code, then its Location Code, Single Capacity Container Code, Sample Handling Code and Notes are updated accordingly.

If nothing is provided for an optional field then the related portion's field remains unchanged.

Example of parsed scanner text:

Text Bar Code Location Code Single Capacity Code Sample Handling Code Notes

B_58909_JOB.0000000341_1.001|LOCATION01|SINGLE01|SHC1|Some Notes

B_58909_JOB.0000000341_1.001

LOCATION01

SINGLE01

SCH1

Some notes

B_58909_JOB.0000000341_1.002||||Some Notes

B_58909_JOB.0000000341_1.001

 

 

 

Some notes

B_58909_JOB.0000000341_1.003|LOCATION02|||Some Notes

B_58909_JOB.0000000341_1.001

LOCATION02

 

 

Some notes

B_58909_JOB.0000000341_1.003|LOCATION02|||Some Notes|With a Pipe in it

B_58909_JOB.0000000341_1.001

LOCATION02

 

 

Some notes| With a Pipe in it

B_58909_JOB|LOCATION02|||Some Notes|With a Pipe in it

B_58909_JOB

LOCATION02

 

 

Some notes| With a Pipe in it

B_58909_JOB|LOCATION02||

B_58909_JOB

LOCATION02

 

 

 

B_58909_JOB.0000000341||SINGLE01|

B_58909_JOB.0000000341_1

 

SINGLE01

 

 

Load sample portion details from a scanner

Load sample portion details from a file

Upon Updating Sample Portion Details

  • Any attempt to clear the sample portion's Location Code, Sample Handling Code or Single-capacity Container Type Code is ignored.

  • If a portion's Location Code is updated, then the portion's Sample Handling Code defaults to the location's Default Sample Handling Code, upon which, the location's sample preparation action determines whether the related sample scheme's Workflow Status remains unchanged or is set to Not Started, Started or Completed.

    However, where a portion is associated with a sample in a cancelled job, when the portion's Location Code is updated that could potentially mark a sample preparation scheme's Workflow Status as Not Started, Started or Completed, then NO changes are made to the associated sample scheme, sample, job scheme or job's Workflow Status.

  • When a portion's Sample Handling Code is updated, then the sample handling's Duration determines the portion's sample handling Due On date-time, the sample handling's Set portion Is Active flag sets the portion's Is Active flag accordingly, and the portion's Started By and Started On are set to the current user and laboratory date-time, respectively.