Import — User Guides

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