31:T480,table = textarea({ title: "Copy the results below", width: "100%", rows: 10, value: `${Object.entries(groupedData).map( g => `${getHeader()} ${g[0]} ${g[1].map( d => ` ${d.rank}. ${d.title} by ${d.author} ${d.description} ${d.weeks} ` )}

` )}` })32:[] 2f:{"title":"Bestsellers Newsgate converter","cells":[{"id":0,"value":"md`# Bestsellers Newsgate converter\n\nUpload a CSV with the latest bestsellers list to this page. Download an HTML export ready to run in Newsgate.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"md`## 1. Paste in CSV data. Hit the convert button`","pinned":false,"hidden":false,"mode":"ojs"},{"id":42,"value":"viewof csvText = textarea({\n title:\n \"Columns must include list, rank, title, author, weeks and description\",\n description:\n \"You can find an example of what's expected here.\",\n width: \"100%\",\n rows: 10,\n submit: \"Convert\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"md`## Step 2. Download table tags for Newsgate`","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":163,"value":"md`The code that powers this page is below. If there's a problem, contact Ben Welsh.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":168,"value":"getHeader = () => {\n return `\nBESTSELLERS\n\n \n\nLOS ANGELES TIMES\n${nextSunday.format('MMMM D, YYYY')}\n\n`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":182,"value":"nextSunday = moment(getNextDayOfWeek(new Date(), 7))","pinned":false,"hidden":false,"mode":"ojs"},{"id":170,"value":"function getNextDayOfWeek(date, dayOfWeek) {\n // Code to check that date and dayOfWeek are valid left as an exercise ;)\n\n var resultDate = new Date(date.getTime());\n\n resultDate.setDate(date.getDate() + ((7 + dayOfWeek - date.getDay()) % 7));\n\n return resultDate;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":113,"value":"groupedData = {\n parsedData.sort((a, b) => (a.rank > b.rank ? 1 : -1));\n const groups = groupBy(parsedData, 'list');\n return groups;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":82,"value":"parsedData = {\n if (csvText.includes(\"\\t\")) {\n return d3.tsvParse(csvText, d3.autoType);\n } else {\n return d3.csvParse(csvText, d3.autoType);\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"groupBy = function(xs, key) {\n return xs.reduce(function(rv, x) {\n (rv[x[key]] = rv[x[key]] || []).push(x);\n return rv;\n }, {});\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":58,"value":"import { textarea } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":185,"value":"moment = require(\"moment\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":37,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}