Export Records
Labii’s export function allows users to export either the current page’s data or a customized dataset with selectable columns, size, and file format.
Last updated
Labii’s export function allows users to export either the current page’s data or a customized dataset with selectable columns, size, and file format.
Last updated
Labii’s export functionality is table-specific and can only be accessed from the table list view. It offers two types of exports: Export Current Page, which allows users to export all data displayed in the current list view, and Export with Customization, which provides flexibility in selecting the number of columns, adjusting the data size, and choosing the desired file format. This ensures that users can efficiently extract the exact data they need in a structured and customizable manner.
Labii allows users to export the contents of a list at the current page into a .tsv (Tab-Separated Values) file for easy data sharing and analysis. Follow these steps to perform an export:
Navigate to the List View – Ensure you are in the table’s list view where the data is displayed.
Click the Export Button – Locate the Export button in the top-right corner of the interface.
Select “Export Current Page (*.tsv)” – From the dropdown menu, choose this option to export all data currently visible in the list view.
Download the File – The export process will begin automatically, and the .tsv file will be downloaded to your device.
The .tsv format is useful for transferring structured data while maintaining easy compatibility with spreadsheet software, text editors, and data processing tools. If you need more customization, consider using the “Export with Customization” option for selecting specific columns, adjusting file size, and choosing alternative formats.
The customizable export enables you to:
The ability to export any number of records. In addition to being able to export one particular page or all records, you can also export specific records.
Choose an output format. Various text files can be exported, such as *.tsv, *.csv, and *.txt. *.json and *.hl7 files can also be exported. *.hl7 is currently under development.
Customize the columns. You can specify which columns to export.
Combine with other tables. Information from other tables can now be exported via the ForeignKey widget. In the case of a biospecimen generated from a patient, when exporting the biospecimen table, you can include the patient's name, age, gender, etc.
Exporting from the List View:
Navigate to the List View – Ensure you are in the table’s list view where your data is displayed.
Click the Export Button – Locate and click the Export button in the top-right corner.
Select “Export with Customization” – Choose this option from the dropdown menu.
Configure Export Settings – A new export page will appear, allowing you to customize the number of columns, file size, and format.
Download the File – After configuring your export, confirm the settings and download the file.
Exporting Selected Records:
Use this option to export only specific records instead of the entire list.
Navigate to the List View – Open the table containing the records you want to export.
Select Records – Check the boxes next to one or more records you wish to export.
Click the Export Button – In the top-right corner, click Export to open the menu.
Select “Export” – Choose this option to proceed with exporting the selected records.
Customize Export Settings – A new export page will appear, allowing you to adjust file format, columns, and data size as needed.
Download the File – Once configured, confirm and download your export.
The following settings can be configured:
Records - Number of records to be exported
Selected records
Current page
All
Data format - Choose what type of data you want to export
*.tsv
*.csv
*.txt
*.json
Columns - The columns to export
Joined tables - Access data from other tables that are joined through ForeignKeys.
You will see a real-time preview table as you change the configuration. This record is shown only as an example. It may not be included in the final export.