Purpose
To provide details about the necessary steps to implement the ThermoFisher Nanodrop1000 data connector for use with the Benchling Connect platform.
Introduction
Connectors allow Benchling to read a file generated by an instrument and take inventory actions in Benchling or record measurements. Benchling connectors use Allotrope Simple Models (ASM) where possible. This guide provides a non-ASM approach to Connect instruments with Benchling until ASM models or Benchling ASM converters exist.
Connector guides describe the required file format, Benchling configuration steps, and outcomes supported by the connector. The connector is specific to a single file format and a single type of assay. Your file must meet the requirements described below to be compatible with the instructions that follow. If it does not, it may be possible to adjust your file and the steps to support your instrument’s file format or it may not. Please reach out to your Benchling representative or support@benchling.com for assistance.
File Format Requirement Specifications:
-
Your export file must be a .CSV or .XLSX formatted file with one tab.
- If multiple tabs are present, only the first tab will be processed and others will be ignored.
-
Your ThermoFisher Nanodrop1000 file contains a single data table that either:
- Starts with column headers in row 1 and data in the following rows.
- Starts with headers that are a consistent length. i.e. we can always remove the first n rows and after doing so the data table will begin in cell A1.
- Your data table contains columns (exact names can differ) including:
-
Required* columns:
- Sample Name
- Sample Type
-
Optional columns (examples, but not limited to):
- Abs (absorbance value)
- Detection limit
- Nucleic acid conc.
- The values in the ThermoFisher Nanodrop1000 columns must refer to unique barcode or name values for a plate or container that already exists in Benchling Inventory or that will be created by the run.
Steps within Benchling
From within Benchling, a user must:
-
Enable the Generic FileWatcher data connector on the tenant [internal admin console]
-
Create a FileWatcher Connection schema
-
Configure a FileWatcher Connection
-
Create a (or select an existing) Result schema to structure the data to be recorded
-
Configure a Run schema to accept data from [Connector Name] and records Results
For steps 1 - 3, please reference the Benchling Connect Installation Guide for details related to creating and installing a Gateway and configuring a Connection.
Create Result Schema for Nanodrop1000 data
The Benchling Connect - Nanodrop1000 data connector uses Benchling’s built-in transform steps to structure the information parsed from the Nanodrop1000 file export. The data are processed to trigger corresponding Registry, Results, and/or Inventory actions. Instructions below describe creating a new schema of each kind required. If you want to map to an existing schema instead, review the instructions to be sure they are compatible.
Result Schema fields:
- Sample ID
- Sample Name
- Nucleic acid conc. (ng/uL)
- A260 10 mm
- A280 10 mm
- 260/280
- 260/230
- ng/uL
Configure Run Schema for Nanodrop1000 data
-
Create a new Run schema. Select the Benchling FileWatcher connection schema.
- Click “next”
- Click “+” to the right of “Output file configurations”
- Set a custom name and select:
- “Record results”
-
Under “Result schema” select the results schema you would like to use or “Create new result schema” then “Copy column headers from file” > “From example file”
- Copy your data table from an example file and paste in. Assign the detected column headers to their Benchling purposes.
- Set data columns to “New result schema field”
- Click “Create” result schema then name your result schema and click “Next.”
- You may need to adjust the data types or add fields
- Click “Create result schema”
- Click “Done”
-
If your file does not have headers, skip this step. If your file has headers, click “set transforms:
- Select Type > Extra headers
- In the “Row number of column header” box, type the row number where the data table begins. In the example in the first image above, you would choose “9.”
-
Under “Configure column mapping” choose to specify either “by column order” or “by column name”
- “by column order” assigns the columns to their purpose based on position so if column header names change the run will still work. Additional columns not specified will be ignored.
- “by column name” assigns the columns to their purpose based on exact match to the column header name. Columns not exactly matched will be ignored.
- Set the columns to map to their purpose (typically sample name, container or plate barcode, position, or results schema field values).
- Click “Update” and your run is complete.
- Create a connection to the FileWatcher into which files from this instrument will be saved and add the run you created to your Notebook Entries and templates to select and process the file to take the corresponding actions in Benchling.
Revision History
- 2024/04 Initial Version