Spaces:
Sleeping
Sleeping
Commit History
-
Add a knowledge sheet template to share with universities
Donne120 +1: Claude Opus 5The publisher script matches column names loosely, so a university using "Topic" instead of "Question" still works. That is a safety net, not a substitute for everyone starting from the same shape — with a shared template we can help someone over the phone without first asking what they called their columns. Knowledge_Sheet_Template.csv is the master copy: Question, Answer, Link, Category, Updated, with ten realistic example rows (add/drop deadlines, scholarships, library hours) rather than placeholder text, so a registrar can see the expected level of detail instead of guessing. The README covers how to set up the Drive master — with the script already attached, so universities use File → Make a copy and never paste code — what to tell them, and the writing advice that actually affects answer quality: write answers rather than headings, one question per row, no "see below" since each row is retrieved alone. Verified the shipped CSV parses through the shipped script: all ten rows pub…564ecf4 -
Add a Sheet publisher script that works for any university
Donne120 +1: Claude Opus 5Code.gs is ALU's bespoke publisher: TAB_CONFIG hardcodes that sheet's tab names, its header rows (row 2 on one tab, row 7 on another), and even a misspelled `discription` column. Pasted into another university's sheet it matches none of those tab names and publishes zero entries — silently, because unconfigured tabs are skipped rather than reported. Onboarding a university therefore meant an engineer rewriting TAB_CONFIG by hand, which is exactly the bottleneck the per-organization sheet work was meant to remove. UniversityTemplate.gs needs no editing. It searches the first ten rows for a header (so a title banner above the columns doesn't break it), matches column names by meaning rather than exact spelling — Question / Title / Topic all resolve to the same field — reads every tab, and skips ones whose names look internal (workplan, draft, scratch). previewPayload() reports per-tab counts so a zero result is diagnosable rather than mysterious. Verified against ten sheet shapes a uni…13d7de0
-
sheet_sync: disambiguate duplicate entry ids within a batch
Donne120392a0c4 -
Wire Google Sheet knowledge base into Claude RAG
Donne120eaa56f0