Function parseImportCSV

src/lib/importData.js:46–98

(content, schema = {})

 * @returns {{ rows: Object[]|null, error: string|null }}
 */
export function parseImportCSV(content, schema = {}) {
  if (!content || content.trim().length === 0) {
    return { rows: null, error: 'File is empty.' };
  }

  const lines = parseCSVLines(content);
  if (lines.length === 0) {
    return { rows: null, error: 'File is empty.' };
  }

  const headers = lines[0];
  if (lines.length < 2) {
    return { rows: null, error: 'No data rows found. The file contains only headers.' };
  }

  const rows = [];
  for (let i = 1; i < lines.length; i++) {
    const values = lines[i];
    const row = {};
    for (let j = 0; j < headers.length; j++) {
      const header = headers[j];
      const raw = j < values.length ? values[j] : '';
      if (raw === '') {
        continue; // omit empty cells
      }
      const colSchema = schema[header];
      const type = colSchema ? colSchema.type : 'String';
      const converted = convertCSVValue(raw, type, colSchema);
      if (converted === undefined) {
        continue;
      }
      if (type === 'Number' && Number.isNaN(converted)) {
        return {
          rows: null,
          error: `Invalid number in row ${i}, column "${header}".`,
        };
      }
      if (type === 'Boolean' && raw.toLowerCase() !== 'true' && raw.toLowerCase() !== 'false') {
        return {
          rows: null,
          error: `Invalid boolean in row ${i}, column "${header}".`,
        };
      }
      row[header] = converted;
    }
    if (Object.keys(row).length === 0) {
      continue;
    }
    rows.push(row);
  }

  return { rows, error: null };
}

/**
 * Parse CSV content into an array of arrays (rows of fields).