Import

​

Core Purpose

• Execution Tracking: Records each run of an import processor
• Status Management: Tracks progress from pending to completed/failed
• Audit Trail: Links imports to users and organizations
• Error Handling: Stores error messages when imports fail

​

Entity Structure

Import {
  id: "imp-...",
  importDefinitionId: "impdef-...",  // The definition used
  userId: "user-...",                 // Who executed the import
  organizationId: "org-...",          // Organization context
  rowCount: 150,                      // Total rows in source file
  status: "completed",                // pending, processing, completed, failed
  error: null,                        // Error message if failed
  processedAt: "2024-01-15T10:30:00Z" // When processing completed
}

​

Import Lifecycle

​

Status Values

​

Relationships

​

Row Count

• How much data was provided
• Progress during processing
• Comparison with actual results produced

​

Error Handling

{
  "status": "failed",
  "error": "Invalid column mapping: 'consumption' not found in source file"
}

• Missing required columns
• Invalid data types
• Processor code errors
• Database constraint violations

​

Access Control

• Imports are scoped to organizations via RLS policies
• Users can only see imports from their current organization
• The executing user is recorded but doesn’t restrict access

​

Querying Imports

SELECT * FROM "Import"
WHERE "organizationId" = 'org-123'
ORDER BY "createdAt" DESC
LIMIT 10;

SELECT * FROM "Import"
WHERE status = 'failed'
  AND "organizationId" = 'org-123';

​

Related Entities

• ImportDefinition: Defines the transformation rules
• ImportResult: Per-site results from the import
• FormElementSubmission: Values created by the import