Use Import function to create and update data in bulk
With Labii's import function, you can create and update records for multiple columns in bulk.
File preparation for import
*.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:
The first row serves as the title.
To ignore a row, use # at the beginning.
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.
For the MultiSelect or ForeignKeys widget, use , to separate multiple values.
Use UID or name for ForeignKey widget.
If a column is using Boolean widget, use true if it is true and false if it is false.
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.
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.