Import Samples in a Sample Batch

The import sample method utilizes Excel or an ASCII text file to extract the sample IDs. This is a fast process, especially when you have a large quantity of samples to add to the batch. It does not have limitations on the sample ID type. Using Excel, you can select the range of samples and specify the column from which you want to extract them. Therefore, it is the most commonly used method when extracting a large quantity of data or selecting a specific range of the data at a time.

Activity Steps

1. Add a Sample Batch.

   The Edit Samples screen displays.

2. Add samples using the import option:

   1. In the Edit Sample screen, click Import from the menu.

      The Data Source screen displays.

   2. To import from a text file:

      1. Set Data source to ASCII Text File.

      2. Click OK.

         The AssayNet LIMS screen displays.

      3. Locate the ASCII text file; for example, a csv or txt file.

      4. Click Open.

      5. Click Receive All in the menu to receive all the samples entered.

         The Lab Code is populated for this sample batch.

         Important: If you exit the window before receiving all the samples, you will need to start the whole process again.

      6. Click OK.

   3. To import from an Excel spreadsheet:

      1. Set Data Source to Excel Spreadsheet.

         The Import Spreadsheet screen displays.

      2. Locate the Excel workbook.

      3. Click Open.

         The Import Sample Labels screen displays.

      4. Click the Sample Range icon to select the sample range in the Excel file.

         The selected Excel file opens.

      5. Drag the mouse to select the samples.

      6. Alternatively, you can enter the range in the Obtain Object Range box; for example, $A$1:$A$2, to select cells from 1 to 2.

         1. Click Accept.

            Note: The Field Range option is not in use.

      7. Enter a Prefix if required.

      8. Enter a Suffix if required.

      9. Click Next.

         The Import Sample Labels screen displays.

      10. Click the Add Sample icon to add one sample or click Add All Samples to add all samples.

      11. Click Next.

      12. Click Finish.

      13. Click Receive All in the menu to receive all the samples entered.

          The Lab Code is populated for this sample batch.

          Important: If you exit the window before receiving all the samples, you will need to start the whole process again.

      14. Click OK in the Add Sample Batch screen.

      15. To edit a sample ID after the batch is logged:

          1. On the Job Book, click Sample Batches.

          2. Select the sample batch.

          3. Click Edit in the menu.

             The Edit Sample Batch screen displays.

          4. Click Samples.

             The Edit Samples screen displays.

          5. Select the sample from the main table.

          6. Update the Client ID in the Sample Detail field group.

          7. Click OK.

3. To save the samples as a series, see Save a Sample Batch as a Series.