📊 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}","createdAt",["D",1738989668630],"version",53,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","geordie","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yajZPVDRYVHJFeUNkUFRIY01hMW1JckMxa0oifQ","forkedVal","interval","slug","geordie/bandcampcsvprocessor","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[141,144,148,152,156,160,164,168,172,176,180,184,188,192,196,200,204,208,212,216,220,224,228,232,236,240,244,248,252,256,260,264,268,272,276,280,284,288,292,296,300,304,308,312,316,320,324,328,332,336,340,344,347,351],{"_118":119,"_142":-5,"_116":143,"_113":111},"prId",["D",1738989668630],{"_118":145,"_142":-5,"_116":146,"_113":147},52,["D",1738989613194],"c9254a6e-e5d6-11ef-84ed-e6cdfca9ef9f",{"_118":149,"_142":-5,"_116":150,"_113":151},51,["D",1738989609184],"c6c07b54-e5d6-11ef-ad26-e6cdfca9ef9f",{"_118":153,"_142":-5,"_116":154,"_113":155},50,["D",1738989445032],"64e7e2aa-e5d6-11ef-8bf4-e6cdfca9ef9f",{"_118":157,"_142":-5,"_116":158,"_113":159},49,["D",1738989413526],"52200bb6-e5d6-11ef-a735-e6cdfca9ef9f",{"_118":161,"_142":-5,"_116":162,"_113":163},48,["D",1738989385476],"41681eee-e5d6-11ef-b27a-e6cdfca9ef9f",{"_118":165,"_142":-5,"_116":166,"_113":167},47,["D",1738989382269],"3f7ef8e6-e5d6-11ef-a735-e6cdfca9ef9f",{"_118":169,"_142":-5,"_116":170,"_113":171},46,["D",1738989376639],"3c2391b6-e5d6-11ef-a735-e6cdfca9ef9f",{"_118":173,"_142":-5,"_116":174,"_113":175},45,["D",1738989278550],"01acc03e-e5d6-11ef-8793-e6cdfca9ef9f",{"_118":177,"_142":-5,"_116":178,"_113":179},44,["D",1738989277176],"00dcd2a2-e5d6-11ef-827f-e6cdfca9ef9f",{"_118":181,"_142":-5,"_116":182,"_113":183},43,["D",1738989267919],"fb597218-e5d5-11ef-ba89-e6cdfca9ef9f",{"_118":185,"_142":-5,"_116":186,"_113":187},42,["D",1738989257153],"f4ebfb1c-e5d5-11ef-9121-e6cdfca9ef9f",{"_118":189,"_142":-5,"_116":190,"_113":191},41,["D",1738989239100],"ea294b12-e5d5-11ef-bcab-e6cdfca9ef9f",{"_118":193,"_142":-5,"_116":194,"_113":195},40,["D",1738989225697],"e22d0dea-e5d5-11ef-bcab-e6cdfca9ef9f",{"_118":197,"_142":-5,"_116":198,"_113":199},39,["D",1738989216866],"dce8b406-e5d5-11ef-84e5-e6cdfca9ef9f",{"_118":201,"_142":-5,"_116":202,"_113":203},38,["D",1738989165099],"be0e598c-e5d5-11ef-811b-e6cdfca9ef9f",{"_118":205,"_142":-5,"_116":206,"_113":207},37,["D",1738989136212],"acd6e738-e5d5-11ef-81cd-e6cdfca9ef9f",{"_118":209,"_142":-5,"_116":210,"_113":211},36,["D",1738988870405],"0e66e526-e5d5-11ef-ad0a-e6cdfca9ef9f",{"_118":213,"_142":-5,"_116":214,"_113":215},35,["D",1738988863840],"0a7d5fd0-e5d5-11ef-9df7-e6cdfca9ef9f",{"_118":217,"_142":-5,"_116":218,"_113":219},34,["D",1738988844967],"ff3e3dd8-e5d4-11ef-ae8f-e6cdfca9ef9f",{"_118":221,"_142":-5,"_116":222,"_113":223},33,["D",1738988691233],"a39c5636-e5d4-11ef-ab48-e6cdfca9ef9f",{"_118":225,"_142":-5,"_116":226,"_113":227},32,["D",1738988636164],"82ca1916-e5d4-11ef-bbee-e6cdfca9ef9f",{"_118":229,"_142":-5,"_116":230,"_113":231},31,["D",1738988498950],"30ff5830-e5d4-11ef-9e6e-e6cdfca9ef9f",{"_118":233,"_142":-5,"_116":234,"_113":235},30,["D",1738988492968],"2d6eedca-e5d4-11ef-b3cd-e6cdfca9ef9f",{"_118":237,"_142":-5,"_116":238,"_113":239},29,["D",1738988433598],"0a0bb1ba-e5d4-11ef-af68-e6cdfca9ef9f",{"_118":241,"_142":-5,"_116":242,"_113":243},28,["D",1738988403783],"f845969e-e5d3-11ef-980c-e6cdfca9ef9f",{"_118":245,"_142":-5,"_116":246,"_113":247},27,["D",1738988385494],"ed600a2a-e5d3-11ef-980c-e6cdfca9ef9f",{"_118":249,"_142":-5,"_116":250,"_113":251},26,["D",1738988372310],"e58445fa-e5d3-11ef-bd39-e6cdfca9ef9f",{"_118":253,"_142":-5,"_116":254,"_113":255},25,["D",1738988366175],"e1db4214-e5d3-11ef-bbc4-e6cdfca9ef9f",{"_118":257,"_142":-5,"_116":258,"_113":259},24,["D",1738988328029],"cb1e5372-e5d3-11ef-8e05-e6cdfca9ef9f",{"_118":261,"_142":-5,"_116":262,"_113":263},23,["D",1738988313869],"c2ae54e4-e5d3-11ef-9cee-e6cdfca9ef9f",{"_118":265,"_142":-5,"_116":266,"_113":267},22,["D",1738988291818],"b5897186-e5d3-11ef-b3b0-e6cdfca9ef9f",{"_118":269,"_142":-5,"_116":270,"_113":271},21,["D",1738988285026],"b17dde7e-e5d3-11ef-8c06-e6cdfca9ef9f",{"_118":273,"_142":-5,"_116":274,"_113":275},20,["D",1738988262225],"a3e57006-e5d3-11ef-8429-e6cdfca9ef9f",{"_118":277,"_142":-5,"_116":278,"_113":279},19,["D",1738988010807],"0e0b3f34-e5d3-11ef-8bc5-e6cdfca9ef9f",{"_118":281,"_142":-5,"_116":282,"_113":283},18,["D",1738987940477],"e41ea288-e5d2-11ef-924b-e6cdfca9ef9f",{"_118":285,"_142":-5,"_116":286,"_113":287},17,["D",1738987387141],"9a4fb65c-e5d1-11ef-a869-e6cdfca9ef9f",{"_118":289,"_142":-5,"_116":290,"_113":291},16,["D",1738987336057],"7bdbb55e-e5d1-11ef-8c46-e6cdfca9ef9f",{"_118":293,"_142":-5,"_116":294,"_113":295},15,["D",1738987263373],"508ac1f6-e5d1-11ef-bec4-e6cdfca9ef9f",{"_118":297,"_142":-5,"_116":298,"_113":299},14,["D",1738987077367],"e1abad54-e5d0-11ef-879d-e6cdfca9ef9f",{"_118":301,"_142":-5,"_116":302,"_113":303},13,["D",1738986876261],"69cdf990-e5d0-11ef-956b-e6cdfca9ef9f",{"_118":305,"_142":-5,"_116":306,"_113":307},12,["D",1738986856785],"5e319ab0-e5d0-11ef-a68e-e6cdfca9ef9f",{"_118":309,"_142":-5,"_116":310,"_113":311},11,["D",1738986826384],"4c13153e-e5d0-11ef-9422-e6cdfca9ef9f",{"_118":313,"_142":-5,"_116":314,"_113":315},10,["D",1738986730551],"12f7e496-e5d0-11ef-baec-e6cdfca9ef9f",{"_118":317,"_142":-5,"_116":318,"_113":319},9,["D",1738986710194],"06d0f266-e5d0-11ef-8bb1-e6cdfca9ef9f",{"_118":321,"_142":-5,"_116":322,"_113":323},8,["D",1738986569615],"b3065748-e5cf-11ef-a22d-e6cdfca9ef9f",{"_118":325,"_142":-5,"_116":326,"_113":327},7,["D",1738986513738],"91b900ae-e5cf-11ef-bbdb-e6cdfca9ef9f",{"_118":329,"_142":-5,"_116":330,"_113":331},6,["D",1738986409406],"53883e94-e5cf-11ef-bbdb-e6cdfca9ef9f",{"_118":333,"_142":-5,"_116":334,"_113":335},5,["D",1738986343011],"2bf560e6-e5cf-11ef-bbdb-e6cdfca9ef9f",{"_118":337,"_142":-5,"_116":338,"_113":339},4,["D",1738986307959],"1711ae64-e5cf-11ef-bbdb-e6cdfca9ef9f",{"_118":341,"_142":-5,"_116":342,"_113":343},3,["D",1738986258542],"f99d2836-e5ce-11ef-9870-e6cdfca9ef9f",{"_118":91,"_142":-5,"_116":345,"_113":346},["D",1738986063594],"856a7ee6-e5ce-11ef-b244-e6cdfca9ef9f",{"_118":348,"_142":-5,"_116":349,"_113":350},1,["D",1738985844514],"02d40344-e5ce-11ef-8f4f-e6cdfca9ef9f",{"_118":32,"_142":-5,"_116":352,"_113":353},["D",1738985012544],"12f1c2c2-e5cc-11ef-9099-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_361":362,"_363":32,"_364":136,"_365":32,"_95":366},"dependenciesList",[],"dependenciesCount","valname","page",{"_113":111,"_99":100,"_129":130,"_11":97,"_118":119,"_101":102,"_114":115,"_105":106,"_112":26,"_135":136},"routes/_app","actionData","errors"]