Batch Upload Results

Batch Upload Results (To Patients via SMS / Email, to Dr.Chrono)

Link: https://retool2.cityhealth.com/apps/Encino Lab/Lab Tools - Result Delivery

What does this tool do?

Once the testing instrument is done processing a batch of samples, the output for the results.csv is the Lab Barcode and the Result. This tool takes the CSV from the instrument, looks up the lab barcode in our database (which should have been linked previously via the Batch Barcode Link Tool or added individually by the Specimen Barcode Lookup and Create Tool

Instructions

  1. Download the CSV results for the specific time interval via Roche Infinity server

  2. Open the Result Delivery retool

  3. Click the upload box, and find the file on your computer

    upload3.png

    upload2.png

  4. Once you select the file, the retool should separate the file into rows in the Barcode Table

    validate.png

  5. Click the blue Validate button at the bottom to check the database for if the specimen barcodes are in our database. The results should be separated like this:

send_results.png

  1. How to interpret the tables:
    1. Results Table - what is remaining in the barcode table are the specimen barcodes found in our database, and are ready to be linked to the lab barcode
    2. Barcode Not Found - these were not found in our database, so needs to be investigated or followed up with ops in order to link the two codes. This should have been resolved during the batch barcode linking process, but will also show here
      1. See instructions on how to resolve missing specimen barcodes here
    3. Results Already Sent - these have been already linked in our database, so it won’t be linked again.
  2. Hit the blue Send Results button to link the remining barcodes. This will only be blue if there are results to link.
  3. After this is done, try uploading the same csv file and validating, to ensure all the barcodes are either are linked or in the missing specimen column.

Commonly Asked Questions

What if I need to overwrite existing linked barcodes?

There is now an override existing link as a toggle on the right side of the tool:

common.png

Please use carefully and ensure that the barcodes that are being overwritten require it, otherwise there could

Back to top