Unlock the potential of your data with ease. Install our free Sample Batch Import add-on from the Marketplace and experience the seamless import of table-based formats like Excel spreadsheets.
Marketplace Add-on installationeLabNext offers a wide range of add-ons and integrations to enhance the functionality of your digital lab platform. The categories include biobanking, utilities, productivity, and reporting. The eLab Marketplace is conveniently available within the eLabNext platform, making it easy to find, install, and start using add-ons immediately. To install an add-on, navigate to the Marketplace tab and choose "Install" for the add-on you'd like to add. Depending on the add-on or your organization-wide settings, some add-ons might already be installed for you by default. |
After installing the Sample Batch Import add-on, go to Inventory Browser and select "Import Samples" from the sample dropdown.
In the next step you need to specify the following import settings:
- Number of samples – the number of samples you want to import. The number of samples may be limited depending on your hosting solution or organization, typically ranging from 400 to 1000. For more information, please contact us.
- Storage locations – location start position of the samples you want to imported.
- Sample type – select the sample type of the samples you want to import.
- Fields to import – select the sample type fields that you want to import (required fields cannot be unchecked)
To import samples in multiple locations select multiple locations until the number of samples that fit the compartments matches the number of samples you want to import, all samples will be imported in the chosen compartment orientation.
After setting the import settings, click on Start Import to continue. A batch import table will be opened that is tailored to the specifications you entered. You can copy and paste data from Excel in the following ways:
- Paste from Excel – Click on the Past from clipboard button to open a window to paste all data
- Paste all data from Excel – Copy all data in the Excel file and select the cell the first cell in the Sample Name field and press CTRL + V to paste
- Paste data per column – Copy the data of one column in the Excel file and select the first cell in the corresponding import table and use CTRL + V to paste
When importing samples using the batch import option, it's important to ensure that the data is formatted correctly. When a copy from Excel is performed ensure that the order of fields in your eLabNext import window matches the order of fields in your Excel sheet.
Below, you can find additional information on how to import data types into various sample type fields.
-
Open text fields – can contain any data without further restriction in format
Numeric fields – requires an input of a numeric value (for decimal numbers use the . (dot) as the separator) - Date fields – requires input in the same format as your account settings
- Date and time fields – requires input in the same format as your account settings
- Option fields (checkboxes, drop down and radio button) – requires input that corresponds exactly with one of the value options (also case sensitive). For checkboxes with multiple options, use the comma as the separator)
- File Attachment fields – requires input in the format of filename.ext (note that the file should first be uploaded in the File Storage to allow linking)
- Sample Link fields– requires input to correspond with the sample name of the sample to be linked (it will link to the first sample found in the system in case of more than one sample with the same name is found). To link a specific sample use the sample link using the following format: SampleID:123456
After pasting data, click Import to add the sample batch to your inventory.