Clean Up your Data
Before importing your existing data, you’ll need to quickly clean up your spreadsheets.
- Get an Excel sheet ready with your existing inventory.
- Tip: You can export your Filemaker Pro or Lab Guru databases as .csv files.
- Add a column to your spreadsheet called “ID” and assign it unique ID names. If this is your first sheet, start with 1.
- See the Registry IDs section of Creating New Data in the Bioregistry for more information on file IDs.
Now you’re ready to import your spreadsheets.
- To import files, select the registry button (9 dots) from the left navigation panel. Expand the view by hitting the → so your screen looks like the image below. Click the plus sign and select Import Entities from Schema.
- In the new window, select the schema (e.g. Bacterial Strain) and registry collection (personal or organization) for your import. If importing to a personal collection, you can designate the desired folder. Click Next when complete.
- To start the import, drag in your Excel file or search for the file on your computer and click Next.
- Assign a type for each column in your sheet. The importer will parse through your sheet and import each column. You have 6 types to choose from:
- ID for Org Collection: ID of the file. Each sample must have a unique ID number.
- Alias: If your lab uses multiple names for an entity, use this type. The file’s alias can be found via search queries
- .Schema Field: Required metadata for a file. Hover over the Schema Field type and select the specific schema field that this column represents. In the example below, the column “Resistance” represents the schema field “Antibiotic”.
- Note: The options in the Schema Field dropdown correspond to the Schema Fields in the registry settings.
- Custom Field: Optional metadata for a file. Some entities in your inventory may have extra columns that are not crucial for tracking, but still need to be associated with a file.
- Description: Fields from this column go into the description tab of file.
- Ignore: The Benchling importer will ignore this column.
- Bases: This example describes importing files from a custom inventory-type schema. If importing files from a sequence-type schema, the Column Type of “Bases” must be specified. The bases will be used to generate sequence files for each imported entry.
Import columns as file links to access plasmid maps and lineages.
- Select the appropriate schema field and specify all folders to search for links.
- Example: All my lab’s plasmids are located in Benchling in a folder called Example Project. The bacterial strains I’m importing all reference plasmids in this folder; Benchling will automatically create a hyperlink to the plasmid map in the “Plasmid” schema field section of each strain.
Click Next and the Benchling will check for any errors.
Click Import to import your inventory into your bioregistry.