Upload Pre-analytical Data

Upload a CSV file with pre-analytical sample data (food/drink intake, caffeine, tobacco, alcohol timing). Select a format from "Example Data" below to see samples.
Need help? Make sure your CSV file follows the expected format. View existing pre-analytical results for reference.
Download Example CSV
Column Mapping Example
Download Mapping Example
Expected CSV Format

The CSV file should contain the following columns:

  • CMMI_ID - Participant identifier (required)
  • STUDY_ID - Study identifier
  • CMMI_INTERP_COLLECTION_DATETIME - Sample collection date and time
  • CMMI_INTERP_FOOD_DRINK_TIMING - Time since last food/drink intake
  • CMMI_INTERP_CAFFEINE_TIMING - Time since last caffeine intake
  • CMMI_INTERP_TOBACCO_TIMING - Time since last tobacco use
  • CMMI_INTERP_ALCOHOL_TIMING - Time since last alcohol consumption
  • CMMI_INTERP_SAMPLE_COLLECTION_STATUS - Sample collection status/notes
How it works:
  • Your file will be scanned for duplicates before import
  • Duplicates are detected by matching participant ID, study ID, and collection datetime
  • If duplicates are found, you can choose to skip or import them
What is a Mapping Example?

If your CSV file uses different column names than the standard format shown above, you can use the column mapping feature. Upload a file with non-standard column names, and the system will let you map your columns to the expected format. The mapping example demonstrates this workflow with intentionally different column names (e.g., "ParticipantID" instead of "CMMI_ID").