Import
Use Import function to create and update data in bulk

Overview

With Labii's import function, you can create and update records for multiple columns in bulk.

File preparation for import

File format

*.tsv, or *.xlsx file is supported. *.csv is not allowed because , is used as separate for multiple choose.
*.xlsx file will only use data from the first sheet.

Import file template

Import templates are not required for the import. Labii is capable of reading any tabular file. Columns can be selected for import, as well as for where they should be imported.
For the preparation of the import document, please follow these guidelines:
  1. 1.
    The first row serves as the title.
  2. 2.
    To ignore a row, use # at the beginning.
  3. 3.
    Match and update existing records using Unique IDs (UIDs). Unmatched UIDs will be ignored and a new UID will be generated. By using this method, you can reuse existing UIDs if you create records by mistake.
  4. 4.
    For the MultiSelect or ForeignKeys widget, use , to separate multiple values.
  5. 5.
    Use UID or name for ForeignKey widget.
  6. 6.
    If a column is using Boolean widget, use true if it is true and false if it is false.
  7. 7.
    Use YYYY-MM-DD for Date widget. This column can be configured to display the date in a different format.
The file will be processed locally and will not be uploaded. Make sure your data has been successfully imported before deleting it.

How to use

The import function is only available in the table list view. Click the Import button in the table list view to begin importing.

Step 1: Select file

During the importing process, the first step is to select a file that you wish to import. The projects that are going to be assigned also need to be specified.
Workflows
After the import has been completed, select workflows to be executed. Use this field if you want to create 5 vials when a sample is created.

Step 2: Match file headers

Once clicked Submit button, you will be direct to the second step of importing: match file headers with column names.
This form allows you to specify which fields to import and where they should be imported. Every field in the list represents a header from the file provided. The dropdown menu represents the columns defined in the Labii.
To import the value from the file into a particular column, choose an option from the dropdown menu. The options with the same header as the file will be selected, so please review the headers to ensure all are correct.
To disregard a column to be imported, click CLEAR.
The UID must be included and selected if you want to update existing records.
You can select Metadata multiple times, all headers will be included.

Execute workflows after importing

Workflows can be executed after the import has been completed. Use this function if you want to create 5 vials when a sample is created.
  1. 1.
    You can create one or more workflows. You do not need to include any triggers.
  2. 2.
    If you need to create multiple records within a workflow, prepare columns with "," to separate values.
    1. 1.
      The column title must match the column name.
    2. 2.
      Use "," to separate values for multiple workflow actions. In the case where only one value is provided, it will be applied to each workflow action item.
    3. 3.
      For foreignKey replacement, use UID.
    4. 4.
      To replace the serial number, you can also use {{INDEX}} or {{LETTERINDEX}}.
    5. 5.
      To create a serial of storage coordinates, "A1,A2,A3" is identical to "A{{INDEX}}".
  3. 3.
    Choose one or more workflows to execute at the first step of importing
  4. 4.
    To pass the column to workflow actions, select Workflow data in step 2.
Copy link
On this page
Overview
File preparation for import
File format
Import file template
How to use
Step 1: Select file
Step 2: Match file headers
Execute workflows after importing