Import Instrument Run Data

Results obtained from instruments can be imported into AssayNet LIMS using various methods, including manual entry in the Data screen on the Instrument Run page. For example, results from AA instruments stored in an Access database are automatically loaded into LIMS when the Data screen is opened. Or they can also be automatically loaded using commands that extract the results file directly with the Reading ID. In other cases, upon opening the Data screen, AssayNet LIMS prompts the Import Spreadsheet + Instrument Name screen, allowing you to locate and import a results file.

In some instances, AssayNet LIMS automatically locates the result files when the instrument exports results into a single file for each batch. The system matches the sample IDs and schemes in the result file with those in LIMS. For this process to work, the Auto Import setting in the Analysis Code must be configured and the correct file path must be specified.

This activity describes how to manually enter sample data in the Data Capture screen or record weights using a connected balance. It also describes available options for each sample in the run, such as adding an NCS code, entering comments, or placing a sample on hold. The Data Capture screen in AssayNet LIMS provides tools to audit and trace changes made to sample results, ensuring compliance with regulatory requirements.

Activity Steps

On the Job Book screen, click Instrument Runs.
Locate and select the Run ID.
Alternatively, use any AssayNet LIMS page to locate and select the corresponding Batch Code or Job Number.
1. Click Working View, then locate and select the Run ID.
Click the Data command button.

The Data Capture screen displays.

Note: If the Prompt for File option is enabled in the analysis code and instrument configuration, the Import Spreadsheet + Instrument Name screen displays immediately after opening the Data screen. If the Auto Import option is enabled, the system attempts to retrieve the results automatically. For more details, see Add a Template to an Instrument.
To import data from an Excel file when prompted:
1. Locate and open the result file in Import Spreadsheet + Instrument Name.
  
  The system loads the results for each sample ID and scheme, matching them with the records in LIMS.
  
  Note: In the Configure an Import Template activity, you can define how AssayNet LIMS matches sample IDs and schemes—either by Position or Text Value. The Position option may pose a risk if the sample order in the file does not match the system, making Text Value the preferred method.
2. If the system does not prompt for a file or retrieve results automatically, close and reopen the Data screen to retry the process.
3. Alternatively, to manually trigger an import in the Data screen:
  1. Click Import and set the Data Source to Auto.
  2. Click OK.
To manually enter data:

Note: Instrument runs with approved results have the Mode option disabled, preventing changes. To modify approved results, the run must first be unapproved. For instructions, see View and Approve Results.
1. Set the Mode to Manual.
2. Click the first sample ID row under the analyte scheme name column header.
3. Enter the value for the first sample (ensure the correct Analyte Scheme is selected in the top-left window).
4. Press Enter to move to the next sample row.
5. Repeat step 6 c-d to enter values for all samples.
6. Select the next Analyte Scheme (if applicable) and repeat steps b-e.
7. Alternatively, to copy and paste values into the Data screen:
  1. Copy the values from an external file or another instrument run.
  2. Click and drag to the left of the Line column to select the cells where data will be pasted.
  3. Click the Paste icon.
8. When all samples share the same value:
  1. Enter the value for the first sample.
  2. Click the Fill Down icon.
    
    The value is copied to all samples.
To enter weight values from a connected balance:

Note: A balance must be set up and linked to the station where weights are captured. If the balance is correctly communicating with AssayNet LIMS, the Port Status displays as Open in a green box. For more information, see Instruments.
1. Set the Mode to Auto.
2. Click the first sample ID row under the analyte scheme name column header.
3. Press Enter or use the balance’s dedicated button to send the weight to the cell.
  
  The weight is entered, and the next row is highlighted.
4. Repeat step 7 c to enter values for all samples.
5. Select the next Analyte Scheme (if applicable) and repeat steps b-d.
To add an NCS code:
1. Right-click the sample ID and select Add NCS Code from the menu.
  The Add NCS Code screen displays.
2. Select an NCS Code.
3. Click OK.
To add a comment:
1. Right-click the sample ID and select Comment from the menu.
  
  The Sample Comment screen displays.
2. In the Comments window, click New.
3. The Add Comment screen displays.
4. Update the Comment Date if required. Defaults to the current date.
5. Update the Time if required. Defaults to the current time.
6. Enter a Comment.
7. To create multiple comments from the same screen:
  1. Press Ctrl+N.
    The previous data entries are temporarily saved.
  2. Update the fields as required.
  3. Click OK.
8. Alternatively, to select a pre-configured comment:
  
  Note: A pre-configured comment must already exist.
  1. Click Select.
    
    The Report Comments screen displays.
  2. Select the Comment.
  3. Click OK.
9. Click Close.
To hold a sample:
1. Right-click the sample ID and select Hold from the menu.
  The sample is highlighted in red.
To view and trace sample result changes:
1. Right-click the sample ID and select View Audit.
  The Audit History screen displays relevant data.
To validate and approve final results, see View and Approve Results.