Labii Documentation
HomeFree SignupFree DemoContact Us
  • Getting Started
    • Introduction
    • Quick Start
  • User Guide
    • Interface
      • Side Menu
      • Views
    • Add Record
      • Add a project
      • Add a blank record
      • Add records in bulk
      • Add a record from a template
      • Add record(s) from file(s)
      • Add a template
    • Record List View
      • Table List View
      • Project List View
      • Row List View
      • ❗Import Records
      • Export Records
      • Bulk Operations
        • Bulk Edit Columns
        • Bulk Edit Sections
        • Bulk Print Detail
        • Bulk Print Labels
        • Bulk Print Barcodes
        • Bulk Print QR Codes
        • Bulk Download
        • Use Selected to Add Blank Record
        • Use Selected to Bulk Add Records
    • Record Detail View
      • Columns
      • Sections
      • Notes
      • Signers
      • Versions
      • Activities
      • Visitors
      • Permissions
      • Section
      • Actions
        • Sign
        • Print
        • Share
    • Navbar
      • Search
        • Global search
        • Search at list view
        • Search query
      • Scan
    • Side Menu
      • Dashboard
      • Calendar
      • Notifications
      • Reload Organization
      • Switch Organization
      • Change Data Center
    • Accounts
      • Authentication
      • Setup an account
      • Create an account
      • My Profile
    • AI Integration
      • Prompt box
      • Prompt template
      • ProtocolGPT
      • AI in Widgets
      • Use cases
  • Admin Guide
    • Organization
    • Backups
    • Personnel
    • Certifications
    • Teams
    • Projects
      • Members
    • Applications
    • Tables
      • Columns
      • Sections
      • Filters
    • Workflows
    • Widgets
    • Subscriptions
    • Credits
    • Invoices
    • Single Sign On
      • Google G Suite
      • Okta
      • OneLogin
      • Microsoft Azure
    • API Keys
  • Widgets
    • Overview
    • Column Widgets
      • Form
        • Text inputs
          • Text
          • MultilineText
          • RichText
          • Number
          • RangeUnit
          • Email
          • Phone
          • Secret
          • Link
          • Address
        • Boolean
          • Checkbox
          • Switch
        • DateTime
          • Date
          • Time
          • DateTime
          • Appointment
          • TimeStamp
          • Timezone
        • Dropdown
          • Select
          • MultiSelect
          • ForeignKey
          • ForeignKeys
          • Member
          • Members
        • File
          • Files
          • Image
          • File Path
          • File Size
          • File Antivirus Status
      • Barcode
        • Barcode
        • QR Code
      • Calculation
        • Formula
        • Numbering
        • RowCount
        • Consumption
      • Integration
        • API
          • API
        • Dropdown
          • API ForeignKey
          • API ForeignKeys
      • Column
        • Record Citation
        • Column Citation
        • Column Data
        • Column Addition
      • Regulation
        • Signature
          • Signature
          • Open Signature
          • Signature Status
      • ❗Chemistry
      • ❗PubMed
      • ❗Device
      • ❗Integration
      • Advanced
        • Subtitle
        • Rating
        • Nested Fields
        • Storage
        • Storage Coordinates
    • Section Widgets
      • Office
        • Text
          • Plain Text
          • CKEditor Classic
          • CKEditor Balloon
          • CKEditor Document
          • CKEditor Restricted
          • CKEditor Classic Controlled
          • Code Editor
        • ❗Table
        • File
          • Files
          • File Preview
        • Google Drive
        • Drawing
        • G Suite
        • Microsoft Office
      • Data Display
        • Columns
          • Columns
          • Metadata
        • Sections
          • Section Display By Record
          • Section Display By ForeignKey
        • Record List
          • Record List
          • Record List by Column
          • Record List by ForeignKey
          • Record List by Query
      • ✅Regulation
        • Signers
        • ✅Audit Trail
          • ✅Activities
          • Versions
          • Visitors
      • Process Management
        • Flowchart
        • Steps
      • Diagram
        • Mermaid
        • Gantt Chart
        • Stage Flowchart
        • Relation Flowchart
      • Reference Manager
      • Biology
        • Molecular Biology Suite
          • Plasmid Editor
          • Open Vector Editor
        • Microplate
          • 6-Well Plate
          • 12-Well Plate
          • 24-Well Plate
          • 48-Well Plate
          • 96-Well Plate
          • 384-Well Plate
          • Flexible Well Plate
        • Sample Aliquoting
        • Assay
          • ELISA Standard Curve
          • ELISA Qualitative
          • Dose Response Curve
        • Protein
          • MolStar
          • RCSB Saguaro
        • Bioinformatics
          • QUiCKR Analysis
          • CRISPResso2
      • Chemistry
        • Chemical Formats
        • Chemical Drawing
        • Chemical Analysis
        • Chemical Reaction
      • Combination
        • Clinical Genomicist Workstation
      • Productivity
        • ✅Calendars
          • Calendar
          • Scheduling
        • Automation
          • Workflows
        • Ungrouped
          • Storage Map
        • Table of Contents
        • Communication
          • Email Template
          • Notifications
          • Comments
        • Barcode
        • ToDo
        • Timer
      • Report
        • Record Summary
          • Record Summary
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Custom Input Charts
          • Data Visualizer
    • Dashboard Widgets
      • Labii
      • Shortcut
        • Applications
        • Links
        • Filters
      • Productivity
        • Office
        • Flowchart
        • Section
        • Project Management
          • ✅Tasks
        • Summary
      • ✅Reports
        • Record Summary
          • Record Summary By Date
          • Record Summary By Tables
          • Record Summary By Projects
          • Record Summary By Users
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Matrix
          • Record Count By Filter
        • Audit
          • Storage Audit
      • Integration
        • Quickbooks
          • Quickbooks Customers
          • Quickbooks Accounts
          • Quickbooks Items
          • Quickbooks Invoices
  • API
    • Concepts
      • How to get token from Labii ELN & LIMS
      • How can I load Labii data from API into DataFrame
    • Methods
      • Authentication
      • Notification
      • Organization
      • Personnel
      • Team
      • Organization Widget
      • Statement
      • Backup
      • Project
      • Member
      • Table
      • Column
      • Filter
      • Row
      • Cell
      • Section
      • Activity
      • Version
      • Visitor
      • Workflow
      • Step
      • Widget
    • Variables
    • SDK
      • API Client (python)
      • API Client (javascript)
      • SDK (python)
      • SDK (javascript)
      • Examples
  • Applications
    • Electronic Lab Notebook
      • ELN for Research and Development
      • ELN for Production
      • ELN for ELISA Data Analysis
      • ELN for Dose Response Curve
    • Process Management
      • ❗Report creating process in diagnosis testing
      • ❗Email follow up process in CRM
      • ❗Management of the purchasing, approval, and ordering processes.
    • Sample Management
      • Sample Receiving
      • Track sample consumption
      • Aliquots Management
    • Equipment Management
      • ❗Equipment Scheduling
      • ❗Equipment Maintenance
    • Inventory Management
      • Barcode System
      • Stock Checkin and Checkout
      • Storage Management
      • ❗Purchase Management
    • Laboratory Information Management System
      • LIMS for Sample Testing
      • LIMS for NGS
    • Customer Relationship Management (CRM)
      • Quickbooks Integration
    • Document Management
    • Chemical Registration
    • Mouse Colony Management
    • Diagnostic Testing
    • Diabetes Tracker
    • Project Management
      • Task Management
      • How to manage research goals
    • Reference Management
    • Training Management
  • Support
    • Overview
    • Documentation
    • YouTube
    • Videos
    • Tickets
    • Chat with us
    • Schedule a meeting
    • Take a survey
    • Resources
    • Download
    • Blogs
    • FAQ
    • Other
      • Guidelines for Preparing Documents on Research Needs for Labii Configuration
