There are three ways to import container information from a spreadsheet:
- Creation of containers during registry entity upload (registry item does not exist yet
- Standalone creation of containers (registry item already exists)
- Bulk Transfer Data (moving existing registry item between containers)
Method 1: Creation of containers during entity upload
If you wish to import registry entities and submit their locations during upload, you can do so through the Import Entities link on your Registry page as shown below:
Select the "Create Containers with Input Batches" (or entities, depending on your sample type). Note: If you don't see this option, you will need to configure your sample type for your Registry Schema in the Registry Settings page.
In order to create containers at the same time as you import your entities into Benchling, you will need several additional columns in your spreadsheet:
- Box Barcode - A column that contains the barcode of the box(es) where your containers will be transferred into.
- # of containers - the amount of containers you will be importing into Benchling's box
- Location Position - the position where your container will be stored in the box. There must be enough positions listed to match the # of containers, and these positions must not be filled up.
Here is an example:
Method 2: Standalone Creation of Containers
Creating containers is an integral part of this process, as all sample entities/batches must be stored in a container.
1). Creating containers:
First create empty containers and assign these containers to a specific location.
- Open the Storage section of the registry and select the “+” button, choose Container → Import Containers.
- Select the Container schema to be imported.
- Fill out the Project field if you want to set permissions on who can read/write over these containers.
- If a Project is not specified, then the storage items default to the same permissions as its registry.
- Transfer the container information from the spreadsheet into Benchling's data importer.
The spreadsheet should contain:
- A column for the Box (or Location) barcode where the containers should be stored.
- A column for the position (e.g. A1, A2, and etc.) within the Box where the container should occupy.
2). Filling empty containers:
Afterwards, we will fill these newly-created empty containers with registered batch samples using a spreadsheet.
- Batch samples must exist before being transferred into their containers (preferably, these entities and batches have also been registered).
- To fill containers, open the Storage section of the Registry and select “+” → Import Transfer Data.
- Open the spreadsheet containing the batch information to be transferred into the containers.
The spreadsheet should contain these fields (see example below):
- The ID of the sample batch (Batch ID) that will be transferred into the container.
- The volume AND volume units of the sample batch to be transferred.
- The concentration AND concentration units of the sample batch to be transferred.
- The barcode of the destination container.
- Copy the information into Benchling's data importer and press Next.
- Verify that the column names and column types match up.
- Press Next to transfer samples batches into their respective containers.
Once inside their containers, you can look up their sample information by clicking into the wells of the box and subsequently clicking into the highlighted container.
Method 3: Import Transfer Data
Importing transfer data allows you to transfer your samples in bulk from their initial locations to a final location (and volumes, concentrations, etc.)
To import transfer data, go to the Storage section and select "Import Transfer Data" from the + menu.