The Import page is your gateway for bringing data into the app. Whether you're importing timeseries data, run data, event notes, or file attachments, the tools provided here allow you to upload files, making them available for your analysis. Navigate to the 'View History' page for a detailed view of historical file uploads.
Option 1: Data from File
Upload bioprocess data from files
Option 2: Other Files
Upload files as run attachments
Option 3: View History
View historical file uploads
Option 1: Data from File
This is the primary method for uploading bioprocess data from files. Pick a file and choose a mapping template from the list that supports the structure of your data. The mapping ensures that your data is imported correctly into the app. Press 'Start Import' to initiate file ingestion.
Step 1: File Picker
Select a file from your computer using the File Picker. Supported file extensions include .csv, .xls, and .xlsx. You can upload multiple files at once, as long as they share the same file structure. It is recommended to carefully review each file before ingestion to avoid ingestion of faulty data.
Step 2: Mapping Picker
Select a mapping template that best fits your data structure. Several mappings are available to support the following data types: Run Data, Timeseries Data, or Run Events. Custom mappings can be added to list upon request. Refer to the mapping example in the top right corner of the screen or consult the Mapping Guide below for more information on a particular mapping.
Step 3: Settings (Timeseries Data Only)
When importing timeseries data, you have the option to either 'merge' or 'replace' existing datasets. Choose 'merge' to update an existing dataset by either overwriting or appending data. Alternatively, select 'replace' to discard the existing dataset for a given metric and replace it entirely with the imported data.
Step 4: Start Import
Click the 'Start Import' button to initiate file ingestion. This will direct you to the 'Importing' page where you can review 'Import details' for more information on ingestion status. Depending on the file size, file ingestion may take up to several minutes to complete.
Step 5: Ingestion Evaluation
Step 5.1: Successful File Uploads
Upon file ingestion, ensure data imported into Invert meet your expectations. Click 'Runs' or 'Metrics' for a comprehensive overview on the imported data. Consider editing and re-uploading files to update or replace data inside the app as needed.
Step 5.2: Failed ingestion attempts
Failed file ingestions may occur if the source file contains unexpected incomplete data or the file structure is not supported by the selected mapping. Consult the error log on the 'Importing' page for more details and ensure the file meets the mapping criteria. Consider reaching out to Invert staff for additional support.
Mapping Guide:
Run Data
Description: Metadata associated with a run
Example: LOT#, Reactor ID, Site, Operator
Mapping: 'Run Data'
Required Columns:
Run
Metric A (unit)
Recommended Columns:
Experiment
Timeseries Data
Description: Time-based metrics
Example: Time (h) versus Temperature (°C)
Mapping:
Timeseries Data (absolute time)
Required Columns:
Run
Timestamp
Metric A (unit)
Timeseries Data (relative time)
Required Columns:
Run
Time (h) or Time (min)
Metric A (unit)
Run Events
Description: Notes associated with a run.
Example: Reactor Foaming @ 24h EFT
Mapping:
Run Events (absolute time)
Required Columns:
Run
Timestamp
Metric A (unit)
Run Events (relative time)
Required Columns:
Run
Time (h) or Time (min)
Metric A (unit)
Invert Data
Description: Import data from an Invert export file
Example: Time (h) versus Temperature (°C)
Mapping:
Invert
Required Columns:
Export file structure generated by Invert
Option 2: Other Files
The second option allows you to upload files as run attachments. Use the file picker to select the file you wish to upload, and then choose the relevant run from the dropdown menu. Once uploaded, the file can be accessed from the Run summary page, providing easy access to additional documentation or resources related to your runs.
Option 3: View History
Navigate to the 'Import History' page to get an overview on historical file ingestions. Select a upload from the list for more details on a specific file upload task. Review imported 'Runs' or 'Metrics' and download a copy of the file