These are the files that support the schedule page for the MA+S Rendezvous at Duke University.
The data for the past and upcoming talks is kept in a Google Spreadsheet that has a separate tab for each semester. In the past, besides adding a new tab to the spreadsheet, I had to create a new page every semester and change some header and footer info in old ones. Now, the schedule page itself is a single page application that draws from that data and automatically deals slightly differently with the current page vs past or future semesters.
For convenience of programming, I make a separate Excel spreadsheet, SiteNames.xlsx, which specifies the tab
names, and holds some other metadata necessary for creating the sitemap.xml file which
Google uses for indexing since there are not individual page files for each semester's schedule.
When you want to add a new semster on to the schedule:
- Add a new tab to the Google spreadsheet with the name of the semester in the format
(Fall|Spring)_YYYY. - Add a new row to the
SiteNames.xlsxfile with the new tab name in the Semester column - Update which semesters are current, past or future.
- Update dates when Google should think the pages were last modified. None required for current or future.
- I've been using 0.6 priority for current, 0.3 for one semster past, 0.1 for two semesters past and 0.05 for further past. No priority value is entered for future semesters.
- Run the
excel2json_sheetnames_sitemap.pyscript to generate both the JSON file the site Javascript will use, plus thesitemap.xmlfile that Google will use for indexing the site.