Dynamic Template Learning System

Create custom import templates from your data files
1
Upload Template
2
Analyze Columns
3
Map Fields
4
Configure Tests
5
Review & Save

Upload Template File

Upload a sample CSV/Excel file that represents your standard result format. This will be used to create a reusable template for future imports and manual entry.

📁

Drop your template file here or click to browse

Supported formats: CSV, XLS, XLSX

Column Analysis & Auto-Detection

AI-powered field recognition
89
Total Columns
42
Auto-Detected
15
Required Fields
97
Sample Records
📋 Sample Identification Fields 8 fields
Column Name Data Type Sample Values Map To Manual Entry Required
Sample Name Auto-detected String TC, DFC 01, DFC 02...
Sample Type Auto-detected String Unknown, Blank, QC...
Acquisition Date & Time Auto-detected DateTime 6/30/2025 10:28:05 AM
📊 Result Data Fields 12 fields
🔬 Quality Control Fields 25 fields

Field Mapping Summary

Review and adjust how your columns map to system fields. These mappings will be used for both imports and manual entry.

42
Mapped Fields
28
Manual Entry Fields
15
Required Fields
47
Ignored Fields

Sample Data Preview (First 5 Records)

Sample Name Component Name Calculated Concentration Units Retention Time Area Signal/Noise
TC Gabapentin 1 12432.84 ng/mL 0.6946 1609717.11 608.92
TC Oxycodone 1 4417.71 ng/mL 2.34 854231.45 432.11
DFC 01 Methadone 1 987.65 ng/mL 3.15 125678.90 234.56

Configure Test Associations

Select which tests this template will be used for. The system will automatically match analytes from your file.

Available Tests

LC-MS/MS Drug Screen Panel
99 analytes • Method: LC-MS/MS
Opioid Confirmation Panel
15 analytes • Method: LC-MS/MS
Benzodiazepine Panel
12 analytes • Method: LC-MS/MS

Detected Analytes

Auto-matched from your file's "Component Name" column

✓ Gabapentin (1 & 2)
✓ Oxycodone (1 & 2)
✓ Methadone (1 & 2)
✓ Alprazolam (1 & 2)
✓ Cocaine/Benzoylecgonine (1 & 2)
⚠️ 94 more analytes detected...

Analyte Mapping Rules

Configure how analyte names from your file match to system analytes

Template Configuration Complete!

Your template is ready to use for imports and manual entry

Template Summary

Template Name: HAN SOLO LC-MS Template
Source File: HAN SOLO 063025 S2 pos AG.csv
Total Columns: 89
Mapped Fields: 42
Manual Entry Fields: 28
Associated Tests: LC-MS/MS Drug Screen Panel
Detected Analytes: 99

What's Next?

📥
Import Results

Use this template to import result files

✏️
Manual Entry

Enter results using configured fields

⚙️
Edit Template

Modify field mappings anytime