CSV Importer

import Papa from "papaparse";

export function CSVImporter({ schema, onImport }) {
  const [step, setStep] = useState("upload"); // upload | map | preview | done
  const [data, setData] = useState([]);
  const [mapping, setMapping] = useState({});

  const handleFile = (file: File) => {
    Papa.parse(file, {
      header: true,
      complete: (results) => {
        setData(results.data);
        setMapping(autoMapColumns(results.meta.fields, schema));
        setStep("map");
      },
    });
  };

  const handleImport = async () => {
    const mapped = data.map((row) => applyMapping(row, mapping, schema));
    const { valid, errors } = validate(mapped, schema);
    if (errors.length > 0) return showErrors(errors);
    await onImport(valid);
    setStep("done");
  };
}