Import Process

The import process is the first step in Ivandt's data onboarding flow. It handles file uploads, parsing, and intelligent column mapping.

Overview

1. User uploads a file (Excel, CSV, JSON, etc.)
2. Ivandt parses the file structure
3. AI attempts automatic column mapping
4. User reviews and adjusts mapping if needed
5. Data flows to the Review step for validation

Smart Column Mapping

Ivandt uses AI to automatically map uploaded columns to your schema fields.

What Gets Sent to AI

Only column headers - never the actual data. This is crucial for security and privacy.

Uploaded Excel: "First Name", "Last Name", "Email Address"
Schema expects: "firstName", "lastName", "email"
AI maps: ✓ Automatic match

When Auto-Mapping Succeeds

Users skip directly to the Review step. No manual intervention needed.

When Auto-Mapping Fails

Users see the mapping interface to:

• Review suggested mappings
• Manually map unmapped columns
• Combine multiple columns into one
• Split one column into multiple fields

File Upload Configuration

Configure upload behavior in your schema:

stepsConfig: {
  uploadFileStep: {
    supportedExtensions: ['xlsx', 'xls', 'csv', 'json', 'txt'],
    dataEntryMethod: 'manual_and_upload',
    maxColumns: 50,
    maxRows: 100000,
    maxFileSize: 20 * 1024 * 1024 // 20MB
  }
}

Next Steps

• Validation - Learn about data validation
• Review Step - Understand the review interface