Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.
TypeScript ai-agentsbill-of-materialserpinventory-managementleanmanufacturingmanufacturing-execution-systemmcp-servermesmrpopen-source-erppostgresqlproduction-planningqmsquality-management-systemreact-routerself-hostedsupabasetraceabilitytypescript
// SPDX-License-Identifier: AGPL-3.0-only
// Carbon (github.com/crbnos/carbon). Modified or adapted versions of this file,
// including ports, remain AGPLv3; serving them over a network requires releasing their source.
import { useCarbon } from "@carbon/auth";
import { downloadText, storage } from "@carbon/files";
import {
CSV_CONTENT_TYPE,
encodeCsvTable,
parseCsvFile
} from "@carbon/files/csv";
import {
Button,
cn,
ModalBody,
ModalDescription,
ModalHeader,
ModalTitle,
Spinner,
toast
} from "@carbon/react";
import { Trans, useLingui } from "@lingui/react/macro";
import { nanoid } from "nanoid";
import { useCallback, useState } from "react";
import { flushSync } from "react-dom";
import { useDropzone } from "react-dropzone";
import { LuDownload, LuFileSpreadsheet } from "react-icons/lu";
import { useUser } from "~/hooks/useUser";
import {
fieldMappings,
type importSchemas
} from "~/modules/shared/imports.models";
import { useCsvContext } from "./useCsvContext";
export const UploadCSV = ({ table }: { table: keyof typeof importSchemas }) => {
const { t } = useLingui();
const { carbon } = useCarbon();
const { company } = useUser();
const { setFile, setFileColumns, setFirstRows, setFilePath } =
useCsvContext();
const [uploading, setUploading] = useState(false);
const [loading, setLoading] = useState(false);
const [error, setError] = useState<string | null>(null);
const downloadTemplate = useCallback(() => {
const mapping = fieldMappings[table];
const fields = Object.values(mapping) as Array<{
label: string;
required?: boolean;
type: "string" | "boolean" | "enum" | "numeric";
enumData?: {
description?: string;
options?: readonly string[];
fetcher?: unknown;
};
}>;
const headers = fields.map((f) => f.label);
// Hint row: helps users see required-ness + valid values at a glance.
// It's a CSV data row (CSV has no comment syntax) — users overwrite it
// before re-uploading.
const hints = fields.map((f) => {
const prefix = f.required ? "REQUIRED" : "optional";
if (f.type === "enum" && f.enumData?.options) {
return `${prefix} — one of: ${f.enumData.options.join(" | ")}`;
}
if (f.type === "enum" && f.enumData?.fetcher) {
return `${prefix} — ${f.enumData.description ?? "see your configured options"}`;
}
if (f.type === "boolean") return `${prefix} — true | false`;
if (f.type === "numeric") return `${prefix} — number`;
return prefix;
});
downloadText(
encodeCsvTable(headers, [hints]),
`${table}-template.csv`,
CSV_CONTENT_TYPE
);
}, [table]);
const processFile = async (file: File) => {
if (!file) {
setFileColumns(null);
return;
}
flushSync(() => {
setLoading(true);
});
let parsed: Awaited<ReturnType<typeof parseCsvFile>>;
try {
parsed = await parseCsvFile(file);
} catch (error) {
setError(error instanceof Error ? error.message : String(error));
setFileColumns(null);
setFirstRows(null);
setLoading(false);
return;
}
const { rows: data, fields } = parsed;
if (!data || data.length < 2) {
setError(t`CSV file must have at least 2 rows.`);
setFileColumns(null);
setFirstRows(null);
setLoading(false);
return;
}
// `<= 1` rejected a legitimate single-column file. It was written as a
// "this isn't really a CSV" heuristic — PapaParse hands back one field
// holding the whole line for a non-delimited file — and was unreachable
// while every import type had two or more mappable fields. Scrap
// reasons and storage types have exactly one (`name`), so a correct CSV
// for them is one column wide. The mapping step is what tells the user
// whether the parse was sane; a bad file simply maps to nothing there.
if (fields.length < 1) {
setError(t`Failed to retrieve CSV column data.`);
setFileColumns(null);
setFirstRows(null);
setLoading(false);
return;
}
setFileColumns(fields);
setFirstRows(data as Record<string, string>[]);
setLoading(false);
};
const uploadFile = async (file: File) => {
toast.info(t`Uploading ${file.name}`);
const fileName = `${company.id}/imports/${nanoid()}.csv`;
if (!carbon) {
setError(t`Carbon client not available`);
setFileColumns(null);
setFirstRows(null);
setLoading(false);
return;
}
const { data, error } = await storage(carbon)
.company(company.id)
.upload(fileName, file);
if (error) {
setError(t`Failed to upload CSV file.`);
setFileColumns(null);
setFirstRows(null);
setLoading(false);
return;
}
setFilePath(data.path);
};
const onDrop = async (acceptedFiles: File[]) => {
if (!carbon) {
toast.error(t`Carbon client not available`);
return;
}
if (acceptedFiles.length > 0) {
flushSync(() => {
setUploading(true);
});
if (acceptedFiles[0]) {
setFile(acceptedFiles[0]);
await Promise.all([
processFile(acceptedFiles[0]),
uploadFile(acceptedFiles[0])
]);
}
setUploading(false);
}
};
const { getRootProps, getInputProps, isDragActive, isDragReject } =
useDropzone({
onDrop,
accept: { "text/csv": [".csv"] },
maxFiles: 1,
maxSize: 5 * 1024 * 1024, // 5MB
disabled: uploading
});
return (
<>
<ModalHeader>
<ModalTitle>
<Trans>Upload CSV</Trans>
</ModalTitle>
<ModalDescription>
<Trans>Please upload a CSV file of your data</Trans>
</ModalDescription>
</ModalHeader>
<ModalBody>
<div className="mt-1 mb-4 flex items-center justify-between gap-4 rounded-md border bg-muted/40 px-4 py-3">
<div className="flex min-w-0 items-center gap-3">
<div className="flex h-9 w-9 flex-shrink-0 items-center justify-center rounded-md border bg-background">
<LuFileSpreadsheet className="h-4 w-4 text-muted-foreground" />
</div>
<div className="flex min-w-0 flex-col">
<span className="text-sm font-medium">
<Trans>Need the right columns?</Trans>
</span>
<span className="text-xs text-muted-foreground">
<Trans>Hints in the first row</Trans>
</span>
</div>
</div>
<Button
variant="secondary"
size="md"
leftIcon={<LuDownload />}
onClick={downloadTemplate}
>
<Trans>Download template</Trans>
</Button>
</div>
<div
{...getRootProps()}
className={cn(
"w-full border-2 border-dashed h-[200px] rounded-md mb-8 flex items-center justify-center text-muted-foreground hover:border-primary hover:text-foreground cursor-pointer focus-visible:border-primary focus-visible:text-foreground hover:bg-primary/5 focus-visible:outline-none",
isDragActive
? "border-primary text-foreground bg-primary/5"
: "border-muted",
isDragReject && "border-destructive"
)}
>
<div className="text-center flex items-center justify-center flex-col text-xs">
<input {...getInputProps()} />
{loading ? (
<div className="flex space-x-1 items-center">
<Spinner />
<span>
<Trans>Loading...</Trans>
</span>
</div>
) : (
<div>
<p>
<Trans>Drop your file here, or click to browse.</Trans>
</p>
<span>
<Trans>5MB file limit</Trans>
</span>
</div>
)}
{error && (
<p className="text-center text-sm text-red-600 mt-4">{error}</p>
)}
</div>
</div>
</ModalBody>
</>
);
};