Export
Export Labii records to a file
Overview
The export functions are table-specific, and can only be accessed under the table list view.
Labii supports two types of exports:
Export current page - export all data from the current list view.
Export with customization - customize the number of columns, the size, and the type of files you wish to export.
Export current page
The function exports the contents of a list into a .tsv file. To perform the export:
Navigate to the list view
Click the Actions button at the top right
Select the option "Export current page (*.tsv)"
The file will automatically download.
Using a filter or URL parameter will download filtered data.
Export with customization
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.
Column names can be customized. Metadata can be used to change column names during the export process. Multiple metadata labels can be used if you have multiple partners that need to have different column names.
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.
To export at list view:
Navigate to the list view
Click the Actions button at the top right
Select the option "Export with customization"
A new export page will appear
To export with selected records:
Navigate to the list view
Choose one or more records
In the top right corner, click the Actions button
Select the option "Export"
A new export page will appear
Export settings
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
Metadata label - The column metadata can be used to rename a column during export. The original column name will be used if the column metadata is not present.
Joined tables - Access data from other tables that are joined through ForeignKeys.
Export preview
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.
Reformat
Downloading thousands of files takes time. It is possible to reformat a downloaded file with a different data format and column layout after it has been downloaded. Here is how:
Include all columns and export the file in *.json format.
Labii API can also be used to download the *.json file.
You can also use the *.json file created in the backup.
Click the cloud icon to select a *.json file or drag the file into the reformat section
Upon completion of the reformatting process, a new file will automatically be downloaded.
Last updated