Theo Todman's Web Page

For Text Colour-conventions (at end of page): Click Here

Status Reports - Status: Summary (2020 - June)

Rationale for this Report


Projects in Progress
Actuals & Planning
Detailed Interim Activities

Plans for the Near Future25
  1. Thesis
  2. Religion
  3. Website
  4. Music
  5. Bridge
  6. Chess
  7. Consciousness
  8. Languages
  9. Mathematics
  10. HiQ
  1. Thesis26
    1. Continue with my Thesis27; in particular
      1. Spend at least an hour a day writing something original.
      2. Fill out those sections that I can write something on without further research.
      3. Rework the structure so that Level-1 or -2 print produces the thesis with the correct reading-list.
    2. Continually review the Note describing my Current Beliefs28 on the topic of Personal Identity.
    3. Complete a full review and update of the Notes I’ve created on Personal Identity, focusing on:-
      1. Those directly referenced by my Current Beliefs29,
      2. Those without a reading list: Evolution30, Person31, Physicalism32, Psychological View33, Psychology34, Religion35, Semantics36, Soul Criterion37, Souls38, Unity of the Person39.
      3. Those not yet in the latest standard format.
    4. Make progress on specific Chapters of my Thesis, using the materials below →
    5. Chapter 140 (Introduction). Focussing on:-
      1. Locke41
        → "Duncan (Matt) - I Think, Therefore I Persist", Complete Write-up
        → "Maurer (Nicholas) - Too Many Persons, or None At All?", Write-up
        → "Strawson (Galen) - 'The Secrets of All Hearts': Locke on Personal Identity", Read
        → "Strawson (Galen) - 'Where our responsibility lies': Locke on personal identity", Read
      2. Introductory and General Works
        → "Unger (Peter) - Identity, Consciousness and Value", Re-read and write up comments
        → "Unger (Peter) - Precis of 'Identity, Consciousness and Value'", Re-read ... also other items from the symposium
    6. Chapter 242 (What Are We?). Focussing on:-
      1. General: "Olson (Eric) - What are We? A Study of Personal Ontology", a core text!
      2. Brains43: "Mitchell (Kevin J.) - Innate: How the Wiring of Our Brains Shapes Who We Are", Read & review
      3. Human Beings44: Review the Symposium between:-
        → "Robinson (Denis) - Human Beings, Human Animals, and Mentalistic Survival", Read and Write-up
        → "Johnston (Mark) - 'Human Beings' Revisited: My Body is Not an Animal", Complete Write-up
      4. Persons45: "Cottingham (John) - Why we are not 'persons'", Complete Write-up
      5. Selves46:-
        1. "Arikha (Noga) - The Interoceptive Turn", Read and Write-up
        2. "Dainton (Barry) - Self: Philosophy In Transit", Read and Write-up
        3. "Dainton (Barry) - The Phenomenal Self", Read and Write-up47
        4. "O'Hear (Anthony), Ed. - Mind, Self and Person", Complete Reading and Write-ups
    7. Chapter 348 (What Is A Person49?).
      1. General:-
        → "Noller (Jorg) - A Transformative Account of Personal Identity", Read and write-up
        → "Noller (Jorg) - Person", Read and write-up
      2. Free Will50
        → "Ellis (George F.R.), Etc - From Chaos to Free Will": Complete review & analysis
        → "Gazzaniga (Michael S.) - Who's in Charge? Free Will and the Science of the Brain", Read
        → "Murphy (Nancey), O'Connor (Timothy) & Ellis (George F.R.) - Downward Causation and the Neurobiology of Free Will": Quick review & analysis
        → "Murphy (Nancey) & Brown (Warren) - Did My Neurons Make Me Do It?": Quick review & analysis
        → "Nanay (Bence) - Catching Desires": Complete write-up
      3. Personites51, develop Note, using:-
        → "Olson (Eric) - Ethics and the Generous Ontology", Write-up, then …
        → "Eklund (Matti) - The Existence of Personites", Read and write-up
        → "Johnston (Mark) - The Personite Problem: Should Practical Reason Be Tabled?", Read and write-up
        → "Johnston (Mark) - Personites, Maximality and Ontological Trash", Read and write-up
        → "Kaiserman (Alexander) - Stage Theory and the Personite Problem", Read and write-up
        → "Pautz (Adam) - Johnston’s Puzzle about Personites", Read and write-up.
    8. Chapter 452 (Basic Metaphysical Issues). Focus on:-
      1. General: "Hazlett (Allan) - New Waves in Metaphysics", Read
      2. Existence53: "Williams (Christopher) - Death and Other Difficulties", Read and write-up
      3. Logic of Identity54
        1. Partial Identity55
          → "Baxter (Donald L.M.) - Temporary and Contingent Instantiation as Partial Identity", Read and write-up
          → "Hawley (Katherine) - Almost Identical, Almost Innocent", Read and write-up.
        2. Artifacts56
          → "Han (Byung-Chul) - The copy is the original", Write-up
          → "Han (Byung-Chul) - Shanzhai: Deconstruction in Chinese", Read and write-up
        3. "Loose and Popular" vs "Strict and Philosophical" senses of identity
          → "Noonan (Harold) - Identity, Constitution and Microphysical Supervenience", Write-up57
      4. Parfit58
        → "Colen (J.A.) - In Memoriam Derek Parfit (1942-2017)", Write-up
        → "Funkhouser (Eric) - Notes on Parfit, 'Personal Identity'", Write-up
        → "Korsgaard (Christine) - Personal Identity and the Unity of Agency: A Kantian Response to Parfit", Read and write-up
        → "McDowell (John) - Reductionism and the First Person", Write-up59=47
        → "Perry (John) - Time, Fission, and Personal Identity", Read and write-up
        → "Parfit (Derek) - Personal Identity", Write-up
        → "Parfit (Derek) - Prudence, morality, and the prisoner's dilemma", Read and write-up, Note60
        → "Parfit (Derek) - Who do you think you are?", Write-up
        → Complete run-through of the Parfit reading-list
      5. Simple View61
        → "Duncan (Matt) - A Challenge to Anti-Criterialism"
        → "Duncan (Matt) - A Renewed Challenge to Anti-Criterialism"
        → "Duncan (Matt) - Dualists Needn’t Be Anti-Criterialists (Nor Should They Be)"
      6. Vague Identity62
        → "Broome (John) - Indefiniteness in Identity",
        → "Noonan (Harold) - Vague Identity Yet Again"
      7. Narrative Identity63 / Race64. Focussing On65:-
        1. Race and Racism66
          → "Boxill (Bernard), Ed. - Race and Racism: Oxford Readings in Philosophy"
          → "Brues (Alice M.) - People and Races"
          → "Glasgow (Joshua) - Another Look at the Reality of Race, By Which I Mean Race-f"
          → "Olusoga (David) - Black and British: A Forgotten History"
        2. The British Empire & its 'Crimes': obtain a balanced view from:-
          → "Lawrence (James) - Rise And Fall Of The British Empire"
          → "Brendon (Piers) - The Decline And Fall Of The British Empire"
          → "Paxman (Jeremy) - Empire: What Ruling the World Did to the British"
          → "Ferguson (Niall) - Empire: How Britain Made the Modern World"
    9. Chapter 567 (Persistence68 and Time69). Focussing on:-
      1. General
        1. "Sider (Ted), Hawthorne (John) & Zimmerman (Dean), Eds. - Contemporary Debates in Metaphysics",
      2. Persistence70
        1. "Haslanger (Sally) & Kurtz (Roxanne), Eds. - Persistence : Contemporary Readings",
        2. "Hawley (Katherine) - Persistence and Determination",
        3. "Wiggins (David) - Continuants: Their Activity, Their Being, and Their Identity", especially
          → "Noonan (Harold) - Review of Wiggins's 'Continuants'", and
          → "Wiggins (David) - Identity, Individuation, and Substance"
      3. Time71
        1. "Boccardi (Emiliano), Ed. - Manuscrito vol. 39 no.4: Recent Trends in the Philosophy of Time: An Introduction to Time and Reality - I", and
        2. "Boccardi (Emiliano), Ed. - Manuscrito vol. 40 no.1: The Passage of Time and its Enemies: An Introduction to Time and Reality - II"
        3. "Botros (Sophie) - Truth, Time and History: A Philosophical Enquiry", Re-read & Annotate ... also especially
          → "Botros (Sophie) - Truth, Time and History - A Philosophical Inquiry with Dr Sophie Botros", Complete analysis
        4. "Bourne (Craig) - A Future for Presentism",
        5. "Buonomano (Dean) - Your Brain Is a Time Machine: The Neuroscience and Physics of Time",
        6. "Correia (Fabrice) & Rosenkranz (Sven) - Unfreezing the Spotlight: Tense Realism and Temporal Passage",
        7. "Costa (Damiano), Gilmore (Cody) & Calosi (Claudio) - Relativity and Three Four-Dimensionalisms",
        8. Natalja Deng: Various papers, starting with
          → "Deng (Natalja) - One Thing After Another: Why the Passage of Time is Not an Illusion",
        9. Mauro Dorato: Various papers,
          → "Dorato (Mauro) - Presentism / Eternalism and Endurantism / Perdurantism: why the unsubstantiality of the first debate implies that of the second",
          → "Dorato (Mauro) - Presentism and the Experience of Time",
          → "Dorato (Mauro) - The Irrelevance of the Presentist / Eternalist Debate for the Ontology of Minkowski Spacetime".
        10. "Fischer (Florian) - Philosophy of time: A slightly opinionated introduction",
        11. "Friebe (Cord) - Eternalism and the Temporal Content of Persistence", and
        12. "Friebe (Cord) - Metametaphysics: the Ontology of Spacetime and the Presentist/Eternalist Debate".
        13. "Lebens (Samuel) & Goldschmidt (Tyron) - The Promise of a New Past": Complete and send to Sophie Botros & Michael J. Alter,
        14. "LePoidevin (Robin) - Travels in Four Dimensions: The Enigmas of Space and Time",
        15. "LePoidevin (Robin) & MacBeath (Murray), Eds. - The Philosophy of Time: Oxford Readings in Philosophy",
        16. "Mellor (D.H.) - Review of Michael Tooley: 'Time, Tense, and Causation'", Read & review
        17. "Miller (Kristie) - Issues in Theoretical Diversity: Persistence, Composition, and Time",
        18. "Roselli (Andrea) - How Long is Now? A New Perspective on the Specious Present",
        19. "Rovelli (Carlo) - The Order of Time",
        20. "Sattig (Thomas) - The Flow of Time in Experience",
        21. "Savitt (Steven) - Presentism and Eternalism in Perspective",
        22. "Skow (Bradford) - Objective Becoming",
        23. "Torrengo (Giuliano) - Time and Simple Existence",
        24. "Thomas (Emily) - Before, now, and next", Expand review
        25. "Thomas (Emily) - Does the Future Exist?", Expand review
        26. "Zimmerman (Dean) - Presentism and the Space-Time Manifold"
    10. Chapter 672 (Animalism73). Focussing on:-
      1. Animals74:
        1. "Chittka (Lars) & Wilson (Catherine) - Bee-brained",
        2. "Keim (Brandon) - I, cockroach",
        3. "Rachlin (Howard) - Teleological behaviourism or what it means to imagine a lion",
        4. "Ross (Don) - Consciousness, language, and the possibility of non-human personhood: Reflections on elephants".
      2. Animalism75
        1. "Hershenov (David) - Review of David DeGrazia’s Human Identity and Bioethics",
        2. "Merricks (Trenton) - Objects and Persons",
        3. "Olson (Eric) - The Human Animal - Personal Identity Without Psychology", my core text,
        4. "Shoemaker (Sydney) - Persons, Animals, and Identity",
        5. "Snowdon (Paul) - Persons, Animals, Ourselves",
      3. Life76
        1. "Al-Khalili (Jim) & McFadden (Johnjoe) - Life on the Edge: The Coming of Age of Quantum Biology", Finish reading & write file-note
        2. "Difrisco (James) & Mossio (Matteo) - Diachronic Identity in Complex Life Cycles: An Organizational Perspective",
        3. "Lachmann (Michael) & Walker (Sara) - Life ≠ alive",
        4. "Noble (Denis) - The Music of Life: Biology Beyond Genes", Read
        5. "Noble (Denis) - Dance to the Tune of Life: Biological Relativity", Read
        6. "Schrodinger (Erwin) - What is Life?"
    11. Chapter 777 (The Constitution View78):-
      1. "Baker (Lynne Rudder) - Persons and Bodies: A Constitution View": My other core text. Start a serious review.
      2. "Baker (Lynne Rudder), Etc. - E-Symposium on 'Persons & Bodies: A Constitution View'": Write up reviews of papers,
      3. "Corcoran (Kevin) - Rethinking Human Nature: A Christian Materialist Alternative to the Soul": Read and review,
      4. "Loose (Jonathan) - Constitution and the Falling Elevator": Write a Note.
      5. "Mellor (D.H.) - Micro-composition": Read
      6. "Zahavi (Dan) - Subjectivity and Selfhood: Investigating the First-Person Perspective": Write-up.
    12. Chapter 879 (Arguments against Animalism80):-
      1. "Bailey (Andrew M.) - The Elimination Argument",
      2. Dicephalus & Conjoined Twins81
        1. "Buchanan (Rachael) - The battle to separate Safa and Marwa"
        2. "Campbell (Tim) & McMahan (Jeff) - Animalism and the Varieties of Conjoined Twinning"
        3. "Olson (Eric) - The Metaphysical Implications of Conjoined Twining"
        4. "Stone (James L.) & Goodrich (James T.) - The craniopagus malformation: classification and implications for surgical separation"
        5. "Wikipedia - Craniopagus twins"
      3. "Olson (Eric) - The Role of the Brainstem in Personal Identity",
      4. "Olson (Eric) - On Parfit's View That We Are Not Human Beings",
      5. Pregnancy82
        1. "Damschen (Gregor), Gomez-Lobo (Alfonso) & Schonecker (Dieter) - Sixteen Days? A Reply to B. Smith and B. Brogaard on the Beginning of Human Individuals",
        2. Elselijn Kingma. Especially
          → "Finn (Suki) - Bun or bump?",
          → "Kingma (Elselijn) - Lady Parts: The Metaphysics of Pregnancy", and
          → "Kingma (Elselijn) - Were You Part of Your Mother?".
        3. "Gomez-Lobo (Alfonso) - Sortals and Human Beginnings",
        4. "Isaac (Sasha) - Is artificial-womb technology a tool for women’s liberation?",
        5. "Oderberg (David) - The Metaphysical Status of the Embryo: Some Arguments Revisited",
        6. "Smith (Barry) & Brogaard (Berit) - Sixteen Days".
    13. Chapter 1083 (Thought Experiments84):-
      1. "Nielsen (Lasse) - Reconstructing Thought Experiments in Personal Identity", Read & Write-up
      2. "Searle (John), Etc. - Minds, Brains, and Programs", Annotate
      3. "Wilson (James) - The trolley problem problem", Write-up
      4. Investigate Transhumanism85. In particular,
        1. "Alexander (Denis) - Healing, enhancement and the human future": Read,
        2. "Awad (Edmond), Etc. - The Moral Machine experiment": Read,
        3. "Ball (Philip) - Sim ethics": Write up,
        4. "Bostrom (Nick) - Superintelligence: Paths, Dangers, Strategies": Read,
        5. "Bridle (James) - New Dark Age: Technology and the End of the Future": Read,
        6. "Clark (Andy) & Kuhn (Robert Lawrence) - Aeon: Video - Andy Clark - Virtual immortality": Review write-up86,
        7. "Contera (Sonia) - Nano Comes to Life": Read,
        8. "Davies (Sally) - Women’s minds matter" (and papers cited / resisted)
        9. "Francis (Matthew) - Is this life real?", Write-up
        10. "Fry (Hannah) - Hello World: How to be Human in the Age of the Machine": Read & review,
        11. "Graziano (Michael) - Endless fun": Detailed review,
        12. "Hanson (Robin) - The Age of Em: Work, Love, and Life when Robots Rule the Earth", Read
        13. "Harari (Yuval Noah) - Homo Deus: A Brief History of Tomorrow": Review, especially Chapter 8,
        14. "Kent (Adrian) - Replication Ethics": Read,
        15. "Kobie (Nicole) - Quantum Supremacy is here - So what?": Complete write-up,
        16. "Madary (Michael) & Metzinger (Thomas) - Real Virtuality: A Code of Ethical Conduct": Read,
        17. "Marshall (Richard) & Metzinger (Thomas) - Thomas Metzinger: All About the Ego Tunnel": Read,
        18. "Midgley (Mary) - Biotechnology and Monstrosity: Why We Should Pay Attention to the 'Yuk Factor'": Complete,
        19. "O'Connell (Mark) - To be a Machine": Briefly review,
        20. "Otsuka (Michael) - Personal Identity, Substantial Change, and the Significance of Becoming": Read,
        21. "Schneider (Susan) - Artificial You": Read,
        22. "Shipley (G.J.) - Review of Andy Clark's 'Natural-Born Cyborgs'": Complete review,
        23. "Smith (Wilfred Cantwell) - The Promise of Artificial Intelligence": Read,
        24. "Tegmark (Max) - Life 3.0: Being Human in the Age of Artificial Intelligence": Read,
        25. "Wyatt (John) - Artificial intelligence and simulated relationships": Write-up.
    14. Chapter 1187 (Resurrection88):-
      1. Death89
        1. "Baillie (James) - We all know that we will die, so why do we struggle to believe it?": Complete review
        2. "Bradley (Ben), Feldman (Fred) & Johansson (Jens) - The Oxford Handbook of Philosophy of Death": Start a review, especially
          → "Zimmerman (Dean) - Personal Identity and the Survival of Death",
        3. "Kaufman (Sharon) - Neither person nor cadaver", Review
        4. "Luper (Steven), Ed. - The Cambridge Companion to Life and Death": Start a review, especially
          → "Olson (Eric) - The Nature of People",
        5. "Stone (Alison) - Thinking about one’s birth is as uncanny as thinking of death": review
        6. "Veatch (Robert M.) - Would a Reasonable Person Now Accept the 1968 Harvard Brain Death Report? A Short History of Brain Death": review
      2. Makropulos Case90
        1. "Moore (Adrian W.) - Is the quest for immortality worse than death?": Detailed analysis
        2. "Moore (Adrian W.) - Williams, Nietzsche, and the Meaninglessness of Immortality": Read and review
      3. Reincarnation91
        1. "Barua (Ankur) - Revisiting the Rationality of Reincarnation-Talk": Write a file-note.
        2. "MacIntosh (J.J.) - Reincarnation and Relativized Identity": Read and review
        3. "Noonan (Harold) - The Possibility of Reincarnation": Read and review
      4. Resurrection92
        1. "Martin (L. Michael) & Augustine (Keith) - The Myth of an Afterlife: The Case against Life After Death": Start a thorough review,
        2. "Badham (Paul) - Christian Beliefs About Life After Death": Read and review
        3. "Baker (Lynne Rudder) - Death and the Afterlife": Read and review
        4. "Corcoran (Kevin) - Dualism, Materialism and the Problem of Post Mortem Survival": Read and review
    15. As background tasks:-
      1. Ensure all items in:-
        → "Various - Papers on Desktop", and
        → "Various - Papers in Desk Drawer"
        are either addressed or re-filed.
      2. Maintain "Various - Papers Yet To Be Logged", and log papers therein if they become important.
      3. Convert old PDF-précis, Etc93 to Notes.
        1. Review the above two reports (how is the first produced, and why aren't the pdfs highlighted?)
        2. As an interim task, if possible, correct the dates + email address on the longer pdfs
        3. Re-read & enhance recent conversions, ie:-
          → "Dennett (Daniel) - True Believers: The Intentional Strategy and Why it Works"
          → "Popper (Karl) - Corroboration: The Merits of Improbability"
          → "Skyrms (Brian) - The Goodman Paradox and the New Riddle of Induction"
          → "Woolhouse (Roger) - Leibniz and Substance"
          → "Woolhouse (Roger) - Spinoza and Substance"
      4. Complete cataloguing the books downloaded from Springer,
      5. Continue with "Marshall (Richard) - Philosophy at 3:AM: Questions and Answers with 25 Top Philosophers",
      6. Complete reading (or make notes on):-
        1. "Ball (Philip) - Beyond Weird: Why Everything You Thought You Knew About Quantum Mechanics is ... Different",
        2. "Barker (Jonathan) - Debunking Arguments and Metaphysical Laws",
        3. "Borges (Jorge Luis) - Labyrinths: Selected Stories and Other Writings",
        4. "Costa (Albert) - The Bilingual Brain: And What It Tells Us about the Science of Language",
          → "Hernandez (Arturo E.), Etc - In Memoriam - The Bilingual Brain: Emergent, Dynamic, and Variable. Albert Costa (1970–2018)"
        5. "Dennett (Daniel) - The Mind's I - Fantasies and Reflections on Self and Soul: Introduction",
        6. "Erber (Joan T.) & Szuchman (Lenore T.) - Great Myths of Aging",
        7. "Everett (Daniel) - Did Homo erectus speak?",
        8. "Greene (Brian) - The Hidden Reality: Parallel Universes and the Deep Laws of the Cosmos",
        9. "Hoffman (Donald D.) - The Case Against Reality: How Evolution Hid the Truth from Our Eyes",
          → "Gefter (Amanda) & Hoffman (Donald D.) - The Evolutionary Argument Against Reality"
          → "O'Grady (Jane) - Donald Hoffman’s 'The Case Against Reality' is hard to get your head around"
        10. "Hofstadter (Douglas) - Godel, Escher, Bach: an Eternal Golden Braid - A Metaphorical Fugue on Minds and Machines in the Spirit of Lewis Carroll",
        11. "Howson (Colin) & Urbach (Peter) - Scientific Reasoning: The Bayesian Approach",
        12. "Ord (Toby) - The Precipice: Existential Risk and the Future of Humanity",
        13. "Rovelli (Carlo) - Reality Is Not What It Seems: The Journey to Quantum Gravity",
        14. "Vedral (Vlatko) - Decoding Reality: The Universe as Quantum Information".
      7. Complete my Note on "Smith (Martin) - Why Throwing 92 Heads in a Row Is Not Surprising" and discuss with Pete & Mike.
      8. Continue reading and reviewing papers issued by Aeon94,
      9. Keep up with the Journals via JSTOR & Cambridge Core.
      10. Update my Journals Note95: Review the journals I have access to; more are available as a Cambridge Alumnus.
      11. Keep up with the philosophical world by regular reviews of "Interaction - Philos-List", but only seriously pursue items relevant to my research.
  2. Religion96
    1. Philosophy of Religion:
      1. "Antony (Louise M.) - Philosophers without Gods: Meditations on Atheism and the Secular Life": Continue reading,
      2. "Ferguson (Matthew) - Κέλσος": Continue reading the Blog,
      3. "Insole (Christopher J.) - Realism and Anti-Realism": Read,
      4. "Plantinga (Alvin) & Dennett (Daniel) - Science and Religion: Are They Compatible?": Read.
    2. Resurrection: Continue reviewing97
      1. "Alter (Michael J.) - The Resurrection: A Critical Inquiry", and
      2. "Alter (Michael J.) - The Resurrection & Christian Apologetics: A Critical Inquiry Volume 2".
    3. Background:
      1. Aeon (https://aeon.co/): Read & annotate papers as they arise
      2. "Finkelstein (Israel) & Silberman (Neil Asher) - The Bible Unearthed": Continue reading
      3. "Finkel (Irving) - The Ark Before Noah: Decoding the Story of the Flood": Continue reading
      4. "Lennox (John C.) - Where Is God in a Coronavirus World?": Review in Blog
      5. "Levine (Amy-Jill) & Brettler (Marc Zvi), Eds. - The Jewish Annotated New Testament": Continue reading
      6. "Taylor (Joan E.) - Jesus and Brian: Exploring the Historical Jesus and His Times Via Monty Python's Life of Brian": Review KCL Conference videos
  3. Website98
    1. Own Website: Priority 1 Items By Category:-
      • Architecture
        1. Compact and Repair Problems
          1. On compacting and repairing my main database I sometimes get the error "The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result".
          2. It happens 3 times while the database is re-opening.
          3. There is lots of space, and the database is only 600Mb (and the error started when it was under 500Mb).
          4. This mostly happens after I've run long processes, so I usually close the database, re-open it and then try the compact and repair. Usually this works, but not always. But I then try again and the message disappears.
          5. I strongly suspect that this is MS Access itself re-indexing tables, and blowing up a temporary database, but I can’t find any evidence for this on-line. Or help, other than suggestions to split databases and do other sensible things. Given that the error occurs when the database is re-opening, with no temporary file visible, is very strange.
          6. 17/04/20 - set MaxLocksPerFile to 1,000,000 (from the default 9,500). Sadly, it doesn't seem to have made a difference.
        2. Complete XRef-re-engineering project:-
          1. Ensure all links and link-pages use the new XRef table, and pension off the old tables.
          2. Look into writing out specific object-identifiers, and linking thereto for Citations, rather than paragraph references. An issue is multiple instances of the same object in a document.
          3. Check all link-types still work and fix any errors.
          4. Complete the auto-triggering of regeneration of “associated” link pages.
          5. Fix update bug in Convert_Webrefs.
          6. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
          7. Document the process!
        3. Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
        4. Where possible, use ID rather than NAME for in-page hyperlinks
      • Backups
        1. Investigate Record-count discrepancies:-
          1. How do website files work as far as counts are concerned?
          2. Why aren't they recorded in Backup_History, nor the fact that the website was backed up?
          3. Different counts depending on whether new or old laptop is backed up. Investigate 63k discrepancy - lower on new laptop.
        2. Review architecture to improve performance; Need to document first
      • Books
        1. Further improve the time to regenerate Book Summaries. Now takes about 39 minutes, but should be under 5 minutes!
      • Books/Papers
        1. Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
        2. Reformat the PaperCitings pages:-
          1. Include only useful information on the detail pages; but if there are multiple links from the same object, include them on the same line as 'extra links' as in Authors' Citations (copy the code).
          2. Include counts on the summary page.
          3. Document!
          Do the same for BookCitings
      • Bridge
        1. Develop auto-reconciliation routines vs EBU results download
      • Documenter
        1. Investigate the error reports from the Documenter, especially unused variables & queries.
        2. Provide Functional Documentation for Website Generator (using Notes)
      • Education
        1. "Sitepoint (Learnable) - Sitepoint Learnable Web Development Courses": Membership cancelled, but plan what to do with the eBooks in my possession.
        2. Read "PC Pro - Computing in the Real World".
        3. Read "White (Ron) & Downs (Timothy Edward) - How Computers Work: The Evolution of Technology".
      • Infrastructure
        1. iCloud for Windows: Re-install & solve 'The upload folder for iCloud Photos is missing' problem. Try on new Laptop.
      • Notes
        1. Add "Note Alternates" to Note pages.
        2. Add option in Auto-Reference Notes to automatically ignore words containing certain strings that include the key-word (eg. ignore 'grace' and 'trace' when indexing 'race')
        3. Add option in Auto-Reference Notes to only confirm new items (leaving previously-flagged items untouched)
        4. Allow the option to concatenate Notes in the Printed version (ie. linearly embed them essay-style), rather than treating the hyperlinks as footnotes – but still keep the hyperlink & cross-referencing in place.
          1. For use as "disclaimers" - eg. for "Plug Notes".
          2. For Thesis / essays: the difficulty here is the need for linking passages to make the text run smoothly.
        5. As part of the Cross-Referencing project, check out the consistent treatment of Note 87599, which should be universally ignored. Recently, links to it appeared on Book-Summaries, Book_Paper_Abstracts and Note_Book_Links, as a Note referencing a Book. The critical item was a row on the Note_Book_Links table.
        6. Determine why very long printable notes (eg. Level 3+ for Note 170100) are being truncated. Probably suppress them in any case, as they take far too long to load.
        7. Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
        8. Investigate Note_Links: Section references seem to be incorrect
        9. Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
        10. Split Aeon Page101 into multiple sub-pages (either by topic or by priority)
        11. Suppress the publication of the Printable versions of Temp Notes
      • Papers
        1. The monthly regeneration process for Paper Abstracts still takes just over 5 hours. Problem is with Cross_Reference_Deletions and Cross_Reference_Additions. Cannot be fixed until the cross-referencing project is fully complete and documented.
      • Photos
        1. Develop software & procedure to make adding more content to the photos pages easier to undertake.
        2. Timeline software: Add photos for Holidays & Family History
      • Process
        1. Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
      • Spider
        1. Analyse the results of the data collection exercise and design a plan of campaign to fix broken Internal links and prevent recurrence.
          1. Correct the code so the problems discovered by the Spider don’t recur.
          2. Delete 'orphan pages' that are never linked to, ie. Use the Spider to prune redundant pages102 automatically where possible.
          3. Fix the historical data where errors are uncovered by the Spider. An easier task now the site has a full-regen function.
        2. The size of the main database bloats to over 1.6Gb during the spider run, so is approaching the 2Gb limit.
          1. Use Check_Database_Size, with a parameter, to monitor the size – output a message along the those reporting the compact / repair of the Slave database).
          2. Put a checks in to STOP if over 1.8Gb.
          3. Determine a solution as the limit is pushed. Some tables are “local” for performance reasons and are later copied to the Slave … maybe move them?
        3. The Spider was generating WebRefs. Procedurally, this ought not to have been possible.
          1. The major problem turned out to be because unprocessed103 URLs got added to the end of the last WebLinks_Tester_Brief page, which then got Spidered. I've stopped this happening, so hopefully the problem will not recur. The fix was made in 18Q2.
          2. However, 4 other creations appeared - dated 18/05/18 - from the run of 10/07/18. The creation date was from the previous spider run, but the IDs show that they were produced in the latest run.
          I've re-opened the case!
      • Status
        1. Quarterly Project Reports: Correct Functor_08. The Project Planned YTD % keeps having to be bodged!
      • Technology
        1. Look into Sistrix Smart104. Errors and warnings itemised are:-
          1. Duplicate content: seems to be variants on theotodman.com
          2. Title Tags: Empty, too long, identical
          3. Page Not Found
          4. Filesize in excess of 1Mb
          5. Meta-Description: Empty
          6. Few words on Page
          7. H1: Not used, used multiple times per page, identical across pages
          8. Pictures: Alt attribute missing
      • WebRefs
        1. Documentation & Bug-fixes: Phase 2
          1. Re-document the procedures in the light of recent changes.
          2. Resolve issues generated / revealed by the spider.
          3. Investigate - and fix where possible - broken links.
        2. Improve WebRefs checker (Webrefs_Update) further to check for Error 403 "Forbidden". This will often involve finding way of checking pdfs where the returned page is in fact HTML or XML (see DevLog Ref 379).
        3. Investigate defunct items. Populate Defunct_Explanation in WebRefs_Table and include in relevant WebLinks_Tester reports. Consider use of FairUse (Link - Fair Use) for documents no longer available that I'd downloaded.
        4. Reformat WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm
          1. Clarify 'truncated': Display, not link
          2. Allow more space for 'link returned', 'issue' and 'display text'
          3. The 'As Above" lines waste space. Only for Notes Archive? Consolidate onto single second line.
        5. Reformat WebLinks_Tester_Brief: Allow more space for 'link returned', 'issue' and 'display text'
    2. Other Websites: Priority 1 Items By Category:-
      • Bridge
        1. Regular updates to the Hutton Bridge Club (https://www.bridgewebs.com/hutton.html) Website.
        2. Regular updates to the Mountnessing Bridge Club (https://www.bridgewebs.com/mountnessingbc/) Website.
      • Enigma
        1. Termly updates to the Enigma Ensemble (http://www.enigmaensemble.co.uk/) Website.
  4. Music105
    1. Oboe:-
      1. Practice the oboe for two 30-minute sessions each and every day106 – focussing on the items below and …
      2. Occasionally combine into an hour-long session to build up stamina further.
      3. Work through, and perfect, scales & arpeggios107 for Grades I-VIII, using
        → "Trinity Guildhall - Trinity Guildhall Scales & Arpeggios for Oboe (Grades 1–8)", and
        → "ABRSM - Scales and Arpeggios for Oboe, Grades 1-8 (ABRSM Scales & Arpeggios)".
      4. Improve sight-reading by playing through
        → "Trinity Guildhall - Sound at Sight Oboe Grades 1-8", and
        → "Davies (John) & Harris (Paul) - 80 Graded Studies for Oboe: Book 1".
      5. Occasionally review Grade VI pieces, in particular
        → "Boni (Giovanni) - Sonata in G" (Prelude, but also 2nd, 3rd & 4th movements for interest),
        → "Davies (John) & Harris (Paul) - 80 Graded Studies for Oboe: Book 2" (Blatt - Study No. 52),
        → "Morricone (Ennio) - Gabriel's Oboe (Piano Solo Or Oboe/Piano)"
        → "Miller (Vojislav) & Liebermann (Winfried), Eds. - Test Pieces for Orchestral Auditions (Orchester Probespiel) - Oboe" (Eroica, Aida, Der Freischutz),
        → "Nielsen (Carl) - Two Fantasy Pieces, Op. 2" (Romanze only)
      6. Prepare Grade VII pieces, in particular108
        → "Albinoni (Tomaso) - Concerto in D Minor Op. 9/2 for Oboe & Piano", 1st movement (but also 2nd & 3rd for interest)
        → "Bach (J.S.) - 105 Difficult Passages from the Works of J. S. Bach. For oboe", Items 49 & 70
        → "Cimarosa (Domenico) - Oboe Concerto in C minor", All, but particularly 1st & 4th movements
        → "Davies (John) & Harris (Paul) - 80 Graded Studies for Oboe: Book 2" (Ferling - Study No. 62)
        → "Fiocco (J.H.) - Arioso - Oboe + Piano",
        → "Head (Michael) - Presto for Oboe & Piano",
        → "Hinke (Gustav Adolf) - Elementary Method For Oboe", Items 14 & 18
        → "Miller (Vojislav) & Liebermann (Winfried), Eds. - Test Pieces for Orchestral Auditions (Orchester Probespiel) - Oboe" (Mozart Jupiter, Tchaikovsky Pathetique, Stravinsky Pucinella),
        → "Mower (Mike) - The Good Tempered Oboe" (Nos. 28 & 35: 'Jauntless Jig' & 'May The Fourth Be With You'; also No. 30: 'Answer the Question'),
        → "Nielsen (Carl) - Two Fantasy Pieces, Op. 2" (Humoresque),
        → "Saint-Saens (Camille) - Sonata Op.166 in D Major for Oboe & Piano" (1st Movement),
        → "Schumann (Robert) - 3 Romances, Op. 94 for Oboe and Piano" (1st & 3rd Movements; 2nd for interest).
      7. Prepare Grade VIII pieces, in particular109
        → "Bach (J.S.) - 105 Difficult Passages from the Works of J. S. Bach. For oboe", Items 62, 66 and 28
        → "Davies (John) & Harris (Paul) - 80 Graded Studies for Oboe: Book 2" (Harris - Study No. 74; Luft - Study No. 77)
        → "Miller (Vojislav) & Liebermann (Winfried), Eds. - Test Pieces for Orchestral Auditions (Orchester Probespiel) - Oboe" (try various),
        → "Mower (Mike) - The Good Tempered Oboe" (No. 44 - 'Dop Dop Doobah'; also No. 45: 'Enlightenment'),
        → "Saint-Saens (Camille) - Sonata Op.166 in D Major for Oboe & Piano" (2nd & 3rd Movements),
      8. Read and apply oboe practice techniques recommended by:-
        Martin Schuring, and
        → "Benedetti (Nicola) - My five tips for learning an instrument".
      9. Read "Caplan (Stephen) - Oboe: The Breathing Book".
    2. Piano: Try to develop some minimal competence as an aid to theory, so:-
      1. Continue practicing "Rhodes (James) - How to Play the Piano" (Bach's Prelude #1),
      2. Work through "ABRSM - Selected Piano Exam Pieces 2009-2010: Grade 1", and
      3. Try to play by ear, using for inspiration:-
        → "Cannel (Ward) & Marx (Fred) - How to Play the Piano Despite Years of Lessons: What Music Is and How to Make It at Home".
    3. Theory: Prepare for Grade 5 Theory, so:-
      1. Study
        → "Taylor (Eric) - The AB Guide to Music Theory - Part 1", and
        → "Taylor (Eric) - The AB Guide to Music Theory - Part 2",
      2. Whiz through110 the exercises in
        → "Taylor (Eric) - Music Theory in Practice: Grade 1",
        → "Taylor (Eric) - Music Theory in Practice: Grade 2",
        → "Taylor (Eric) - Music Theory in Practice: Grade 3",
        → "Taylor (Eric) - Music Theory in Practice: Grade 4", and
        → "Taylor (Eric) - Music Theory in Practice: Grade 5",
    4. Aural:
      1. Run through:-
        → "Trinity Guildhall - Trinity College London Aural Tests Book 1 (Initial to Grade 5) 2017", and
        → "Trinity Guildhall - Trinity College London Aural Tests Book 2 (Grades 6 to 8) 2017".
      2. Get a grip on the process of ear-training by reading "Deutsch (Diana) - Absolute Pitch", and related material111.
      3. Try out "Boytim (Joan Frey) - The First Book Of Baritone/Bass Solos".
      4. Also follow up items in:-
        → "Various - Music - Aural - Various On-line Training".
  5. Bridge112
    1. Bridge "at the table" is on hold. Only play on-line if pressurised by partners.
    2. Review hands from National Masters Pairs in March 2020.
    3. Review Mountnessing Bridge Club: Hands of the Week (https://www.bridgewebs.com/cgi-bin/bwon/bw.cgi?club=mountnessingbc&pid=display_page6).
    4. Bridge Admin: Committee and Website involvement for Mountnessing and Hutton.
    5. Re-read Hand-counting papers, focussing on
      → Papers in Counting the Hands113,
      → "Bourke (Tim) & Smith (Marc), Bird (David) - Countdown to Winning Bridge", and
      → "Lawrence (Mike) - How to read your opponents' cards: The bridge expert's way to locate missing high cards"
      → "Lawrence (Mike) - How to Play Card Combinations"
    6. Read "Klinger (Ron) - Five-card Majors".
    7. Read "Reading - Bridge - Magazines".
  6. Chess114
    1. Why Play Chess: Seriously consider the issues raised by "Ramon y Cajal (Santiago) - On Chess".
    2. Chess Study:-
      → "Hansen (Carsten) - The Full English Opening: Mastering the Fundamentals",
      → "Ris (Robert) - Crucial Chess Skills for the Club Player: Volume 1",
      → "Ris (Robert) - Crucial Chess Skills for the Club Player: Volume 2",
      → "Sadler (Matthew) & Regan (Natasha) - Game Changer: AlphaZero's Groundbreaking Chess Strategies and the Promise of AI",
      → "Speelman (Jon), Tisdall (Jon) & Wade (Bob) - Batsford Chess Endings",
      → "van der Sterren (Paul) - FCO - Fundamental Chess Openings", and
      → "Willemze (Thomas) - The Chess Toolbox: Practical Techniques Everyone Should Know".
    3. Chess Training:-
      Chess.com (https://www.chess.com/) (game analysis & daily 10-minute game),
      → "Chess - Chess - YouTube Videos"
      → Complete review of 2018/19 season's games, and keep up to date with those of the current season.
    4. Chess Play: Participation115 if and when play resumes in Billericay Chess Club:-
      → Club Nights
      → NECL matches
      → Southend League matches
      → Consider on-line club play
  7. Consciousness116
    1. Aeon117: Read & annotate papers as they arise, especially ...
      → "Chittka (Lars) & Wilson (Catherine) - Bee-brained": Write-up
      → "Frankish (Keith) - The Consciousness Illusion": Write-up
      → "Frohlich (Joel) - Frames of consciousness": Read & write-up
      → "Parks (Tim) & Manzotti (Riccardo) - You are the world": Read & write-up
      → "Pigliucci (Massimo) - Consciousness is real": Read & write-up
    2. "Bonhomme (Vincent), Etc. - General Anesthesia: A Probe to Explore Consciousness": Read & write-up
    3. "Crane (Tim) - Elements of Mind - An Introduction to the Philosophy of Mind": Re-read and review notes.
    4. "Dehaene (Stanislas) - Consciousness and the Brain: Deciphering How the Brain Codes Our Thoughts": Read.
    5. "Dennett (Daniel) - Illusionism as the Obvious Default Theory of Consciousness": Read.
    6. "Donald (Merlin) - A Mind So Rare: The Evolution of Human Consciousness": Read.
    7. "Eliot (Lise) - What's Going On in There?: How the Brain And Mind Develop in the First Five Years of Life": Read.
    8. "Kammerer (Francois) - The Hardest Aspect of the Illusion Problem - and How to Solve it": Read.
    9. "Papineau (David) - Introducing Consciousness": Re-read and write notes.
    10. "Shapiro (Lawrence) - The Mind Incarnate": Read.
    11. "Strawson (Galen) - The Consciousness Deniers": Read & write-up
    12. "Tegmark (Max) - Life 3.0: Being Human in the Age of Artificial Intelligence": Write up Chapter 8: Consciousness
  8. Languages118
    1. Thai: Following Nat's emigration to Thailand & marriage to Fon:-
      → "Lang Workbooks - Master the Thai Alphabet: a Handwriting Practice Workbook",
      → "Ling - Learn Thai",
      → "Lonely Planet - Lonely Planet Thai Phrasebook & Dictionary",
      → "Becker (Benjawan Poomsan) - Thai for Beginners",
      → "ThaiNotes - Thai Notes",
      → "Various - On-Line Thai Learning",
      → "Wikipedia - Thai Alphabet", and
      → "Wikipedia - Thai Language".
  9. Mathematics119
    1. Aeon120: Read papers as they arise.
    2. "Feynman (Richard), Leighton (Robert B.) & Sands (Matthew) - The Feynman Lectures on Physics - Vol I": Read.
    3. "Gowers (Timothy), Barrow-Green (June) & Leader (Imre), Eds. - The Princeton Companion to Mathematics": Browse.
    4. "Polya (George), Stewart (Ian) - How to Solve IT: A New Aspect of Mathematical Method": Read.
    5. Try the puzzles in
      → "Polya (George) & Kilpatrick (Jeremy) - The Stanford Mathematics Problem Book: With Hints and Solutions", and
      → "UKMT, du Sautoy (Marcus) - The Ultimate Mathematical Challenge".
    6. "Shapiro (Stewart) - Thinking about Mathematics - The Philosophy of Mathematics": Complete reading.
    7. "Smith (Martin) - Why Throwing 92 Heads in a Row Is Not Surprising": Analyze.
    8. "Tammet (Daniel) - Thinking in Numbers: How Maths Illuminates Our Lives": Read.
    9. "Wilmott (Paul) - Machine Learning: An Applied Mathematics Introduction": Read.
  10. HiQ121
    1. ISPE
    2. Mensa
      • Nothing planned.



In-Page Footnotes

Footnote 1:
  • Since the contents of the groups changes over time, this justification for their segregation isn’t entirely accurate.
Footnote 12:
  • Mind you, the mathematical bits didn’t function very well in my youth, so what hope is there now?
Footnote 14:
  • Due to administrative confusion, I needlessly took their latest entrance test. After chasing them up I was told I “passed with flying colours”, but could get no more information.
Footnote 15:
  • Coxes Farm hails from the 16th century, or possibly earlier, and is very “wonky”, requiring continual maintenance.
  • In December 2017, a base to roof crack appeared in the render at the front.
  • Subsequent investigations revealed that the frame at the front – which had been added in the 17th century – has rotted away, so the front façade was held up by the brick infill and an impervious cement render, the cause of the rot.
  • The front of the house has now been rebuilt, as has ¾ of the rear. A third project – currently on hold – is to rebuild the lower part of a side wall.
  • I’ve written a Blog Item on this saga, with some theoretical thoughts, which I hope to have published in due course.
Footnote 16:
  • If these link to the wrong version, ie. the current one, you’ll need to go the “previous versions” and select the correct one.
Footnote 20:
  • 25 hours / week represents the amount of time that I’d need to spend if I were pursuing my research part-time at Birkbeck – which would be something like 5 hours / day, 5 days a week.
Footnote 21:
  • As my purchasing has now dropped to a relative trickle, I’ve extended the selection range to cover the last 6 months.
  • Some of these are random purchases from charity shops, or presents. Others are selectively purchased in support of my various projects.
  • Poverty and lack of space is severely curtailing my purchasing power.
Footnote 22:
  • Or at least those recently added to my database, in the case of electronic items that sometimes arrive too fast to be catalogued immediately.
Footnote 25:
  • In the light of the segregation of my projects into three tiers, items for tertiary projects are only to be addressed if everything of higher priority is in shape.
  • If there are any changes to this list between quarters, they will appear in the Priority Task List.
Footnotes 47, 59: Footnote 57:
  • This paper covers the 'Loose and Popular' vs 'Strict and Philosophical' senses of identity, amongst much else.
Footnote 60: Footnote 65:
  • Neither sub-topic is really part of my research into the metaphysics of personal identity, but it's become such an important topic of late - one on which I'm largely ignorant and need to have a considered opinion.
Footnote 86:
  • Also look through other works by Andy Clark to get a handle on what he means by 'patterns in information space'.
Footnote 97:
  • While I couldn't submit to Michael Alter's deadlines and the amount of work required, I ought to at least read these books.
Footnote 102:
  • Note that Backup_Prune_Ctrl deletes (relevant) pages that weren't regenerated in the last full site-regen, but this isn't the same thing.
Footnote 103:
  • These are URLs that were used in web pages but hadn't yet been converted to the +WnnnW+ format, so appeared at the end with no WebRef ID.
Footnote 104:
  • See Sistrix (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Optimizr (http://www.optimizr.com/) (which now auto-forwards to Sistrix).
  • A quick look doesn’t show it to be an obvious scam, but I need to double-check.
  • An unsolicited analysis of my site turned up monthly from Optimizr from January 2015 to October 2017, listing a large number of “problems” that I think I know about, but which are in the queue to address.
  • It restarted in February 2018, under the Sistrix name (this seems to have been associated with Optimizr since November 2015).
  • The free version of this software is restricted to 1,000 pages, which is a very small proportion of my Site, though I may be able to point it to difference base-URLs.
  • But I do need to address the problems validly itemised, and a sub-set is still useful.
Footnote 106:
  • Well, maybe with the occasional holiday, and excluding days on which I have a lesson or the Enigma Ensemble (currently in hibernation).
Footnote 107:
  • I don't intend to present these for the Trinity exams, as I can present Orchestral Audition pieces instead; but they are essential for technique.
Footnote 108:
  • I've yet to decide which to present for the Exam, so this long list will get whittled down in due course.
Footnote 109:
  • These are just the ones from the Trinity schedule that I happen to have. Some look rather fearsome.
  • The only one I've had assigned is the Second Movement of the Saint-Saens.
Footnote 110:
  • The earlier grades are very elementary, but I need practice writing musical notation.
Footnote 111: Ie. The following:- Footnote 115:
  • This used to say "full participation", but I've let the team captain know that my focus is now on Bridge, and that - while I'm willing to "fill a board" - I don't want to take the place of anyone more enthusiastic.
  • In any case, there's now no over the board chess to be had.
Footnote 122:
  • Though I will probably book the time against my Thesis, as it involves what it is to be a person, transhumanism and the like.


Note last updated: 03/07/2020 22:09:07


Footnote 2: (Status: Personal Identity (2020 - June))

Rationale for this Project

  • I am researching the subject of Personal Identity primarily because of its intrinsic interest and importance. It is really a sub-topic in my Philosophy of Religion project, with its penultimate chapter considering the metaphysical possibility of resurrection.
  • While I’m interested in the topic of my research in its own right, I think when I’ve sorted it out a bit, and have something to say, I’ll want to engage with other philosophers active in this field – and re-starting a PhD at Birkbeck or elsewhere might be the only effective way to do this.
  • While a PhD is not an end in itself, and certainly not the ultimate aim of my doing philosophy, it’s still true that a PhD would teach me research techniques, provide focus and direction, and furnish a professional qualification should I want to publish any results in this or any other area of philosophy.
  • The best place to find my current views is here.
  • The jumping-off point for my thesis is here, and a progress dashboard is here4, though neither of these has changed for some considerable time.

Summary of Progress during April - June 2020
  1. I spent 342 hours in 20Q2 on this Project, or related work (796 hours YTD, where for "YTD" - Year to Date - I mean the (academic) year that commenced in October 2019). That's 121.1% of the planned effort (93% YTD). Overall, 47% of my Project effort in the Quarter was directed towards this project (making 38.1% YTD) - as against 40.7% planned (38% YTD).
  2. A full list of items worked on in the quarter appears below.
  3. Most previous reports have itemised where my focus has been, but I only intend to do this annually from now on. While I “have to” spend rather too long keeping up with Aeon, I did focus quite well on the real matter of my Thesis, and spent 20% more time than planned on this project (at the expense of Bridge – at last)!
  4. Progress between reports can be obtained from the relevant section of my Summary Task List. More detail follows:-
Thesis (Total Hours = 229)
  1. Thesis - Reading / Writing (Total Hours = 204.5)
  2. Thesis - Research Repositioning (Total Hours = 24.5)
Thesis Background (Total Hours = 81)
  1. Thesis Background - Reading / Writing (Total Hours = 78.25)
  2. Thesis Background - Books Admin (Total Hours = 0.5)
  3. Thesis Background - Status
Thesis (Aeon) (Total Hours = 32)
Plans for the Near Future – Top Priority Tasks
Summary of Progress to Date

This was hived off to a separate Note back in 2010, and hasn’t changed much since.




In-Page Footnotes

Footnote 7:
  • Hopefully, I may complete, or get stuck, earlier.
  • I had hoped to complete this phase of my research by my 65th birthday – ie. by 13/11/2018. Previously, I’ve remarked “This is not to slip!” Unfortunately, the distraction of the problems with Coxes Farm – as well as a general lack of focus – have meant that it has!
  • On the plus side, I’m already much further advanced than would be expected of someone commencing a PhD.
  • On the minus side, I want to go into much greater depth, and have other projects on the go – most notably Music, Philosophy of Religion, Bridge, Chess and – particularly – my Web-tools project.
  • The original reason for deferring to my 65th birthday was that this is when I became eligible for my State Pension. This may not be much to live on – but it is a quite generous supplement which would make a significant contribution towards the fees and expenses, which prior thereto I couldn’t afford.
  • Unfortunately, my state pension (and Julie’s, for that matter) has been more than gobbled up by payments on the mortgage I’ve managed to obtain for Coxes Farm. We’ll be repaying that until 2031, by which time I’ll be 77. Maybe litigation against a negligent surveyor will liberate some cash.
Footnote 8:
  • This used to say “complete a thesis …”, which is obviously impossible, given that my idea of a thesis is way in excess of what is required.
Footnote 10:
  • This is still ludicrously inadequate for what I want to achieve, but is approximately what would be expected of a part-time research student.
Footnote 12:
  • This is obviously far too long, and keeps getting items “carried forward” tacked on to it.
  • Maybe I’ll prune it next time.
Footnote 33: Footnote 43:
  • This paper covers the 'Loose and Popular' vs 'Strict and Philosophical' senses of identity, amongst much else.
Footnote 45: Footnote 46: Footnote 51:
  • Neither sub-topic is really part of my research into the metaphysics of personal identity, but it's become such an important topic of late - one on which I'm largely ignorant and need to have a considered opinion.
Footnote 72:
  • Also look through other works by Andy Clark to get a handle on what he means by 'patterns in information space'.

Note last updated: 03/07/2020 22:09:07


Footnote 2.4: (Status: Thesis Dashboard (2020: June))

Below is a table1 showing the indicative progress on my Thesis, broken down by Chapter. More detail is given in footnotes. For a definition of the Tasks, follow this Link3.

ChapterTask 01Task 02Task 03Task 04Task 05Task 06Task 07Task 08Task 09Task 10Task 11Task 12
Chapter 01 (Introduction)CompleteCompleteCompleteCompleteStartedCompleteDrafted5  Complete6  
Chapter 02 (What are We?)CompleteStarted8Complete9CompleteStartedComplete10Drafted  Drafted  
Chapter 03 (What is a Person?)CompleteIteration_1Complete      Started  
Chapter 04 (Basic Metaphysical Issues)CompleteStarted13Complete      Drafted  
Chapter 05 (Persistence and Time)CompleteIteration_115Complete      Started  
Chapter 06 (Animalism and Arguments for It)CompleteStarted17Complete      Started  
Chapter 07 (The Constitution View and Arguments for It)CompleteCompleteComplete      Started  
Chapter 08 (Arguments against Animalism)CompleteCompleteComplete         
Chapter 09 (Arguments against the Constitution View)CompleteCompleteComplete         
Chapter 10 (Thought Experiments)CompleteComplete22Started23         
Chapter 11 (Resurrection)CompleteCompleteComplete      Started  
Chapter 12 (Conclusion)N/A26N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A





In-Page Footnotes

Footnote 1: Footnote 3: The definitions of the 12 tasks are a follows:-
  1. Determine which Notes that I have written are relevant to this Chapter.
  2. Fill out any Note-place-holders with whatever's in my head!
  3. Use the reading lists associated with these Notes to establish a limited reading list for the Chapter.
  4. Review whatever I've written, in whatever format, on the items in the derived reading lists, and make necessary cosmetic changes in the process of evaluating the items.
  5. Segregate this reading list into:-
    • Higher versus lower priority,
    • Read versus unread,
    • Annotated (by hand) versus unannotated
    • Those with an Abstract or Note Write-up versus those without
  6. Cull items that are unlikely to be addressed in the next two years and list them as specifically excluded. I may pick up on these at a later stage of the project, but in the short term the culling process will be essential for making across-the-board progress.
  7. Determine why the residue are important and relevant - if they are - and briefly document the reasons.
  8. Migrate any Book or Paper Abstracts that I have written (as distinct from copied from elsewhere) to Write-Up Notes.
  9. If the Book or Paper is important enough, migrate any hand-written annotations to a Write-Up Note, and complete any important incomplete Write-Up Notes.
  10. Write and maintain a Chapter Summary, motivating and summarising the Chapter. Use this to ensure I don't get side-tracked.
  11. Incorporate the key points of Write-Up Notes into the Topic Notes.
  12. Incorporate the highest level thoughts from the Topic Notes into the Main Text of the Chapter.
Footnote 5: Needs reviewing as part of the "culling" process.

Footnote 6: This is just the aggregate of the Chapter Abstracts

Footnote 8: Beings and Souls are a bit skimpy.

Footnote 9:
  • This is the Chapter on which I was working when I started my PhD, and the papers are those I was assigned. They have extensive Write-ups and supervision notes.
  • However, I need to undertake a more thorough review of the literature.
Footnote 10: I probably need to be more rigorous in the culling of items on Selves and Souls.

Footnote 13: Relative Identity, Vague Identity, Indeterminate Identity, Contingent Identity, Occasional Identity and Substance are skeletal.

Footnote 15: Time, Persistence and Persistence Criteria are all rather skimpy.

Footnote 17: Thinking Animal Argument is skeletal and "Other Arguments For Animalism" requires a Note.

Footnote 22: Siliconisation is probably Unger's idea, but I seem to have lost the reference.

Footnote 23:
  • The reading-list for the theory of thought-experiments is OK, but not for the TEs themselves.
  • Many of the relevant papers will have been considered earlier in the Thesis, but they need to be reviewed here.
Footnote 26: This Chapter is non-standard.

Note last updated: 03/07/2020 20:28:19


Footnote 2.6: (Psychological Continuity - Forward)

Plug Note

  • I think there’s a conceptual difference between:-
    1. Forward psychological continuity, and
    2. Backward psychological continuity.
  • Imagine the case where (on an endurantist account of persistence; see later for the distinction – and it’s relevance to this case – between endurantism and perdurantism), I’m put into a duplicating machine5, but something goes wrong and my body is destroyed by the duplication process, though my duplicate wakes up perfectly happily. Then, it seems to me, I would never wake up, and would have no experience beyond entry to the duplicating machine. I would have no forward psychological continuity.
  • However, my duplicate does have backward psychological continuity. Any duplicate of me, looking backward, would consider himself to be “me”, having my memories, abilities, plans and so forth, and a body looking just like mine. But, would I ever wake up as the duplicate? My intuition on the endurantist account, as I have said, is that I would not, though I suspect that on the perdurantist account, this might be seen as a case of intended fission in which I was intended to wake up twice, provided we consider that the right sort of causality is in place.
  • The above considerations raise issues similar to those in closest continuer accounts of personal identity, and the Only 'X' and 'Y' Principle. How can what happens to someone else affect whether (so to speak) I am me? How could the “right sort of causality” have anything to do with how I experience things?
  • Fission is, in any case, hard to imagine happening to oneself. Just what does it mean to “wake up twice”? I dare say one could get one’s head(s) around it. The two selves would then be distinct individuals, with distinct consciousnesses, but with a shared past. On the perdurantist account, we were always distinct, but co-located with everything in common.
  • Let’s consider forward psychological continuity in everyday life. What ensures forward continuity of consciousness in the normal case of sleep and temporary unconsciousness? I cannot know “from the inside” that when I awake I’m the same human being as the one that went to sleep in my bed. The reason I believe this is for external reasons: duplication is not physically possible (or at least practical), and in any case I have no reason to believe it happened to me last night. Other people assure me that there was nothing out of the ordinary going on.
  • This seems a very important issue to me, and I need to make more of it. For example, in teletransportation thought experiment, it seems to me18 that a new person wakes up, but I don’t, nor do I experience anything, though the new person claims to be me. Incidentally, it’s not just a new person, but a new human being who wakes up.
  • This is the sort of question that the Logical Positivists would denounce as meaningless, as no empirical evidence can decide it.
  • Andy Clark, in "Clark (Andy) & Kuhn (Robert Lawrence) - Aeon: Video - Andy Clark - Virtual immortality", raises the question about what ensures psychological continuity – more or less than in the case of Teletransportation – in the case of dreamless sleep, or (hypothetically) being frozen and then thawed out. We might ask what it is in the normal waking case. Maybe the whole thing is related to the arrow of time or in the distinctions between forward-looking psychological properties – desires and intentions yet to be satisfied or acted upon, and memories of what has already taken place.
  • Producing a reading list on this topic is difficult as the distinction – to my knowledge – isn’t usually made. There’s a huge overlap with the general literature of psychological continuity and connectedness and that on Teletransportation. For these, see:-
    Psychological Continuity,
    Teletransportation.
  • So, the above caveats aside, works on this topic that I’ve actually read, include the following:-
    1. "Blackburn (Simon) - Has Kant Refuted Parfit?", Blackburn
    2. "Clark (Andy) & Kuhn (Robert Lawrence) - Aeon: Video - Andy Clark - Virtual immortality", Clark & Kuhn
    3. "Dainton (Barry) - Self: Philosophy In Transit: Prologue", Dainton
    4. "Ehring (Douglas) - Personal Identity and Time Travel", Ehring
    5. "Lockwood (Michael) - When Does a Life Begin?", Lockwood
    6. "Olson (Eric) - Immanent Causation and Life After Death", Olson
    7. "Shoemaker (David) - Personal Identity and Immortality", Shoemaker
    8. "Shoemaker (David) - Personal Identity, Rational Anticipation, and Self-Concern", Shoemaker
    9. "Smith (Barry C.), Broks (Paul), Kennedy (A.L.) & Evans (Jules) - What Does It Mean to Be Me?", Smith
  • A further reading list might start with:-
    1. TBA: I’ll add items to the list as they arise.
  • This is mostly a place-holder.





In-Page Footnotes

Footnote 5: Footnote 18:

Note last updated: 15/06/2020 18:28:48


Footnote 4: (Status: Web-Tools (2020 - June))

Rationale for this Project

  • This Project was alluded to briefly in a footnote on research methodology in my original Research Proposal under the head Research - Internet Technology. When last at Birkbeck, I wrote a more extensive paper defending the Project and describing its rationale. Now that my PhD is in suspense, I have decided to take this Project further. There’s a lot to do: still quite a few items on the “wish list”. It is fairly critical as an enabler for my research, so I need to get a move on as I want it all out of the way before I re-start4 formal research.
  • For documentation on my website (currently password protected) follow the links below:-
    1. Functional5 Documentation6.
    2. Technical7 Documentation.
  • Other Websites8
    1. Active
      1. I’ve created and continue to maintain a small website for a music group Julie and I attend – the Enigma Ensemble (http://www.enigmaensemble.co.uk/).
      2. I established the Hutton Bridge Club (https://www.bridgewebs.com/hutton.html) Website in 11Q4 using the standard Bridgewebs service, but with a couple of competitions using my own routines. This was handed over in 15Q3, but I’ve taken it on again as of March 2020, not that there’s currently much to do. It needs a spring clean, but I’m waiting to see whether the club (and its members) survive the coronavirus pandemic.
      3. In 16Q3 I created the Mountnessing Bridge Club Archive (http://mountnessing.theotodman.com/index.shtml) website, using the vast bulk of the pages from their legacy site, as the club had moved to Bridgewebs and lost its historical data. As of March 2020 I’ve taken over the aforementioned Mountnessing Bridge Club (https://www.bridgewebs.com/mountnessingbc/) website itself.
    2. Inactive
      1. Sometime around 2005, I created a website for Dr. Sophie Botros (http://www.sophiebotros.com/), one of my supervisors at Birkbeck, but we then lost touch and it got maintained (very badly) by some desktop support outfit. In 15Q2 I took it back on again and spruced it up a bit, and maintain it periodically until 19Q3, when it was taken on by a professional outfit, Bookswarm (https://bookswarm.co.uk/). The “Sophie Botros” link in this bullet is now to their version of the site.
      2. I created and / or ran a multitude of other bridge websites, but as of January 2018 I have either handed them over or mothballed them9:-
        1. In 15Q1, I took over the support and development of the Essex Contract Bridge Association (https://www.bridgewebs.com/essex/) (ECBA) website, which also uses Bridgewebs, but is very much larger. I wrote a lot of code10 to make this job less tedious. The site was handed over in 17Q4.
        2. For several years, I collected data11 on bridge activity in the Billericay/Brentwood area (initially needed for a project to set up a new consolidated club) by “scraping” data off web pages, consolidating it into a database and modelling it in various ways.
        3. I used this data to generate websites with a multitude of ladders for small clubs (Essex Bridge Results (http://www.theotodman.com/Bridge/index.htm)). These are now mothballed.
        4. I created and maintained a new website for the First Class Bridge (https://www.bridgewebs.com/firstclassbridge/) Academy, giving it “small clubs” ladders (Bernie's Ladders Archive (https://www.bridgewebs.com/cgi-bin/bwom/bw.cgi?club=firstclassbridge&pid=display_page10)) as these were easy to maintain with little intervention.
        5. In 16Q3 I created the Mountnessing Bridge Club Archive (http://mountnessing.theotodman.com/index.shtml) website, using the vast bulk of the pages from their legacy site, as the club had moved to Bridgewebs and lost its historical data.
      3. I created a website for displaying the textual and grammatical analyses and appendices of Pete’s PhD on the Acts of the Apostles. It exists in two versions: Acts: Live Site (http://www.acts-research.website/) and Acts: Test Site (http://www.theotodman.com/Petes_PhD/index.htm).

Summary of Progress during April - June 2020
  1. I spent 138.25 hours in 20Q2 on this Project, or related work (332.5 hours YTD, where for "YTD" - Year to Date - I mean the (academic) year that commenced in October 2019). That's 134.6% of the planned effort (116.6% YTD). Overall, 19% of my Project effort in the Quarter was directed towards this project (making 15.9% YTD) - as against 14.8% planned (12.6% YTD).
  2. In 20Q2 I made quite a lot of progress documenting and improving the Cross-Referencing algorithms12 and – as it turned out a related matter – improving the run times of the full Website regeneration routines. Consequently, I overspent my time budget by over a third. Time well spent, though.
  3. Completed items included:-
    1. Own Website:
      • Architecture
        1. Enhanced the Functor processing to allow parameters. Previously, I had to create a new Functor ID each time for a very similar requirement. The main problem with this old method was that these Functors (where they call another Functor, or subroutine from a row in Functor) didn't feed through into the Documenter subroutines properly.
        2. Truncated Cross_Reference_Changes table (from over 1M rows to under 50k) which should be self-maintaining, but isn't. This seems to have improved the regeneration times of Notes, Archived Notes and some other objects now that insertions into this table are quicker. Needs a permanent solution as part of my Cross-Referencing project.
      • Authors
        1. Enabled "alternate names" for identically-named authors (to avoid middle-initial = X):-
          1. Set up and populated Author_Name_Display
          2. Ensured Author_Name_Display appears on the Author page.
        2. Determined why the monthly regeneration process for Authors has ballooned from under 4 hours in January 2020 to over 17 hours in April 2020. Fix on 11/04/20 - time more than halved to 8.25 hours - by re-engineering the 'menu' process that counts the items linked to further down the page.
        3. Further reduced the monthly regeneration process time for Authors from 8.25 hours to 13 minutes! Fixed by materialising and indexing a 'view' to table Authors_Cited_By_All_List.
      • Books
        1. Determined why the monthly regeneration process for Book Summaries had ballooned from 1.1 hours in January 2020 to 3.5 hours in April 2020. Partly fixed by by materialising and indexing the view (now table) Book_Citings_List_New, so now takes 39 minutes. Further improvement required, given that Paper Summaries only takes 5 minutes.
      • Books/Papers
        1. Determined why the monthly regeneration process for Book-Paper Abstracts had doubled from 2.4 hours in January 2020 to 4.8 hours in April 2020. Successfully reduced to just upder one hour by materialising and indexing BookPaperAbstracts_List.
      • Documenter
        1. Created various generic Functors to help Document Cross-Referencing by producing cross-tabs and lists from queries. Then the associated stats can be regenerated each time the documentation13 is regenerated (as TEMP): Functor_21, Functor_22, Functor_23, Number_Format.
      • Notes
        1. As revealed by Spider: Sundry uncategorised. Refs failing. 30 items. Fixed manually.
      • Papers
        1. Determined why the monthly regeneration process for Paper Abstracts had ballooned from just over 6 hours in January 2020 to over 17 hours in April 2020. Reduced to just under 4 hours as a result of materialising and indexing the view (now table) Paper_Citings_List_New. Further improvements required.
        2. Determined why the monthly regeneration process for Paper Summaries had ballooned from just over 3.5 hours in January 2020 to around 11.5 hours in April 2020. Fixed by materialising and indexing the view (now table) Paper_Citings_List_New, so now takes 6 minutes!
      • Process
        1. Full Website Regeneration took 60 hours in April 2020. This has now been substantially fixed, as of end June 2020, in that regeneration now takes just under 11 hours. While further improvements are possible, the best use of time is to avoid the need for regular regeneration altogether by completing my Cross-referencing project.
        2. Corrective work was split out into the items requiring improvement, must of which have now been implemented.
        3. History and analysis:-
          1. This 'balooning' was on my new laptop which has solid state disks - it was taking 36 hours on my old laptop, then halved when I got the replacement, but then nearly doubled!
          2. I investigated why this was so, and improved performance mainly by putting in a trace (using a timer - GetTickCount - found on the web that allows logging of elapsed time in milliseconds, using StartTimer and EndTimer) and finding the 'pinch points'
          3. I suspected that it was a new release of MS Access that's caused a problem; maybe a lost index or something similar. I couldn't find any evidence of this, but a mumber of queries were taking a second or so to execute, which small times multiplied up drastically when the number of pages on my site - over 100k - are taken into account. Quite why a cliff-edge had been reached, I know not!
          4. Three areas had been particularly impacted: Authors, Paper Abstracts & Paper Summaries, which have all trippled or worse. These are covered as seperate developments under 'Authors' and 'Papers'.
          5. Book Summaries and Book-Paper Abstracts had also at least doubled, but this has had less of an impact as they took much less time in the first place.
          6. Other regeneration processes - in particular 'Notes' - didn't appear to have been impacted.
        4. Wrote Check_Database_Size to check that the size of the database isn't at risk of breaching the 2GB limit. Required because of the need to re-materialise various views that have been instituted to speed up the full website regeneration routines, and which need to be run each time cmdRecalculate_Click is run, which is often.
      • WebRefs
        1. As revealed by Spider: WebLinks_Tester_Full_Map.htm (etc). Refs failing. 184 items. res://ieframe.dll/ in Returned_URL.
        2. WebLinks_Tester_Full & WebLinks_Tester_Full_Map: Reformated Jump Table to 30 columns and multiple rows.
        3. WebLinks_Tester: If the URLs of WebRefs are changed between Spider runs, the URL mapping fails, and the WebRefs appear at the end of the last page, wrongly categorised. Fixed to ensure they appear on their own page, added to the jump table as 'WebRef Missing' and added an explanation.
        4. Webrefs_Update: Improved the processing of this sub which controls IE to check the URLs corresponding to WeRefs are still valid.
          1. Improved the recovery processing after IE fails or becomes detached. Now seems to work perfectly!
          2. Improved processing for 404 (page not found) errors - detect them where URL returned differs from that requested (so the error is correctly categorised) and also where it is the same (so the error is detected) - by using the GetElementsByTagName method to look through Title and H1 elemnts (where they exist).
          3. Note that there is still an issue for pdfs where the above methods don't work; though the page returned is an HTML or XML page, the changed URL still claims to be a pdf, so I can't check in case it's a real pdf and the process fails.
        5. Amended WebRef 'Name' links to #Off-Page_Link_WxxxW style so referencing from other pages is possible (useful for Aeon)
    2. Other Websites:
      • Nothing to Report.
  4. Full details for 20Q2 are given below14:-
Website (Total Hours = 126.5)
  1. Website - Development (Total Hours = 93.25)
    • Improvements to CreatePaperCitingsWebPages (0.75 hours)
    • Website - Generator - Amend WebRef 'Name' link to #Off-Page_Link_WxxxW style (1.5 hours)
    • Website - Generator - Automate Aeon Page output - Add total 'unread' count + 'read' narrative (0.75 hours)
    • Website - Generator - Compact / Repair re-open '2Gb' problem - set MaxLocksPerFile to 1,000,000 (from 9,500) (0.25 hours)
    • Website - Generator - Correct Functor_16 to remove hyperlinks from Title (1.75 hours)
    • Website - Generator - Correct Quarterly Reporting for YTD % Planned (0.5 hours)
    • Website - Generator - Correct Subtotalling of Aeon Webref items in Summary task List reports (1.25 hours)
    • Website - Generator - Document Cross-Referencing (17 hours)
    • Website - Generator - Document Cross-Referencing: Create Functor_21 (2.75 hours)
    • Website - Generator - Document Cross-Referencing: Create Functor_22 (0.5 hours)
    • Website - Generator - Document Cross-Referencing: Create Functor_23 (2 hours)
    • Website - Generator - Document Cross-Referencing: Create Number_Format (1 hour)
    • Website - Generator - Document Functors (2.5 hours)
    • Website - Generator - Enhance Functor processing to allow parameters (2.25 hours)
    • Website - Generator - Fix various bugs in the Spider_WebLinks_Tester set of subroutines (2.75 hours)
    • Website - Generator - Fixes re Broken Links revealed by Spider (7.5 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - Authors (11.5 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - Book Summaries (1.5 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - Book-Paper Abstracts (2.5 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - Check on database size (1.25 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - Cross-Referencing (2.25 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - General planning (1.5 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - Notes Archive (2.75 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - Paper Abstracts (2.5 hours)
    • Website - Generator - Full Website Regen - Performance Improvements - Paper Summaries (3.75 hours)
    • Website - Generator - Investigate & Fix WebRefs_Update checker for 404 check not working (4.25 hours)
    • Website - Generator - Investigate & Fix WebRefs_Update checker for restarts not working (1.5 hours)
    • Website - Generator - Investigate 2Gb query message on Compact & Repair (1.25 hours)
    • Website - Generator - Modify Functor_17 to segragate Audio Files to Music Page (2 hours)
    • Website - Generator - Site Map (8.25 hours)
    • Website - Generator - Spider - Monitor performance & Main database size (0.5 hours)
    • Website - Update 'Photos' Page with Family history photos for Vicky (1 hour)
      → See "Software Development - Website - Development" (93.25 hours)
  2. Website - Education (Total Hours = 1.5)
  3. Website - Infrastructure (Total Hours = 12.75)
    • Email - Mailbox compromised: changed passwords (1 hour)
    • Email - Mailbox not compacting (0.75 hours)
    • Google - Passwords Compromised? (0.25 hours)
    • Microsoft Windows 10 / MS Office - Releases, Bugs & Periodic Re-boots (4.5 hours)
    • Naomi's BT connection in new flat (1 hour)
    • PC Backups / OneDrive (1.25 hours)
    • Re-installing PdfElement (0.25 hours)
    • Set up Bluejeans Conferencing system for Quiz (1.75 hours)
    • Sky Q Fixes (1.5 hours)
    • Ubisoft Password Compromised? (0.5 hours)
      → See "Admin - Website - Admin & Maintenance" (12.75 hours)
  4. Website - Maintenance (Total Hours = 19)
    • 20Q1 Status Reports (0.75 hours)
    • Updated my Home page (0.75 hours)
    • Website - Generator - WebRefs - Manual / Automatic URL Checks & Fixes (6.75 hours)
    • Website - Periodic Full Regeneration (8.25 hours)
    • Website - Run Web Spider (2.5 hours)
      → See "Admin - Website - Admin & Maintenance" (19 hours)
Website Others (Total Hours = 11.75)
  1. Website Others - Enigma Ensemble
  2. Website Others - Hutton DBC Maintenance
  3. Website Others - Mountnessing DBC Maintenance

Plans for the Near Future

The Plan below is taken automatically from the Priority 1 items on my Development Log, as published in my Outstanding Developments Report. I’ve again increased the weekly allocation marginally to 10 hours. This is to allow further work on my Cross-Referencing project.
  1. Own Website: Priority 1 Items By Category:-
    • Architecture
      1. Compact and Repair Problems
        1. On compacting and repairing my main database I sometimes get the error "The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result".
        2. It happens 3 times while the database is re-opening.
        3. There is lots of space, and the database is only 600Mb (and the error started when it was under 500Mb).
        4. This mostly happens after I've run long processes, so I usually close the database, re-open it and then try the compact and repair. Usually this works, but not always. But I then try again and the message disappears.
        5. I strongly suspect that this is MS Access itself re-indexing tables, and blowing up a temporary database, but I can’t find any evidence for this on-line. Or help, other than suggestions to split databases and do other sensible things. Given that the error occurs when the database is re-opening, with no temporary file visible, is very strange.
        6. 17/04/20 - set MaxLocksPerFile to 1,000,000 (from the default 9,500). Sadly, it doesn't seem to have made a difference.
      2. Complete XRef-re-engineering project:-
        1. Ensure all links and link-pages use the new XRef table, and pension off the old tables.
        2. Look into writing out specific object-identifiers, and linking thereto for Citations, rather than paragraph references. An issue is multiple instances of the same object in a document.
        3. Check all link-types still work and fix any errors.
        4. Complete the auto-triggering of regeneration of “associated” link pages.
        5. Fix update bug in Convert_Webrefs.
        6. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
        7. Document the process!
      3. Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
      4. Where possible, use ID rather than NAME for in-page hyperlinks
    • Backups
      1. Investigate Record-count discrepancies:-
        1. How do website files work as far as counts are concerned?
        2. Why aren't they recorded in Backup_History, nor the fact that the website was backed up?
        3. Different counts depending on whether new or old laptop is backed up. Investigate 63k discrepancy - lower on new laptop.
      2. Review architecture to improve performance; Need to document first
    • Books
      1. Further improve the time to regenerate Book Summaries. Now takes about 39 minutes, but should be under 5 minutes!
    • Books/Papers
      1. Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
      2. Reformat the PaperCitings pages:-
        1. Include only useful information on the detail pages; but if there are multiple links from the same object, include them on the same line as 'extra links' as in Authors' Citations (copy the code).
        2. Include counts on the summary page.
        3. Document!
        Do the same for BookCitings
    • Bridge
      1. Develop auto-reconciliation routines vs EBU results download
    • Documenter
      1. Investigate the error reports from the Documenter, especially unused variables & queries.
      2. Provide Functional Documentation for Website Generator (using Notes)
    • Education
      1. "Sitepoint (Learnable) - Sitepoint Learnable Web Development Courses": Membership cancelled, but plan what to do with the eBooks in my possession.
      2. Read "PC Pro - Computing in the Real World".
      3. Read "White (Ron) & Downs (Timothy Edward) - How Computers Work: The Evolution of Technology".
    • Infrastructure
      1. iCloud for Windows: Re-install & solve 'The upload folder for iCloud Photos is missing' problem. Try on new Laptop.
    • Notes
      1. Add "Note Alternates" to Note pages.
      2. Add option in Auto-Reference Notes to automatically ignore words containing certain strings that include the key-word (eg. ignore 'grace' and 'trace' when indexing 'race')
      3. Add option in Auto-Reference Notes to only confirm new items (leaving previously-flagged items untouched)
      4. Allow the option to concatenate Notes in the Printed version (ie. linearly embed them essay-style), rather than treating the hyperlinks as footnotes – but still keep the hyperlink & cross-referencing in place.
        1. For use as "disclaimers" - eg. for "Plug Notes".
        2. For Thesis / essays: the difficulty here is the need for linking passages to make the text run smoothly.
      5. As part of the Cross-Referencing project, check out the consistent treatment of Note 875, which should be universally ignored. Recently, links to it appeared on Book-Summaries, Book_Paper_Abstracts and Note_Book_Links, as a Note referencing a Book. The critical item was a row on the Note_Book_Links table.
      6. Determine why very long printable notes (eg. Level 3+ for Note 170) are being truncated. Probably suppress them in any case, as they take far too long to load.
      7. Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
      8. Investigate Note_Links: Section references seem to be incorrect
      9. Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
      10. Split Aeon Page into multiple sub-pages (either by topic or by priority)
      11. Suppress the publication of the Printable versions of Temp Notes
    • Papers
      1. The monthly regeneration process for Paper Abstracts still takes just over 5 hours. Problem is with Cross_Reference_Deletions and Cross_Reference_Additions. Cannot be fixed until the cross-referencing project is fully complete and documented.
    • Photos
      1. Develop software & procedure to make adding more content to the photos pages easier to undertake.
      2. Timeline software: Add photos for Holidays & Family History
    • Process
      1. Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
    • Spider
      1. Analyse the results of the data collection exercise and design a plan of campaign to fix broken Internal links and prevent recurrence.
        1. Correct the code so the problems discovered by the Spider don’t recur.
        2. Delete 'orphan pages' that are never linked to, ie. Use the Spider to prune redundant pages19 automatically where possible.
        3. Fix the historical data where errors are uncovered by the Spider. An easier task now the site has a full-regen function.
      2. The size of the main database bloats to over 1.6Gb during the spider run, so is approaching the 2Gb limit.
        1. Use Check_Database_Size, with a parameter, to monitor the size – output a message along the those reporting the compact / repair of the Slave database).
        2. Put a checks in to STOP if over 1.8Gb.
        3. Determine a solution as the limit is pushed. Some tables are “local” for performance reasons and are later copied to the Slave … maybe move them?
      3. The Spider was generating WebRefs. Procedurally, this ought not to have been possible.
        1. The major problem turned out to be because unprocessed20 URLs got added to the end of the last WebLinks_Tester_Brief page, which then got Spidered. I've stopped this happening, so hopefully the problem will not recur. The fix was made in 18Q2.
        2. However, 4 other creations appeared - dated 18/05/18 - from the run of 10/07/18. The creation date was from the previous spider run, but the IDs show that they were produced in the latest run.
        I've re-opened the case!
    • Status
      1. Quarterly Project Reports: Correct Functor_08. The Project Planned YTD % keeps having to be bodged!
    • Technology
      1. Look into Sistrix Smart21. Errors and warnings itemised are:-
        1. Duplicate content: seems to be variants on theotodman.com
        2. Title Tags: Empty, too long, identical
        3. Page Not Found
        4. Filesize in excess of 1Mb
        5. Meta-Description: Empty
        6. Few words on Page
        7. H1: Not used, used multiple times per page, identical across pages
        8. Pictures: Alt attribute missing
    • WebRefs
      1. Documentation & Bug-fixes: Phase 2
        1. Re-document the procedures in the light of recent changes.
        2. Resolve issues generated / revealed by the spider.
        3. Investigate - and fix where possible - broken links.
      2. Improve WebRefs checker (Webrefs_Update) further to check for Error 403 "Forbidden". This will often involve finding way of checking pdfs where the returned page is in fact HTML or XML (see DevLog Ref 379).
      3. Investigate defunct items. Populate Defunct_Explanation in WebRefs_Table and include in relevant WebLinks_Tester reports. Consider use of FairUse (Link - Fair Use) for documents no longer available that I'd downloaded.
      4. Reformat WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm
        1. Clarify 'truncated': Display, not link
        2. Allow more space for 'link returned', 'issue' and 'display text'
        3. The 'As Above" lines waste space. Only for Notes Archive? Consolidate onto single second line.
      5. Reformat WebLinks_Tester_Brief: Allow more space for 'link returned', 'issue' and 'display text'
  2. Other Websites: Priority 1 Items By Category:-
    • Bridge
      1. Regular updates to the Hutton Bridge Club (https://www.bridgewebs.com/hutton.html) Website.
      2. Regular updates to the Mountnessing Bridge Club (https://www.bridgewebs.com/mountnessingbc/) Website.
    • Enigma
      1. Termly updates to the Enigma Ensemble (http://www.enigmaensemble.co.uk/) Website.

Summary of Progress to Date

This is hived off to various separate documents, which have now been harmonising and / or consolidated:-
  1. Summary of Progress to Date22.
  2. Outstanding Developments23,
  3. Functional Documentation24,
  4. A summary of time expended across the years developing my website25 is at "Software Development - Website - Development".





In-Page Footnotes

Footnote 4:
  • Well, in a sense, I’ve missed the boat as I’m now putting effort into my research, though in an informal basis, so will need to continue with both projects in parallel.
  • This was always likely to be necessary, as new features will always arise in use. It’s a prototype methodology, after all.
Footnote 5:
  • This is very tedious to produce and consequently is both incomplete and out of date.
Footnote 7:
  • This is much more fun, as it’s a purely technical task.
  • I’ve written a vastly-improved general-purpose technical documenter for MS Access.
Footnote 9:
  • It’s a shame to abandon the “mini websites” with all their ladders, as it’s rather well done.
  • However, I couldn’t waste time on these after I’d abandoned bridge.
Footnote 10:
  • In particular, for the ECBA “Victor Ludorum” competition.
  • I cannot hand any of this code over, so the tedium will return, though not to me!
Footnote 11:
  • I had agreed to share this data sometime early in 2018
  • But will wait until asked again, as I doubt it’ll be of any real use to anyone.
Footnote 14:
  • Note that where fixes or small enhancements are made to a previously “completed” development, I don’t announce it again against the list of “completed” items above, though the work appears in the full list for the quarter.
Footnote 19:
  • Note that Backup_Prune_Ctrl deletes (relevant) pages that weren't regenerated in the last full site-regen, but this isn't the same thing.
Footnote 20:
  • These are URLs that were used in web pages but hadn't yet been converted to the +WnnnW+ format, so appeared at the end with no WebRef ID.
Footnote 21:
  • See Sistrix (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Optimizr (http://www.optimizr.com/) (which now auto-forwards to Sistrix).
  • A quick look doesn’t show it to be an obvious scam, but I need to double-check.
  • An unsolicited analysis of my site turned up monthly from Optimizr from January 2015 to October 2017, listing a large number of “problems” that I think I know about, but which are in the queue to address.
  • It restarted in February 2018, under the Sistrix name (this seems to have been associated with Optimizr since November 2015).
  • The free version of this software is restricted to 1,000 pages, which is a very small proportion of my Site, though I may be able to point it to difference base-URLs.
  • But I do need to address the problems validly itemised, and a sub-set is still useful.
Footnote 25:
  • As distinct from developing other peoples’ websites – time which is also recorded against this project, but not against this task.

Note last updated: 03/07/2020 22:09:07


Footnote 4.8: (Websites Maintained by Theo Todman)

I used to maintain a large number of websites on behalf of others, and this page was used as a jumping-off point so I could check up on them, particularly from my iPhone, without having to scrabble around.

I had handed over the maintenance of almost all of these, or they have been redeveloped, but – just before the Coronavirus struck – I had agreed to take on – or take back on – a couple of bridge websites.

So, the active exceptions are:-


I also reconstituted – and still host – the Mountnessing Bridge Club Archive (http://mountnessing.theotodman.com/index.shtml).

The following sites are static:-
Sites that I used to maintain, but have now handed over are:-


Finally, I re-engineered and supported the site for the Open Bible Trust, but it has now been ported to OpenCart: OBT (http://www.obt.org.uk/)

I have never charged for any of this work.




In-Page Footnotes

Footnote 1:
  • "The Rise and Fall of the Twelve – A Study in the Use of Story Structure in Acts"
  • Both Sites show various marked-up versions of the Greek text of the Biblical Book of the Acts of the Apostles.

Note last updated: 04/04/2020 00:14:24


Footnote 4.12: (Website Generator Documentation - Cross-Referencing)

Introduction

  • This document covers1 the use of the table Cross_Reference, both in how it is maintained, and what it is used for.
  • In the course of writing this Note I will hopefully complete item 193 in my Development Log, ie. “Complete XRef-re-engineering project”:-
    1. Ensure all links and link-pages use the new XRef table, and pension off the old tables.
    2. Look into writing out specific object-identifiers, and linking thereto for Citations, rather than paragraph references. An issue is multiple instances of the same object in a document.
    3. Check all link-types still work and fix any errors.
    4. Complete the auto-triggering of regeneration of “associated” link pages.
    5. Fix update bug in Convert_Webrefs.
    6. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
    7. Document the process!
  • This is probably one of the most complex parts of my website generator, but the cross-referencing function is really the reason I embarked on this project in the first place.

The Cross_Reference Table Itself
  • The record-counts appear in the following table (provided by Functor_21 using query Cross_Reference_By_Type):-
     
    Type_Calling ↓Type_Called →ABINN_APWTOTAL
    A 3534 194 33326622
    B 511951 1,634 6888244,608
    N 1,6092,7942,2865,662 8,9082,91324,172
    N_A 4,46920,4687,87594420,62940,81210,937106,134
    P 3,1874,9572617,828 11,4855,64143,124
    TOTAL 9,81129,20410,18726,26220,62961,92620,641178,660

  • Key:-
    • A = Author
    • B = Book
    • I = Image
    • N = Note
    • N_A = Archived Note
    • P = Paper
    • W = WebRef
    • “Calling” types are in the first column, “called” types are the other column headings.
    • What is meant be “calling” is that references to objects of the “called” type appear in objects of the “calling” type.
    • Note that Images and WebRefs, by their nature, can be called, but cannot call.
  • The table ought to be self-regulating, and maybe it is. However, there are (as of 28/06/2020 21:13:35, using Functor_22 & query Cross_Reference_By_Year) the following counts of records on the table with timestamps in the years below:-
    • 2015: 936
    • 2016: 68
    • 2017: 3
    • 2018: 766
    • 2019: 1
    • 2020: 176,886
  • Since the website is fully regenerated on a monthly basis, cross-references prior to the latest regeneration should not exist, and require investigation. Presumably, any such are either the result of errors during development or of interventions in the system. There are (according to Functor_23 using query Dud_Cross_References_This_Year) 1 records for 2020 prior to the June regeneration, which is worrying. Investigate!
  • In addition to the Cross_Reference table there are the following related tables:-
    1. Cross_Reference_Changes
    2. Cross_Reference_Zapper
  • The Cross_Reference_Table table is maintained by the following generic Routines & Queries:-
  • Two of these queries are particularly time-consuming – in that they take about a second, which multiplies up drastically when run thousands of times. They are both Append queries, discussed later:
  • A potential issue is the table’s primary key – an ID which is a Long integer with a maximum value of 2,147,483,647. It is needed to enable the deletion of records. These are replaced wholesale, so this ID is romping up. Using Functor_23 and query Cross_Reference_MaxID, as of 28/06/2020 21:13:38 it is 12,883,186 - but it's taken 5 years to get this far (though the number of links has been rising). So, it looks as though it won’t be under pressure for a while! It would be possible to reset it, or – given I have a 64-bit system – change the data type to LongLong, which has a maximum value of 9,223,372,036,854,775,807.

Detailed Processing
  1. Cross_Reference Deletions
  2. Cross_Reference Additions
  3. Cross_Reference_Changes
    • Following the first round of investigation and documentation, I decided to delete all rows from this table more than 40 days old. The table will build up again until I introduce changes for non-Notes (Notes are already fully implemented). I’ve done this to see if it improves performance.
    • The record-counts now appear in the following table (provided by Functor_21 using query Cross_Reference_Changes_By_Type):-
       
      Type_Calling ↓Type_Called →ABINPWTOTAL
      B 38714 5 4761
      N 21,7653,656101227,38910,52543,467
      N_A 759369  1,0176002,745
      P 10860  1,3701291,667
      TOTAL 22,6704,799101279,77611,25848,640

    • Key:-
      • A = Author
      • B = Book
      • I = Image
      • N = Note
      • N_A = Archived Note
      • P = Paper
      • W = WebRef
      • Calling types are in the first column, called types are the other column headings
      • Note that Images and WebRefs, by their nature, can be called, but cannot call.
    • This table (according to Functor_23, option 3) has 48,640 rows, as of 28/06/2020 21:13:39, split by month (using Functor_22, Cross_Reference_Changes_By_Month):-
      • 2020_05: 15,283
      • 2020_06: 33,357
    • Rows are added using two complex queries, but before describing them it’s worth describing what’s been going on. The table Cross_Reference_Zapper is populated with all the cross-references from the changed calling objects held in Cross_Reference, prior to the new ones being added in. They are removed from the Cross_Reference table ready for these new cross-references to be loaded. By the time we get to adding rows to Cross_Reference_Changes, the changes to Cross_Reference have already been applied, but comparison with Cross_Reference_Zapper tell us which pages to regenerate based on both deleted and added cross-references.
    • So, the queries are:-
      1. Cross_Reference_Changes_Deletions_Add is run first. If anything that was deleted hasn’t been replaced, the called pages have to be regenerated.
      2. Cross_Reference_Changes_Additions_Add which is slow because of an inner join to the query Cross_Reference_Latest (which is a summation query on Cross_Reference_Zapper) and an outer join to the table Cross_Reference_Zapper (for which, see below).
    • Something very cunning is going on here! Pages have to be regenerated whenever objects that call them have references either added or deleted, hence the two queries. Also, there needs to be some conflict avoidance.
    • In order to improve the run-times of a full website regeneration, I’ve removed these updates (where variable *** is set to True) from all places where they are invoked, ie. from:-
      1. CreateAbstractWebPages (Paper Abstracts: run time reduced from 8.17 hours to 3.93 hours)
      2. CreateAuthorsWebPages (Authors: Had already reduced to 16 minutes; now 13 minutes).
      3. CreateBookPaperAbstractsWebPages (Book/Paper Abstracts: run time reduced from 72 minutes to 22 minutes).
      4. Notes_Text_Format
        → Notes: run time reduced from 3.62 hours to 1.57 hours.
        → Notes Archived: run time reduced from 2.32 hours to 1.29 hours.
      This is a sensible move because – on a full re-gen – all pages are being regenerated in any case.
    • Rows are deleted by cmdRecalculate_Click using SQL driven by table Page_Regen, but only for Called_Type of “N”. So, the table only contains a few very recent rows of this type, but multitudes of rows for others, as is shown in the table above. I need to explain why this is the case: if looks like deletions may just have been forgotten.
    • So, what is the table actually used for? Most usages are either diagnostic or maintenance, and the only serious one seems to be Page_Regen_GEN, also invoked by cmdRecalculate_Click.
    • I suspect a fault in that this function regenerates the wrong pages. So, we might be on to something here! However, most pages – ie. authors, book and paper summaries – are regenerated by the badly-named cmdPaperSummaries_Click.
    • On investigation, using query Page_Regen_GEN_Test, a non-updating version of Page_Regen_GEN, there were (before Cross_Reference was truncated to the latest 40-days) 21.1k rows output to Page_Regen, including 4 to Author ID=0 and 2 to Image ID=0 (but these represented over 100k and 3k rows, respectively). Not sure to the purpose of including Images since they don’t have pages to regenerate (WebRefs are already excluded for that reason).
    • Table Page_Regen is then used 4 times in cmdRecalculate_Click:-
      → to warn how many Notes with be regenerated
      → to delete all its rows
      → to regenerate all its rows, as above
      → to regenerate all “called” Notes based on the rows just created.
    • No queries use the table other in the circumstances just listed. So, it seems that the table is not used other than to regenerate Notes implicated in changes to other objects (including Notes).
    • Hence, it looks like the functions envisaged for the Cross_Reference_Changes table have not been fully implemented, and that it can be truncated until they have been!
    • Note that it’s not straightforward to fully implement regeneration of the “impacted” pages, as some are cross-references … more on this later.
    • I intend to delete all rows more than 40 old days in cmdRecalculate_Click once I’m pretty clear I’ve fully understood the process.
  4. Cross_Reference_Zapper

Improvements and Rationalisation Required
Performance Improvements
  • Further, I note here that there are some very complex queries that dig out the links when pages are being generated. During a full regeneration, these queries (that take a second or so to run) mount up when run thousands of times and bloat the site-regeneration time to around 11 hours. One of the main purposes of this documentation is to determine where the pinch-points are, to avoid unnecessary processing and to “materialise” certain “views” (ie. convert queries to tables).
  • The materialised views currently developed bloat the size of the database, so a more subtle method may need to be developed in due course. They are:-
    Authors_Cited_By_All_List
    Authors_Summary_Temp
    Authors_Summary_Temp_Count
    BookPaperAbstracts_List
    Book_Citings_List_New
    Notes_Cited_By_All_List
    Paper_Citings_List_New





In-Page Footnotes

Footnote 1:
  • Or will do, once it has been completed!
Footnote 3: Footnote 4:
  • It’s use is that it is two-way: it shows those objects that have been impacted by changes to other objects, in that the links to it have changed.
  • This functionality has only been implemented for Notes, it seems.

Note last updated: 03/07/2020 22:09:07


Footnote 4.22: (Website - Progress to Date (2020 - June))

Rationale for this Document

  • This report summarises progress to date on my Web Tools project.
  • I produce a variety of other documents related to my Web Tools Project:-
    1. A Quarterly Status Report.
    2. Functional Documentation.
    3. Technical Documentation
    4. Outstanding Developments.
  • I have now automated the detailed upgrade path reporting, in that lists of “Items Completed” are automatically appended – based on my Development Log – each time this report is run. Completed developments are listed below in two sequences:-
    1. By Date
    2. By Category


Items Completed In6:-
  • 20Q2
    1. Architecture: Truncated Cross_Reference_Changes table (from over 1M rows to under 50k) which should be self-maintaining, but isn't. This seems to have improved the regeneration times of Notes, Archived Notes and some other objects now that insertions into this table are quicker. Needs a permanent solution as part of my Cross-Referencing project.
    2. Architecture: Enhanced the Functor processing to allow parameters. Previously, I had to create a new Functor ID each time for a very similar requirement. The main problem with this old method was that these Functors (where they call another Functor, or subroutine from a row in Functor) didn't feed through into the Documenter subroutines properly.
    3. Authors: Further reduced the monthly regeneration process time for Authors from 8.25 hours to 13 minutes! Fixed by materialising and indexing a 'view' to table Authors_Cited_By_All_List.
    4. Authors: Enabled "alternate names" for identically-named authors (to avoid middle-initial = X):-
      1. Set up and populated Author_Name_Display
      2. Ensured Author_Name_Display appears on the Author page.
    5. Authors: Determined why the monthly regeneration process for Authors has ballooned from under 4 hours in January 2020 to over 17 hours in April 2020. Fix on 11/04/20 - time more than halved to 8.25 hours - by re-engineering the 'menu' process that counts the items linked to further down the page.
    6. Books: Determined why the monthly regeneration process for Book Summaries had ballooned from 1.1 hours in January 2020 to 3.5 hours in April 2020. Partly fixed by by materialising and indexing the view (now table) Book_Citings_List_New, so now takes 39 minutes. Further improvement required, given that Paper Summaries only takes 5 minutes.
    7. Books/Papers: Determined why the monthly regeneration process for Book-Paper Abstracts had doubled from 2.4 hours in January 2020 to 4.8 hours in April 2020. Successfully reduced to just upder one hour by materialising and indexing BookPaperAbstracts_List.
    8. Documenter: Created various generic Functors to help Document Cross-Referencing by producing cross-tabs and lists from queries. Then the associated stats can be regenerated each time the documentation is regenerated (as TEMP): Functor_21, Functor_22, Functor_23, Number_Format.
    9. Notes: As revealed by Spider: Sundry uncategorised. Refs failing. 30 items. Fixed manually.
    10. Papers: Determined why the monthly regeneration process for Paper Summaries had ballooned from just over 3.5 hours in January 2020 to around 11.5 hours in April 2020. Fixed by materialising and indexing the view (now table) Paper_Citings_List_New, so now takes 6 minutes!
    11. Papers: Determined why the monthly regeneration process for Paper Abstracts had ballooned from just over 6 hours in January 2020 to over 17 hours in April 2020. Reduced to just under 4 hours as a result of materialising and indexing the view (now table) Paper_Citings_List_New. Further improvements required.
    12. Process: Wrote Check_Database_Size to check that the size of the database isn't at risk of breaching the 2GB limit. Required because of the need to re-materialise various views that have been instituted to speed up the full website regeneration routines, and which need to be run each time cmdRecalculate_Click is run, which is often.
    13. Process: Full Website Regeneration took 60 hours in April 2020. This has now been substantially fixed, as of end June 2020, in that regeneration now takes just under 11 hours. While further improvements are possible, the best use of time is to avoid the need for regular regeneration altogether by completing my Cross-referencing project.
    14. Corrective work was split out into the items requiring improvement, must of which have now been implemented.
    15. History and analysis:-
      1. This 'balooning' was on my new laptop which has solid state disks - it was taking 36 hours on my old laptop, then halved when I got the replacement, but then nearly doubled!
      2. I investigated why this was so, and improved performance mainly by putting in a trace (using a timer - GetTickCount - found on the web that allows logging of elapsed time in milliseconds, using StartTimer and EndTimer) and finding the 'pinch points'
      3. I suspected that it was a new release of MS Access that's caused a problem; maybe a lost index or something similar. I couldn't find any evidence of this, but a mumber of queries were taking a second or so to execute, which small times multiplied up drastically when the number of pages on my site - over 100k - are taken into account. Quite why a cliff-edge had been reached, I know not!
      4. Three areas had been particularly impacted: Authors, Paper Abstracts & Paper Summaries, which have all trippled or worse. These are covered as seperate developments under 'Authors' and 'Papers'.
      5. Book Summaries and Book-Paper Abstracts had also at least doubled, but this has had less of an impact as they took much less time in the first place.
      6. Other regeneration processes - in particular 'Notes' - didn't appear to have been impacted.
    16. WebRefs: WebLinks_Tester_Full & WebLinks_Tester_Full_Map: Reformated Jump Table to 30 columns and multiple rows.
    17. WebRefs: WebLinks_Tester: If the URLs of WebRefs are changed between Spider runs, the URL mapping fails, and the WebRefs appear at the end of the last page, wrongly categorised. Fixed to ensure they appear on their own page, added to the jump table as 'WebRef Missing' and added an explanation.
    18. WebRefs: As revealed by Spider: WebLinks_Tester_Full_Map.htm (etc). Refs failing. 184 items. res://ieframe.dll/ in Returned_URL.
    19. WebRefs: Amended WebRef 'Name' links to #Off-Page_Link_WxxxW style so referencing from other pages is possible (useful for Aeon)
    20. WebRefs: Webrefs_Update: Improved the processing of this sub which controls IE to check the URLs corresponding to WeRefs are still valid.
      1. Improved the recovery processing after IE fails or becomes detached. Now seems to work perfectly!
      2. Improved processing for 404 (page not found) errors - detect them where URL returned differs from that requested (so the error is correctly categorised) and also where it is the same (so the error is detected) - by using the GetElementsByTagName method to look through Title and H1 elemnts (where they exist).
      3. Note that there is still an issue for pdfs where the above methods don't work; though the page returned is an HTML or XML page, the changed URL still claims to be a pdf, so I can't check in case it's a real pdf and the process fails.
  • 20Q1
    1. Abstracts: As revealed by Spider: Link to PaperCitings failing (2 items) - Timing issue
    2. Authors: As revealed by Spider: Philosophers_Index_List_OA.htm. Author Names Scrambled. 133 items. Dud page (Ontological Argument) deleted.
    3. Authors: Restrict jump-table at top of Authors pages to relevant items, and include the item counts.
    4. Bridge: As revealed by Spider: Bridge_Code_Archive.htm (14 items) & Bridge_Code_Archive_Recent.htm (5 items)
    5. Notes: As revealed by Spider: Blackberry links from archived Note 1010 (Maintenance Dashboard). 38 items.
    6. Notes: As revealed by Spider: #Reference links: fail for Printable Notes. 24 items.
    7. Notes: As revealed by Spider: Blog Achived Notes - sundry links to Printable Notes. Live Note OK. 97 items.
    8. Notes: Solve the problem of the size limitation for Notes by allowing their concatenation.
    9. Notes: As revealed by Spider: Old links from Archive Notes to (non-existent) Archived Printable Notes. 42 items.
    10. Papers: Make use of Comments for large Abstracts seamless by appending Comments (if > 5k) to Abstracts.
    11. WebRefs: As revealed by Spider: WebLinks_Tester_Brief_12.htm (etc). Refs failing. 41 items. res://ieframe.dll/ in Returned_URL.
    12. WebRefs: As revealed by Spider: WebLinks_Tester_Map_3.htm (etc). Refs failing. 51 items outstanding. res://ieframe.dll/ in Returned_URL.
    13. WebRefs: As revealed by Spider: WebLinks_Tester_4.htm. Refs failing. 32 items. res://ieframe.dll/ in Returned_URL.
    14. WebRefs: WebRefs checker failing to detect broken links for Aeon - if a link fails, I get the message 'The page you were looking for could not be found (404)', but since the URL doesn't change, I don't spot it. This may happen for other sites as well. Fixed for Aeon - watch out for others.
  • 19Q4
    1. Animadversions: Create Aeon_Files table & code to generate Aeon Page (to simplify processing and get round the 64k character limit).
    2. Authors: Improve author-citations process:-
      1. Show author-citation counts on Author Summary pages.
      2. Only have an author-citation link on Authors pages if the author is cited!
      3. Import Authors from Aeon_Files table.
    3. Notes: Create procedures (manual and via Functor_17) to add Audio Files to Notes
    4. Process:
      1. Full Website Regeneration failed in Notes Regen because the first Private Note (133) couldn't be copied from the Transfer directory as the private note hadn't been created there by then.
      2. It should have been, from looking at the code.
      3. Also, the private note itself (1163) is not regenerated until later.
      4. In the start-December 2019 run, no such problem occurred. Maybe the problem was caused by copied between laptops. So, I've flagged it as complete for now, pending a recurrence.
    5. Process: Fix Functors to enable previous quarter's Status Reports after Time period roll-over
  • 19Q3
    • Own Website
      1. Authors: As revealed by Spider: Author pages not regenerated when name corrected, leading to Sundry broken Links from other pages.
      2. Books/Papers: Print Write-up Notes (not just the links) for appropriate Papers in BookPaperAbstracts
      3. Bridge: NGS Refinements
      4. Bridge: Add Mountnessing archive links to Results
      5. Bridge: Synchronise Documentator with main website generator
      6. Infrastructure: Purchase & Commission new Lenovo Laptop: awaiting replacement following motherboard failure!
      7. Infrastructure: PDFelement: Purchase & Commission upgrade from Version 5 to Version 7 for $39 - await new Laptop
      8. WebRefs: As revealed by Spider: Hits_Pages_Total_Crosstab_Descending.htm.
    • Other Websites
      1. Sophie: Dismantle my old version of Sophie Botros (http://www.sophiebotros.com/).
  • 19Q2
    1. Authors: Added Jump Table to sections of Authors Pages
    2. General: Created 'Chess' Home Page
      1. Created as a main menu item and Note
      2. Created consolidated results pages
      3. Added games & links to pgn4web
    3. Status: Corrected Quarterly Reporting for uneven Plan (Holidays)
  • 19Q1
    1. Books/Papers: Removed Blackberry processing and associated pages as no longer needed with fast broadband.
    2. Photos: Timeline software: Added photos of Coxes Farm
    3. Photos: Created Photo-logging usage via Images table.
    4. Photos: Created Timeline software
    5. Technology: Investigated the Hit Stats provided by Webalizer and produced web-pages to show the most active pages.
  • 18Q4
    • Own Website
      1. Architecture: As revealed by Spider: Old links in unregenerated pages. 8 Items.
      2. Documenter: Outstanding Developments by Category appearing all in Bold, and links to lists failing.
      3. Notes: As revealed by Spider: Sundry links failed for Supervisions. 30 items.
      4. Notes: As revealed by Spider: Status Reports - Achived Notes - sundry links failing. 50 items in total. Live Notes fixed.
        1. Website: Maintenance Dashboard. 14 items.
        2. Personal Identity Status Report. 11 items.
        3. Summary Status Report. 4 items.
        4. Actual Detail Summary Report. 6 items.
        5. Chess Status Report. 12 items.
        6. Etc. 3 items.
      5. Notes: As revealed by Spider: Links to sundry 'static' pages failing.
        1. 13 items fixed.
        2. 7 items outstanding: to do with Pete's PhD Test site. Links seem to be OK, so may be a problem with the Spider. Directory "Petes_PhD" was the only one set to "do not parse". The file wasn't in the site map. Reset; hopefully it'll work!
      6. Notes: As revealed by Spider: Links from Blog in Level 1 or 2 Printed Notes 512 and 981 failing. 141 items.
      7. Notes: As revealed by Spider: Consciousness Status Report Achived Notes - links to BookCatalogCategorised_16_115_471.htm failing. Live Note OK. 46 items. 24 items outstanding.
      8. Notes: Create Priority Task List Report.
      9. Process: Added 'time to regenerate' sub-totals & grand-totals to Website Maintenance Dashboard.
      10. Spider: Determined why Full_Link_Up_Levels_Gen takes so long - approximately 4 hours. Re-architected to reduce database reads.
      11. Status: Links occasionally missing from Summary Task List and Summary Task List (YTD).
      12. WebRefs: Added Display text to WebRefs for Links to Stanford, Wikipedia & Aeon
    • Other Websites
      1. Enigma: Added 'EE' shortcut icon on all Webpage browser tabs
      2. Sophie: Added 'SB' shortcut icon on all Webpage browser tabs
  • 18Q3
    1. Architecture: Added 'TT' shortcut icon on all Webpage browser tabs
    2. Authors: As revealed by Spider: 'Extra' Links to Notes from Citations List have the wrong directory (clumped in 1,000's like Papers rather than 100's). 7 items. Problem with AddCitations_List, so not just an issue for Authors.
    3. Authors: Authors Narrative: enable footnotes.
    4. Books: As revealed by Spider: BookCitings. 405 items. Fixed problem with CreateBookCitingsWebPages not checking for change of Book during 'Repeats' processing.
    5. Books/Papers: Paper & Book Abstracts - Make 'Disclaimer' more prominent & show 'Paper Statistics' rather than 'Paper Summaries'
    6. Bridge: Reformated + Fixed Hand-dealing pages to CSS standards
    7. Documenter: Fixed Bug where a variable has the same name as a procedure, and is thereby confused with one. Produced a warning query (Variable_Code_Name_Clashes) for manual correction.
    8. Documenter: Created Functor using Form_Documentation_Links to automatically add control-links to documentation Notes.
    9. Footnotes: Enabled the re-use of Footnotes in the same Note25. They appeared multiple times, now just once. Fixed for:-
      1. Notes (OutputNotesWebPage)
      2. Printable Notes (NoteForPrinting), and
      3. Archived Notes (OutputNotesWebPage_Archived)
      All of which use Notes_Text_Format and the Note_Footnotes table. Also,
      1. Book & Paper Abstracts & Comments used to use an array in Reference_Footnotes, but changed to use a new table26 Abstract_Footnotes.
    10. Notes: Created auto-regen of all Note Link (Note_nnn_Link) Pages
    11. Notes: Automatic Key-word Hyperlinking to Notes Project: Phase 2
      1. Added links based on Book & Paper Titles
      2. Added ***Read***-marker to Lists
      3. Allowed links to be ignored (rather than suppressed) during approval process
      4. Skip links to Status Reports, etc.
    12. Notes: Blog: Created Functor to generate Blog from Blog.
    13. Notes: Created new '+LL+' Functor for links to Note_Link pages; fixed associated Notes.
    14. Notes: As revealed by Spider: Languages Status Report Achived Notes - links to Dissertation failing. Live Note OK. 43 items.
    15. Notes: As revealed by Spider: Notes_List_Control links fail for Supervisions. 58 items.
    16. Notes: As revealed by Spider: Links to Notes_xxx_Links, from Abstracts (94 items), Notes (25 … corrected manually), NotesPrint (1916). Fixed by +LL+ functor implementation.
    17. Notes: As revealed by Spider: Bridge Status Report Achived Notes - sundry links failing. Live Note OK. 70 items.
    18. Notes: As revealed by Spider: Religion Status Report Achived Notes - sundry links failing. Live Note OK. 59 items.
    19. Photos: Fix Bug: photos in Abstracts with embedded Notes - eg. "Grossman (Lev), Kurzweil (Ray) - 2045: The Year Man Becomes Immortal" - not displaying
    20. Photos: As revealed by Spider: Fixed ImageRef to work for both embedded ('SRC') & linked images on the same page - eg. Carthusians. 12 items.
    21. Status: Status: Summary - Actual versus Plan between quarters says "previous quarter"; should be "current quarter"
  • 18Q2
    1. Architecture: Adjusted MS Access Control Page to feature new functions (Development Log & Automatic XRef) and consolidated the categorised Notes Lists into one button.
    2. Documenter: Investigated the error reports from the Documenter:
      1. Improved the diagostics
      2. Removed unused variables from the Generator code.
    3. General: Website Tidy-up:-
      1. Wrote a function to delete - with specified exceptions - items not regenerated in the last full website regeneration.
      2. Tidied up Site - deleted non-updated pages (especially old Printed Notes). Automatically on the local site, manually - using the audit log - on the live site.
      3. Investigated setting up an FTP link as a drive so I could automatically delete from the live site, but couldn't get it to work. Easy to set up as a drive, but not to assign a drive-letter so the drive can be used by VBA.
    4. Notes: Added a process to 'fix' - by adding the Note-ID - those note-links added without stating the ID. This will save processing time.
    5. Notes: Created automatic key-word referencing (ie. to Notes in the Notes-Group "Personal Identity"). This was complicated for a number of reasons:-
      1. There are always false positives, so there needed to be a way of "proofing" what's to be done before doing anything.
      2. There will be times where it is inappropriate (eg. in quoted work by other authors). So, there had to be a way of permanently suppressing such links.
      3. The referencing differs depending on whether the term is in a Footnote or not.
      4. I needed to check for already-existing links, variant grammatical forms, etc.
      5. I created a MsgBox routine - providing context - so that what needed to be done with potential links could easily be decided when the linking process was (re-)run.
      6. Links are always to Notes, but are from Notes, Archived Notes, Authors and Book & Paper Abstracts & Comments.
    6. Papers: Papers associated with broken links:-
      1. Created an area to hold pdfs, and automated links thereto.
      2. Created a pop-up to say I'd remove such pdfs if requested by their authors.
      3. Consequently, haven't password protected the area yet.
    7. Process: Re-engineered Website Maintenance Dashboard to show extra topical links (and show them at the top of the page).
    8. Status: Added extra items to Functors to facilitate Quarterly Reporting:-
      1. Automatically calculated QTD & YTD time statistics in the quarterly reports.
      2. Provided a YTD task list for Status Reports for projects "in abeyance" to make reporting easier.
      3. Modified the statistics - to be just YTD - for YTD Status reports.
      4. Created table for - by Project - "Plans for the near future" tasks, and a functor to add them to the status report.
      5. Took "items competed" and "plans for the near future from the development log for the Web-tools status report.
      6. Created another functor to add these lists to the Summary report.
    9. WebRefs: Created Functor to add stats to Website Generator Documentation - Web Links page.
  • 18Q1
    1. Bridge: Corrected format of Links from Bridge Page
    2. Documenter: Created consolidated Development Log, and updated "Progress to Date" and "Outstanding Developments" Reports
    3. Documenter: Documenter Bug-fixes: Objects in Comments, MsgBoxs & Debugs
    4. Infrastructure: Migration of Website from UKServers to Namesco. Test out.
    5. Notes: Extended deduction of Note links to Papers, and Papers with embedded Notes.
    6. Notes: Automated format-change of old tables in Notes and Notes_Archive
    7. Notes: Removed old "Printable Notes" links from Archived Notes
    8. Notes: Notes Functor35 Processing: Phase 1
      1. Basic processing to interpret comments in HTML code
      2. 01: Quarterly Report: Activity insert
      3. 02: Development Log report - Completed Items by Date
      4. 03: Development Log report - Outstanding Items by Priority
      5. 04: Development Log report - Outstanding Items by Category
      6. 05: Development Log report - Completed Items by Category
      7. 06: Quarterly Report: Priority 1 Outstanding Developments by Category
    9. Papers: Correction of narratives on Note time-recording pseudo-papers
    10. Process: Wrote a routine to update a set of .htm files, replacing text in them all
    11. Process: Improved efficiency of daily changes regeneration (removed msgboxes)
    12. Status: Created web-page generator for Development items (ie. Created the Web-Project "To Do" List and "Outstanding Developments" directly from this list).
    13. WebRefs: Determined & reported usage directly using embedded +WnnnW+ encoding rather than via the Spider. Reconciled the two methods.
    14. WebRefs: Documentation & Bug-fixes: Phase 1
      1. Completed "as is" functional documentation so I could see what's going on.
      2. Re-engineered so it made sense and ran efficiently without bugs
      3. Fixed the obvious data errors that confused the statistics - ie. where the returned URL differs from that requested and https issues.
      4. Wrote / improved diagnostic reports (web pages)
  • 17Q4
    1. Architecture: Automated links between Quarterly reports (Task Lists)
    2. Books/Papers: New "Recent Acquisitions" Book List - Uncategorised
    3. Documenter: Code Archive: Hadn't been working - fixed and recovered a selection from backups
    4. Documenter: Code Archive: Created Web-pages of Recent Code Changes
    5. Notes: Added %age complete to Notes Reading Lists
    6. Notes: Enabled deduction of Note link by omitting the Note ID from the mark-up and doing a look up on the key-word and its varients.
    7. Timesheets: Separated Time Recording for Aeon
  • 17Q3
    1. Notes: Added Colour-coded "quality markers" to Notes: included them in lists and jump-tables
  • 17Q2
    1. Bridge: Created hyperlinks from my consolidated results pages to the actual results
    2. Search: Wrote routines to create a cut-down Website excluding pages with irrelevant or duplicated information. Used this to create the ZoomSearch facility.
  • 17Q1
    1. Bridge: Added new features (70s Club & Monthly Pairs Winners) to my Bridge mini-websites.
    2. Bridge: Created Master Point Lists & Promotions for the ECBA website.
  • 16Q4
    1. Spider: Added “.shtml” and “.shtm” to the list of web-suffices.
  • 16Q3
    1. Acts: Developed a website for displaying the textual and grammatical analyses and appendices of Pete’s PhD on the Acts of the Apostles. Two versions: Live (Acts: Live Site (http://www.acts-research.website/)) and Test (Acts: Test Site (http://www.theotodman.com/Petes_PhD/index.htm)).
    2. Bridge: Revived the archive website for Mountnessing Bridge Club (Mountnessing Bridge Club Archive (http://mountnessing.theotodman.com/index.shtml)).
  • 16Q2
    1. Clock: Created a "chess clock" application to help time tasks. Not much use in the end.
  • 16Q1
    • Own Website
      1. Books/Papers: Created direct links from Subject, Topic & Sub-topic (in Book and Paper Summaries) to their link pages.
      2. Documenter: Created an automatic Forms documenter – with links to the code.
      3. Notes: Allowed Note- & Footnote-links from multiple words42. This is such a useful feature!
      4. Notes: Stopped (I hope!) “private” Notes showing in Paper Abstracts.
      5. Notes: Completed converting “static” pages to Notes.
      6. Notes: Enabled direct links to Notes from within Footnotes.
      7. WebRefs: Some tidying up of the 3,000-odd external links from my website.
    • Other Websites
      1. Bridge: Accommodated Alaric’s new scoring system for St. Edith’s.
      2. Bridge: Reconciled my X-IMP calculations with a new feature provided by Bridgewebs.
      3. Bridge: Created Ladies’ and Gentlemen’s ladders for my mini-websites.
  • 15Q4
    • Own Website
      1. Abstracts: Corrected data format on Identity Abstracts
      2. Aesthetics: Reduced font + changed text in ubiquitous THEO'S PAGE heading
      3. Authors: Provided easy links to works by the same author; Books, Papers; Joint authors
      4. Authors: Corrected author's names (SN (FN)) for all papers and books
      5. Backups: Enhanced my backup system to prune items backed up multiple times (eg. if they moved directory).
      6. Books/Papers: Updated booklists to include shelf-identifiers
      7. Books/Papers: Neatened up the linkage headers in Book & Paper Abstracts.
      8. Data: Corrected data content on Identity Sub-topics
      9. Documenter: Segregated the code-archive, which was bloating43 the generator database.
      10. Notes: Fixed problem of images not appearing in "Printed" Notes (wrong directory level) unless the images are repeated
      11. Notes: Converted the “static” pages in my website to Note format (so they can change and retain history).
      12. Process: Created a consolidated processor to enable overnight regeneration of the whole website.
      13. Spider: Finally cracked the Spider for external links, and used it to check the 3,000-odd links from my website. Some tidying up outstanding.
    • Other Websites
      1. Bridge: Segregated the Bridge website generators from those for my own website. They now live in separate databases and have their own documenters.
  • 15Q3
    • Own Website
      1. Architecture: Made a lot of progress on improving the hyperlinking in my own website – I’ve made a good start on this project. The links now work accurately, but I need to ensure the efficient propagation of linkage changes across the site without requiring a complete regeneration.
      2. Notes: Tidied up the archived Notes.
    • Other Websites
      1. Bridge: Ported my “handicap / improvers” routines from Hutton to “Mini Websites”.
      2. Bridge: Created a new website (using Bridgewebs) for the First Class Bridge Academy (First Class Bridge (https://www.bridgewebs.com/firstclassbridge/)).
      3. Enigma: Created a small website for a music group Julie and I attend – the Enigma Ensemble (http://www.enigmaensemble.co.uk/).
      4. Sophie: Completed the upgrade of Sophie Botros44’s website; see Sophie Botros (http://www.sophiebotros.com/).
  • 15Q2
    1. Bridge: Development of the “Eve Goblets” (victor ludorum) software for the ECBA, and roll-over to the new season.
  • 15Q1
    • Own Website
      1. Architecture: Vastly improved the “bulleting” options in Notes, etc.
      2. Authors: Improved the format and content of “Authors” pages.
      3. Timesheets: Segregated time-recording so I can easily see how much time is spent developing and supporting my own website, and how much is spent on those of other organisations.
    • Other Websites
      1. Bridge: Started a project to provide small websites for bridge clubs without sites: Essex Bridge Results (http://www.theotodman.com/Bridge/index.htm).
      2. Bridge: Further improvements to my Butler-IMPs and Cross-IMPs calculation routines.
      3. Bridge: Took on the ECBA Website (ECBA Website (http://www.essexbridge.co.uk/)), at the cost of considerable effort by way of reformatting & tidy-up.
  • 14Q4
    • Own Website
      1. Notes: Made improvements to the regeneration and referencing of archived Notes.
      2. Spider: Fixed the bug wherein the Spider ran out of system resources on large runs: now compacts & repairs the slave database as it does along (every 200k links; parameterised).
    • Other Websites
      1. Bridge: Improvements to my Butler-IMPs and Cross-IMPs calculation routines – different formats, including the Jeff Smith format, and extension to Butler-scored Pairs events. This work has been taken up by the ECBA selectors for county-team selection.
  • 14Q3
    • Own Website
      1. Notes: Created a progress-tracker for my Thesis.
      2. Notes: Improved error-recovery where encoding fails for Notes links.
      3. Notes: Started to split Paper Abstracts from Write-ups.
      4. Spider: Continued working on my Spider and started to use it to clean up my website by diagnosing broken links.
    • Other Websites
      1. Bridge: Created a suite of programs to extract data and calculate Butler-IMPs and Cross-IMPs from the travellers on Bridgewebs Teams events, and output ranking-lists to the Web.
  • 14Q2
    1. Architecture: Added extra linkages between pages (eg. on Author).
    2. Authors: Created the facility for Author Narratives.
    3. Backups: Used a clone of my Spider routines to create a backup and restore system.
    4. Documenter: Created multiple secure areas on my website, so that Documentation is no longer hiding under my Supervision Notes.
    5. Notes: Wrote routines to import old (but missing) archived Notes into the database so they can be (and have been) re-exported in the current format.
  • 14Q1
    1. Architecture: Repaired / updated my Website site-map.
    2. Notes: Made a lot of improvements to my Site generators, in particular the pesky bug that stopped the links to archived Notes working correctly.
    3. Process: Created a “Website Regeneration Dashboard” to show when the various elements of my website have been refreshed, and how long the routines took to run. Links to this appear in the footer to each webpage.
    4. Process: Improved the regeneration routines for the various classes of webpage, and got them to record statistics in support of the “Website Regeneration Dashboard”.
  • 13Q3
    1. Architecture: Sorted conflicts between Subject, Topic & Sub-Topic IDs
    2. Books/Papers: Improved linkages between Book/Paper Lists and Summaries or Abstracts
    3. Books/Papers: Made enhancements to "Books & Papers Collection Categorised" Pages
    4. Notes: Simplified / Re-engineered Notes processing
    5. Notes: "Single Image" development for Notes
    6. Notes: Created Archived Notes Re-Export facility
    7. Notes: Allowed "Authors Works Lists" to be linked-to from Notes
    8. Status: Re-engineered Monthly Reporting on Change of Year
    9. Technology: Converted Tables to CSS3 standard
    10. Technology: Used CSS in all manually-crafted and automatically-generated pages
    11. Timesheets: Re-engineered Time-Recording, so that actuals are held against Papers (and Books) in a separate table, rather than as columns by year in the Papers / Books tables themselves. Retained the grand totals only.
  • 13Q2
    • Own Website
      1. Architecture: Replaced macros with code.
      2. Architecture: Improved error-recovery where encoding fails for links to Books, Papers and Authors. That is, where one of my bespoke tags (eg. +B46) doesn’t match with its corresponding anti-tag (eg. B+).
      3. Books/Papers: Developed "Books by Location" Pages
      4. Books/Papers: Improved the linkage between Papers and Books.
      5. Bridge: Created “Consolidated Bridge Results” webpages (for my own results).
      6. Documenter: Wrote the Code Documenter.
      7. Documenter: Created a code & query archive facility as part of the Code Documenter.
      8. Notes: Improved "Concatenated Notes" production
      9. Photos: Reduced the size of photos (to make the pages quicker to load).
      10. Spider: De-bugged the Spider.
      11. Status: Improved "This Month's Summary" Reporting
      12. Status: Improved Quarterly Reporting
      13. WebRefs: Some pages render oddly in Chrome (and maybe other browsers) – investigated47.
    • Other Websites
      1. Bridge: Merged48 Philosophy & Bridge Databases
  • 13Q1
    1. Status: Re-engineered Monthly Reporting Tables & improved Monthly Reporting
    2. Technology: Standardised to HTML549
  • 12Q3
    1. General: Improved Titles for Search Results display optimisation
  • 11Q4
    1. Books/Papers: Showed Percentage of Paper / Book Read
  • 11Q2
    1. Authors: Created Author Cross-reference
    2. Books/Papers: Added “changed dates” to Paper and Book abstracts, and produced “recently changed” pages for them
    3. Books/Papers: Created Inter-Book-Paper Citings Cross-reference
  • 10Q3
    1. Notes: Investigate Note_Links: needs versioning, and section of calling Note
    2. Notes: Wrote routines to automatically generate the “Printable Notes” footer – and to create the corresponding web pages – from the control table. Very useful.
    3. Notes: Add “Date Created” to Note_Links (for audit purposes; I’m still not convinced that links disappear when they should).
    4. WebRefs: Improved the functionality for automatically generating external Web-links in Notes, Book Abstracts and Paper Abstracts. Corrected current data to accommodate the new code.
  • 10Q2
    1. Footnotes: Added intra-Note footnotes – a real breakthrough (strange I’d not thought of this before). It will enable me to convert to Note form all the old .pdfs from my undergraduate days – which are replete with footnotes – if this is any use.
    2. Spider: Wrote my own Web Spider.
      1. It’s a little bit of a cheat, in that it doesn’t actually invoke the web-links, but crawls through my directory structure selecting all the .htm files, and rummages through the HTML looking for links which it then copies to a table.
      2. It also maintains a table of the directory structure and files therein, and then works out the real address from the relative addressing.
      3. It then allows cross-checking between the links and the files.
      4. Links external to the site have to be investigated manually (at least I have a list of all the links) – unless I can work out how to use the list to power a browser to check.
      5. There are about 333k links in 55k files – the full run took about 8 hours.
      6. It now runs incrementally based on file last-updated dates.
  • 09Q4
    1. Notes: Restricted the size of the “previous versions” tables for Notes to 12.
    2. Process: Set up my database system to roll forward to the next academic year, and generate web-pages appropriately.
  • 09Q3
    1. Books/Papers: Made a lot of changes to the way Books and Papers are categorised; in particular:-
      1. Added 2-level jump tables, to save the browser being crowded with hundreds of cross-categorisations in the same page.
      2. While it’s OK for Books, it seems to have a few potholes for Papers, as some of the links fail.
      3. The problem may be something to do with my economical way of suppressing redundant sub-categorisation - ie. where one or more of Subject, Topic and Sub-topic are the same.
    2. Books/Papers: Completed a full 2-way link from Book/Paper Summaries to Notes.
    3. Notes: Ensured that the Notes Reading-list is generated from all 3 sub-topics.
    4. Notes: Improved the performance of “All Notes” regeneration. The problem was with the generation of the generic reading lists based on Note Title. These only apply to the “Identity” Notes, and it was taking a long time to determine there was no list to produce.
    5. Notes: Functionally enhanced the Notes-generation processing options; to make niftier production possible. In particular, where individual Notes are selected, I made the re-generation of the cross-references optional (so that if only textual variation is being iterated, the iterations are quicker).
    6. Notes: Enabled Concatenated Notes (by Group). This is only allowed for “Identity” Notes at the moment, which is what I’d wanted it for. It allows all Notes for a Group to be printed off in Title sequence, for ease of review.
    7. Notes: Enabled automatic immediate promotion to Live Website of selected Temp Notes.
    8. Process: Created a “performance stats” database and routines to write to it – though I only implemented them for the Notes generator.
  • 09Q2
    1. Architecture: Created Site-map for Website
    2. Books/Papers: Improved, and corrected errors in, the Blackberry-friendly formatted lists of Books and Papers.
    3. Books/Papers: Added "quality marker" to Paper & Book Abstracts
    4. Books/Papers: De-duplicated Books / Papers to Notes links
    5. Notes: Added a table of Notes history at the end of each Note (ie. not just previous version) - to save tedious chaining
  • 09Q1
    1. Books/Papers: Improved the Books / Papers to Notes links to include the right Version and Section (and historical Title) of the Note
    2. Books/Papers: Enabled links from Books to the Papers contained therein
    3. Books/Papers: Provided an automated link from Books / Papers to the Notes referencing them
    4. Books/Papers: Enhanced Books to Papers links to include papers multiply held
    5. Books/Papers: Created automatic links from Paper Summary to Book Summary
    6. Notes: Option for Notes-Regen:
      1. Changed-only
      2. Changed, and all impacted by Change
      3. All
    7. Notes: Created optional "don't print" feature for specific footnotes.
    8. Notes: Fixed the problem of the overpopulation of the Notes directory
    9. Notes: Added reading-list (of works cited) at the end of the Note, as well as in the Printed Note
  • 08Q4
    1. Timesheets: Updated Book totals from totals of the Papers contained therein
  • 08Q1
    1. Notes: Allowed regeneration of Temp Notes only
  • 07Q4
    1. Architecture: Added password-protection to selected pages
    2. Notes: When a Note is archived, ensured a printable note is also archived50 (if this Note has a print)
    3. Notes: Improve "Temp" note processing. Suppress "_T" suffix (just don't copy to Transfer)
    4. Notes: Added referenced Books / Papers as footnote jump table to Notes
    5. Notes: Added referenced reading lists to printable version of Notes
    6. Search: Created search facility using ZoomSearch
  • 07Q3
    1. Animadversions: Added a "hot topics" link - things that I'm currently working on and want feedback ("Animadversions")
    2. Footnotes: Improved transparency of Footnote referencing in printed Notes
    3. Notes: Created51 a "quick lookup" table of responses to a note and its sub-notes (recursive function on Notes_Links)
    4. Notes: Created "respondent notes" - database identifier & red indicator + text
    5. Notes: Enabled generation of printable version of Notes
    6. Notes: Made Note-change-history available on-line (added status + publishable flags)
  • 07Q2
    1. Abstracts: Created auto-backup of Abstracts, and more efficient maintenance web-routines
    2. Abstracts: Segregated Abstracts into multiple directories
    3. Abstracts: Added "Extra Data" parallel to Abstracts; ie. "More …" (Location etc.)
    4. Architecture: Tidied up Footers throughout Philosophy Papers site (made into tables)
    5. Architecture: Segregated database52 into Master and Slaves (code, papers, books, notes, web control, … vs PI)
    6. Books/Papers: Created "Papers by Title within Topic" list
    7. Books/Papers: Added Flags for "laptop" and "photocopy"; removed document location from Comments
    8. Books/Papers: Created "Identity Read Papers by Sub-Topic" list
    9. Books/Papers: Added change of author or title in "Abstracts audit"
    10. Books/Papers: Created "Identity Papers Full by Sub-Topic" list
    11. Books/Papers: Jump-Tables: added "by topic" option
    12. Books/Papers: Added "read" column in papers / books lists
    13. Books/Papers: Created "BB-friendly53" lists: Papers (Full) and Books
    14. Books/Papers: Added multiple Jump-levels for BB Lists (to keep pages small)
    15. Books/Papers: Added Book Comments and Abstracts (as "More…") to Book-lists
    16. Footnotes: Created auto-renumbering54 routine for Footnotes
    17. Footnotes: Created auto-backup of Footnotes55=54, and more efficient maintenance web-routines
    18. General: Improved "Disclaimer56" Page. Reduce font, add ref to philosophy databases + hyperlinks
    19. Notes: Added "footnote" pages57=54 for Carthusians & King's
    20. Notes: Added "outgoing links" summary footer to Notes pages
    21. Notes: Allowed two sorts of Note - document-specific ("Write-up") and general
    22. Process: Improved ease of FTP process by use of Transfer Directory
    23. WebRefs: Made Web Refs in Comments / Abstracts into Hyperlinks



Items Completed by Category:
  1. Own Website: Completed Items By Category:-
    • Abstracts
      1. 20Q1: As revealed by Spider: Link to PaperCitings failing (2 items) - Timing issue
      2. 15Q4: Corrected data format on Identity Abstracts
      3. 07Q2: Added "Extra Data" parallel to Abstracts; ie. "More …" (Location etc.)
      4. 07Q2: Created auto-backup of Abstracts, and more efficient maintenance web-routines
      5. 07Q2: Segregated Abstracts into multiple directories
    • Aesthetics
      1. 15Q4: Reduced font + changed text in ubiquitous THEO'S PAGE heading
    • Animadversions
      1. 19Q4: Create Aeon_Files table & code to generate Aeon Page (to simplify processing and get round the 64k character limit).
      2. 07Q3: Added a "hot topics" link - things that I'm currently working on and want feedback ("Animadversions")
    • Architecture
      1. 20Q2: Enhanced the Functor processing to allow parameters. Previously, I had to create a new Functor ID each time for a very similar requirement. The main problem with this old method was that these Functors (where they call another Functor, or subroutine from a row in Functor) didn't feed through into the Documenter subroutines properly.
      2. 20Q2: Truncated Cross_Reference_Changes table (from over 1M rows to under 50k) which should be self-maintaining, but isn't. This seems to have improved the regeneration times of Notes, Archived Notes and some other objects now that insertions into this table are quicker. Needs a permanent solution as part of my Cross-Referencing project.
      3. 18Q4: As revealed by Spider: Old links in unregenerated pages. 8 Items.
      4. 18Q3: Added 'TT' shortcut icon on all Webpage browser tabs
      5. 18Q2: Adjusted MS Access Control Page to feature new functions (Development Log & Automatic XRef) and consolidated the categorised Notes Lists into one button.
      6. 17Q4: Automated links between Quarterly reports (Task Lists)
      7. 15Q3: Made a lot of progress on improving the hyperlinking in my own website – I’ve made a good start on this project. The links now work accurately, but I need to ensure the efficient propagation of linkage changes across the site without requiring a complete regeneration.
      8. 15Q1: Vastly improved the “bulleting” options in Notes, etc.
      9. 14Q2: Added extra linkages between pages (eg. on Author).
      10. 14Q1: Repaired / updated my Website site-map.
      11. 13Q3: Sorted conflicts between Subject, Topic & Sub-Topic IDs
      12. 13Q2: Improved error-recovery where encoding fails for links to Books, Papers and Authors. That is, where one of my bespoke tags (eg. +B60=46) doesn’t match with its corresponding anti-tag (eg. B+).
      13. 13Q2: Replaced macros with code.
      14. 09Q2: Created Site-map for Website
      15. 07Q4: Added password-protection to selected pages
      16. 07Q2: Segregated database61=52 into Master and Slaves (code, papers, books, notes, web control, … vs PI)
      17. 07Q2: Tidied up Footers throughout Philosophy Papers site (made into tables)
    • Authors
      1. 20Q2: Determined why the monthly regeneration process for Authors has ballooned from under 4 hours in January 2020 to over 17 hours in April 2020. Fix on 11/04/20 - time more than halved to 8.25 hours - by re-engineering the 'menu' process that counts the items linked to further down the page.
      2. 20Q2: Enabled "alternate names" for identically-named authors (to avoid middle-initial = X):-
        1. Set up and populated Author_Name_Display
        2. Ensured Author_Name_Display appears on the Author page.
      3. 20Q2: Further reduced the monthly regeneration process time for Authors from 8.25 hours to 13 minutes! Fixed by materialising and indexing a 'view' to table Authors_Cited_By_All_List.
      4. 20Q1: As revealed by Spider: Philosophers_Index_List_OA.htm. Author Names Scrambled. 133 items. Dud page (Ontological Argument) deleted.
      5. 20Q1: Restrict jump-table at top of Authors pages to relevant items, and include the item counts.
      6. 19Q4: Improve author-citations process:-
        1. Show author-citation counts on Author Summary pages.
        2. Only have an author-citation link on Authors pages if the author is cited!
        3. Import Authors from Aeon_Files table.
      7. 19Q3: As revealed by Spider: Author pages not regenerated when name corrected, leading to Sundry broken Links from other pages.
      8. 19Q2: Added Jump Table to sections of Authors Pages
      9. 18Q3: As revealed by Spider: 'Extra' Links to Notes from Citations List have the wrong directory (clumped in 1,000's like Papers rather than 100's). 7 items. Problem with AddCitations_List, so not just an issue for Authors.
      10. 18Q3: Authors Narrative: enable footnotes.
      11. 15Q4: Corrected author's names (SN (FN)) for all papers and books
      12. 15Q4: Provided easy links to works by the same author; Books, Papers; Joint authors
      13. 15Q1: Improved the format and content of “Authors” pages.
      14. 14Q2: Created the facility for Author Narratives.
      15. 11Q2: Created Author Cross-reference
    • Backups
      1. 15Q4: Enhanced my backup system to prune items backed up multiple times (eg. if they moved directory).
      2. 14Q2: Used a clone of my Spider routines to create a backup and restore system.
    • Books
      1. 20Q2: Determined why the monthly regeneration process for Book Summaries had ballooned from 1.1 hours in January 2020 to 3.5 hours in April 2020. Partly fixed by by materialising and indexing the view (now table) Book_Citings_List_New, so now takes 39 minutes. Further improvement required, given that Paper Summaries only takes 5 minutes.
      2. 18Q3: As revealed by Spider: BookCitings. 405 items. Fixed problem with CreateBookCitingsWebPages not checking for change of Book during 'Repeats' processing.
    • Books/Papers
      1. 20Q2: Determined why the monthly regeneration process for Book-Paper Abstracts had doubled from 2.4 hours in January 2020 to 4.8 hours in April 2020. Successfully reduced to just upder one hour by materialising and indexing BookPaperAbstracts_List.
      2. 19Q3: Print Write-up Notes (not just the links) for appropriate Papers in BookPaperAbstracts
      3. 19Q1: Removed Blackberry processing and associated pages as no longer needed with fast broadband.
      4. 18Q3: Paper & Book Abstracts - Make 'Disclaimer' more prominent & show 'Paper Statistics' rather than 'Paper Summaries'
      5. 17Q4: New "Recent Acquisitions" Book List - Uncategorised
      6. 16Q1: Created direct links from Subject, Topic & Sub-topic (in Book and Paper Summaries) to their link pages.
      7. 15Q4: Neatened up the linkage headers in Book & Paper Abstracts.
      8. 15Q4: Updated booklists to include shelf-identifiers
      9. 13Q3: Improved linkages between Book/Paper Lists and Summaries or Abstracts
      10. 13Q3: Made enhancements to "Books & Papers Collection Categorised" Pages
      11. 13Q2: Developed "Books by Location" Pages
      12. 13Q2: Improved the linkage between Papers and Books.
      13. 11Q4: Showed Percentage of Paper / Book Read
      14. 11Q2: Added “changed dates” to Paper and Book abstracts, and produced “recently changed” pages for them
      15. 11Q2: Created Inter-Book-Paper Citings Cross-reference
      16. 09Q3: Completed a full 2-way link from Book/Paper Summaries to Notes.
      17. 09Q3: Made a lot of changes to the way Books and Papers are categorised; in particular:-
        1. Added 2-level jump tables, to save the browser being crowded with hundreds of cross-categorisations in the same page.
        2. While it’s OK for Books, it seems to have a few potholes for Papers, as some of the links fail.
        3. The problem may be something to do with my economical way of suppressing redundant sub-categorisation - ie. where one or more of Subject, Topic and Sub-topic are the same.
      18. 09Q2: Added "quality marker" to Paper & Book Abstracts
      19. 09Q2: De-duplicated Books / Papers to Notes links
      20. 09Q2: Improved, and corrected errors in, the Blackberry-friendly formatted lists of Books and Papers.
      21. 09Q1: Created automatic links from Paper Summary to Book Summary
      22. 09Q1: Enabled links from Books to the Papers contained therein
      23. 09Q1: Enhanced Books to Papers links to include papers multiply held
      24. 09Q1: Improved the Books / Papers to Notes links to include the right Version and Section (and historical Title) of the Note
      25. 09Q1: Provided an automated link from Books / Papers to the Notes referencing them
      26. 07Q2: Added "read" column in papers / books lists
      27. 07Q2: Added Book Comments and Abstracts (as "More…") to Book-lists
      28. 07Q2: Added change of author or title in "Abstracts audit"
      29. 07Q2: Added Flags for "laptop" and "photocopy"; removed document location from Comments
      30. 07Q2: Added multiple Jump-levels for BB Lists (to keep pages small)
      31. 07Q2: Created "BB-friendly62=53" lists: Papers (Full) and Books
      32. 07Q2: Created "Identity Papers Full by Sub-Topic" list
      33. 07Q2: Created "Identity Read Papers by Sub-Topic" list
      34. 07Q2: Created "Papers by Title within Topic" list
      35. 07Q2: Jump-Tables: added "by topic" option
    • Bridge
      1. 20Q1: As revealed by Spider: Bridge_Code_Archive.htm (14 items) & Bridge_Code_Archive_Recent.htm (5 items)
      2. 19Q3: Add Mountnessing archive links to Results
      3. 19Q3: NGS Refinements
      4. 19Q3: Synchronise Documentator with main website generator
      5. 18Q3: Reformated + Fixed Hand-dealing pages to CSS standards
      6. 18Q1: Corrected format of Links from Bridge Page
      7. 17Q2: Created hyperlinks from my consolidated results pages to the actual results
      8. 13Q2: Created “Consolidated Bridge Results” webpages (for my own results).
    • Clock
      1. 16Q2: Created a "chess clock" application to help time tasks. Not much use in the end.
    • Data
      1. 15Q4: Corrected data content on Identity Sub-topics
    • Documenter
      1. 20Q2: Created various generic Functors to help Document Cross-Referencing by producing cross-tabs and lists from queries. Then the associated stats can be regenerated each time the documentation is regenerated (as TEMP): Functor_21, Functor_22, Functor_23, Number_Format.
      2. 18Q4: Outstanding Developments by Category appearing all in Bold, and links to lists failing.
      3. 18Q3: Created Functor using Form_Documentation_Links to automatically add control-links to documentation Notes.
      4. 18Q3: Fixed Bug where a variable has the same name as a procedure, and is thereby confused with one. Produced a warning query (Variable_Code_Name_Clashes) for manual correction.
      5. 18Q2: Investigated the error reports from the Documenter:
        1. Improved the diagostics
        2. Removed unused variables from the Generator code.
      6. 18Q1: Created consolidated Development Log, and updated "Progress to Date" and "Outstanding Developments" Reports
      7. 18Q1: Documenter Bug-fixes: Objects in Comments, MsgBoxs & Debugs
      8. 17Q4: Code Archive: Created Web-pages of Recent Code Changes
      9. 17Q4: Code Archive: Hadn't been working - fixed and recovered a selection from backups
      10. 16Q1: Created an automatic Forms documenter – with links to the code.
      11. 15Q4: Segregated the code-archive, which was bloating64=43 the generator database.
      12. 14Q2: Created multiple secure areas on my website, so that Documentation is no longer hiding under my Supervision Notes.
      13. 13Q2: Created a code & query archive facility as part of the Code Documenter.
      14. 13Q2: Wrote the Code Documenter.
    • Footnotes
      1. 18Q3: Enabled the re-use of Footnotes in the same Note65=25. They appeared multiple times, now just once. Fixed for:-
        1. Notes (OutputNotesWebPage)
        2. Printable Notes (NoteForPrinting), and
        3. Archived Notes (OutputNotesWebPage_Archived)
        All of which use Notes_Text_Format and the Note_Footnotes table. Also,
        1. Book & Paper Abstracts & Comments used to use an array in Reference_Footnotes, but changed to use a new table66=26 Abstract_Footnotes.
      2. 10Q2: Added intra-Note footnotes – a real breakthrough (strange I’d not thought of this before). It will enable me to convert to Note form all the old .pdfs from my undergraduate days – which are replete with footnotes – if this is any use.
      3. 07Q3: Improved transparency of Footnote referencing in printed Notes
      4. 07Q2: Created auto-backup of Footnotes67=54, and more efficient maintenance web-routines
      5. 07Q2: Created auto-renumbering68=54 routine for Footnotes
    • General
      1. 19Q2: Created 'Chess' Home Page
        1. Created as a main menu item and Note
        2. Created consolidated results pages
        3. Added games & links to pgn4web
      2. 18Q2: Website Tidy-up:-
        1. Wrote a function to delete - with specified exceptions - items not regenerated in the last full website regeneration.
        2. Tidied up Site - deleted non-updated pages (especially old Printed Notes). Automatically on the local site, manually - using the audit log - on the live site.
        3. Investigated setting up an FTP link as a drive so I could automatically delete from the live site, but couldn't get it to work. Easy to set up as a drive, but not to assign a drive-letter so the drive can be used by VBA.
      3. 12Q3: Improved Titles for Search Results display optimisation
      4. 07Q2: Improved "Disclaimer70=56" Page. Reduce font, add ref to philosophy databases + hyperlinks
    • Infrastructure
      1. 19Q3: PDFelement: Purchase & Commission upgrade from Version 5 to Version 7 for $39 - await new Laptop
      2. 19Q3: Purchase & Commission new Lenovo Laptop: awaiting replacement following motherboard failure!
      3. 18Q1: Migration of Website from UKServers to Namesco. Test out.
    • Notes
      1. 20Q2: As revealed by Spider: Sundry uncategorised. Refs failing. 30 items. Fixed manually.
      2. 20Q1: As revealed by Spider: #Reference links: fail for Printable Notes. 24 items.
      3. 20Q1: As revealed by Spider: Blackberry links from archived Note 1010 (Maintenance Dashboard). 38 items.
      4. 20Q1: As revealed by Spider: Blog Achived Notes - sundry links to Printable Notes. Live Note OK. 97 items.
      5. 20Q1: As revealed by Spider: Old links from Archive Notes to (non-existent) Archived Printable Notes. 42 items.
      6. 20Q1: Solve the problem of the size limitation for Notes by allowing their concatenation.
      7. 19Q4: Create procedures (manual and via Functor_17) to add Audio Files to Notes
      8. 18Q4: As revealed by Spider: Consciousness Status Report Achived Notes - links to BookCatalogCategorised_16_115_471.htm failing. Live Note OK. 46 items. 24 items outstanding.
      9. 18Q4: As revealed by Spider: Links from Blog in Level 1 or 2 Printed Notes 512 and 981 failing. 141 items.
      10. 18Q4: As revealed by Spider: Links to sundry 'static' pages failing.
        1. 13 items fixed.
        2. 7 items outstanding: to do with Pete's PhD Test site. Links seem to be OK, so may be a problem with the Spider. Directory "Petes_PhD" was the only one set to "do not parse". The file wasn't in the site map. Reset; hopefully it'll work!
      11. 18Q4: As revealed by Spider: Status Reports - Achived Notes - sundry links failing. 50 items in total. Live Notes fixed.
        1. Website: Maintenance Dashboard. 14 items.
        2. Personal Identity Status Report. 11 items.
        3. Summary Status Report. 4 items.
        4. Actual Detail Summary Report. 6 items.
        5. Chess Status Report. 12 items.
        6. Etc. 3 items.
      12. 18Q4: As revealed by Spider: Sundry links failed for Supervisions. 30 items.
      13. 18Q4: Create Priority Task List Report.
      14. 18Q3: As revealed by Spider: Bridge Status Report Achived Notes - sundry links failing. Live Note OK. 70 items.
      15. 18Q3: As revealed by Spider: Languages Status Report Achived Notes - links to Dissertation failing. Live Note OK. 43 items.
      16. 18Q3: As revealed by Spider: Religion Status Report Achived Notes - sundry links failing. Live Note OK. 59 items.
      17. 18Q3: As revealed by Spider: Links to Notes_xxx_Links, from Abstracts (94 items), Notes (25 … corrected manually), NotesPrint (1916). Fixed by +LL+ functor implementation.
      18. 18Q3: As revealed by Spider: Notes_List_Control links fail for Supervisions. 58 items.
      19. 18Q3: Automatic Key-word Hyperlinking to Notes Project: Phase 2
        1. Added links based on Book & Paper Titles
        2. Added ***Read***-marker to Lists
        3. Allowed links to be ignored (rather than suppressed) during approval process
        4. Skip links to Status Reports, etc.
      20. 18Q3: Blog: Created Functor to generate Blog from Blog.
      21. 18Q3: Created auto-regen of all Note Link (Note_nnn_Link) Pages
      22. 18Q3: Created new '+LL+' Functor for links to Note_Link pages; fixed associated Notes.
      23. 18Q2: Added a process to 'fix' - by adding the Note-ID - those note-links added without stating the ID. This will save processing time.
      24. 18Q2: Created automatic key-word referencing (ie. to Notes in the Notes-Group "Personal Identity"). This was complicated for a number of reasons:-
        1. There are always false positives, so there needed to be a way of "proofing" what's to be done before doing anything.
        2. There will be times where it is inappropriate (eg. in quoted work by other authors). So, there had to be a way of permanently suppressing such links.
        3. The referencing differs depending on whether the term is in a Footnote or not.
        4. I needed to check for already-existing links, variant grammatical forms, etc.
        5. I created a MsgBox routine - providing context - so that what needed to be done with potential links could easily be decided when the linking process was (re-)run.
        6. Links are always to Notes, but are from Notes, Archived Notes, Authors and Book & Paper Abstracts & Comments.
      25. 18Q1: Automated format-change of old tables in Notes and Notes_Archive
      26. 18Q1: Extended deduction of Note links to Papers, and Papers with embedded Notes.
      27. 18Q1: Notes Functor84=35 Processing: Phase 1
        1. Basic processing to interpret comments in HTML code
        2. 01: Quarterly Report: Activity insert
        3. 02: Development Log report - Completed Items by Date
        4. 03: Development Log report - Outstanding Items by Priority
        5. 04: Development Log report - Outstanding Items by Category
        6. 05: Development Log report - Completed Items by Category
        7. 06: Quarterly Report: Priority 1 Outstanding Developments by Category
      28. 18Q1: Removed old "Printable Notes" links from Archived Notes
      29. 17Q4: Added %age complete to Notes Reading Lists
      30. 17Q4: Enabled deduction of Note link by omitting the Note ID from the mark-up and doing a look up on the key-word and its varients.
      31. 17Q3: Added Colour-coded "quality markers" to Notes: included them in lists and jump-tables
      32. 16Q1: Allowed Note- & Footnote-links from multiple words91=42. This is such a useful feature!
      33. 16Q1: Completed converting “static” pages to Notes.
      34. 16Q1: Enabled direct links to Notes from within Footnotes.
      35. 16Q1: Stopped (I hope!) “private” Notes showing in Paper Abstracts.
      36. 15Q4: Converted the “static” pages in my website to Note format (so they can change and retain history).
      37. 15Q4: Fixed problem of images not appearing in "Printed" Notes (wrong directory level) unless the images are repeated
      38. 15Q3: Tidied up the archived Notes.
      39. 14Q4: Made improvements to the regeneration and referencing of archived Notes.
      40. 14Q3: Created a progress-tracker for my Thesis.
      41. 14Q3: Improved error-recovery where encoding fails for Notes links.
      42. 14Q3: Started to split Paper Abstracts from Write-ups.
      43. 14Q2: Wrote routines to import old (but missing) archived Notes into the database so they can be (and have been) re-exported in the current format.
      44. 14Q1: Made a lot of improvements to my Site generators, in particular the pesky bug that stopped the links to archived Notes working correctly.
      45. 13Q3: "Single Image" development for Notes
      46. 13Q3: Allowed "Authors Works Lists" to be linked-to from Notes
      47. 13Q3: Created Archived Notes Re-Export facility
      48. 13Q3: Simplified / Re-engineered Notes processing
      49. 13Q2: Improved "Concatenated Notes" production
      50. 10Q3: Add “Date Created” to Note_Links (for audit purposes; I’m still not convinced that links disappear when they should).
      51. 10Q3: Investigate Note_Links: needs versioning, and section of calling Note
      52. 10Q3: Wrote routines to automatically generate the “Printable Notes” footer – and to create the corresponding web pages – from the control table. Very useful.
      53. 09Q4: Restricted the size of the “previous versions” tables for Notes to 12.
      54. 09Q3: Enabled automatic immediate promotion to Live Website of selected Temp Notes.
      55. 09Q3: Enabled Concatenated Notes (by Group). This is only allowed for “Identity” Notes at the moment, which is what I’d wanted it for. It allows all Notes for a Group to be printed off in Title sequence, for ease of review.
      56. 09Q3: Ensured that the Notes Reading-list is generated from all 3 sub-topics.
      57. 09Q3: Functionally enhanced the Notes-generation processing options; to make niftier production possible. In particular, where individual Notes are selected, I made the re-generation of the cross-references optional (so that if only textual variation is being iterated, the iterations are quicker).
      58. 09Q3: Improved the performance of “All Notes” regeneration. The problem was with the generation of the generic reading lists based on Note Title. These only apply to the “Identity” Notes, and it was taking a long time to determine there was no list to produce.
      59. 09Q2: Added a table of Notes history at the end of each Note (ie. not just previous version) - to save tedious chaining
      60. 09Q1: Added reading-list (of works cited) at the end of the Note, as well as in the Printed Note
      61. 09Q1: Created optional "don't print" feature for specific footnotes.
      62. 09Q1: Fixed the problem of the overpopulation of the Notes directory
      63. 09Q1: Option for Notes-Regen:
        1. Changed-only
        2. Changed, and all impacted by Change
        3. All
      64. 08Q1: Allowed regeneration of Temp Notes only
      65. 07Q4: Added referenced Books / Papers as footnote jump table to Notes
      66. 07Q4: Added referenced reading lists to printable version of Notes
      67. 07Q4: Improve "Temp" note processing. Suppress "_T" suffix (just don't copy to Transfer)
      68. 07Q4: When a Note is archived, ensured a printable note is also archived93=50 (if this Note has a print)
      69. 07Q3: Created "respondent notes" - database identifier & red indicator + text
      70. 07Q3: Created94=51 a "quick lookup" table of responses to a note and its sub-notes (recursive function on Notes_Links)
      71. 07Q3: Enabled generation of printable version of Notes
      72. 07Q3: Made Note-change-history available on-line (added status + publishable flags)
      73. 07Q2: Added "footnote" pages95=54 for Carthusians & King's
      74. 07Q2: Added "outgoing links" summary footer to Notes pages
      75. 07Q2: Allowed two sorts of Note - document-specific ("Write-up") and general
    • Papers
      1. 20Q2: Determined why the monthly regeneration process for Paper Abstracts had ballooned from just over 6 hours in January 2020 to over 17 hours in April 2020. Reduced to just under 4 hours as a result of materialising and indexing the view (now table) Paper_Citings_List_New. Further improvements required.
      2. 20Q2: Determined why the monthly regeneration process for Paper Summaries had ballooned from just over 3.5 hours in January 2020 to around 11.5 hours in April 2020. Fixed by materialising and indexing the view (now table) Paper_Citings_List_New, so now takes 6 minutes!
      3. 20Q1: Make use of Comments for large Abstracts seamless by appending Comments (if > 5k) to Abstracts.
      4. 18Q2: Papers associated with broken links:-
        1. Created an area to hold pdfs, and automated links thereto.
        2. Created a pop-up to say I'd remove such pdfs if requested by their authors.
        3. Consequently, haven't password protected the area yet.
      5. 18Q1: Correction of narratives on Note time-recording pseudo-papers
    • Photos
      1. 19Q1: Created Photo-logging usage via Images table.
      2. 19Q1: Created Timeline software
      3. 19Q1: Timeline software: Added photos of Coxes Farm
      4. 18Q3: As revealed by Spider: Fixed ImageRef to work for both embedded ('SRC') & linked images on the same page - eg. Carthusians. 12 items.
      5. 18Q3: Fix Bug: photos in Abstracts with embedded Notes - eg. "Grossman (Lev), Kurzweil (Ray) - 2045: The Year Man Becomes Immortal" - not displaying
      6. 13Q2: Reduced the size of photos (to make the pages quicker to load).
    • Process
      1. 20Q2: Full Website Regeneration took 60 hours in April 2020. This has now been substantially fixed, as of end June 2020, in that regeneration now takes just under 11 hours. While further improvements are possible, the best use of time is to avoid the need for regular regeneration altogether by completing my Cross-referencing project.
      2. Corrective work was split out into the items requiring improvement, must of which have now been implemented.
      3. History and analysis:-
        1. This 'balooning' was on my new laptop which has solid state disks - it was taking 36 hours on my old laptop, then halved when I got the replacement, but then nearly doubled!
        2. I investigated why this was so, and improved performance mainly by putting in a trace (using a timer - GetTickCount - found on the web that allows logging of elapsed time in milliseconds, using StartTimer and EndTimer) and finding the 'pinch points'
        3. I suspected that it was a new release of MS Access that's caused a problem; maybe a lost index or something similar. I couldn't find any evidence of this, but a mumber of queries were taking a second or so to execute, which small times multiplied up drastically when the number of pages on my site - over 100k - are taken into account. Quite why a cliff-edge had been reached, I know not!
        4. Three areas had been particularly impacted: Authors, Paper Abstracts & Paper Summaries, which have all trippled or worse. These are covered as seperate developments under 'Authors' and 'Papers'.
        5. Book Summaries and Book-Paper Abstracts had also at least doubled, but this has had less of an impact as they took much less time in the first place.
        6. Other regeneration processes - in particular 'Notes' - didn't appear to have been impacted.
      4. 20Q2: Wrote Check_Database_Size to check that the size of the database isn't at risk of breaching the 2GB limit. Required because of the need to re-materialise various views that have been instituted to speed up the full website regeneration routines, and which need to be run each time cmdRecalculate_Click is run, which is often.
      5. 19Q4:
        1. Full Website Regeneration failed in Notes Regen because the first Private Note (133) couldn't be copied from the Transfer directory as the private note hadn't been created there by then.
        2. It should have been, from looking at the code.
        3. Also, the private note itself (1163) is not regenerated until later.
        4. In the start-December 2019 run, no such problem occurred. Maybe the problem was caused by copied between laptops. So, I've flagged it as complete for now, pending a recurrence.
      6. 19Q4: Fix Functors to enable previous quarter's Status Reports after Time period roll-over
      7. 18Q4: Added 'time to regenerate' sub-totals & grand-totals to Website Maintenance Dashboard.
      8. 18Q2: Re-engineered Website Maintenance Dashboard to show extra topical links (and show them at the top of the page).
      9. 18Q1: Improved efficiency of daily changes regeneration (removed msgboxes)
      10. 18Q1: Wrote a routine to update a set of .htm files, replacing text in them all
      11. 15Q4: Created a consolidated processor to enable overnight regeneration of the whole website.
      12. 14Q1: Created a “Website Regeneration Dashboard” to show when the various elements of my website have been refreshed, and how long the routines took to run. Links to this appear in the footer to each webpage.
      13. 14Q1: Improved the regeneration routines for the various classes of webpage, and got them to record statistics in support of the “Website Regeneration Dashboard”.
      14. 09Q4: Set up my database system to roll forward to the next academic year, and generate web-pages appropriately.
      15. 09Q3: Created a “performance stats” database and routines to write to it – though I only implemented them for the Notes generator.
      16. 07Q2: Improved ease of FTP process by use of Transfer Directory
    • Search
      1. 17Q2: Wrote routines to create a cut-down Website excluding pages with irrelevant or duplicated information. Used this to create the ZoomSearch facility.
      2. 07Q4: Created search facility using ZoomSearch
    • Spider
      1. 18Q4: Determined why Full_Link_Up_Levels_Gen takes so long - approximately 4 hours. Re-architected to reduce database reads.
      2. 16Q4: Added “.shtml” and “.shtm” to the list of web-suffices.
      3. 15Q4: Finally cracked the Spider for external links, and used it to check the 3,000-odd links from my website. Some tidying up outstanding.
      4. 14Q4: Fixed the bug wherein the Spider ran out of system resources on large runs: now compacts & repairs the slave database as it does along (every 200k links; parameterised).
      5. 14Q3: Continued working on my Spider and started to use it to clean up my website by diagnosing broken links.
      6. 13Q2: De-bugged the Spider.
      7. 10Q2: Wrote my own Web Spider.
        1. It’s a little bit of a cheat, in that it doesn’t actually invoke the web-links, but crawls through my directory structure selecting all the .htm files, and rummages through the HTML looking for links which it then copies to a table.
        2. It also maintains a table of the directory structure and files therein, and then works out the real address from the relative addressing.
        3. It then allows cross-checking between the links and the files.
        4. Links external to the site have to be investigated manually (at least I have a list of all the links) – unless I can work out how to use the list to power a browser to check.
        5. There are about 333k links in 55k files – the full run took about 8 hours.
        6. It now runs incrementally based on file last-updated dates.
    • Status
      1. 19Q2: Corrected Quarterly Reporting for uneven Plan (Holidays)
      2. 18Q4: Links occasionally missing from Summary Task List and Summary Task List (YTD).
      3. 18Q3: Status: Summary - Actual versus Plan between quarters says "previous quarter"; should be "current quarter"
      4. 18Q2: Added extra items to Functors to facilitate Quarterly Reporting:-
        1. Automatically calculated QTD & YTD time statistics in the quarterly reports.
        2. Provided a YTD task list for Status Reports for projects "in abeyance" to make reporting easier.
        3. Modified the statistics - to be just YTD - for YTD Status reports.
        4. Created table for - by Project - "Plans for the near future" tasks, and a functor to add them to the status report.
        5. Took "items competed" and "plans for the near future from the development log for the Web-tools status report.
        6. Created another functor to add these lists to the Summary report.
      5. 18Q1: Created web-page generator for Development items (ie. Created the Web-Project "To Do" List and "Outstanding Developments" directly from this list).
      6. 13Q3: Re-engineered Monthly Reporting on Change of Year
      7. 13Q2: Improved "This Month's Summary" Reporting
      8. 13Q2: Improved Quarterly Reporting
      9. 13Q1: Re-engineered Monthly Reporting Tables & improved Monthly Reporting
    • Technology
      1. 19Q1: Investigated the Hit Stats provided by Webalizer and produced web-pages to show the most active pages.
      2. 13Q3: Converted Tables to CSS3 standard
      3. 13Q3: Used CSS in all manually-crafted and automatically-generated pages
      4. 13Q1: Standardised to HTML5104=49
    • Timesheets
      1. 17Q4: Separated Time Recording for Aeon
      2. 15Q1: Segregated time-recording so I can easily see how much time is spent developing and supporting my own website, and how much is spent on those of other organisations.
      3. 13Q3: Re-engineered Time-Recording, so that actuals are held against Papers (and Books) in a separate table, rather than as columns by year in the Papers / Books tables themselves. Retained the grand totals only.
      4. 08Q4: Updated Book totals from totals of the Papers contained therein
    • WebRefs
      1. 20Q2: Webrefs_Update: Improved the processing of this sub which controls IE to check the URLs corresponding to WeRefs are still valid.
        1. Improved the recovery processing after IE fails or becomes detached. Now seems to work perfectly!
        2. Improved processing for 404 (page not found) errors - detect them where URL returned differs from that requested (so the error is correctly categorised) and also where it is the same (so the error is detected) - by using the GetElementsByTagName method to look through Title and H1 elemnts (where they exist).
        3. Note that there is still an issue for pdfs where the above methods don't work; though the page returned is an HTML or XML page, the changed URL still claims to be a pdf, so I can't check in case it's a real pdf and the process fails.
      2. 20Q2: Amended WebRef 'Name' links to #Off-Page_Link_WxxxW style so referencing from other pages is possible (useful for Aeon)
      3. 20Q2: As revealed by Spider: WebLinks_Tester_Full_Map.htm (etc). Refs failing. 184 items. res://ieframe.dll/ in Returned_URL.
      4. 20Q2: WebLinks_Tester: If the URLs of WebRefs are changed between Spider runs, the URL mapping fails, and the WebRefs appear at the end of the last page, wrongly categorised. Fixed to ensure they appear on their own page, added to the jump table as 'WebRef Missing' and added an explanation.
      5. 20Q2: WebLinks_Tester_Full & WebLinks_Tester_Full_Map: Reformated Jump Table to 30 columns and multiple rows.
      6. 20Q1: As revealed by Spider: WebLinks_Tester_4.htm. Refs failing. 32 items. res://ieframe.dll/ in Returned_URL.
      7. 20Q1: As revealed by Spider: WebLinks_Tester_Brief_12.htm (etc). Refs failing. 41 items. res://ieframe.dll/ in Returned_URL.
      8. 20Q1: As revealed by Spider: WebLinks_Tester_Map_3.htm (etc). Refs failing. 51 items outstanding. res://ieframe.dll/ in Returned_URL.
      9. 20Q1: WebRefs checker failing to detect broken links for Aeon - if a link fails, I get the message 'The page you were looking for could not be found (404)', but since the URL doesn't change, I don't spot it. This may happen for other sites as well. Fixed for Aeon - watch out for others.
      10. 19Q3: As revealed by Spider: Hits_Pages_Total_Crosstab_Descending.htm.
      11. 18Q4: Added Display text to WebRefs for Links to Stanford, Wikipedia & Aeon
      12. 18Q2: Created Functor to add stats to Website Generator Documentation - Web Links page.
      13. 18Q1: Determined & reported usage directly using embedded +WnnnW+ encoding rather than via the Spider. Reconciled the two methods.
      14. 18Q1: Documentation & Bug-fixes: Phase 1
        1. Completed "as is" functional documentation so I could see what's going on.
        2. Re-engineered so it made sense and ran efficiently without bugs
        3. Fixed the obvious data errors that confused the statistics - ie. where the returned URL differs from that requested and https issues.
        4. Wrote / improved diagnostic reports (web pages)
      15. 16Q1: Some tidying up of the 3,000-odd external links from my website.
      16. 13Q2: Some pages render oddly in Chrome (and maybe other browsers) – investigated106=47.
      17. 10Q3: Improved the functionality for automatically generating external Web-links in Notes, Book Abstracts and Paper Abstracts. Corrected current data to accommodate the new code.
      18. 07Q2: Made Web Refs in Comments / Abstracts into Hyperlinks
  2. Other Websites: Completed Items By Category:-
    • Acts
      1. 16Q3: Developed a website for displaying the textual and grammatical analyses and appendices of Pete’s PhD on the Acts of the Apostles. Two versions: Live (Acts: Live Site (http://www.acts-research.website/)) and Test (Acts: Test Site (http://www.theotodman.com/Petes_PhD/index.htm)).
    • Bridge
      1. 17Q1: Added new features (70s Club & Monthly Pairs Winners) to my Bridge mini-websites.
      2. 17Q1: Created Master Point Lists & Promotions for the ECBA website.
      3. 16Q3: Revived the archive website for Mountnessing Bridge Club (Mountnessing Bridge Club Archive (http://mountnessing.theotodman.com/index.shtml)).
      4. 16Q1: Accommodated Alaric’s new scoring system for St. Edith’s.
      5. 16Q1: Created Ladies’ and Gentlemen’s ladders for my mini-websites.
      6. 16Q1: Reconciled my X-IMP calculations with a new feature provided by Bridgewebs.
      7. 15Q4: Segregated the Bridge website generators from those for my own website. They now live in separate databases and have their own documenters.
      8. 15Q3: Created a new website (using Bridgewebs) for the First Class Bridge Academy (First Class Bridge (https://www.bridgewebs.com/firstclassbridge/)).
      9. 15Q3: Ported my “handicap / improvers” routines from Hutton to “Mini Websites”.
      10. 15Q2: Development of the “Eve Goblets” (victor ludorum) software for the ECBA, and roll-over to the new season.
      11. 15Q1: Further improvements to my Butler-IMPs and Cross-IMPs calculation routines.
      12. 15Q1: Started a project to provide small websites for bridge clubs without sites: Essex Bridge Results (http://www.theotodman.com/Bridge/index.htm).
      13. 15Q1: Took on the ECBA Website (ECBA Website (http://www.essexbridge.co.uk/)), at the cost of considerable effort by way of reformatting & tidy-up.
      14. 14Q4: Improvements to my Butler-IMPs and Cross-IMPs calculation routines – different formats, including the Jeff Smith format, and extension to Butler-scored Pairs events. This work has been taken up by the ECBA selectors for county-team selection.
      15. 14Q3: Created a suite of programs to extract data and calculate Butler-IMPs and Cross-IMPs from the travellers on Bridgewebs Teams events, and output ranking-lists to the Web.
      16. 13Q2: Merged107=48 Philosophy & Bridge Databases
    • Enigma
      1. 18Q4: Added 'EE' shortcut icon on all Webpage browser tabs
      2. 15Q3: Created a small website for a music group Julie and I attend – the Enigma Ensemble (http://www.enigmaensemble.co.uk/).
    • Sophie
      1. 19Q3: Dismantle my old version of Sophie Botros (http://www.sophiebotros.com/).
      2. 18Q4: Added 'SB' shortcut icon on all Webpage browser tabs
      3. 15Q3: Completed the upgrade of Sophie Botros108=44’s website; see Sophie Botros (http://www.sophiebotros.com/).





In-Page Footnotes

Footnote 6:
  • There have been continual changes and bug-fixes that are not worth reporting.
  • A quarterly release - or the equivalent - of small changes is to be understood passim.
  • There were gaps in the development log that have been filled in from old reports. I've ignored developments for now-defunct sites.
  • However, for my own site I've erred in the direction of plenitude to remind me of what went on. I may prune the list in due course.
Footnote 25:
  • This situation occurs in these reports, and elsewhere.
Footnote 26: Footnote 35:
  • An eccentric use of this term.
  • By it I mean the extraction of data from a database, formatting it, and inserting the resulting text in line into a web-page.
Footnote 42:
  • As demonstrated here!
Footnote 43:
  • I subsequently found a bug whereby it was backing up the entire code-base each time!
Footnote 44:
  • Sophie is an old friend and supervisor from Birkbeck.
Footnote 46:
  • Naturally, I can now say precisely what I mean, by using a plus-sign, as it no longer causes the process to fail!
Footnote 47:
  • Fixed – it was very long blank-free URLs in the Source column.
  • I now call my “WebRef” function to convert these to hyperlinks.
Footnote 48:
  • This was a mistaken idea, and was subsequently reversed!
Footnote 49:
  • Rather irritatingly, when I checked my site in all browsers, I found that it appeared a right mess in some of them (I forget the details).
  • It all stemmed from the DocType parameter, which I had to revert.
Footnote 50:
  • I must have unwound this one - presumably it didn't work - and need to re-do it.
Footnote 51:
  • Did I - or was this an intention?
  • The whole "respondent" process didn't work out well as it fragments the discussion, so this might be important.
Footnote 52:
  • This must have been unwound if it was ever implemented.
Footnote 53:
  • "BB" = "Blackberry" (for when I had one!)
  • Response times - eg. in bookshops - used to be awful. This "binary chop" approach is no longer needed.
Footnote 54:
  • What was this?
Footnote 55:
  • What was this?
Footnote 56:
  • Presumably this was the ancester of this page before it was converted to a Note?
Footnote 57:
  • What was this?
Footnote 60:
  • Naturally, I can now say precisely what I mean, by using a plus-sign, as it no longer causes the process to fail!
Footnote 61:
  • This must have been unwound if it was ever implemented.
Footnote 62:
  • "BB" = "Blackberry" (for when I had one!)
  • Response times - eg. in bookshops - used to be awful. This "binary chop" approach is no longer needed.
Footnote 64:
  • I subsequently found a bug whereby it was backing up the entire code-base each time!
Footnote 65:
  • This situation occurs in these reports, and elsewhere.
Footnote 66: Footnote 67:
  • What was this?
Footnote 68:
  • What was this?
Footnote 70:
  • Presumably this was the ancester of this page before it was converted to a Note?
Footnote 84:
  • An eccentric use of this term.
  • By it I mean the extraction of data from a database, formatting it, and inserting the resulting text in line into a web-page.
Footnote 91:
  • As demonstrated here!
Footnote 93:
  • I must have unwound this one - presumably it didn't work - and need to re-do it.
Footnote 94:
  • Did I - or was this an intention?
  • The whole "respondent" process didn't work out well as it fragments the discussion, so this might be important.
Footnote 95:
  • What was this?
Footnote 104:
  • Rather irritatingly, when I checked my site in all browsers, I found that it appeared a right mess in some of them (I forget the details).
  • It all stemmed from the DocType parameter, which I had to revert.
Footnote 106:
  • Fixed – it was very long blank-free URLs in the Source column.
  • I now call my “WebRef” function to convert these to hyperlinks.
Footnote 107:
  • This was a mistaken idea, and was subsequently reversed!
Footnote 108:
  • Sophie is an old friend and supervisor from Birkbeck.

Note last updated: 03/07/2020 22:09:07


Footnote 4.23: (Website - Outstanding Developments (2020 - June))

Rationale for this Document

  • My website has evolved over time, and some parts are more active than others. Some parts haven’t been looked at (by me) for years.
  • I have known of various problems for some time, and they have been queuing for development awaiting opportunity / enthusiasm.
  • My focus has always been content before form. However, it’s form that catches the eye. So, the site needs a makeover.
  • I’ve also used rather primitive HTML techniques – whatever’s simplest, quickest and less distracting from my philosophical studies.
  • I have started to document my website and the site-generator. The results are currently in a password-protected area.
    1. The Functional Documentation is very rudimentary, but
    2. The Technical Documentation – in the form of the actual code with hyperlinks between routines, and links to the tables and queries used – is wonderful (even if I say so myself) – something Microsoft should have supplied.
    3. The Progress to Date Document provides a brief functional overview, together with the schedule of past quarterly upgrades.
  • Outstanding developments are listed below in two sequences:-
    1. By Priority
    2. By Category
  • Items that have been “Cancelled” or for which a “Work-around” has been found are included in the lists under these status-codes so they are not lost sight of.


  1. Own Website: Outstanding Items By Priority:-
    • Priority: 1
      1. Architecture (In Progress): Compact and Repair Problems
        1. On compacting and repairing my main database I sometimes get the error "The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result".
        2. It happens 3 times while the database is re-opening.
        3. There is lots of space, and the database is only 600Mb (and the error started when it was under 500Mb).
        4. This mostly happens after I've run long processes, so I usually close the database, re-open it and then try the compact and repair. Usually this works, but not always. But I then try again and the message disappears.
        5. I strongly suspect that this is MS Access itself re-indexing tables, and blowing up a temporary database, but I can’t find any evidence for this on-line. Or help, other than suggestions to split databases and do other sensible things. Given that the error occurs when the database is re-opening, with no temporary file visible, is very strange.
        6. 17/04/20 - set MaxLocksPerFile to 1,000,000 (from the default 9,500). Sadly, it doesn't seem to have made a difference.
      2. Architecture (In Progress): Complete XRef-re-engineering project:-
        1. Ensure all links and link-pages use the new XRef table, and pension off the old tables.
        2. Look into writing out specific object-identifiers, and linking thereto for Citations, rather than paragraph references. An issue is multiple instances of the same object in a document.
        3. Check all link-types still work and fix any errors.
        4. Complete the auto-triggering of regeneration of “associated” link pages.
        5. Fix update bug in Convert_Webrefs.
        6. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
        7. Document the process!
      3. Architecture (On-Going): Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
      4. Architecture: Where possible, use ID rather than NAME for in-page hyperlinks
      5. Backups: Investigate Record-count discrepancies:-
        1. How do website files work as far as counts are concerned?
        2. Why aren't they recorded in Backup_History, nor the fact that the website was backed up?
        3. Different counts depending on whether new or old laptop is backed up. Investigate 63k discrepancy - lower on new laptop.
      6. Backups: Review architecture to improve performance; Need to document first
      7. Books: Further improve the time to regenerate Book Summaries. Now takes about 39 minutes, but should be under 5 minutes!
      8. Books/Papers: Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
      9. Books/Papers: Reformat the PaperCitings pages:-
        1. Include only useful information on the detail pages; but if there are multiple links from the same object, include them on the same line as 'extra links' as in Authors' Citations (copy the code).
        2. Include counts on the summary page.
        3. Document!
        Do the same for BookCitings
      10. Bridge (In Progress): Develop auto-reconciliation routines vs EBU results download
      11. Documenter (On-Going): Investigate the error reports from the Documenter, especially unused variables & queries.
      12. Documenter (In Progress): Provide Functional Documentation for Website Generator (using Notes)
      13. Education: "Sitepoint (Learnable) - Sitepoint Learnable Web Development Courses": Membership cancelled, but plan what to do with the eBooks in my possession.
      14. Education (In Progress): Read "PC Pro - Computing in the Real World".
      15. Education: Read "White (Ron) & Downs (Timothy Edward) - How Computers Work: The Evolution of Technology".
      16. Infrastructure: iCloud for Windows: Re-install & solve 'The upload folder for iCloud Photos is missing' problem. Try on new Laptop.
      17. Notes: Add "Note Alternates" to Note pages.
      18. Notes: Add option in Auto-Reference Notes to automatically ignore words containing certain strings that include the key-word (eg. ignore 'grace' and 'trace' when indexing 'race')
      19. Notes: Add option in Auto-Reference Notes to only confirm new items (leaving previously-flagged items untouched)
      20. Notes: Allow the option to concatenate Notes in the Printed version (ie. linearly embed them essay-style), rather than treating the hyperlinks as footnotes – but still keep the hyperlink & cross-referencing in place.
        1. For use as "disclaimers" - eg. for "Plug Notes".
        2. For Thesis / essays: the difficulty here is the need for linking passages to make the text run smoothly.
      21. Notes: As part of the Cross-Referencing project, check out the consistent treatment of Note 875, which should be universally ignored. Recently, links to it appeared on Book-Summaries, Book_Paper_Abstracts and Note_Book_Links, as a Note referencing a Book. The critical item was a row on the Note_Book_Links table.
      22. Notes: Determine why very long printable notes (eg. Level 3+ for Note 170) are being truncated. Probably suppress them in any case, as they take far too long to load.
      23. Notes: Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
      24. Notes: Investigate Note_Links: Section references seem to be incorrect
      25. Notes: Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
      26. Notes: Split Aeon Page into multiple sub-pages (either by topic or by priority)
      27. Notes: Suppress the publication of the Printable versions of Temp Notes
      28. Papers: The monthly regeneration process for Paper Abstracts still takes just over 5 hours. Problem is with Cross_Reference_Deletions and Cross_Reference_Additions. Cannot be fixed until the cross-referencing project is fully complete and documented.
      29. Photos: Develop software & procedure to make adding more content to the photos pages easier to undertake.
      30. Photos: Timeline software: Add photos for Holidays & Family History
      31. Process: Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
      32. Spider (On-Going): Analyse the results of the data collection exercise and design a plan of campaign to fix broken Internal links and prevent recurrence.
        1. Correct the code so the problems discovered by the Spider don’t recur.
        2. Delete 'orphan pages' that are never linked to, ie. Use the Spider to prune redundant pages6 automatically where possible.
        3. Fix the historical data where errors are uncovered by the Spider. An easier task now the site has a full-regen function.
      33. Spider: The size of the main database bloats to over 1.6Gb during the spider run, so is approaching the 2Gb limit.
        1. Use Check_Database_Size, with a parameter, to monitor the size – output a message along the those reporting the compact / repair of the Slave database).
        2. Put a checks in to STOP if over 1.8Gb.
        3. Determine a solution as the limit is pushed. Some tables are “local” for performance reasons and are later copied to the Slave … maybe move them?
      34. Spider (In Progress): The Spider was generating WebRefs. Procedurally, this ought not to have been possible.
        1. The major problem turned out to be because unprocessed7 URLs got added to the end of the last WebLinks_Tester_Brief page, which then got Spidered. I've stopped this happening, so hopefully the problem will not recur. The fix was made in 18Q2.
        2. However, 4 other creations appeared - dated 18/05/18 - from the run of 10/07/18. The creation date was from the previous spider run, but the IDs show that they were produced in the latest run.
        I've re-opened the case!
      35. Status (In Progress): Quarterly Project Reports: Correct Functor_08. The Project Planned YTD % keeps having to be bodged!
      36. Technology (In Progress): Look into Sistrix Smart8. Errors and warnings itemised are:-
        1. Duplicate content: seems to be variants on theotodman.com
        2. Title Tags: Empty, too long, identical
        3. Page Not Found
        4. Filesize in excess of 1Mb
        5. Meta-Description: Empty
        6. Few words on Page
        7. H1: Not used, used multiple times per page, identical across pages
        8. Pictures: Alt attribute missing
      37. WebRefs: Documentation & Bug-fixes: Phase 2
        1. Re-document the procedures in the light of recent changes.
        2. Resolve issues generated / revealed by the spider.
        3. Investigate - and fix where possible - broken links.
      38. WebRefs: Improve WebRefs checker (Webrefs_Update) further to check for Error 403 "Forbidden". This will often involve finding way of checking pdfs where the returned page is in fact HTML or XML (see DevLog Ref 379).
      39. WebRefs: Investigate defunct items. Populate Defunct_Explanation in WebRefs_Table and include in relevant WebLinks_Tester reports. Consider use of FairUse (Link - Fair Use) for documents no longer available that I'd downloaded.
      40. WebRefs: Reformat WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm
        1. Clarify 'truncated': Display, not link
        2. Allow more space for 'link returned', 'issue' and 'display text'
        3. The 'As Above" lines waste space. Only for Notes Archive? Consolidate onto single second line.
      41. WebRefs: Reformat WebLinks_Tester_Brief: Allow more space for 'link returned', 'issue' and 'display text'
    • Priority: 2
      1. Abstracts (In Progress): Ensure some minimal data on Abstracts for Identity Papers Read
      2. Architecture: Improve flexibility of password-protected areas (ie. multiple areas, with different log-ons).
      3. Backups: Determine why flag on directories "not to be backed up" gets reset
      4. Backups: Investigate historic error messages
      5. Education: "Harvard University - CS50 Introduction to Computer Science": Re-start, or maybe just "audit".
      6. Education: "Harvard University - CS50W Web Programming with Python and JavaScript": Re-start, or maybe just "audit".
      7. Education: Bitcoin & Blockchain: Understand better
      8. Education: Bootstrap: Investigate.
      9. Notes: Add "Specific", "Contextual" & "General" Notes as an optional footer to all Notes. I think this is important – part of the difficulty in understanding some philosophers is knowing what their background assumptions are, as this influences what they take to be “obvious” or “a given”.
      10. Notes: Bug: "++ NP ++" links to previously linked note or to (non-)Note 0. Example!
      11. Notes: Check (in use) that the optional "don't print" feature for specific footnotes doesn't print other footnotes further down the chain. Probably OK.
      12. Notes: Enable reproduction of archived “Printed Notes”.
      13. Notes: Improve Printable notes processing for "Temp" Notes (ie. produce a "_T" (& include all "_T"s), but leave standard prints free of "Temps".
      14. Notes: Investigate Notes Archiving - see if could re-create re-formatted if required from saved historical versions (but not fixed re directories)
      15. Notes: Reading Lists: Fix duplications:-
        1. Items "cited" and "categorised" (sometimes seem to) appear twice.
        2. Books and "single papers" of that Book both appear.
      16. Papers: When "+PnnnP+" reference used in an Object, allow "#Reference" style to be more specific where in the Paper Abstract the reference is.
      17. Technology: Increase use of CSS Style Sheets
      18. WebRefs (In Progress): Complete investigation and correction of broken “External” Links.
    • Priority: 3
      1. Aesthetics: Undertake a trawl through all (categories of) web-page, making aesthetic improvements, and correcting content.
      2. Architecture: Add scrolling titles to Lists
      3. Books/Papers: Introduce check that if a Book is flagged as "read" so are its Papers. Manual check completed in March 2018.
      4. Books/Papers: Review the effectiveness of the categorised reading lists for both Papers and Books.
      5. Bridge: Hand-Dealing:
        1. Some hands not showing in consolidated lists
        2. Bidding sometimes missing for SD (maybe connected)
      6. Documenter: Investigate & fix “Query Fragments” issue.
      7. Documenter: Separate Documenter from the main database & code, then add a parameter so it doesn’t necessarily document itself.
      8. Documenter: Undertake a trawl through the code for all functions within the generator – making improvements for efficiency and function. Supply rudimentary functional documentation as a spin-off therefrom.
      9. Facebook: Upgrade my Facebook page ("Facebook - Understand Facebook & Build Personal Facebook Page") using "Abram (Carolyn) - Facebook for Dummies: Fifth Edition" for inspiration / guidance.
      10. Notes: Fix problem with broken bespoke links to Printed Notes from Archived Notes.
      11. Notes: Improve flexibility of reading lists attached to printable version of Notes (different sort orders, priority items only, etc).
      12. Notes: Improve reading-lists from Notes (ie. firstly PID, then all starting with topic from Philosophy Papers Full)
      13. Status: Check how "YTD Planned %" is calculated - seems incorrect early in the Quarter if the plan varies during the year.
      14. Technology: Investigate the use of RTF in memo fields, so that I can get round the 64k character limit.
      15. Technology: Read the Google documentation (Link (https://www.google.com/webmasters/)) to investigate where I’m going wrong in the (failure to) use META tags to ensure my stuff sorts correctly in the search engines.
      16. Technology: Use generated Javascript to allow multi-level expandable / contractable lists in Notes and Paper Abstracts.
      17. Technology: Very long pages (eg. Concatenated Notes and Book Paper Abstracts) fail to render correctly in Firefox (mostly OK in other browsers). Investigate whether it’s possible to subdivide them.
      18. WebRefs (In Progress): Amend WebRef 'Name' link to #Off-Page_Link_WxxxW style. Also amend Quarterly and Annual task lists to use this reference.
    • Priority: 4
      1. Technology: Add page-hit counters
    • Priority: 5
      1. Documenter: Technical Documenter:-
        1. Investigate possibilities of retailing the documenter.
        2. Enhance to document Macros.
        3. Look at ways of documenting other (MS Access) databases & trial on Northwind.
    • Work-arounds
      1. Books (Work-around): Book Comments: if there are explicit internal links to files in Book Comments, they cannot work both in the BookSummary and BookPaperAbstracts, which are at different directory levels. So, don’t put them in the Comments – only in the Abstract.
      2. Books (Work-around): Books - Referencing of Notes: The "+NnnnN+" method works from the Book Summary, "++nnn++" from Book Abstract, but neither vice-versa.
      3. Books (Work-around): Books by Location: the jump table led to an invalid location. I bodged the data, by deleting an unused location, and didn’t properly investigate.
      4. Books (Work-around): Books to Notes: There’s an issue if a Note changes from Secure to non-Secure, but I bodged the data and didn’t try to fix it.
    • Cancelled Developments
      1. Architecture: Create expandable lists in Abstracts, Notes ("Plus table12" cells? For categorised lists)
      2. Authors: Completely re-engineer Authors processing to use IDs rather than Names:-
        1. CANCELLED: Originally needed because of difficulties transferring special characters in file names. But, this can be achieved by avoiding special characters in Author_Name, and putting them in Author_Name_Display.
        2. Had been:-
          → Authors' pages to be identified by Author_nnnnn, where nnnnn is the (numeric) Author_ID.
          → Directory-structure in thousands: Author_mm.
          → Use Author_ID in all Tables.
          → Needed because of difficulties transferring special characters in file names.
      3. Backups: Copying Errors:
        1. Investigate & fix directory error when backing up ZoomSearch database.
        2. This directory structure was set "not to back-up". Determine why this was ignored.
      4. Books: Create "Books by Subject" and "Books by Title" lists
      5. Books/Papers: Create list of "Identity" papers - and books - to obtain (ie. the "zzz"s)
      6. Books/Papers: Create Second-Level Jump (+ maybe split pages) for Philosophy / Identity Papers / Books Full - similar to Blackberry pages
      7. Books/Papers: Determine more efficient method of updating "Books to Papers", "Papers to Notes" and "Books to Notes" - use archiving
      8. Education: Read "Barnes (Russell), Ed. - Web Designer".
      9. General: Fix "American" date formats in Electronic Resources page
      10. Notes: Create "who's who" of respondents (will just be private notes)
      11. Notes: Create Functor to facilitate addition of Audio Files to Music Page (not sure why raised - see ID=348)
      12. Papers: Remove all large 'Comments' that have been utilised to expand Paper Abstracts (by moving them to Notes13). Cancelled and replaced by simply appending large (> 5k) Comments to Abstracts, so the work-around looks seamless.
      13. Photos: As revealed by Spider: Links failing in NotesPrint_1282_0_P_R.htm. 20 items.
      14. Technology: Create own local webserver
      15. Technology: Increase use of Frames14
      16. Technology: Investigate Wiki-technology (inc. Confluence, Plone CMS & Windows Help)
      17. WebRefs: Add collection of "non-identity" weblinks.
  2. Other Websites: Outstanding Items By Priority:-
    • Priority: 1
      1. Bridge (On-Going): Regular updates to the Hutton Bridge Club (https://www.bridgewebs.com/hutton.html) Website.
      2. Bridge (On-Going): Regular updates to the Mountnessing Bridge Club (https://www.bridgewebs.com/mountnessingbc/) Website.
      3. Enigma (On-Going): Termly updates to the Enigma Ensemble (http://www.enigmaensemble.co.uk/) Website.
    • Cancelled Developments
      1. Bridge: Create "Small Sites" database for Alaric (if chased)
      2. Bridge: Run Eve Goblets - if asked!



Outstanding Developments by Category
  1. Own Website: Outstanding Items By Category:-
    • Abstracts
      1. Priority 2 (In Progress): Ensure some minimal data on Abstracts for Identity Papers Read
    • Aesthetics
      1. Priority 3: Undertake a trawl through all (categories of) web-page, making aesthetic improvements, and correcting content.
    • Architecture
      1. Priority 1 (In Progress): Compact and Repair Problems
        1. On compacting and repairing my main database I sometimes get the error "The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result".
        2. It happens 3 times while the database is re-opening.
        3. There is lots of space, and the database is only 600Mb (and the error started when it was under 500Mb).
        4. This mostly happens after I've run long processes, so I usually close the database, re-open it and then try the compact and repair. Usually this works, but not always. But I then try again and the message disappears.
        5. I strongly suspect that this is MS Access itself re-indexing tables, and blowing up a temporary database, but I can’t find any evidence for this on-line. Or help, other than suggestions to split databases and do other sensible things. Given that the error occurs when the database is re-opening, with no temporary file visible, is very strange.
        6. 17/04/20 - set MaxLocksPerFile to 1,000,000 (from the default 9,500). Sadly, it doesn't seem to have made a difference.
      2. Priority 1 (In Progress): Complete XRef-re-engineering project:-
        1. Ensure all links and link-pages use the new XRef table, and pension off the old tables.
        2. Look into writing out specific object-identifiers, and linking thereto for Citations, rather than paragraph references. An issue is multiple instances of the same object in a document.
        3. Check all link-types still work and fix any errors.
        4. Complete the auto-triggering of regeneration of “associated” link pages.
        5. Fix update bug in Convert_Webrefs.
        6. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
        7. Document the process!
      3. Priority 1 (On-Going): Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
      4. Priority 1: Where possible, use ID rather than NAME for in-page hyperlinks
      5. Priority 2: Improve flexibility of password-protected areas (ie. multiple areas, with different log-ons).
      6. Priority 3: Add scrolling titles to Lists
      7. Cancelled: Create expandable lists in Abstracts, Notes ("Plus table15=12" cells? For categorised lists)
    • Authors
      1. Cancelled: Completely re-engineer Authors processing to use IDs rather than Names:-
        1. CANCELLED: Originally needed because of difficulties transferring special characters in file names. But, this can be achieved by avoiding special characters in Author_Name, and putting them in Author_Name_Display.
        2. Had been:-
          → Authors' pages to be identified by Author_nnnnn, where nnnnn is the (numeric) Author_ID.
          → Directory-structure in thousands: Author_mm.
          → Use Author_ID in all Tables.
          → Needed because of difficulties transferring special characters in file names.
    • Backups
      1. Priority 1: Investigate Record-count discrepancies:-
        1. How do website files work as far as counts are concerned?
        2. Why aren't they recorded in Backup_History, nor the fact that the website was backed up?
        3. Different counts depending on whether new or old laptop is backed up. Investigate 63k discrepancy - lower on new laptop.
      2. Priority 1: Review architecture to improve performance; Need to document first
      3. Priority 2: Determine why flag on directories "not to be backed up" gets reset
      4. Priority 2: Investigate historic error messages
      5. Cancelled: Copying Errors:
        1. Investigate & fix directory error when backing up ZoomSearch database.
        2. This directory structure was set "not to back-up". Determine why this was ignored.
    • Books
      1. Priority 1: Further improve the time to regenerate Book Summaries. Now takes about 39 minutes, but should be under 5 minutes!
      2. Work-around: Book Comments: if there are explicit internal links to files in Book Comments, they cannot work both in the BookSummary and BookPaperAbstracts, which are at different directory levels. So, don’t put them in the Comments – only in the Abstract.
      3. Work-around: Books - Referencing of Notes: The "+NnnnN+" method works from the Book Summary, "++nnn++" from Book Abstract, but neither vice-versa.
      4. Work-around: Books by Location: the jump table led to an invalid location. I bodged the data, by deleting an unused location, and didn’t properly investigate.
      5. Work-around: Books to Notes: There’s an issue if a Note changes from Secure to non-Secure, but I bodged the data and didn’t try to fix it.
      6. Cancelled: Create "Books by Subject" and "Books by Title" lists
    • Books/Papers
      1. Priority 1: Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
      2. Priority 1: Reformat the PaperCitings pages:-
        1. Include only useful information on the detail pages; but if there are multiple links from the same object, include them on the same line as 'extra links' as in Authors' Citations (copy the code).
        2. Include counts on the summary page.
        3. Document!
        Do the same for BookCitings
      3. Priority 3: Introduce check that if a Book is flagged as "read" so are its Papers. Manual check completed in March 2018.
      4. Priority 3: Review the effectiveness of the categorised reading lists for both Papers and Books.
      5. Cancelled: Create list of "Identity" papers - and books - to obtain (ie. the "zzz"s)
      6. Cancelled: Create Second-Level Jump (+ maybe split pages) for Philosophy / Identity Papers / Books Full - similar to Blackberry pages
      7. Cancelled: Determine more efficient method of updating "Books to Papers", "Papers to Notes" and "Books to Notes" - use archiving
    • Bridge
      1. Priority 1 (In Progress): Develop auto-reconciliation routines vs EBU results download
      2. Priority 3: Hand-Dealing:
        1. Some hands not showing in consolidated lists
        2. Bidding sometimes missing for SD (maybe connected)
    • Documenter
      1. Priority 1 (On-Going): Investigate the error reports from the Documenter, especially unused variables & queries.
      2. Priority 1 (In Progress): Provide Functional Documentation for Website Generator (using Notes)
      3. Priority 3: Investigate & fix “Query Fragments” issue.
      4. Priority 3: Separate Documenter from the main database & code, then add a parameter so it doesn’t necessarily document itself.
      5. Priority 3: Undertake a trawl through the code for all functions within the generator – making improvements for efficiency and function. Supply rudimentary functional documentation as a spin-off therefrom.
      6. Priority 5: Technical Documenter:-
        1. Investigate possibilities of retailing the documenter.
        2. Enhance to document Macros.
        3. Look at ways of documenting other (MS Access) databases & trial on Northwind.
    • Education
      1. Priority 1: "Sitepoint (Learnable) - Sitepoint Learnable Web Development Courses": Membership cancelled, but plan what to do with the eBooks in my possession.
      2. Priority 1 (In Progress): Read "PC Pro - Computing in the Real World".
      3. Priority 1: Read "White (Ron) & Downs (Timothy Edward) - How Computers Work: The Evolution of Technology".
      4. Priority 2: "Harvard University - CS50 Introduction to Computer Science": Re-start, or maybe just "audit".
      5. Priority 2: "Harvard University - CS50W Web Programming with Python and JavaScript": Re-start, or maybe just "audit".
      6. Priority 2: Bitcoin & Blockchain: Understand better
      7. Priority 2: Bootstrap: Investigate.
      8. Cancelled: Read "Barnes (Russell), Ed. - Web Designer".
    • Facebook
      1. Priority 3: Upgrade my Facebook page ("Facebook - Understand Facebook & Build Personal Facebook Page") using "Abram (Carolyn) - Facebook for Dummies: Fifth Edition" for inspiration / guidance.
    • General
      1. Cancelled: Fix "American" date formats in Electronic Resources page
    • Infrastructure
      1. Priority 1: iCloud for Windows: Re-install & solve 'The upload folder for iCloud Photos is missing' problem. Try on new Laptop.
    • Notes
      1. Priority 1: Add "Note Alternates" to Note pages.
      2. Priority 1: Add option in Auto-Reference Notes to automatically ignore words containing certain strings that include the key-word (eg. ignore 'grace' and 'trace' when indexing 'race')
      3. Priority 1: Add option in Auto-Reference Notes to only confirm new items (leaving previously-flagged items untouched)
      4. Priority 1: Allow the option to concatenate Notes in the Printed version (ie. linearly embed them essay-style), rather than treating the hyperlinks as footnotes – but still keep the hyperlink & cross-referencing in place.
        1. For use as "disclaimers" - eg. for "Plug Notes".
        2. For Thesis / essays: the difficulty here is the need for linking passages to make the text run smoothly.
      5. Priority 1: As part of the Cross-Referencing project, check out the consistent treatment of Note 875, which should be universally ignored. Recently, links to it appeared on Book-Summaries, Book_Paper_Abstracts and Note_Book_Links, as a Note referencing a Book. The critical item was a row on the Note_Book_Links table.
      6. Priority 1: Determine why very long printable notes (eg. Level 3+ for Note 170) are being truncated. Probably suppress them in any case, as they take far too long to load.
      7. Priority 1: Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
      8. Priority 1: Investigate Note_Links: Section references seem to be incorrect
      9. Priority 1: Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
      10. Priority 1: Split Aeon Page into multiple sub-pages (either by topic or by priority)
      11. Priority 1: Suppress the publication of the Printable versions of Temp Notes
      12. Priority 2: Add "Specific", "Contextual" & "General" Notes as an optional footer to all Notes. I think this is important – part of the difficulty in understanding some philosophers is knowing what their background assumptions are, as this influences what they take to be “obvious” or “a given”.
      13. Priority 2: Bug: "++ NP ++" links to previously linked note or to (non-)Note 0. Example!
      14. Priority 2: Check (in use) that the optional "don't print" feature for specific footnotes doesn't print other footnotes further down the chain. Probably OK.
      15. Priority 2: Enable reproduction of archived “Printed Notes”.
      16. Priority 2: Improve Printable notes processing for "Temp" Notes (ie. produce a "_T" (& include all "_T"s), but leave standard prints free of "Temps".
      17. Priority 2: Investigate Notes Archiving - see if could re-create re-formatted if required from saved historical versions (but not fixed re directories)
      18. Priority 2: Reading Lists: Fix duplications:-
        1. Items "cited" and "categorised" (sometimes seem to) appear twice.
        2. Books and "single papers" of that Book both appear.
      19. Priority 3: Fix problem with broken bespoke links to Printed Notes from Archived Notes.
      20. Priority 3: Improve flexibility of reading lists attached to printable version of Notes (different sort orders, priority items only, etc).
      21. Priority 3: Improve reading-lists from Notes (ie. firstly PID, then all starting with topic from Philosophy Papers Full)
      22. Cancelled: Create "who's who" of respondents (will just be private notes)
      23. Cancelled: Create Functor to facilitate addition of Audio Files to Music Page (not sure why raised - see ID=348)
    • Papers
      1. Priority 1: The monthly regeneration process for Paper Abstracts still takes just over 5 hours. Problem is with Cross_Reference_Deletions and Cross_Reference_Additions. Cannot be fixed until the cross-referencing project is fully complete and documented.
      2. Priority 2: When "+PnnnP+" reference used in an Object, allow "#Reference" style to be more specific where in the Paper Abstract the reference is.
      3. Cancelled: Remove all large 'Comments' that have been utilised to expand Paper Abstracts (by moving them to Notes22=13). Cancelled and replaced by simply appending large (> 5k) Comments to Abstracts, so the work-around looks seamless.
    • Photos
      1. Priority 1: Develop software & procedure to make adding more content to the photos pages easier to undertake.
      2. Priority 1: Timeline software: Add photos for Holidays & Family History
      3. Cancelled: As revealed by Spider: Links failing in NotesPrint_1282_0_P_R.htm. 20 items.
    • Process
      1. Priority 1: Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
    • Spider
      1. Priority 1 (On-Going): Analyse the results of the data collection exercise and design a plan of campaign to fix broken Internal links and prevent recurrence.
        1. Correct the code so the problems discovered by the Spider don’t recur.
        2. Delete 'orphan pages' that are never linked to, ie. Use the Spider to prune redundant pages23=6 automatically where possible.
        3. Fix the historical data where errors are uncovered by the Spider. An easier task now the site has a full-regen function.
      2. Priority 1: The size of the main database bloats to over 1.6Gb during the spider run, so is approaching the 2Gb limit.
        1. Use Check_Database_Size, with a parameter, to monitor the size – output a message along the those reporting the compact / repair of the Slave database).
        2. Put a checks in to STOP if over 1.8Gb.
        3. Determine a solution as the limit is pushed. Some tables are “local” for performance reasons and are later copied to the Slave … maybe move them?
      3. Priority 1 (In Progress): The Spider was generating WebRefs. Procedurally, this ought not to have been possible.
        1. The major problem turned out to be because unprocessed24=7 URLs got added to the end of the last WebLinks_Tester_Brief page, which then got Spidered. I've stopped this happening, so hopefully the problem will not recur. The fix was made in 18Q2.
        2. However, 4 other creations appeared - dated 18/05/18 - from the run of 10/07/18. The creation date was from the previous spider run, but the IDs show that they were produced in the latest run.
        I've re-opened the case!
    • Status
      1. Priority 1 (In Progress): Quarterly Project Reports: Correct Functor_08. The Project Planned YTD % keeps having to be bodged!
      2. Priority 3: Check how "YTD Planned %" is calculated - seems incorrect early in the Quarter if the plan varies during the year.
    • Technology
      1. Priority 1 (In Progress): Look into Sistrix Smart25=8. Errors and warnings itemised are:-
        1. Duplicate content: seems to be variants on theotodman.com
        2. Title Tags: Empty, too long, identical
        3. Page Not Found
        4. Filesize in excess of 1Mb
        5. Meta-Description: Empty
        6. Few words on Page
        7. H1: Not used, used multiple times per page, identical across pages
        8. Pictures: Alt attribute missing
      2. Priority 2: Increase use of CSS Style Sheets
      3. Priority 3: Investigate the use of RTF in memo fields, so that I can get round the 64k character limit.
      4. Priority 3: Read the Google documentation (Link (https://www.google.com/webmasters/)) to investigate where I’m going wrong in the (failure to) use META tags to ensure my stuff sorts correctly in the search engines.
      5. Priority 3: Use generated Javascript to allow multi-level expandable / contractable lists in Notes and Paper Abstracts.
      6. Priority 3: Very long pages (eg. Concatenated Notes and Book Paper Abstracts) fail to render correctly in Firefox (mostly OK in other browsers). Investigate whether it’s possible to subdivide them.
      7. Priority 4: Add page-hit counters
      8. Cancelled: Create own local webserver
      9. Cancelled: Increase use of Frames26=14
      10. Cancelled: Investigate Wiki-technology (inc. Confluence, Plone CMS & Windows Help)
    • WebRefs
      1. Priority 1: Documentation & Bug-fixes: Phase 2
        1. Re-document the procedures in the light of recent changes.
        2. Resolve issues generated / revealed by the spider.
        3. Investigate - and fix where possible - broken links.
      2. Priority 1: Improve WebRefs checker (Webrefs_Update) further to check for Error 403 "Forbidden". This will often involve finding way of checking pdfs where the returned page is in fact HTML or XML (see DevLog Ref 379).
      3. Priority 1: Investigate defunct items. Populate Defunct_Explanation in WebRefs_Table and include in relevant WebLinks_Tester reports. Consider use of FairUse (Link - Fair Use) for documents no longer available that I'd downloaded.
      4. Priority 1: Reformat WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm
        1. Clarify 'truncated': Display, not link
        2. Allow more space for 'link returned', 'issue' and 'display text'
        3. The 'As Above" lines waste space. Only for Notes Archive? Consolidate onto single second line.
      5. Priority 1: Reformat WebLinks_Tester_Brief: Allow more space for 'link returned', 'issue' and 'display text'
      6. Priority 2 (In Progress): Complete investigation and correction of broken “External” Links.
      7. Priority 3 (In Progress): Amend WebRef 'Name' link to #Off-Page_Link_WxxxW style. Also amend Quarterly and Annual task lists to use this reference.
      8. Cancelled: Add collection of "non-identity" weblinks.
  2. Other Websites: Outstanding Items By Category:-
    • Bridge
      1. Cancelled: Create "Small Sites" database for Alaric (if chased)
      2. Priority 1 (On-Going): Regular updates to the Hutton Bridge Club (https://www.bridgewebs.com/hutton.html) Website.
      3. Priority 1 (On-Going): Regular updates to the Mountnessing Bridge Club (https://www.bridgewebs.com/mountnessingbc/) Website.
      4. Cancelled: Run Eve Goblets - if asked!
    • Enigma
      1. Priority 1 (On-Going): Termly updates to the Enigma Ensemble (http://www.enigmaensemble.co.uk/) Website.





In-Page Footnotes

Footnote 6:
  • Note that Backup_Prune_Ctrl deletes (relevant) pages that weren't regenerated in the last full site-regen, but this isn't the same thing.
Footnote 7:
  • These are URLs that were used in web pages but hadn't yet been converted to the +WnnnW+ format, so appeared at the end with no WebRef ID.
Footnote 8:
  • See Sistrix (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Optimizr (http://www.optimizr.com/) (which now auto-forwards to Sistrix).
  • A quick look doesn’t show it to be an obvious scam, but I need to double-check.
  • An unsolicited analysis of my site turned up monthly from Optimizr from January 2015 to October 2017, listing a large number of “problems” that I think I know about, but which are in the queue to address.
  • It restarted in February 2018, under the Sistrix name (this seems to have been associated with Optimizr since November 2015).
  • The free version of this software is restricted to 1,000 pages, which is a very small proportion of my Site, though I may be able to point it to difference base-URLs.
  • But I do need to address the problems validly itemised, and a sub-set is still useful.
Footnote 12:
  • I'm not sure what was intended here.
Footnote 13:
  • Once the size-limitation on Notes has been resolved.
Footnote 14:
  • This is now archaic, and was subsequently largely abandoned, though useful at the time.
Footnote 15:
  • I'm not sure what was intended here.
Footnote 22:
  • Once the size-limitation on Notes has been resolved.
Footnote 23:
  • Note that Backup_Prune_Ctrl deletes (relevant) pages that weren't regenerated in the last full site-regen, but this isn't the same thing.
Footnote 24:
  • These are URLs that were used in web pages but hadn't yet been converted to the +WnnnW+ format, so appeared at the end with no WebRef ID.
Footnote 25:
  • See Sistrix (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Optimizr (http://www.optimizr.com/) (which now auto-forwards to Sistrix).
  • A quick look doesn’t show it to be an obvious scam, but I need to double-check.
  • An unsolicited analysis of my site turned up monthly from Optimizr from January 2015 to October 2017, listing a large number of “problems” that I think I know about, but which are in the queue to address.
  • It restarted in February 2018, under the Sistrix name (this seems to have been associated with Optimizr since November 2015).
  • The free version of this software is restricted to 1,000 pages, which is a very small proportion of my Site, though I may be able to point it to difference base-URLs.
  • But I do need to address the problems validly itemised, and a sub-set is still useful.
Footnote 26:
  • This is now archaic, and was subsequently largely abandoned, though useful at the time.

Note last updated: 03/07/2020 22:09:07


Footnote 4.24: (Website Generator Documentation - Control Page)

For a high-level and not terribly up-to-date Functional Overview of my website and its generator, see this Note.

Herewith the Jump Table of the Documentation Notes I've so far written.

Herewith the VBA Code Control Page for easy access to the code and tables + queries used to generate the site.

Tables showing (approximately2) when the underlying procedures were updated are given via the links below:-

The documents detailing recent updates and outstanding developments to my Website are given via the links below:-

  • Quarterly Status Report
  • Progress to Date
  • Outstanding Developments

A bitmap of the front screen of the MS Access application that generates my website is as below:-

 


 

Front Screen

 


 

A schematic representation of the front screen is as below.

  • I know it's a bit crowded, but it's for private use.
  • Click on "Code" for links through to the VBA code.
  • For functional documentation, click on "Note". The functions are bunched into classes, so many links will take you to the same place initially.
  • The usual colour-conventions are not followed. This is all my own work!
  • This Note is awaiting further attention.

 


 

 THEO TODMAN'S WEBSITE GENERATOR 
Identity Papers Read
Code + Note
Search Papers
Code + Note
Webpages - Notes Export
Code + Note
Notes Table By Group
Code + Note
Identity Papers Read (Sub-Topic)
Code + Note
Papers Table
Code + Note
Webpages - Printable Note Export
Code + Note
Auto Reference Notes
Code + Note
Identity Papers Full
Code + Note
Search Books
Code + Note
Update Thesis Dashboard
Code + Note
Translate Deduced Note References
Code + Note
Identity Papers Full (Sub-Topic)
Code + Note
Books Table
Code + Note
Missing Timesheet Tasks
Code + Note
Prune Website
Code + Note
Philosophy Papers Full
Code + Note
Search Notes
Code + Note
Books on Order
Code + Note
Development Log
Code + Note
Philosophy Papers Full (by Topic)
Code + Note
Notes and Sub_Notes Tables
Code + Note
Webpage - Maintenance Dashboard
Code + Note
Full Website Re-Gen
Code + Note
Philosophy Papers Full (SubTopic)
Code + Note
Webpages - Paper Abstracts
Code + Note
Quarterly Reporting - Summary
Code + Note
Update / Check Web Links
Code + Note
Webpages - Books
Code + Note
Display Changed Paper Abstracts
Code + Note
Quarterly Reporting - Task Lists
Code + Note
Backups
Code + Note
Webpages - Books (by Topic)
Code + Note
Paper Abstract Archive
Code + Note
Temp Notes and Sub_Notes
Code + Note
Open Notes Archive Regen Form
Code + Note
Webpages - Books (by Location)
Code + Note
Webpage - Paper + Book Summaries Regen
Code + Note
Webpages - Philosophers Index
Code + Note
Run Web Spider
Code + Note
Webpages - Books to Papers Links
Code + Note
Display Changed Paper + Book Summaries
Code + Note
Philosophers Index Abstract Search
Code + Note
Webpages - Book Citings
Code + Note
Webpages - Papers to Notes Links
Code + Note
Paper + Book Summaries Archive
Code + Note
Recalculation + Housekeeping
Code + Note
Webpages - Paper Citings
Code + Note
Webpages - Books to Notes Links
Code + Note
Search / Add Author Narratives
Code + Note
Webpage - Precis Export
Code + Note
Notes_To_Print + Notes_Archive Tables
Code + Note
Webpages - BookPaperAbstracts
Code + Note
Webpages - Author Narratives
Code + Note
Webpage - Electronic Resources
Code + Note
Webpages - Concatenated Notes
Code + Note
Visitor Stats
Code + Note
Books Move
Code + Note
Run Code Documenter
Code + Note
Update / Output Timeline Pages
Code + Note
Audio
Code + Note
CLOSE APPLICATION
Code
Aeon
Code + Note





In-Page Footnotes

Footnote 2:
  • The date/times are those of the documenter-run that archived the particular version of the code.
  • So, they are "latest" dates, the "earliest" being that of the previous archive.
  • I've not written routines to display the archived code, as there's been no need for it.

Note last updated: 03/07/2020 22:09:07


Footnote 5: (Status: Philosophy of Religion (2020 - June))

The text of this report – apart from the automatically-generated statistics – hasn’t been changed since end September 2019 as this project is substantially in abeyance. This report is generated automatically.


Rationale for this Project
  • See my Christian page1 and onward links from there for an explanation of how I got in to and out of evangelical Christianity. This is still a live issue for me, and the reason I originally undertook formal philosophical training.
  • The connection to my current philosophical researches arises from the standard religious hope that resurrection – or some other form of post-mortem survival – is possible. This is a cornerstone of religious claims and expectations, at least in the Abrahamic religions, from those of suicide bombers to those of more pacific persons. I wish to go back to the considerations that originally motivated Locke and research the metaphysical possibility of resurrection, or other post-mortem survival, for beings such as us. My current opinion is that resurrection for human beings is metaphysically impossible2, given that substance dualism is false.
  • In late September 2010 I took the Philosophy of Religion Module of a 2-year part time MA in Philosophy and Religion at Heythrop College London (http://www.heythrop.ac.uk/), University of London. Follow the links for my Personal Statement, Interview Write-up, and Course Outline. I decided not to proceed with the MA but do intend to follow up on7 the many issues raised.
  • During 2016 I assisted with the Appendices of my friend’s PhD Thesis on the Narrative Structure of the Acts of the Apostles, building a website. See "Mansell (Peter) - Bottom Up Reading of Acts".
  • In August 2017 I was asked by Michael J. Alter to review pre-publication his book on the theology of the Resurrection. Unfortunately it turned out to be too much work, and I only commented on the first section.

Summary of Progress during April - June 2020
  1. I spent 38 hours in 20Q2 on this Project, or related work (59 hours YTD, where for "YTD" - Year to Date - I mean the (academic) year that commenced in October 2019). That's 296% of the planned effort (151.6% YTD). Overall, 5.2% of my Project effort in the Quarter was directed towards this project (making 2.8% YTD) - as against 1.9% planned (1.7% YTD).
  2. I spent a lot more time than planned on this project last quarter, as noted above, and for the reasons apparent from the list of tasks below. I may comment on all this in my year-end report.
  3. Religion (Total Hours = 30.25)Religion Background (Total Hours = 7.75)
    1. Religion Background - Admin
    2. Religion Background - Discussions (Total Hours = 7.5)
      • Interaction - Discussions with Mike & Sylvia (0.25 hours)
        → See "Interaction - Discussion with Mike" (0.25 hours)
      • "Interaction - Discussions with Pete" (0.25 hours)
      • Interaction - Pete's Easter Quiz (with Cliffe, Sandra, Mike, Sylvia, Willie & Gill) (3.75 hours)
      • Interaction - Pete's Pentecost Quiz (with Cliffe, Sandra, Mike, Sylvia, Willie & Gill) (3.25 hours)
  4. YTD Activity10
    Religion (Total Hours = 46.25)Religion Background (Total Hours = 12.75)
    1. Religion Background - Admin (Total Hours = 1.25)
      • 19Q3 Status Reports (0.5 hours)
      • 19Q4 Status Reports (0.5 hours)
      • 20Q1 Status Reports (0.25 hours)
        → See "Admin - Religion - Admin" (1.25 hours)
    2. Religion Background - Discussions (Total Hours = 11.5)
      • Interaction - Discussions with Mike & Sylvia (1.75 hours)
        → See "Interaction - Discussion with Mike" (1.75 hours)
      • "Interaction - Discussions with Pete" (2.75 hours)
      • Interaction - Pete's Easter Quiz (with Cliffe, Sandra, Mike, Sylvia, Willie & Gill) (3.75 hours)
      • Interaction - Pete's Pentecost Quiz (with Cliffe, Sandra, Mike, Sylvia, Willie & Gill) (3.25 hours)
  5. Progress (if any) in the current quarter can be obtained from the relevant section of my Summary Task List, and YTD in the current & future “automatic” editions of this report.

Plans for the Near Future
Summary of Progress to Date

I’ve hived off the history to a separate document, which still requires a major update.




In-Page Footnotes

Footnote 2:
  • Or if not strictly impossible – rather unlikely, as the candidates for enabling some sort of physical continuity – from luz bones to “corpse swapping” – have multiple problems.
  • However, there are some interesting ideas by Dean Zimmerman, most recently in "Zimmerman (Dean) - Bodily Resurrection: The Falling Elevator Model Revisited", that argue the contrary.
  • Also, transhumanists – who are almost following a religion – are often hopeful of post-mortem survival. I have no metaphysical worries about “cryonic suspension”, and subsequent resuscitation, but think that uploading is incoherent.
Footnote 7:
  • This pious hope has been sitting unactioned for over 9 years now!
  • The proximate cause of my failure was missing a deadline for my essay on the Ontological Argument, but a more serious reason was that it was all a waste of time (for me, given my research interests). Peter Vardy had warned me about anno domini, with the claim that original work after the age of 65 is unlikely. I hope this is false, as I’ve ignored the warning, and am about to reach that milestone.
Footnote 10:
  • As this project is substantially inactive, I don’t update the text quarterly as for the active projects, but only at the end of the academic year.
  • If there are hours in the Plan, the Quarterly and YTD figures appear against that plan and are “as at” the end of the last Quarter.
  • The YTD Activity-list is to make the end-year task easier, and to give a clearer idea of what – if anything – has been going on in the interim.
  • Items on this list are “as at” the date of production of the report – which may be at any time in a quarter, so totals don’t necessarily cross-cast against the QTD / YTD figures.
Footnote 14:
  • While I couldn't submit to Michael Alter's deadlines and the amount of work required, I ought to at least read these books.

Note last updated: 03/07/2020 22:09:07


Footnote 5.1: (Theo Todman's Christian Page)

  1. For an attempt to describe my Odyssey from
    • retreats at Ampleforth, to
    • postulancy at Parkminster, to
    • Bible study at the Chapel of the Opened Book, to
    • writing for the Open Bible Trust, to
    • fellowship at the FIEC, and finally to
    • the fizzling out of my Christian faith at the CoE in Billericay
    → follow the links in this Note (which arose from a friend asking me to explain these matters).
  2. I attempted an MA in Philosophy and Religion at Heythrop2 during the final term of 2010, but only completed the module on Philosophy of Religion. This link gives my Plan, at the time.
  3. For not-so-current controversies, see the Blog.
  4. For the latest status report on my activities in this area, follow this link.
  5. Links:-
    • For Ampleforth, see Link (http://www.abbey.ampleforth.org.uk/).
    • For Parkminster see the Carthusian link.
    • For the Chapel of the Opened Book (Link (http://apps.hackney.gov.uk/servapps/HackneyDirectory/Details.aspx?OrgID=4894&Admin=0)) and the Berean Forward Movement (Link (https://www.apextesting.co.uk/about-us/the-berean-forward-movement-bfm-trust/)), see also the Charles Welch site (Link (http://charleswelch.net/), there may be others).
    • For the Open Bible Trust (OBT (http://www.obt.org.uk/)) see OBT.
    • For the Fellowship of Independent Evangelical Churches (FIEC), see Link (https://fiec.org.uk/).
    • For the fizzling, see my Tractatus (for the original version, follow this link).





In-Page Footnotes

Footnote 2:
  • It seems that Heythrop is – finally – close in October 2018.
  • See the Statement from the final Principal (Link (http://www.heythrop.ac.uk/news/statement-principal)).

Note last updated: 31/08/2017 19:35:02


Footnote 10: (Status: Languages (2020 - June))

The text of this report – apart from the automatically-generated statistics – hasn’t changed much since end September 2019 as this project is substantially in abeyance. This report is generated automatically.


Rationale for this Project
  • I don’t claim to have any linguistic ability, and am usually too shy to utter anything in public in a language other than English – partly because of an obsession with accuracy, but also because of a lack of interest in the use of language for basic communication, leading to a lack of command of everyday speech.
  • I’m interested in how languages function, and in particular how languages in related or unrelated groups compare as far as their grammar and vocabulary are concerned.
  • I’m also interested in nativist theses about the innate hard-wiring of human brains for the acquisition of natural languages at critical phases of psychological development (see my BA Philosophy dissertation “Poverty of Stimulus Arguments for Innate Grammar1”).
  • Anyway, at various times of my life I have made forays into various languages by formal or informal study.
  • This used to involve listening on my iPod while walking to and from the station, when exercising down the gym, or in the car to and from music lessons. Now these opportunities have mostly gone. I do have the opportunity when walking Henry the dog, but prefer to let my mind wander.
  • Another problem is that, while initially progress seems rapid, after a while repeated listening to a very limited conversational CD doesn’t lead to any further progress in vocabulary and grammatical understanding – for this, reading and careful study is required.
  • Other reasons for bothering with languages are that Classical Greek, Hebrew and maybe Syriac, Arabic and Latin should be of use in my theological studies, and Brazilian Portuguese, Turkish and Thai are important with family-members as native speakers.
  • This project has varied in priority over recent years, but is now mostly moth-balled. This is to provide focus for my major projects, but also reflects the fact that time spent on occasional forays into language-learning is effectively wasted.
  • However, now Nat has arranged to work remotely in Thailand, and has married Fon – his Thai girlfriend – learning Thai has some relevance.
  • Also, a fellow mathematician in my year from King’s has developed the Unicode standards for Egyptian hieroglyphs, so I intend another foray in that direction someday, though not now.

Summary of Progress during April - June 2020
  1. I spent 72 hours in 20Q2 on this Project, or related work (86.25 hours YTD, where for "YTD" - Year to Date - I mean the (academic) year that commenced in October 2019). That's 280.4% of the planned effort (166.7% YTD). Overall, 9.9% of my Project effort in the Quarter was directed towards this project (making 4.1% YTD) - as against 3.7% planned (2.3% YTD).
  2. Languages (Total Hours = 72)
    1. Languages - Admin
    2. Languages - Chinese
    3. Languages - Japanese
    4. Languages - Thai (Total Hours = 71.25)
  3. YTD Activity2
    Languages (Total Hours = 86.25)
    1. Languages - Admin (Total Hours = 1.25)
      • 19Q3 Status Reports (0.5 hours)
      • 19Q4 Status Reports (0.5 hours)
      • 20Q1 Status Reports (0.25 hours)
        → See "Admin - Languages - Admin" (1.25 hours)
    2. Languages - All (Total Hours = 2.75)
    3. Languages - Chinese
    4. Languages - Egyptian
    5. Languages - Greek (Classical)
    6. Languages - Italian
    7. Languages - Japanese
    8. Languages - Thai (Total Hours = 79.75)
  4. Progress (if any) in the current quarter can be obtained from the relevant section of my Summary Task List3, and YTD in the current & future “automatic” editions of this report.

Plans for the Near Future Materials for Use

These can be followed up here4. The document needs a review, but not a major update.




In-Page Footnotes

Footnote 2:
  • As this project is substantially inactive, I don’t usually update the text quarterly as for the active projects, but only at the end of the academic year.
  • If there are hours in the Plan, the Quarterly and YTD figures appear against that plan and are “as at” the end of the last Quarter.
  • The YTD Activity-list is to make the end-year task easier, and to give a clearer idea of what – if anything – has been going on in the interim.
  • Items on this list are “as at” the date of production of the report – which may be at any time in a quarter, so totals don’t necessarily cross-cast against the QTD / YTD figures.

Note last updated: 03/07/2020 22:09:07


Footnote 10.1: (Poverty of Stimulus)

  • This is my BA Dissertation on the topic of Poverty of Stimulus arguments for the Innateness of Grammar. I enjoyed this investigation, and intend to use the kind of abductive arguments on which it is based as a model for my PhD thesis.
  • Currently, this Essay is only available as a PDF: Click here. It is my intention to convert this to Note format shortly.

Note last updated: 01/08/2017 00:11:31


Footnote 10.3: (Status: Summary Task List (2020: April - June))

This is a list of the tasks performed on my various projects since my last status report. It is automatically generated from my time-recording system, so is fairly crude. See also the YTD Report. For the latest list of Priority Tasks that I'm supposed to be working on, follow this link. The main purpose (for me) is to provide readily-available hyperlinks to what I've just written. Projects are in priority sequence, broken down by sub-project where appropriate. If the project name has a superscript, clicking on the name will take you to the last published report for this project. To jump to the Project task-lists, click on the links in the list below:-

  1. Thesis (For the latest Status Dashboard, Click Here)
  2. Thesis Background
  3. Thesis (Aeon)
  4. Religion
  5. Religion Background
  6. Website
  7. Website Others
  8. Music
  9. Bridge
  10. Chess
  11. Consciousness
  12. Languages
  13. Mathematics
  14. HiQ
Links to the latest time-analyses are given first.
  1. Click Here for Actual Detail Summary (2007 - 2021) by Sub-Project
  2. Click Here for (by Project)
    • Summary of Effort YTD & QTD
    • Time Analysis (YTD by Study-location)
  3. Click Here for (by Project)
    • Plan versus Actual Effort Summary - Split (Previous Quarter & YTD)
    • Plan versus Actual Effort Summary - Actual (Previous Quarter & YTD)
    • Plan Summary (Next Quarter & Full Year)
    • Actual & Plan Summary (2007 - 2021)
Project 1: Thesis (Total Hours = 229)
  1. Thesis - Reading / Writing (Total Hours = 204.5)