Powered by GitBook
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
  • Update existing records
  1. User Guide
  2. Record List View

Import Records

Use Import function to create and update data in bulk

PreviousRow List ViewNextExport Records

Last updated 4 months ago

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. The first row serves as the title.

  2. To ignore a row, use # at the beginning.

  3. The Unique IDs (UIDs) are used as a means of matching and updating existing records. If there are any UIDs that do not match, they will be ignored and a new UID will be generated. In the event that you create records by mistake, you can reuse existing UIDs.

  4. If you would like more information on how to prepare data for a particular column, please refer to the Import value of each column widget.

    1. For the MultiSelect or ForeignKeys widget, use , to separate multiple values.

    2. Use UID or name for ForeignKey widget.

    3. If a column is using Boolean widget, use true if it is true and false if it is false.

    4. Use YYYY-MM-DD for Date widget. This column can be configured to display the date in a different format.

  5. It is important to use the same column name as that of the workflow action table when preparing data for workflow.

    1. To separate values for multiple workflow action items, use the , symbol. As an example, you might want to use 10,20 in order to create two aliquots with a volume of 10 and 20, respectively.

      1. It should be noted that if only one value is provided, all workflow items will use the same value. As an example, you could use 10 to create two aliquots of the same volume that are created by the workflow.

    2. If you want to get the numeric id in order, use the {{INDEX}}. As an example, use A{{INDEX}} in order to create storage coordinates for two aliquots that have been segregated into A1 and A2.

    3. If you would like to get letter IDs in order, use {{LETTERINDEX}}. Acceptable range: A to ZZ

The file will be processed locally and will not be uploaded to the server. You should ensure that your data has been successfully imported before deleting it.

How to use

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.

If the title row is located in a row other than the first, kindly indicate the row number where the title row can be found. Once you provide this number, all rows preceding the title row will be disregarded.

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.

  • To pass data to the workflow, you can select the Workflow data multiple times.

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. If you need to create multiple records within a workflow, prepare columns with "," to separate values.

    1. The column title must match the column name.

    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. For foreignKey replacement, use UID.

    4. To replace the serial number, you can also use {{INDEX}} or {{LETTERINDEX}}.

    5. To create a serial of storage coordinates, "A1,A2,A3" is identical to "A{{INDEX}}".

  2. Choose one or more workflows to execute at the first step of importing

  3. To pass the column to workflow actions, select Workflow data in step 2.

Update existing records

Using the import function, you can also update multiple columns for multiple records at the same time. You only need to match the UID column with the UID field to enable it to work.

If you happen to import the same batch of data twice by mistake, you can use the UIDs of the duplicated records with the new imports, and the new records will use the old UIDs from the previous import.

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

You do not need to include any triggers.

❗
table list view
You can create one or more workflows.