2e:null 2f:["$","title",null,{"children":"Bestsellers Newsgate converter | Los Angeles Times Data and Graphics Department | Observable"}] 34: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} ` )}

` )}` })35:[] 32:{"id":"299a1f78af0a88ab","slug":"bestsellers-newsgate-converter","title":"Bestsellers Newsgate converter","thumbnail":"fc35d31213342d63e53c67b7188a7263df0a953316f76d1fb7456f321bd566c0","access_level":"public","create_time":"$D2020-04-27T01:41:47.065Z","update_time":"$D2020-04-29T22:41:58.913Z","view_time":null,"first_public_time":"$D2020-04-27T22:25:30.235Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"f83bbdb03e39d06d","login":"datadesk","name":"Los Angeles Times Data and Graphics Department","avatar_url":"https://avatars-next.observableusercontent.com/ee9f49dffe9fbda0b4257d3a2ea30eadd4f2ae26d7adb555d57afcccd9d46ff3","tier":"pro_2024"},"version":205,"publish_version":205,"role":null,"authored":false,"authors":[{"type":"individual","id":"2977b296b7b0b2fa","login":"palewire","name":"Ben Welsh","avatar_url":"https://avatars-next.observableusercontent.com/09c4b14e7fedb41389efd80f902156893a0c63a226ba56a133a1e931549598bc","tier":null}],"members":[{"type":"team","id":"f83bbdb03e39d06d","login":"datadesk","name":"Los Angeles Times Data and Graphics Department","avatar_url":"https://avatars-next.observableusercontent.com/ee9f49dffe9fbda0b4257d3a2ea30eadd4f2ae26d7adb555d57afcccd9d46ff3","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"1237064497d311dc","slug":"helpers","title":"Helpers","owner":{"id":"f83bbdb03e39d06d","login":"datadesk","name":"Los Angeles Times Data and Graphics Department"}},"type":"notebook","body":{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`## 1. Paste in CSV data. Hit the convert button`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"md`## Step 2. Download table tags for Newsgate`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"nextSunday = moment(getNextDayOfWeek(new Date(), 7))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"import { textarea } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"moment = require(\"moment\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 33:"$32:body"