📊 Financial Report

\n\n

🎵 Artist Earnings

\n \n \n \n \n \n \n \n \n \n \n {processingResult.artistSummary.map((artist) => (\n \n \n \n \n \n \n ))}\n \n

Artist	Total Sales	Tracks	Albums
{artist.name}	${artist.totalSales.toFixed(2)}	{artist.totalTracks}	{artist.totalAlbums}

\n\n

📆 Monthly Breakdown

\n \n \n \n \n \n {processingResult.monthlyBreakdown[0]?.artistSales\n && Object.keys(processingResult.monthlyBreakdown[0].artistSales).map(\n (artist) => ,\n )}\n \n \n \n {processingResult.monthlyBreakdown.map((month) => (\n \n \n \n {Object.entries(month.artistSales).map(([artist, sales]) => (\n \n ))}\n \n ))}\n \n

Month	Total Sales	{artist}
{month.month}	${month.totalSales.toFixed(2)}	${sales.toFixed(2)}

\n\n

💿 Release Details

\n \n \n \n \n \n \n \n \n \n \n {processingResult.artistSummary.flatMap((artist) =>\n artist.releases.map((release, idx) => (\n \n \n \n \n \n \n ))\n )}\n \n

Artist	Release	Type	Sales
{artist.name}	{release.name}	{release.type}	${release.sales.toFixed(2)}

\n )}\n

\n );\n}\n\n// ---- Some Basic Styles ----\nconst dropZoneStyle: React.CSSProperties = {\n border: \"2px dashed #cccccc\",\n borderRadius: \"4px\",\n padding: \"20px\",\n textAlign: \"center\",\n transition: \"background-color 0.3s\",\n minHeight: \"200px\",\n display: \"flex\",\n flexDirection: \"column\",\n justifyContent: \"center\",\n cursor: \"pointer\",\n};\n\nconst errorStyle: React.CSSProperties = {\n color: \"red\",\n marginBottom: \"10px\",\n};\n\nconst resultStyle: React.CSSProperties = {\n marginTop: \"20px\",\n padding: \"10px\",\n backgroundColor: \"#f0f0f0\",\n borderRadius: \"4px\",\n};\n\nconst tableStyle: React.CSSProperties = {\n width: \"100%\",\n borderCollapse: \"collapse\",\n marginBottom: \"20px\",\n marginTop: \"10px\",\n};\n\n// ---- Main App ----\nfunction App() {\n return (\n

Bandcamp CSV Processor

Export raw data Bandcamp Sales Report and upload here.

\n \n

Disclaimer: I have no idea if this is accurate, it is entirely untested.

\n );\n}\n\n// ---- Client Entry Point ----\nfunction client() {\n const rootEl = document.getElementById(\"root\");\n if (rootEl) {\n createRoot(rootEl).render();\n }\n}\n\n// ---- Export for Valtown or Node-like Env ----\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(request: Request): Promise {\n return new Response(\n `\n \n \n Bandcamp CSV Processor\n \n \n \n

\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}","deleted","label",[98],"permalink","https://www.val.town/x/geordie/bandcampcsvprocessor/code/main.tsx","extension","actionData","errors"]