CSV Import Validation Checklist

// Comprehensive CSV validation
function validateCSVImport(csvData, schema) {
  const records = parseCSV(csvData);
  const errors = [];
  const warnings = [];
  
  records.forEach((record, index) => {
    const rowNum = index + 2; // +2 for header row and 0-index
    
    // Required field validation
    schema.required.forEach(field => {
      if (!record[field]) {
        errors.push({
          row: rowNum,
          field,
          error: 'Required field is missing',
          severity: 'error'
        });
      }
    });
    
    // Type validation
    Object.entries(schema.types).forEach(([field, type]) => {
      if (record[field]) {
        if (type === 'email' && !isValidEmail(record[field])) {
          errors.push({
            row: rowNum,
            field,
            error: 'Invalid email format',
            value: record[field],
            severity: 'error'
          });
        }
        
        if (type === 'number' && isNaN(parseFloat(record[field]))) {
          errors.push({
            row: rowNum,
            field,
            error: 'Must be a number',
            value: record[field],
            severity: 'error'
          });
        }
        
        if (type === 'date' && !isValidDate(record[field])) {
          errors.push({
            row: rowNum,
            field,
            error: 'Invalid date format',
            value: record[field],
            severity: 'error'
          });
        }
      }
    });
    
    // Custom validation rules
    schema.rules?.forEach(rule => {
      if (!rule.validate(record)) {
        (rule.severity === 'error' ? errors : warnings).push({
          row: rowNum,
          field: rule.field,
          error: rule.message,
          value: record[rule.field],
          severity: rule.severity
        });
      }
    });
  });
  
  return {
    valid: errors.length === 0,
    errors,
    warnings,
    summary: {
      totalRows: records.length,
      errorCount: errors.length,
      warningCount: warnings.length
    }
  };
}

// Example schema
const userSchema = {
  required: ['email', 'firstName', 'lastName'],
  types: {
    email: 'email',
    age: 'number',
    birthDate: 'date'
  },
  rules: [
    {
      field: 'age',
      validate: (record) => !record.age || record.age >= 18,
      message: 'Must be 18 or older',
      severity: 'warning'
    }
  ]
};