Theo Todman's Web Page

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

Status Reports - Status: Summary (2020 - September)

Rationale for this Report


Projects in Progress
Actuals & Planning
Detailed Interim Activities

Plans for the Near Future25
  1. Thesis
  2. Website
  3. Religion
  4. Music
  5. Languages
  6. Consciousness
  7. Bridge
  8. Chess
  9. Mathematics
  10. HiQ
  1. Thesis26 (24 hours per week)
    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, Religion34, Semantics35, Soul Criterion36, Souls37, Unity of the Person38.
      3. Those not yet in the latest standard format.
    4. Make progress on specific Chapters of my Thesis, using the materials below →
    5. Chapter 139 (Introduction). Focussing on:-
      1. Locke40
        → "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 241 (What Are We?). Focussing on:-
      1. General: "Olson (Eric) - What are We? A Study of Personal Ontology", a core text!
      2. Brains42: "Mitchell (Kevin J.) - Innate: How the Wiring of Our Brains Shapes Who We Are", Read & review
      3. Human Beings43: 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. Persons44:-
        1. "Cottingham (John) - Why we are not 'persons'", Complete Write-up
        2. "Kuhn (Robert Lawrence), Ed. - Closer to Truth: Personal Identity", Watch and write up
        3. "Kuhn (Robert Lawrence), Ed. - Closer to Truth: Persons and Selves", Watch and write up
      5. Selves45:-
        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-up46
        4. "O'Hear (Anthony), Ed. - Mind, Self and Person", Complete Reading and Write-ups
    7. Chapter 347 (What Is A Person48?).
      1. General:-
        → "Noller (Jorg) - A Transformative Account of Personal Identity", Read and write-up
        → "Noller (Jorg) - Person", Read and write-up
      2. Free Will49
        → "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. Personites50, 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 451 (Basic Metaphysical Issues). Focus on:-
      1. General: "Hazlett (Allan) - New Waves in Metaphysics", Read
      2. Existence52: "Williams (Christopher) - Death and Other Difficulties", Read and write-up
      3. Logic of Identity53
        1. Partial Identity54
          → "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. Artifacts55
          → "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-up56
      4. Parfit57
        → "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-up58=46
        → "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, Note59
        → "Parfit (Derek) - Who do you think you are?", Write-up
        → Complete run-through of the Parfit reading-list
      5. Simple View60
        → "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 Identity61
        → "Broome (John) - Indefiniteness in Identity",
        → "Noonan (Harold) - Vague Identity Yet Again"
      7. Narrative Identity62 / Race63. Obtain a balanced view64 Focussing On65:-
        1. Race and Racism66
          → "Black (Jeremy) - A Brief History of Slavery"
          → "Boxill (Bernard), Ed. - Race and Racism: Oxford Readings in Philosophy"
          → "Brues (Alice M.) - People and Races"
          → "Curran (Andrew) - Facing America's History Of Racism Requires Facing The Origins Of 'Race' As A Concept"
          → "Glasgow (Joshua) - Another Look at the Reality of Race, By Which I Mean Race-f"
          → "Mac Donald (Heather) - The Diversity Delusion"
          → "Murray (Douglas) - The Madness of Crowds: Gender, Race and Identity"
          → "Rutherford (Adam) - How to Argue With a Racist: History, Science, Race and Reality"
        2. The British Empire & its 'Crimes': obtain a balanced view67=64 from the following list:-
          → "Brendon (Piers) - The Decline And Fall Of The British Empire"
          → "Darwin (John) - Unfinished Empire: The Global Expansion of Britain"
          → "Lawrence (James) - Rise And Fall Of The British Empire"
          → "Paxman (Jeremy) - Empire: What Ruling the World Did to the British"
          → "Seth (Vikram) - A Suitable Boy"
          → "Tharoor (Shashi) - Inglorious Empire: What the British Did to India"
    9. Chapter 568 (Persistence69 and Time70). Focussing on:-
      1. General
        1. "Sider (Ted), Hawthorne (John) & Zimmerman (Dean), Eds. - Contemporary Debates in Metaphysics",
      2. Persistence71
        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. Time72
        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 673 (Animalism74). Focussing on:-
      1. Animals75:
        1. "Chittka (Lars) & Wilson (Catherine) - Bee-brained", Write up
        2. "Keim (Brandon) - I, cockroach", Write up
        3. "Rachlin (Howard) - Teleological behaviourism or what it means to imagine a lion", Complete Write-up
        4. "Ross (Don) - Consciousness, language, and the possibility of non-human personhood: Reflections on elephants", Write up
        5. "Woodruff (Michael) - The face of the fish", Write up
      2. Animalism76
        1. "Hershenov (David) - Review of David DeGrazia’s Human Identity and Bioethics",
        2. "Madden (Rory) - Human Persistence",
        3. "Merricks (Trenton) - Objects and Persons",
        4. "Olson (Eric) - The Human Animal - Personal Identity Without Psychology", my core text,
        5. "Shoemaker (Sydney) - Persons, Animals, and Identity",
        6. "Snowdon (Paul) - Persons, Animals, Ourselves",
      3. Hybrid Theory
        1. "Kotak (Aakash) - The Hybrid Theory of Personal Identity", Read and evaluate carefully
      4. Life77
        1. "Al-Khalili (Jim) & McFadden (Johnjoe) - Life on the Edge: The Coming of Age of Quantum Biology", Expand 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. "Rose (Steven) - Précis of 'Lifelines: Biology, Freedom, Determinism'", Read
        7. "Schrodinger (Erwin) - What is Life?"
      5. Phase-sortal Animalism
        1. "Sauchelli (Andrea) - The animal, the corpse, and the remnant-person", Read and evaluate carefully
      6. Process Animalism78
        1. "DiFrisco (James) & Mossio (Matteo) - Diachronic Identity in Complex Life Cycles: An Organizational Perspective", Read
        2. "Meincke (Anne Sophie) & Dupre (John) - Biological Identity: Why Metaphysicians and Philosophers of Biology Should Talk to One Another", Read
        3. "Meincke (Anne Sophie) - Human Persons – A Process View", Read
        4. "Meincke (Anne Sophie) - Persons as Biological Processes: A Bio-Processual Way Out of the Personal Identity Dilemma", Read
        5. "Meincke (Anne Sophie) - Processual Animalism: Towards a Scientifically Informed Theory of Personal Identity", Read
        6. "Noller (Jorg) - Beyond Animalism and Constitutionalism: The Person as A Form of Life", Read
    11. Chapter 779 (The Constitution View80):-
      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. "Van Inwagen (Peter) - Can Mereological Sums Change their Parts": Read
      7. "Van Inwagen (Peter) - Inside and outside the ontology room": Read
      8. "Zahavi (Dan) - Subjectivity and Selfhood: Investigating the First-Person Perspective": Write-up.
    12. Chapter 881 (Arguments against Animalism82):-
      1. "Bailey (Andrew M.) - The Elimination Argument",
      2. Brainstem
        1. "Olson (Eric) - The Role of the Brainstem in Personal Identity",
        2. "Tzinman (Rina) - Against the Brainstem View of the Persistence of Human Animals"
      3. Dicephalus & Conjoined Twins83
        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"
      4. "Ferner (Adam) - Metaphysics and biology: a critique of David Wiggins’ account of personal identity"
      5. "Olson (Eric) - On Parfit's View That We Are Not Human Beings",
      6. Pregnancy84
        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. "Paez (Eze) - Abortion: What We Ought to Believe - An Ontological and Normative Analysis",
        7. "Smith (Barry) & Brogaard (Berit) - Sixteen Days".
      7. "Tzinman (Rina) - Memory, Organisms and the Circle of Life".
    13. Chapter 1085 (Thought Experiments86):-
      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 Transhumanism87. 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-up88,
        7. "Contera (Sonia) - Nano Comes to Life": Read,
        8. "da Cunha (Rui Vieira) - Will I ever Be a Cyborg?": Read,
        9. "Davies (Sally) - Women’s minds matter" (and papers cited / resisted)
        10. "Francis (Matthew) - Is this life real?", Write-up
        11. "Fry (Hannah) - Hello World: How to be Human in the Age of the Machine": Read & review,
        12. "Graziano (Michael) - Endless fun": Detailed review,
        13. "Hanson (Robin) - The Age of Em: Work, Love, and Life when Robots Rule the Earth", Read
        14. "Harari (Yuval Noah) - Homo Deus: A Brief History of Tomorrow": Review, especially Chapter 8,
        15. "Kent (Adrian) - Replication Ethics": Read,
        16. "Liao (S. Matthew) - Twinning, Inorganic Replacement, and the Organism View": Read,
        17. "Kobie (Nicole) - Quantum Supremacy is here - So what?": Complete write-up,
        18. "Madary (Michael) & Metzinger (Thomas) - Real Virtuality: A Code of Ethical Conduct": Read,
        19. "Marshall (Richard) & Metzinger (Thomas) - Thomas Metzinger: All About the Ego Tunnel": Read,
        20. "Midgley (Mary) - Biotechnology and Monstrosity: Why We Should Pay Attention to the 'Yuk Factor'": Complete,
        21. "O'Connell (Mark) - To be a Machine": Briefly review,
        22. "Otsuka (Michael) - Personal Identity, Substantial Change, and the Significance of Becoming": Read,
        23. "Schneider (Susan) - Artificial You": Read,
        24. "Shipley (G.J.) - Review of Andy Clark's 'Natural-Born Cyborgs'": Complete review,
        25. "Smith (Wilfred Cantwell) - The Promise of Artificial Intelligence": Read,
        26. "Tegmark (Max) - Life 3.0: Being Human in the Age of Artificial Intelligence": Read,
        27. "Wyatt (John) - Artificial intelligence and simulated relationships": Write-up.
    14. Chapter 1189 (Resurrection90):-
      1. Death91
        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. "Van Inwagen (Peter) - Dualism and Materialism: Athens and Jerusalem?": Read & review
        7. "Veatch (Robert M.) - Would a Reasonable Person Now Accept the 1968 Harvard Brain Death Report? A Short History of Brain Death": review
      2. Makropulos Case92
        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. Reincarnation93
        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. Resurrection94
        1. "Badham (Paul) - Christian Beliefs About Life After Death": Read and review
        2. "Baker (Lynne Rudder) - Death and the Afterlife": Read and review
        3. "Corcoran (Kevin) - Dualism, Materialism and the Problem of Post Mortem Survival": Read and review
        4. "Martin (L. Michael) & Augustine (Keith) - The Myth of an Afterlife: The Case against Life After Death": Start a thorough review,
        5. "Zimmerman (Dean) - The Compatibility of Materialism and Survival: The “Falling Elevator” Model": 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 PDFs to Notes:-
        1. Review the two reports:-
          PDF-précis,
          PDF-essays95.
        2. Determine how the first is produced, and why the pdfs aren't highlighted, and compare with Write-ups Notes Jump Table
        3. Re-read & enhance recent Précis conversions, ie:-
          → "Dennett (Daniel) - True Believers: The Intentional Strategy and Why it Works"
          → "Skyrms (Brian) - The Goodman Paradox and the New Riddle of Induction"
          → "Woolhouse (Roger) - Spinoza and Substance"
        4. Convert outstanding Essays, starting with:-
          Induction96
      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. "Bregman (Rutger) - Utopia for Realists: And How We Can Get There",
        5. "Bregman (Rutger) - Why Garbagemen Should Earn More Than Bankers",
        6. "Dennett (Daniel) - The Mind's I - Fantasies and Reflections on Self and Soul: Introduction",
        7. "Erber (Joan T.) & Szuchman (Lenore T.) - Great Myths of Aging",
        8. "Everett (Daniel) - Did Homo erectus speak?",
        9. "Fine (Cordelia) - Testosterone Rex: Myths of Sex, Science, and Society",
        10. "Greene (Brian) - The Hidden Reality: Parallel Universes and the Deep Laws of the Cosmos",
        11. "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"
        12. "Hofstadter (Douglas) - Godel, Escher, Bach: an Eternal Golden Braid - A Metaphorical Fugue on Minds and Machines in the Spirit of Lewis Carroll",
        13. "Howson (Colin) & Urbach (Peter) - Scientific Reasoning: The Bayesian Approach",
        14. "Ord (Toby) - The Precipice: Existential Risk and the Future of Humanity",
        15. "Rovelli (Carlo) - Reality Is Not What It Seems: The Journey to Quantum Gravity",
        16. "Shand (John) - Central Issues of Philosophy",
        17. "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 Aeon97,
      9. Keep up with the Journals via JSTOR & Cambridge Core.
      10. Update my Journals Note98: 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. Website99 (10 hours per week)
    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. Document100, Repair & update my Website site-map
        4. Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
        5. 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 27 minutes, but should be under 5 minutes!
      • Books/Papers
        1. Change CreateBookPaperAbstractsWebPages so that - while a full re-gen uses the new method - re-gen for a particular book uses the old method (without the materialised view). This is so cmdRecalculate_Click doesn't need to be run beforehand.
        2. Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
        3. Reformat the BookCitings and PaperCitings pages:-
          1. Detail PaperCitings Pages: 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 BookCitings (copy the code: or, better, combine the two subs).
          2. Summary (Author Letter) pages: Include counts (as in Authors' Citations).
          3. Ensure uses the Cross_Reference table.
          4. Document!
      • 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 allow an updating run restricted to 'Read' Books / Papers only (useful for very long lists)
        3. 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')
        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 875101, 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 170102) are being truncated. Probably suppress them in any case, as they take far too long to load.
        7. Enhance Functors to work for selected non-temp Notes so that up-to-date stats can be incorporated. This is complex as I want to avoid production of an Archived Note each time a non-Temp Note is regenerated. I also want to ensure that Notes whose variable text consists entirely of Functors get archived correctly (which they might not if I removed Functor-generated text from Notes before saving them to the Notes table).
        8. Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
        9. Investigate Note_Links: Section references seem to be incorrect
        10. Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
        11. Split Aeon Page103 into multiple sub-pages (either by topic or by priority)
        12. Suppress the publication of the Printable versions of Temp Notes
        13. Upgrade Auto_Reference_Notes to reference Sub-Notes: Currently only affects one note - Somerset Maugham - so not yet urgent
        14. Upgrade Auto_Reference_Notes to save Notes_To_Regen to a new table prior to the run, add new rows to this table, and copy it back after the run. Finally, allow the option of regenerating these Notes. In the interim, use Notes_To_Regen to create Note 874104, then clear it before the copy-back.
        15. Upgraded Auto_Reference_Notes to log its actions to a new table (Auto_Reference_Notes_Actions) so that any errors can be investigated and improvements made.
      • Papers
        1. The monthly regeneration process for Paper Abstracts was still takeing just over 5 hours. Problem is with Cross_Reference_Deletions and Cross_Reference_Additions. I thought it could not be fixed until the cross-referencing project is fully complete and documented. However, it spontaneously improved to 1.6 hours in the August 2020 run. Monitor!
      • 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 pages105 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.
      • Technology
        1. Look into Sistrix Smart106. 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. Webrefs_Update failing because IE loops with Aeon / Psyche pages. Currently doing manual checking - try to find an automated solution.
        2. 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.
        3. Find a way of recording Missing Webrefs other than debug.print: create table, then suppress message for known problems
        4. Investigate items flagged as defunct. Populate Defunct_Explanation in WebRefs_Table. Consider use of FairUse (Link - Fair Use) for documents no longer available that I'd downloaded.
        5. Investigate WebRefs with Issue = 'URL Translated OK': does the translation really work? How?
    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.
  3. Religion107 (2 hours per week)
    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. "Howard-Snyder (Daniel) - The Skeptical Christian": Read,
      4. "Howard-Snyder (Daniel) - Does Faith Entail Belief": Read,
      5. "Insole (Christopher J.) - Realism and Anti-Realism": Read,
      6. "Plantinga (Alvin) & Dennett (Daniel) - Science and Religion: Are They Compatible?": Read.
    2. Resurrection: Continue reviewing108
      1. "Alter (Michael J.) - The Resurrection: A Critical Inquiry", and
      2. "Alter (Michael J.) - The Resurrection & Christian Apologetics: A Critical Inquiry Volume 2".
    3. Essays:
      1. "Todman (Theo) - Philosophy of Religion Essay 1: Can God's necessity establish the existence of God?", Review - what's the latest version?
    4. 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. "Thomson (Oliver) - A History of Sin": Continue reading
      7. "Taylor (Joan E.) - Jesus and Brian: Exploring the Historical Jesus and His Times Via Monty Python's Life of Brian": Review KCL Conference videos
  4. Music109 (7 hours per week)
    1. Oboe:-
      1. Practice the oboe for two 30-minute sessions each and every day110 – 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 & arpeggios111 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 particular112
        → "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 particular113
        → "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 through114 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 material115, and
        → Try out "Earmaster - Ear Training & Sight-singing".
      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. Languages116 (5 hours per week)
    1. Armenian: For fun ...
      → "Ling - Learn Armenian"
      → "Andonian (Hagop) - Beginner's Armenian"
    2. Hindi: For fun ...
      → "Ling - Learn Hindi"
      → "Snell (Rupert) - Beginner's Hindi Script"
    3. 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", and
      → "Becker (Benjawan Poomsan) - Thai for Beginners",
    4. Turkish: For fun ...
      → "Ling - Learn Turkish"
      → "Celen-Pollard (Asuman) & Pollard (David) - Turkish (Teach Yourself Complete Courses)"
  6. Consciousness117 (1 hour per week)
    1. Aeon118: 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
      → "Seth (Anil Kumar) - The real problem": Read & write-up
      → "Seth (Anil Kumar) - How we build perception from the inside out": 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
  7. Bridge119 (2 hours per week)
    1. Bridge "at the table" is on hold. Only play on-line if pressurised by clubs or partners.
    2. Review hands from National Masters Pairs in March 2020.
    3. Investigate RealBridge (https://realbridge.online/).
    4. Bridge Admin: Committee and Website involvement for Mountnessing and Hutton.
    5. Re-read Hand-counting papers, focussing on
      → Papers in Counting the Hands120,
      → "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".
  8. Chess121 (1 hour per week)
    1. Why Play Chess:
      → Seriously consider the issues raised by "Ramon y Cajal (Santiago) - On Chess".
      → Counter this with responsibiity to the local chess scene now I've made contact
    2. Chess Study:-
      → "Gufeld (Eduard) - The Sicilian for the Tournament Player",
      → "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 & occasional 10-minute game),
      Investigate122 LiChess.org (https://lichess.org/)
      → "Chess - Chess - YouTube Videos",
      → Complete review of 2018/19 season's games,
      → Complete review of 2019/20 season's games.
    4. Club Play & Participation:
      1. Over-the-Boad Play: Participation123 if and when play resumes in Billericay Chess Club:-
        → Club Nights
        → NECL matches
        → Southend League matches
      2. Attend weekly Billericay Virtual Chess Club (https://lichess.org/team/billericay-virtual-chess-club) (using Discord (https://discord.com/channels/693153803276517397/693153803276517401))
  9. Mathematics124 (1 hour per week)
    1. Aeon125: Read papers as they arise.
    2. "Gowers (Timothy), Barrow-Green (June) & Leader (Imre), Eds. - The Princeton Companion to Mathematics": Browse.
    3. "Polya (George), Stewart (Ian) - How to Solve IT: A New Aspect of Mathematical Method": Read.
    4. 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".
    5. "Shapiro (Stewart) - Thinking about Mathematics - The Philosophy of Mathematics": Complete reading.
    6. "Smith (Martin) - Why Throwing 92 Heads in a Row Is Not Surprising": Analyze.
    7. "Wilmott (Paul) - Machine Learning: An Applied Mathematics Introduction": Read.
  10. HiQ126 (1 hour per week)
    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 46, 58: Footnote 56:
  • This paper covers the 'Loose and Popular' vs 'Strict and Philosophical' senses of identity, amongst much else.
Footnote 59: Footnotes 64, 67:
  • This list will hopefully diminish over time, as I read the works, so will no longer look balanced.
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 88:
  • Also look through other works by Andy Clark to get a handle on what he means by 'patterns in information space'.
Footnote 105:
  • 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 106:
  • See Sistrix (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Optimizr - Defunct (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 108:
  • 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 110:
  • Well, maybe with the occasional holiday, and excluding days on which I have a lesson or the Enigma Ensemble (currently in hibernation).
Footnote 111:
  • 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 112:
  • I've yet to decide which to present for the Exam, so this long list will get whittled down in due course.
Footnote 113:
  • 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 114:
  • The earlier grades are very elementary, but I need practice writing musical notation.
Footnote 115: Ie. The following:- Footnote 122:
  • And consider migrating from Chess.com (https://www.chess.com/), though I renewed my membership at the end of August 2020, but downgraded from Diamond, costing about £80, to Gold, costing about £24.
Footnote 123:
  • This used to say "full participation", but I've let the team captain know that my 'mind games' focus is 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.


Note last updated: 04/10/2020 00:27:22


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

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 July - September 2020
  1. I spent 385.25 hours in 20Q3 on this Project, or related work (1181.25 hours YTD, where for "YTD" - Year to Date - I mean the (academic) year that commenced in October 2019). That's 134.3% of the planned effort (103% YTD). Overall, 55.3% of my Project effort in the Quarter was directed towards this project (making 42.4% YTD) - as against 40.7% planned (38.8% YTD).
  2. I worked hard and achieved over a third more than my quarterly time budget, and over-achieved my annual budget for the first time ever.
  3. The main success of the quarter was to get all my Notes on Personal Identity up to the standard format, selectively revising the text and generating the Link Pages for each. I also started doing “updating runs” for these and using the findings to update the reading lists.
  4. I’ve got a bit behind on reading Aeon, but at the expense of “real work” on my Thesis.
  5. There was probably too much effort focused on Race, but this is an important topic given current tensions in society.
  6. Progress between reports can be obtained from the relevant section of my Summary Task List.
  7. A full list of items worked on in the quarter appears below.
Thesis (Total Hours = 253.75)
  1. Thesis - Reading / Writing (Total Hours = 242.25)
  2. Thesis - Discussions (Total Hours = 3)
  3. Thesis - Research Repositioning (Total Hours = 8.5)
Thesis Background (Total Hours = 90.75)
  1. Thesis Background - Reading / Writing (Total Hours = 85)
  2. Thesis Background - Books Admin (Total Hours = 4.25)
  3. Thesis Background - Status
Thesis (Aeon) (Total Hours = 40.75)
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 9:
  • 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 10:
  • 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 12:
  • 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 14:
  • This is obviously far too long, and keeps getting items “carried forward” tacked on to it.
  • Maybe I’ll prune it next time.
Footnote 34: Footnote 44:
  • This paper covers the 'Loose and Popular' vs 'Strict and Philosophical' senses of identity, amongst much else.
Footnote 46: Footnote 47: Footnote 52:
  • This list will hopefully diminish over time, as I read the works, so will no longer look balanced.
Footnote 53:
  • 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 55:
  • This list will hopefully diminish over time, as I read the works, so will no longer look balanced.
Footnote 76:
  • Also look through other works by Andy Clark to get a handle on what he means by 'patterns in information space'.

Note last updated: 04/10/2020 00:27:22


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

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: 01/11/2020 09:54:43


Footnote 2.8: (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 me23 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 23:

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


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

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 (https://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 website12 for displaying the textual and grammatical analyses and appendices of Pete’s PhD on the Acts of the Apostles: Acts: Test Site (http://www.theotodman.com/Petes_PhD/index.htm).

Summary of Progress during July - September 2020
  1. I spent 143.75 hours in 20Q3 on this Project, or related work (476.25 hours YTD, where for "YTD" - Year to Date - I mean the (academic) year that commenced in October 2019). That's 110.3% of the planned effort (114.2% YTD). Overall, 20.6% of my Project effort in the Quarter was directed towards this project (making 17.1% YTD) - as against 18.5% planned (14.1% YTD).
  2. In 20Q3 I made quite a lot of further progress over a wide area of highly relevant items, as listed below, with a particular emphasis on Auto_Reference_Notes.
  3. Consequently, I overspent my time budget by 10%. Time well spent, though.
  4. Completed items included:-
    1. Own Website:
      • Architecture
        1. Created Cross_Reference_Changes_Prune to keep Cross_Reference_Changes under control pending completion of the Xref project.
      • Books
        1. BookCitings references not sequenced correctly. Corrected.
        2. BooksToNotes Link Pages: Re-engineered - used CreatePapersToNotesWebPages to generate pages
      • Books/Papers
        1. As revealed by Spider: BooksToNotes and PapersToNotes links failing (45 items). Pages not being regenerated due to wrong joins in Book_Note_Link_List and Paper_Note_Link_List.
        2. CreateBookPaperAbstractsWebPages not translating +RR+ References for Notes Write-ups of associated Papers
      • Notes
        1. Added option in Auto_Reference_Notes to only confirm new items (leaving previously-flagged items untouched)
        2. Added Aeon Abstract (ie. Footnote) link to Aeon Webref items in Summary task List reports for 'read' items
        3. Determined why the run of Auto_Reference_Notes_Regen took 2.5 hours on 02/09/2020 (and climbing). It was down to the Aeon Note being searched; in particular Check_If_In_Container, checking for items in Footnotes and / or Quoted Text. As this Note is regenerated, there's no point auto-linking it. Time reduced to 23 minutes once this Note - and other Notes of inappropriate Note Groups - was removed.
        4. Corrected Issues with Nested Functors: Added Functor_ID to End-tag
        5. Added option in Auto_Reference_Notes to - for Live (ie. not TEMP) Notes - update the latest Archived Note to equal the updated Live Note, hence avoiding superfluous archives.
        6. Upgraded Auto_Reference_Notes to avoid key-words within +AA+-style Authors names (using Check_If_In_Container).
        7. Upgraded Auto_Reference_Notes to allow a parameterised 'termination or continue' for very long update runs
      • Papers
        1. PaperstoNotes Link Pages: Re-engineered and corrected CreatePapersToNotesWebPages pages
      • Process
        1. Determined why Recalculation (cmdRecalculate_Click) took so long: it varied depending on how many Notes were regenerated, but seemed to be 17.5 minutes even if there are none. I think it was down to a problem with nested Functors leading to Notes growing inordinately: in particular the development logs. Now takes around 5 minutes.
      • Spider
        1. The size of the main database was bloating to over 1.5Gb during the spider run, so was approaching the 2Gb limit.
          1. Used Check_Database_Size, with a parameter, to monitor the size of the main database and added a message similar to those reporting the compact / repair of the Slave database each time a status message is printed.
          2. Based on the diagnostics produced, it was found that the bloating occured at two stages:-
            → In Spider_Scurry: during the creation of Raw_Links_Temp_Temp.
            → In Spider_Copy: during the creation of Raw_Links_Temp.
          3. Fixes:-
            → Put check in Check_Database_Size to STOP if the database is over 1.5 Gb (parameterised via Max_Database_Size).
            → Moved Raw_Links_Temp_Temp to the Slave database.
        2. System Resources Exceeded - "Run Time Error 3035"; query Full_Link_Same_Directory_Updt in Spider_Copy. Fixed by using SQL rather than a query.
      • Status
        1. Quarterly Project Reports: Corrected Functor_08. The Project Planned YTD % kept having to be bodged!
        2. Added Weekly Project Plans to Priority Task List
        3. Created web-page (using Functor_21) showing oboe practice hours by work played
      • WebRefs
        1. Reformated WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm: The 'As Above" lines waste space. Consolidate onto single second line.
        2. Reformated WebLinks_Tester_Brief, WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm: Allowed more space for 'link returned', 'issue' and 'display text' and added Explanation column
        3. Improved WebRefs checker (Webrefs_Update) further to check for Error 403 "Forbidden". This involved finding way of checking pdfs where the returned page is in fact HTML or XML (see DevLog Ref 379).
    2. Other Websites:
      • Nothing to Report.
  5. Full details for 20Q3 are given below14:-
Website (Total Hours = 140.75)
  1. Website - Development (Total Hours = 108.75)
    • Todman (Theo) - Tottering Towers & Listing Buildings: Incorporate RICS involvement (1.25 hours)
      → See "Todman (Theo) - Tottering Towers & Listing Buildings" (1.25 hours)
    • Website - Generator - Page for Oboe practice details (2.75 hours)
    • Website - Generator - CreateBookPaperAbstractsWebPages not translating +RR+ References for Notes Write-ups of associated Papers (0.25 hours)
    • Website - Generator - Regen_Note_Links failing for Note 1170 (1.25 hours)
    • Website - Generator - Webrefs_Update failing because IE loops with Aeon / Psyche pages (3.25 hours)
    • Website - Generator - Add Aeon Abstract link to Aeon Webref items in Summary task List reports (1 hour)
    • Website - Generator - Add Weekly Project Plans to Priority Task List (0.75 hours)
    • Website - Generator - As revealed by Spider: BooksToNotes and PapersToNotes links failing (1 hour)
    • Website - Generator - Auto-Reference Notes - Review & Update Documentation & Processing (28.5 hours)
    • Website - Generator - BookCitings references not sequenced correctly (1 hour)
    • Website - Generator - Correct Functor_08. The Project Planned YTD % keeps having to be bodged! (1 hour)
    • Website - Generator - Correct Paper_Note_Link_List_New for CreatePapersToNotesWebPages pages (12.5 hours)
    • Website - Generator - Correct WebRef page links from WebLinks_Test pages (add 'Off-Page_Link_') (0.5 hours)
    • Website - Generator - Document Auto-Referencing Notes (7.5 hours)
    • Website - Generator - Document Cross-Referencing (4 hours)
    • Website - Generator - Document Cross-Referencing: Create Cross_Reference_Changes_Prune (1 hour)
    • Website - Generator - Document Spider (0.25 hours)
    • Website - Generator - Highlight Archived Notes as not the latest (0.5 hours)
    • Website - Generator - Improve WebLinks Tester suite of pages (17.5 hours)
    • Website - Generator - Investigate & Fix WebRefs_Update checker for 404 check not working (6 hours)
    • Website - Generator - Issues with Nested Functors (3.5 hours)
    • Website - Generator - Revise Cross-Referencing Documentation (1.25 hours)
    • Website - Generator - Site Map: Document and update (0.25 hours)
    • Website - Generator - Spider - Monitor performance & Main database size (4.75 hours)
    • Website - Generator - Spider - System Resources Exceeded - "Run Time Error 3035"; query "Full_Link_Same_Directory_Updt" (1.5 hours)
    • Website - Generator - Update Development Log in the light of recent activities (3.25 hours)
    • Website - Generator - Wrote ZapFiles - to clear out WebLinks Tester, Documentation and other page-sets prior to regeneration (2.5 hours)
      → See "Software Development - Website - Development" (107.5 hours)
  2. Website - Education (Total Hours = 3)
  3. Website - Infrastructure (Total Hours = 9.25)
    • Buy & Commission replacement iPhone protective case (0.25 hours)
    • Buy & Commission replacement Mouse (0.75 hours)
    • EE Broadband - Router & Line Issues (4 hours)
    • Microsoft Windows 10 / MS Office - Releases, Bugs & Periodic Re-boots (2.25 hours)
    • PC Backups / OneDrive (0.75 hours)
    • Printer - Problems with USB Drivers (0.25 hours)
    • Try out old TV as Monitor (1 hour)
      → See "Admin - Website - Admin & Maintenance" (9.25 hours)
  4. Website - Maintenance (Total Hours = 19.75)
    • 20Q2 Status Reports (2.75 hours)
    • Website - Generator - WebRefs - Manual / Automatic URL Checks & Fixes (11 hours)
    • Website - Periodic Full Regeneration (3.5 hours)
    • Website - Run Web Spider (2.5 hours)
      → See "Admin - Website - Admin & Maintenance" (19.75 hours)
Website Others (Total Hours = 3)
  1. Website Others - Hutton DBC Maintenance
  2. 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 maintained the weekly allocation at 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. Document, Repair & update my Website site-map
      4. Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
      5. 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 27 minutes, but should be under 5 minutes!
    • Books/Papers
      1. Change CreateBookPaperAbstractsWebPages so that - while a full re-gen uses the new method - re-gen for a particular book uses the old method (without the materialised view). This is so cmdRecalculate_Click doesn't need to be run beforehand.
      2. Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
      3. Reformat the BookCitings and PaperCitings pages:-
        1. Detail PaperCitings Pages: 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 BookCitings (copy the code: or, better, combine the two subs).
        2. Summary (Author Letter) pages: Include counts (as in Authors' Citations).
        3. Ensure uses the Cross_Reference table.
        4. Document!
    • 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 allow an updating run restricted to 'Read' Books / Papers only (useful for very long lists)
      3. 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')
      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. Enhance Functors to work for selected non-temp Notes so that up-to-date stats can be incorporated. This is complex as I want to avoid production of an Archived Note each time a non-Temp Note is regenerated. I also want to ensure that Notes whose variable text consists entirely of Functors get archived correctly (which they might not if I removed Functor-generated text from Notes before saving them to the Notes table).
      8. Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
      9. Investigate Note_Links: Section references seem to be incorrect
      10. Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
      11. Split Aeon Page into multiple sub-pages (either by topic or by priority)
      12. Suppress the publication of the Printable versions of Temp Notes
      13. Upgrade Auto_Reference_Notes to reference Sub-Notes: Currently only affects one note - Somerset Maugham - so not yet urgent
      14. Upgrade Auto_Reference_Notes to save Notes_To_Regen to a new table prior to the run, add new rows to this table, and copy it back after the run. Finally, allow the option of regenerating these Notes. In the interim, use Notes_To_Regen to create Note 874, then clear it before the copy-back.
      15. Upgraded Auto_Reference_Notes to log its actions to a new table (Auto_Reference_Notes_Actions) so that any errors can be investigated and improvements made.
    • Papers
      1. The monthly regeneration process for Paper Abstracts was still takeing just over 5 hours. Problem is with Cross_Reference_Deletions and Cross_Reference_Additions. I thought it could not be fixed until the cross-referencing project is fully complete and documented. However, it spontaneously improved to 1.6 hours in the August 2020 run. Monitor!
    • 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 pages24 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.
    • Technology
      1. Look into Sistrix Smart25. 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. Webrefs_Update failing because IE loops with Aeon / Psyche pages. Currently doing manual checking - try to find an automated solution.
      2. 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.
      3. Find a way of recording Missing Webrefs other than debug.print: create table, then suppress message for known problems
      4. Investigate items flagged as defunct. Populate Defunct_Explanation in WebRefs_Table. Consider use of FairUse (Link - Fair Use) for documents no longer available that I'd downloaded.
      5. Investigate WebRefs with Issue = 'URL Translated OK': does the translation really work? How?
  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 Date26.
  2. Outstanding Developments27,
  3. Functional Documentation28,
  4. A summary of time expended across the years developing my website29 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 12:
  • It used to exist in two versions, live and test.
  • Pete decided not to renew the license for the live site, now it has achieved its purpose, so only the test site remains.
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 24:
  • 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 25:
  • See Sistrix (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Optimizr - Defunct (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 29:
  • As distinct from developing other peoples’ websites – time which is also recorded against this project, but not against this task.

Note last updated: 04/10/2020 00:27:22


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.26: (Website - Progress to Date (2020 - November))

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:-
  • 20Q4
    1. Books/Papers:
    2. Notes:
    3. Spider:
      • System Resources Exceeded - "Run Time Error 3035" - re-emerged in Full_Link_Same_Directory_Gen. Last month I had replaced query Full_Link_Same_Directory_Updt with identical SQL, which had worked OK. This time I removed the "WHERE" statements and put them in the code itself. Seems fine.
    4. Status:
      • Website - Outstanding Developments: Group items in the same period / category together, as in Status: Priority Task List. Ie.
        1. Functor_03 - Completed Items - Priority Sequence
        2. Functor_04 - Outstanding Items - Category Sequence
      • Website - Progress to Date: Group items in the same period / category together, as in Status: Priority Task List. Ie.
        1. Functor_02 - Completed Items - Date Sequence
        2. Functor_05 - Completed Items - Category Sequence
  • 20Q3
    1. Architecture:
    2. Books:
      • BookCitings references not sequenced correctly. Corrected.
      • BooksToNotes Link Pages: Re-engineered - used CreatePapersToNotesWebPages to generate pages
    3. Books/Papers:
    4. Notes:
      • Highlighted Archived Notes clearly as not the latest
      • Added Aeon Abstract (ie. Footnote) link to Aeon Webref items in Summary task List reports for 'read' items
      • Added option in Auto_Reference_Notes to only confirm new items (leaving previously-flagged items untouched)
      • Upgraded Auto_Reference_Notes to allow a parameterised 'termination or continue' for very long update runs
      • Upgraded Auto_Reference_Notes to avoid key-words within +AA+-style Authors names (using Check_If_In_Container).
      • Determined why the run of Auto_Reference_Notes_Regen took 2.5 hours on 02/09/2020 (and climbing). It was down to the Aeon Note being searched; in particular Check_If_In_Container, checking for items in Footnotes and / or Quoted Text. As this Note is regenerated, there's no point auto-linking it. Time reduced to 23 minutes once this Note - and other Notes of inappropriate Note Groups - was removed.
      • Corrected Issues with Nested Functors: Added Functor_ID to End-tag
      • Added option in Auto_Reference_Notes to - for Live (ie. not TEMP) Notes - update the latest Archived Note to equal the updated Live Note, hence avoiding superfluous archives.
      • Upgraded Auto_Reference_Notes to log its actions to a new table (Auto_Reference_Notes_Actions) so that any errors can be investigated and improvements made.
    5. Papers:
    6. Process:
      • Determined why Recalculation (cmdRecalculate_Click) took so long: it varied depending on how many Notes were regenerated, but seemed to be 17.5 minutes even if there are none. I think it was down to a problem with nested Functors leading to Notes growing inordinately: in particular the development logs. Now takes around 5 minutes.
    7. Spider:
      • The size of the main database was bloating to over 1.5Gb during the spider run, so was approaching the 2Gb limit.
        1. Used Check_Database_Size, with a parameter, to monitor the size of the main database and added a message similar to those reporting the compact / repair of the Slave database each time a status message is printed.
        2. Based on the diagnostics produced, it was found that the bloating occured at two stages:-
          → In Spider_Scurry: during the creation of Raw_Links_Temp_Temp.
          → In Spider_Copy: during the creation of Raw_Links_Temp.
        3. Fixes:-
          → Put check in Check_Database_Size to STOP if the database is over 1.5 Gb (parameterised via Max_Database_Size).
          → Moved Raw_Links_Temp_Temp to the Slave database.
      • System Resources Exceeded - "Run Time Error 3035"; query Full_Link_Same_Directory_Updt in Full_Link_Same_Directory_Gen. Fixed by using SQL rather than a query.
    8. Status:
      • Quarterly Project Reports: Corrected Functor_08. The Project Planned YTD % kept having to be bodged!
      • Added Weekly Project Plans to Priority Task List
      • Created web-page (using Functor_21) showing oboe practice hours by work played
    9. WebRefs:
      • Reformated WebLinks_Tester_Brief, WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm: Allowed more space for 'link returned', 'issue' and 'display text' and added Explanation column
      • Reformated WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm: The 'As Above" lines waste space. Consolidate onto single second line.
      • Improved WebRefs checker (Webrefs_Update) further to check for Error 403 "Forbidden". This involved finding way of checking pdfs where the returned page is in fact HTML or XML (see DevLog Ref 379).
  • 20Q2
    1. 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.
      • 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. 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.
      • 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.
      • 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. 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.
    4. 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.
    5. 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.
    6. Notes:
      • As revealed by Spider: Sundry uncategorised. Refs failing. 30 items. Fixed manually.
    7. 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!
      • 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.
    8. 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.
      • Corrective work was split out into the items requiring improvement, must of which have now been implemented.
      • 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.
      • 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.
    9. WebRefs:
      • Amended WebRef 'Name' links to #Off-Page_Link_WxxxW style so referencing from other pages is possible (useful for Aeon)
      • WebLinks_Tester_Full & WebLinks_Tester_Full_Map: Reformated Jump Table to 30 columns and multiple rows.
      • Amend WebRef 'Name' link to #Off-Page_Link_WxxxW style. Also amend Quarterly and Annual task lists to use this reference.
      • 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.
      • 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.
      • As revealed by Spider: WebLinks_Tester_Full_Map.htm (etc). Refs failing. 184 items. res://ieframe.dll/ in Returned_URL.
  • 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.
      • Restrict jump-table at top of Authors pages to relevant items, and include the item counts.
    3. Bridge:
      • As revealed by Spider: Bridge_Code_Archive.htm (14 items) & Bridge_Code_Archive_Recent.htm (5 items)
    4. Notes:
      • As revealed by Spider: Blackberry links from archived Note 1010 (Maintenance Dashboard). 38 items.
      • Solve the problem of the size limitation for Notes by allowing their concatenation.
      • As revealed by Spider: Old links from Archive Notes to (non-existent) Archived Printable Notes. 42 items.
      • As revealed by Spider: Blog Achived Notes - sundry links to Printable Notes. Live Note OK. 97 items.
      • As revealed by Spider: #Reference links: fail for Printable Notes. 24 items.
    5. Papers:
      • Make use of Comments for large Abstracts seamless by appending Comments (if > 5k) to Abstracts.
    6. WebRefs:
      • As revealed by Spider: WebLinks_Tester_Map_3.htm (etc). Refs failing. 51 items outstanding. res://ieframe.dll/ in Returned_URL.
      • As revealed by Spider: WebLinks_Tester_4.htm. Refs failing. 32 items. res://ieframe.dll/ in Returned_URL.
      • 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.
      • As revealed by Spider: WebLinks_Tester_Brief_12.htm (etc). Refs failing. 41 items. res://ieframe.dll/ in Returned_URL.
  • 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.
      • Fix Functors to enable previous quarter's Status Reports after Time period roll-over
  • 19Q3
    1. 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:
        • Synchronise Documentator with main website generator
        • NGS Refinements
        • Add Mountnessing archive links to Results
      4. Infrastructure:
        • PDFelement: Purchase & Commission upgrade from Version 5 to Version 7 for $39 - await new Laptop
        • Purchase & Commission new Lenovo Laptop: awaiting replacement following motherboard failure!
      5. WebRefs:
        • As revealed by Spider: Hits_Pages_Total_Crosstab_Descending.htm.
    2. Other Websites
      1. Sophie:
        • Dismantle my old version of Sophie Botros (https://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
      • Created Timeline software
      • Created Photo-logging usage via Images table.
    3. Technology:
      • Investigated the Hit Stats provided by Webalizer and produced web-pages to show the most active pages.
  • 18Q4
    1. 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: 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.
        • As revealed by Spider: Sundry links failed for Supervisions. 30 items.
        • 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.
        • 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!
        • As revealed by Spider: Links from Blog in Level 1 or 2 Printed Notes 512 and 981 failing. 141 items.
        • Create Priority Task List Report.
      4. Process:
        • Added 'time to regenerate' sub-totals & grand-totals to Website Maintenance Dashboard.
      5. Spider:
        • Determined why Full_Link_Up_Levels_Gen takes so long - approximately 4 hours. Re-architected to reduce database reads.
      6. Status:
        • Links occasionally missing from Summary Task List and Summary Task List (YTD).
      7. WebRefs:
        • Added Display text to WebRefs for Links to Stanford, Wikipedia & Aeon
    2. 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.
      • Authors Narrative: enable footnotes.
    3. Books:
      • As revealed by Spider: BookCitings. 405 items. Fixed problem with CreateBookCitingsWebPages not checking for change of Book during 'Repeats' processing.
    4. Books/Papers:
      • Paper & Book Abstracts - Make 'Disclaimer' more prominent & show 'Paper Statistics' rather than 'Paper Summaries'
    5. Bridge:
      • Reformated + Fixed Hand-dealing pages to CSS standards
    6. Documenter:
      • Created Functor using Form_Documentation_Links to automatically add control-links to documentation Notes.
      • 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.
    7. Footnotes:
    8. Notes:
      • Created auto-regen of all Note Link (Note_nnn_Link) Pages
      • As revealed by Spider: Notes_List_Control links fail for Supervisions. 58 items.
      • Created new '+LL+' Functor for links to Note_Link pages; fixed associated 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.
      • As revealed by Spider: Religion Status Report Achived Notes - sundry links failing. Live Note OK. 59 items.
      • Blog: Created Functor to generate Blog from Blog.
      • As revealed by Spider: Languages Status Report Achived Notes - links to Dissertation failing. Live Note OK. 43 items.
      • As revealed by Spider: Bridge Status Report Achived Notes - sundry links failing. Live Note OK. 70 items.
      • 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.
    9. Photos:
    10. 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:
      • 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.
      • Added a process to 'fix' - by adding the Note-ID - those note-links added without stating the ID. This will save processing time.
    5. 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.
    6. Process:
      • Re-engineered Website Maintenance Dashboard to show extra topical links (and show them at the top of the page).
    7. 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.
    8. 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
      • Documenter Bug-fixes: Objects in Comments, MsgBoxs & Debugs
    3. Infrastructure:
      • Migration of Website from UKServers to Namesco. Test out.
    4. Notes:
      • Notes Functor42 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
      • Extended deduction of Note links to Papers, and Papers with embedded Notes.
      • Removed old "Printable Notes" links from Archived Notes
      • Automated format-change of old tables in Notes and Notes_Archive
    5. Papers:
      • Correction of narratives on Note time-recording pseudo-papers
    6. Process:
      • Wrote a routine to update a set of .htm files, replacing text in them all
      • Improved efficiency of daily changes regeneration (removed msgboxes)
    7. Status:
      • Created web-page generator for Development items (ie. Created the Web-Project "To Do" List and "Outstanding Developments" directly from this list).
    8. 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)
      • Determined & reported usage directly using embedded +WnnnW+ encoding rather than via the Spider. Reconciled the two methods.
  • 17Q4
    1. Architecture:
      • Automated links between Quarterly reports (Task Lists)
    2. Books/Papers:
      • New "Recent Acquisitions" Book List - Uncategorised
    3. Documenter:
      • Code Archive: Created Web-pages of Recent Code Changes
      • Code Archive: Hadn't been working - fixed and recovered a selection from backups
    4. 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.
      • Added %age complete to Notes Reading Lists
    5. 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:
      • Created Master Point Lists & Promotions for the ECBA website.
      • Added new features (70s Club & Monthly Pairs Winners) to my Bridge mini-websites.
  • 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:
  • 16Q2
    1. Clock:
      • Created a "chess clock" application to help time tasks. Not much use in the end.
  • 16Q1
    1. 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 words49. This is such a useful feature!
        • Completed converting “static” pages to Notes.
        • Enabled direct links to Notes from within Footnotes.
        • Stopped (I hope!) “private” Notes showing in Paper Abstracts.
      4. WebRefs:
        • Some tidying up of the 3,000-odd external links from my website.
    2. Other Websites
      1. Bridge:
        • Created Ladies’ and Gentlemen’s ladders for my mini-websites.
        • Reconciled my X-IMP calculations with a new feature provided by Bridgewebs.
        • Accommodated Alaric’s new scoring system for St. Edith’s.
  • 15Q4
    1. 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
        • Corrected author's names (SN (FN)) for all papers and books
      4. Backups:
        • Enhanced my backup system to prune items backed up multiple times (eg. if they moved directory).
      5. Books/Papers:
        • Updated booklists to include shelf-identifiers
        • Neatened up the linkage headers in Book & Paper Abstracts.
      6. Data:
        • Corrected data content on Identity Sub-topics
      7. Documenter:
        • Segregated the code-archive, which was bloating50 the generator database.
      8. Notes:
        • Fixed problem of images not appearing in "Printed" Notes (wrong directory level) unless the images are repeated
        • Converted the “static” pages in my website to Note format (so they can change and retain history).
      9. Process:
        • Created a consolidated processor to enable overnight regeneration of the whole website.
      10. 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.
    2. 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
    1. 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.
    2. Other Websites
      1. Bridge:
        • Created a new website (using Bridgewebs) for the First Class Bridge Academy (First Class Bridge (https://www.bridgewebs.com/firstclassbridge/)).
        • Ported my “handicap / improvers” routines from Hutton to “Mini Websites”.
      2. Enigma:
        • Created a small website for a music group Julie and I attend – the Enigma Ensemble (http://www.enigmaensemble.co.uk/).
      3. Sophie:
  • 15Q2
    1. Bridge:
      • Development of the “Eve Goblets” (victor ludorum) software for the ECBA, and roll-over to the new season.
  • 15Q1
    1. 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.
    2. 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).
        • Further improvements to my Butler-IMPs and Cross-IMPs calculation routines.
        • Took on the ECBA Website (ECBA Website - Defunct), at the cost of considerable effort by way of reformatting & tidy-up.
  • 14Q4
    1. 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).
    2. 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
    1. Own Website
      1. Notes:
        • Created a progress-tracker for my Thesis.
        • Improved error-recovery where encoding fails for Notes links.
        • Started to split Paper Abstracts from Write-ups.
      2. Spider:
        • Continued working on my Spider and started to use it to clean up my website by diagnosing broken links.
    2. 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.
      • 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
      • Made enhancements to "Books & Papers Collection Categorised" Pages
    3. Notes:
      • "Single Image" development for Notes
      • Simplified / Re-engineered Notes processing
      • Allowed "Authors Works Lists" to be linked-to from Notes
      • Created Archived Notes Re-Export facility
    4. Status:
      • Re-engineered Monthly Reporting on Change of Year
    5. Technology:
      • Converted Tables to CSS3 standard
      • Used CSS in all manually-crafted and automatically-generated pages
    6. 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
    1. Own Website
      1. Architecture:
        • Improved error-recovery where encoding fails for links to Books, Papers and Authors. That is, where one of my bespoke tags (eg. +B53) doesn’t match with its corresponding anti-tag (eg. B+).
        • Replaced macros with code.
      2. Books/Papers:
        • Developed "Books by Location" Pages
        • Improved the linkage between Papers and Books.
      3. Bridge:
        • Created “Consolidated Bridge Results” webpages (for my own results).
      4. Documenter:
        • Wrote the Code Documenter.
        • Created a code & query archive facility as part of the Code Documenter.
      5. Notes:
        • Improved "Concatenated Notes" production
      6. Photos:
        • Reduced the size of photos (to make the pages quicker to load).
      7. Spider:
        • De-bugged the Spider.
      8. Status:
        • Improved "This Month's Summary" Reporting
        • Improved Quarterly Reporting
      9. WebRefs:
        • Some pages render oddly in Chrome (and maybe other browsers) – investigated54.
    2. Other Websites
      1. Bridge:
        • Merged55 Philosophy & Bridge Databases
  • 13Q1
    1. Status:
      • Re-engineered Monthly Reporting Tables & improved Monthly Reporting
    2. Technology:
  • 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
      • Created Inter-Book-Paper Citings Cross-reference
  • 10Q3
    1. Notes:
      • Wrote routines to automatically generate the “Printable Notes” footer – and to create the corresponding web pages – from the control table. Very useful.
      • Investigate Note_Links: needs versioning, and section of calling Note
      • Add “Date Created” to Note_Links (for audit purposes; I’m still not convinced that links disappear when they should).
    2. 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.
      • Completed a full 2-way link from Book/Paper Summaries to Notes.
    2. Notes:
      • Enabled automatic immediate promotion to Live Website of selected Temp 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.
      • Ensured that the Notes Reading-list is generated from all 3 sub-topics.
      • 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.
      • 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).
    3. 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:
      • Added "quality marker" to Paper & Book Abstracts
      • De-duplicated Books / Papers to Notes links
      • Improved, and corrected errors in, the Blackberry-friendly formatted lists of Books and Papers.
    3. 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:
      • Enhanced Books to Papers links to include papers multiply held
      • Enabled links from Books to the Papers contained therein
      • Provided an automated link from Books / Papers to the Notes referencing them
      • Created automatic links from Paper Summary to Book Summary
      • Improved the Books / Papers to Notes links to include the right Version and Section (and historical Title) of the Note
    2. Notes:
      • Added reading-list (of works cited) at the end of the Note, as well as in the Printed Note
      • Option for Notes-Regen:
        1. Changed-only
        2. Changed, and all impacted by Change
        3. All
      • Fixed the problem of the overpopulation of the Notes directory
      • Created optional "don't print" feature for specific footnotes.
  • 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:
      • Added referenced reading lists to printable version of Notes
      • When a Note is archived, ensured a printable note is also archived57 (if this Note has a print)
      • Added referenced Books / Papers as footnote jump table to Notes
      • Improve "Temp" note processing. Suppress "_T" suffix (just don't copy to Transfer)
    3. 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:
      • Created "respondent notes" - database identifier & red indicator + text
      • Enabled generation of printable version of Notes
      • Created58 a "quick lookup" table of responses to a note and its sub-notes (recursive function on Notes_Links)
      • 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
      • Segregated Abstracts into multiple directories
      • Added "Extra Data" parallel to Abstracts; ie. "More …" (Location etc.)
    2. Architecture:
      • Segregated database59 into Master and Slaves (code, papers, books, notes, web control, … vs PI)
      • Tidied up Footers throughout Philosophy Papers site (made into tables)
    3. Books/Papers:
      • Created "Papers by Title within Topic" list
      • Created "Identity Read Papers by Sub-Topic" list
      • Added Flags for "laptop" and "photocopy"; removed document location from Comments
      • Added change of author or title in "Abstracts audit"
      • Created "Identity Papers Full by Sub-Topic" list
      • Jump-Tables: added "by topic" option
      • Added "read" column in papers / books lists
      • Created "BB-friendly60" lists: Papers (Full) and Books
      • Added multiple Jump-levels for BB Lists (to keep pages small)
      • Added Book Comments and Abstracts (as "More…") to Book-lists
    4. Footnotes:
      • Created auto-renumbering61 routine for Footnotes
      • Created auto-backup of Footnotes62=61, and more efficient maintenance web-routines
    5. General:
      • Improved "Disclaimer63" Page. Reduce font, add ref to philosophy databases + hyperlinks
    6. Notes:
      • Added "outgoing links" summary footer to Notes pages
      • Allowed two sorts of Note - document-specific ("Write-up") and general
      • Added "footnote" pages64=61 for Carthusians & King's
    7. Process:
      • Improved ease of FTP process by use of Transfer Directory
    8. 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.)
        • Created auto-backup of Abstracts, and more efficient maintenance web-routines
        • 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. 20Q3
      2. 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.
        • 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. +B67=53) doesn’t match with its corresponding anti-tag (eg. B+).
        • Replaced macros with code.
      13. 09Q2
        • Created Site-map for Website
      14. 07Q4
        • Added password-protection to selected pages
      15. 07Q2
        • Segregated database68=59 into Master and Slaves (code, papers, books, notes, web control, … vs PI)
        • 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.
        • 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.
        • 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.
      2. 20Q1
        • As revealed by Spider: Philosophers_Index_List_OA.htm. Author Names Scrambled. 133 items. Dud page (Ontological Argument) deleted.
        • Restrict jump-table at top of Authors pages to relevant items, and include the item counts.
      3. 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.
      4. 19Q3
        • As revealed by Spider: Author pages not regenerated when name corrected, leading to Sundry broken Links from other pages.
      5. 19Q2
        • Added Jump Table to sections of Authors Pages
      6. 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.
        • Authors Narrative: enable footnotes.
      7. 15Q4
        • Corrected author's names (SN (FN)) for all papers and books
        • Provided easy links to works by the same author; Books, Papers; Joint authors
      8. 15Q1
        • Improved the format and content of “Authors” pages.
      9. 14Q2
        • Created the facility for Author Narratives.
      10. 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. 20Q3
        • BookCitings references not sequenced correctly. Corrected.
        • BooksToNotes Link Pages: Re-engineered - used CreatePapersToNotesWebPages to generate pages
      2. 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.
      3. 18Q3
        • As revealed by Spider: BookCitings. 405 items. Fixed problem with CreateBookCitingsWebPages not checking for change of Book during 'Repeats' processing.
    • Books/Papers
      1. 20Q4
      2. 20Q3
      3. 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.
      4. 19Q3
        • Print Write-up Notes (not just the links) for appropriate Papers in BookPaperAbstracts
      5. 19Q1
        • Removed Blackberry processing and associated pages as no longer needed with fast broadband.
      6. 18Q3
        • Paper & Book Abstracts - Make 'Disclaimer' more prominent & show 'Paper Statistics' rather than 'Paper Summaries'
      7. 17Q4
        • New "Recent Acquisitions" Book List - Uncategorised
      8. 16Q1
        • Created direct links from Subject, Topic & Sub-topic (in Book and Paper Summaries) to their link pages.
      9. 15Q4
        • Neatened up the linkage headers in Book & Paper Abstracts.
        • Updated booklists to include shelf-identifiers
      10. 13Q3
        • Improved linkages between Book/Paper Lists and Summaries or Abstracts
        • Made enhancements to "Books & Papers Collection Categorised" Pages
      11. 13Q2
        • Developed "Books by Location" Pages
        • Improved the linkage between Papers and Books.
      12. 11Q4
        • Showed Percentage of Paper / Book Read
      13. 11Q2
        • Added “changed dates” to Paper and Book abstracts, and produced “recently changed” pages for them
        • Created Inter-Book-Paper Citings Cross-reference
      14. 09Q3
        • Completed a full 2-way link from Book/Paper Summaries to Notes.
        • 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.
      15. 09Q2
        • Added "quality marker" to Paper & Book Abstracts
        • De-duplicated Books / Papers to Notes links
        • Improved, and corrected errors in, the Blackberry-friendly formatted lists of Books and Papers.
      16. 09Q1
        • Created automatic links from Paper Summary to Book Summary
        • Enabled links from Books to the Papers contained therein
        • Enhanced Books to Papers links to include papers multiply held
        • Improved the Books / Papers to Notes links to include the right Version and Section (and historical Title) of the Note
        • Provided an automated link from Books / Papers to the Notes referencing them
      17. 07Q2
        • Added "read" column in papers / books lists
        • Added Book Comments and Abstracts (as "More…") to Book-lists
        • Added change of author or title in "Abstracts audit"
        • Added Flags for "laptop" and "photocopy"; removed document location from Comments
        • Added multiple Jump-levels for BB Lists (to keep pages small)
        • Created "BB-friendly69=60" lists: Papers (Full) and Books
        • Created "Identity Papers Full by Sub-Topic" list
        • Created "Identity Read Papers by Sub-Topic" list
        • Created "Papers by Title within Topic" list
        • 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
        • NGS Refinements
        • Synchronise Documentator with main website generator
      3. 18Q3
        • Reformated + Fixed Hand-dealing pages to CSS standards
      4. 18Q1
        • Corrected format of Links from Bridge Page
      5. 17Q2
        • Created hyperlinks from my consolidated results pages to the actual results
      6. 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.
        • 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.
      4. 18Q2
        • Investigated the error reports from the Documenter:
          1. Improved the diagostics
          2. Removed unused variables from the Generator code.
      5. 18Q1
        • Created consolidated Development Log, and updated "Progress to Date" and "Outstanding Developments" Reports
        • Documenter Bug-fixes: Objects in Comments, MsgBoxs & Debugs
      6. 17Q4
        • Code Archive: Created Web-pages of Recent Code Changes
        • Code Archive: Hadn't been working - fixed and recovered a selection from backups
      7. 16Q1
        • Created an automatic Forms documenter – with links to the code.
      8. 15Q4
        • Segregated the code-archive, which was bloating71=50 the generator database.
      9. 14Q2
        • Created multiple secure areas on my website, so that Documentation is no longer hiding under my Supervision Notes.
      10. 13Q2
        • Created a code & query archive facility as part of the Code Documenter.
        • Wrote the Code Documenter.
    • Footnotes
      1. 18Q3
      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 Footnotes74=61, and more efficient maintenance web-routines
        • Created auto-renumbering75=61 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 "Disclaimer77=63" 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
        • Purchase & Commission new Lenovo Laptop: awaiting replacement following motherboard failure!
      2. 18Q1
        • Migration of Website from UKServers to Namesco. Test out.
    • Notes
      1. 20Q4
      2. 20Q3
        • Added Aeon Abstract (ie. Footnote) link to Aeon Webref items in Summary task List reports for 'read' items
        • Added option in Auto_Reference_Notes to - for Live (ie. not TEMP) Notes - update the latest Archived Note to equal the updated Live Note, hence avoiding superfluous archives.
        • Added option in Auto_Reference_Notes to only confirm new items (leaving previously-flagged items untouched)
        • Corrected Issues with Nested Functors: Added Functor_ID to End-tag
        • Determined why the run of Auto_Reference_Notes_Regen took 2.5 hours on 02/09/2020 (and climbing). It was down to the Aeon Note being searched; in particular Check_If_In_Container, checking for items in Footnotes and / or Quoted Text. As this Note is regenerated, there's no point auto-linking it. Time reduced to 23 minutes once this Note - and other Notes of inappropriate Note Groups - was removed.
        • Highlighted Archived Notes clearly as not the latest
        • Upgraded Auto_Reference_Notes to allow a parameterised 'termination or continue' for very long update runs
        • Upgraded Auto_Reference_Notes to avoid key-words within +AA+-style Authors names (using Check_If_In_Container).
        • Upgraded Auto_Reference_Notes to log its actions to a new table (Auto_Reference_Notes_Actions) so that any errors can be investigated and improvements made.
      3. 20Q2
        • As revealed by Spider: Sundry uncategorised. Refs failing. 30 items. Fixed manually.
      4. 20Q1
        • As revealed by Spider: #Reference links: fail for Printable Notes. 24 items.
        • As revealed by Spider: Blackberry links from archived Note 1010 (Maintenance Dashboard). 38 items.
        • As revealed by Spider: Blog Achived Notes - sundry links to Printable Notes. Live Note OK. 97 items.
        • As revealed by Spider: Old links from Archive Notes to (non-existent) Archived Printable Notes. 42 items.
        • Solve the problem of the size limitation for Notes by allowing their concatenation.
      5. 19Q4
        • Create procedures (manual and via Functor_17) to add Audio Files to Notes
      6. 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.
        • As revealed by Spider: Links from Blog in Level 1 or 2 Printed Notes 512 and 981 failing. 141 items.
        • 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!
        • 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.
        • As revealed by Spider: Sundry links failed for Supervisions. 30 items.
        • Create Priority Task List Report.
      7. 18Q3
        • As revealed by Spider: Bridge Status Report Achived Notes - sundry links failing. Live Note OK. 70 items.
        • As revealed by Spider: Languages Status Report Achived Notes - links to Dissertation failing. Live Note OK. 43 items.
        • As revealed by Spider: Religion Status Report Achived Notes - sundry links failing. Live Note OK. 59 items.
        • As revealed by Spider: Links to Notes_xxx_Links, from Abstracts (94 items), Notes (25 … corrected manually), NotesPrint (1916). Fixed by +LL+ functor implementation.
        • As revealed by Spider: Notes_List_Control links fail for Supervisions. 58 items.
        • 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.
        • Blog: Created Functor to generate Blog from Blog.
        • Created auto-regen of all Note Link (Note_nnn_Link) Pages
        • Created new '+LL+' Functor for links to Note_Link pages; fixed associated Notes.
      8. 18Q2
        • Added a process to 'fix' - by adding the Note-ID - those note-links added without stating the ID. This will save processing time.
        • 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.
      9. 18Q1
        • Automated format-change of old tables in Notes and Notes_Archive
        • Extended deduction of Note links to Papers, and Papers with embedded Notes.
        • Notes Functor94=42 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
        • Removed old "Printable Notes" links from Archived Notes
      10. 17Q4
        • Added %age complete to Notes Reading Lists
        • 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.
      11. 17Q3
        • Added Colour-coded "quality markers" to Notes: included them in lists and jump-tables
      12. 16Q1
        • Allowed Note- & Footnote-links from multiple words101=49. This is such a useful feature!
        • Completed converting “static” pages to Notes.
        • Enabled direct links to Notes from within Footnotes.
        • Stopped (I hope!) “private” Notes showing in Paper Abstracts.
      13. 15Q4
        • Converted the “static” pages in my website to Note format (so they can change and retain history).
        • Fixed problem of images not appearing in "Printed" Notes (wrong directory level) unless the images are repeated
      14. 15Q3
        • Tidied up the archived Notes.
      15. 14Q4
        • Made improvements to the regeneration and referencing of archived Notes.
      16. 14Q3
        • Created a progress-tracker for my Thesis.
        • Improved error-recovery where encoding fails for Notes links.
        • Started to split Paper Abstracts from Write-ups.
      17. 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.
      18. 14Q1
        • Made a lot of improvements to my Site generators, in particular the pesky bug that stopped the links to archived Notes working correctly.
      19. 13Q3
        • "Single Image" development for Notes
        • Allowed "Authors Works Lists" to be linked-to from Notes
        • Created Archived Notes Re-Export facility
        • Simplified / Re-engineered Notes processing
      20. 13Q2
        • Improved "Concatenated Notes" production
      21. 10Q3
        • Add “Date Created” to Note_Links (for audit purposes; I’m still not convinced that links disappear when they should).
        • Investigate Note_Links: needs versioning, and section of calling Note
        • Wrote routines to automatically generate the “Printable Notes” footer – and to create the corresponding web pages – from the control table. Very useful.
      22. 09Q4
        • Restricted the size of the “previous versions” tables for Notes to 12.
      23. 09Q3
        • Enabled automatic immediate promotion to Live Website of selected Temp 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.
        • Ensured that the Notes Reading-list is generated from all 3 sub-topics.
        • 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).
        • 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.
      24. 09Q2
        • Added a table of Notes history at the end of each Note (ie. not just previous version) - to save tedious chaining
      25. 09Q1
        • Added reading-list (of works cited) at the end of the Note, as well as in the Printed Note
        • Created optional "don't print" feature for specific footnotes.
        • Fixed the problem of the overpopulation of the Notes directory
        • Option for Notes-Regen:
          1. Changed-only
          2. Changed, and all impacted by Change
          3. All
      26. 08Q1
        • Allowed regeneration of Temp Notes only
      27. 07Q4
        • Added referenced Books / Papers as footnote jump table to Notes
        • Added referenced reading lists to printable version of Notes
        • Improve "Temp" note processing. Suppress "_T" suffix (just don't copy to Transfer)
        • When a Note is archived, ensured a printable note is also archived103=57 (if this Note has a print)
      28. 07Q3
        • Created "respondent notes" - database identifier & red indicator + text
        • Created104=58 a "quick lookup" table of responses to a note and its sub-notes (recursive function on Notes_Links)
        • Enabled generation of printable version of Notes
        • Made Note-change-history available on-line (added status + publishable flags)
      29. 07Q2
        • Added "footnote" pages105=61 for Carthusians & King's
        • Added "outgoing links" summary footer to Notes pages
        • Allowed two sorts of Note - document-specific ("Write-up") and general
    • Papers
      1. 20Q3
      2. 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.
        • 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.
        • Created Timeline software
        • Timeline software: Added photos of Coxes Farm
      2. 18Q3
      3. 13Q2
        • Reduced the size of photos (to make the pages quicker to load).
    • Process
      1. 20Q3
        • Determined why Recalculation (cmdRecalculate_Click) took so long: it varied depending on how many Notes were regenerated, but seemed to be 17.5 minutes even if there are none. I think it was down to a problem with nested Functors leading to Notes growing inordinately: in particular the development logs. Now takes around 5 minutes.
      2. 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.
        • Corrective work was split out into the items requiring improvement, must of which have now been implemented.
        • 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.
        • 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.
      3. 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.
        • Fix Functors to enable previous quarter's Status Reports after Time period roll-over
      4. 18Q4
        • Added 'time to regenerate' sub-totals & grand-totals to Website Maintenance Dashboard.
      5. 18Q2
        • Re-engineered Website Maintenance Dashboard to show extra topical links (and show them at the top of the page).
      6. 18Q1
        • Improved efficiency of daily changes regeneration (removed msgboxes)
        • Wrote a routine to update a set of .htm files, replacing text in them all
      7. 15Q4
        • Created a consolidated processor to enable overnight regeneration of the whole website.
      8. 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.
        • Improved the regeneration routines for the various classes of webpage, and got them to record statistics in support of the “Website Regeneration Dashboard”.
      9. 09Q4
        • Set up my database system to roll forward to the next academic year, and generate web-pages appropriately.
      10. 09Q3
        • Created a “performance stats” database and routines to write to it – though I only implemented them for the Notes generator.
      11. 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. 20Q4
        • System Resources Exceeded - "Run Time Error 3035" - re-emerged in Full_Link_Same_Directory_Gen. Last month I had replaced query Full_Link_Same_Directory_Updt with identical SQL, which had worked OK. This time I removed the "WHERE" statements and put them in the code itself. Seems fine.
      2. 20Q3
        • System Resources Exceeded - "Run Time Error 3035"; query Full_Link_Same_Directory_Updt in Full_Link_Same_Directory_Gen. Fixed by using SQL rather than a query.
        • The size of the main database was bloating to over 1.5Gb during the spider run, so was approaching the 2Gb limit.
          1. Used Check_Database_Size, with a parameter, to monitor the size of the main database and added a message similar to those reporting the compact / repair of the Slave database each time a status message is printed.
          2. Based on the diagnostics produced, it was found that the bloating occured at two stages:-
            → In Spider_Scurry: during the creation of Raw_Links_Temp_Temp.
            → In Spider_Copy: during the creation of Raw_Links_Temp.
          3. Fixes:-
            → Put check in Check_Database_Size to STOP if the database is over 1.5 Gb (parameterised via Max_Database_Size).
            → Moved Raw_Links_Temp_Temp to the Slave database.
      3. 18Q4
        • Determined why Full_Link_Up_Levels_Gen takes so long - approximately 4 hours. Re-architected to reduce database reads.
      4. 16Q4
        • Added “.shtml” and “.shtm” to the list of web-suffices.
      5. 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.
      6. 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).
      7. 14Q3
        • Continued working on my Spider and started to use it to clean up my website by diagnosing broken links.
      8. 13Q2
        • De-bugged the Spider.
      9. 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. 20Q4
        • Website - Outstanding Developments: Group items in the same period / category together, as in Status: Priority Task List. Ie.
          1. Functor_03 - Completed Items - Priority Sequence
          2. Functor_04 - Outstanding Items - Category Sequence
        • Website - Progress to Date: Group items in the same period / category together, as in Status: Priority Task List. Ie.
          1. Functor_02 - Completed Items - Date Sequence
          2. Functor_05 - Completed Items - Category Sequence
      2. 20Q3
        • Added Weekly Project Plans to Priority Task List
        • Created web-page (using Functor_21) showing oboe practice hours by work played
        • Quarterly Project Reports: Corrected Functor_08. The Project Planned YTD % kept having to be bodged!
      3. 19Q2
        • Corrected Quarterly Reporting for uneven Plan (Holidays)
      4. 18Q4
        • Links occasionally missing from Summary Task List and Summary Task List (YTD).
      5. 18Q3
        • Status: Summary - Actual versus Plan between quarters says "previous quarter"; should be "current quarter"
      6. 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.
      7. 18Q1
        • Created web-page generator for Development items (ie. Created the Web-Project "To Do" List and "Outstanding Developments" directly from this list).
      8. 13Q3
        • Re-engineered Monthly Reporting on Change of Year
      9. 13Q2
        • Improved "This Month's Summary" Reporting
        • Improved Quarterly Reporting
      10. 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
        • Used CSS in all manually-crafted and automatically-generated pages
      3. 13Q1
        • Standardised to HTML5118=56
    • 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. 20Q3
        • Improved WebRefs checker (Webrefs_Update) further to check for Error 403 "Forbidden". This involved finding way of checking pdfs where the returned page is in fact HTML or XML (see DevLog Ref 379).
        • Reformated WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm: The 'As Above" lines waste space. Consolidate onto single second line.
        • Reformated WebLinks_Tester_Brief, WebLinks_Tester.htm, WebLinks_Tester_Map.htm, WebLinks_Tester_Full.htm & WebLinks_Tester_Full_Map.htm: Allowed more space for 'link returned', 'issue' and 'display text' and added Explanation column
      2. 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.
        • Amend WebRef 'Name' link to #Off-Page_Link_WxxxW style. Also amend Quarterly and Annual task lists to use this reference.
        • Amended WebRef 'Name' links to #Off-Page_Link_WxxxW style so referencing from other pages is possible (useful for Aeon)
        • As revealed by Spider: WebLinks_Tester_Full_Map.htm (etc). Refs failing. 184 items. res://ieframe.dll/ in Returned_URL.
        • 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.
        • WebLinks_Tester_Full & WebLinks_Tester_Full_Map: Reformated Jump Table to 30 columns and multiple rows.
      3. 20Q1
        • As revealed by Spider: WebLinks_Tester_4.htm. Refs failing. 32 items. res://ieframe.dll/ in Returned_URL.
        • As revealed by Spider: WebLinks_Tester_Brief_12.htm (etc). Refs failing. 41 items. res://ieframe.dll/ in Returned_URL.
        • As revealed by Spider: WebLinks_Tester_Map_3.htm (etc). Refs failing. 51 items outstanding. res://ieframe.dll/ in Returned_URL.
        • 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.
      4. 19Q3
        • As revealed by Spider: Hits_Pages_Total_Crosstab_Descending.htm.
      5. 18Q4
        • Added Display text to WebRefs for Links to Stanford, Wikipedia & Aeon
      6. 18Q2
        • Created Functor to add stats to Website Generator Documentation - Web Links page.
      7. 18Q1
        • Determined & reported usage directly using embedded +WnnnW+ encoding rather than via the Spider. Reconciled the two methods.
        • 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)
      8. 16Q1
        • Some tidying up of the 3,000-odd external links from my website.
      9. 13Q2
        • Some pages render oddly in Chrome (and maybe other browsers) – investigated120=54.
      10. 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.
      11. 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.
        • Created Master Point Lists & Promotions for the ECBA website.
      2. 16Q3
      3. 16Q1
        • Accommodated Alaric’s new scoring system for St. Edith’s.
        • Created Ladies’ and Gentlemen’s ladders for my mini-websites.
        • Reconciled my X-IMP calculations with a new feature provided by Bridgewebs.
      4. 15Q4
        • Segregated the Bridge website generators from those for my own website. They now live in separate databases and have their own documenters.
      5. 15Q3
        • Created a new website (using Bridgewebs) for the First Class Bridge Academy (First Class Bridge (https://www.bridgewebs.com/firstclassbridge/)).
        • Ported my “handicap / improvers” routines from Hutton to “Mini Websites”.
      6. 15Q2
        • Development of the “Eve Goblets” (victor ludorum) software for the ECBA, and roll-over to the new season.
      7. 15Q1
        • Further improvements to my Butler-IMPs and Cross-IMPs calculation routines.
        • Started a project to provide small websites for bridge clubs without sites: Essex Bridge Results (http://www.theotodman.com/Bridge/index.htm).
        • Took on the ECBA Website (ECBA Website - Defunct), at the cost of considerable effort by way of reformatting & tidy-up.
      8. 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.
      9. 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.
      10. 13Q2
        • Merged121=55 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 (https://sophiebotros.com/).
      2. 18Q4
        • Added 'SB' shortcut icon on all Webpage browser tabs
      3. 15Q3





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 32:
  • This situation occurs in these reports, and elsewhere.
Footnote 33: Footnote 42:
  • 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 49:
  • As demonstrated here!
Footnote 50:
  • I subsequently found a bug whereby it was backing up the entire code-base each time!
Footnote 51:
  • Sophie is an old friend and supervisor from Birkbeck.
Footnote 53:
  • Naturally, I can now say precisely what I mean, by using a plus-sign, as it no longer causes the process to fail!
Footnote 54:
  • Fixed – it was very long blank-free URLs in the Source column.
  • I now call my “WebRef” function to convert these to hyperlinks.
Footnote 55:
  • This was a mistaken idea, and was subsequently reversed!
Footnote 56:
  • 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 57:
  • I must have unwound this one - presumably it didn't work - and need to re-do it.
Footnote 58:
  • 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 59:
  • This must have been unwound if it was ever implemented.
Footnote 60:
  • "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 61:
  • What was this?
Footnote 62:
  • What was this?
Footnote 63:
  • Presumably this was the ancester of this page before it was converted to a Note?
Footnote 64:
  • What was this?
Footnote 67:
  • Naturally, I can now say precisely what I mean, by using a plus-sign, as it no longer causes the process to fail!
Footnote 68:
  • This must have been unwound if it was ever implemented.
Footnote 69:
  • "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 71:
  • I subsequently found a bug whereby it was backing up the entire code-base each time!
Footnote 72:
  • This situation occurs in these reports, and elsewhere.
Footnote 73: Footnote 74:
  • What was this?
Footnote 75:
  • What was this?
Footnote 77:
  • Presumably this was the ancester of this page before it was converted to a Note?
Footnote 94:
  • 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 101:
  • As demonstrated here!
Footnote 103:
  • I must have unwound this one - presumably it didn't work - and need to re-do it.
Footnote 104:
  • 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 105:
  • What was this?
Footnote 118:
  • 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 120:
  • Fixed – it was very long blank-free URLs in the Source column.
  • I now call my “WebRef” function to convert these to hyperlinks.
Footnote 121:
  • This was a mistaken idea, and was subsequently reversed!
Footnote 122:
  • Sophie is an old friend and supervisor from Birkbeck.

Note last updated: 01/11/2020 09:40:19


Footnote 4.27: (Website - Outstanding Developments (2020 - November))

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
        • 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.
          → 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!
          → In Progress
        • Document, Repair & update my Website site-map
          → In Progress
        • Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
          → On-Going
        • Where possible, use ID rather than NAME for in-page hyperlinks
      2. 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.
        • Review architecture to improve performance; Need to document first
      3. Books
        • Further improve the time to regenerate Book Summaries. Took about 22 minutes on 04/10/2020, but should be under 5 minutes!
      4. Books/Papers
        • Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
        • Reformat the BookCitings and PaperCitings pages:-
          1. Detail PaperCitings Pages: 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 BookCitings (copy the code: or, better, combine the two subs).
          2. Summary (Author Letter) pages: Include counts (as in Authors' Citations).
          3. Ensure uses the Cross_Reference table.
          4. Document!
      5. Bridge
        • Develop auto-reconciliation routines vs EBU results download
          → In Progress
      6. Documenter
        • Investigate the error reports from the Documenter, especially unused variables & queries.
          → On-Going
        • Provide Functional Documentation for Website Generator (using Notes)
          → In Progress
      7. Education
      8. Infrastructure
        • iCloud for Windows: Re-install & solve 'The upload folder for iCloud Photos is missing' problem. Try on new Laptop.
      9. Notes
        • Add "Note Alternates" to Note pages.
        • 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.
        • 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.
        • 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.
        • Enhance Functors to work for selected non-temp Notes so that up-to-date stats can be incorporated. This is complex as I want to avoid production of an Archived Note each time a non-Temp Note is regenerated. I also want to ensure that Notes whose variable text consists entirely of Functors get archived correctly (which they might not if I removed Functor-generated text from Notes before saving them to the Notes table).
        • Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
        • Investigate Note_Links: Section references seem to be incorrect
        • Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
        • Split Aeon Page into multiple sub-pages (either by topic or by priority)
        • Suppress the publication of the Printable versions of Temp Notes
        • Upgrade Auto_Reference_Notes to reference Sub-Notes: Currently only affects one note - Somerset Maugham - so not yet urgent
      10. Papers
        • The monthly regeneration process for Paper Abstracts was still taking just over 5 hours. I thought it could not be fixed until the cross-referencing project is fully complete and documented. However, it spontaneously improved to 1.6 hours in the August 2020 run. Monitor! Last run: 1.63 hours on 04/10/2020.
      11. Photos
        • Develop software & procedure to make adding more content to the photos pages easier to undertake.
        • Timeline software: Add photos for Holidays & Family History
      12. Process
        • Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
      13. Spider
        • 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 pages7 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.
          → On-Going
      14. Technology
        • 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
          → In Progress
      15. WebRefs
        • Webrefs_Update failing because IE loops with Aeon / Psyche pages. Currently doing manual checking - try to find an automated solution.
          → In Progress
        • 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.
        • Find a way of recording Missing Webrefs other than debug.print: create table, then suppress message for known problems
        • Investigate items flagged as defunct. Populate Defunct_Explanation in WebRefs_Table. Consider use of FairUse (Link - Fair Use) for documents no longer available that I'd downloaded.
          → On-Going
        • Investigate WebRefs with Issue = 'URL Translated OK': does the translation really work? How?
    • Priority: 2
      1. Abstracts
        • Ensure some minimal data on Abstracts for Identity Papers Read
          → In Progress
      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
        • Investigate historic error messages
      4. Education
      5. 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”.
        • Bug: "++ NP ++" links to previously linked note or to (non-)Note 0. Example!
        • Check (in use) that the optional "don't print" feature for specific footnotes doesn't print other footnotes further down the chain. Probably OK.
        • Enable reproduction of archived “Printed Notes”.
        • Improve Printable notes processing for "Temp" Notes (ie. produce a "_T" (& include all "_T"s), but leave standard prints free of "Temps".
        • Investigate Notes Archiving - see if could re-create re-formatted if required from saved historical versions (but not fixed re directories)
        • Reading Lists: Fix duplications:-
          1. Items "cited" and "categorised" (sometimes seem to) appear twice.
          2. Books and "single papers" of that Book both appear.
      6. Papers
        • When "+PnnnP+" reference used in an Object, allow "#Reference" style to be more specific where in the Paper Abstract the reference is.
      7. Technology
        • Increase use of CSS Style Sheets
    • 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.
        • Review the effectiveness of the categorised reading lists for both Papers and Books.
      4. Bridge
        • Hand-Dealing:
          1. Some hands not showing in consolidated lists
          2. Bidding sometimes missing for SD (maybe connected)
      5. Documenter
        • Investigate & fix “Query Fragments” issue.
        • Separate Documenter from the main database & code, then add a parameter so it doesn’t necessarily document itself.
        • 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. Facebook
      7. Notes
        • As revealed by Spider: NotesPrint from Secure_Jen fails for Notes_Jump links. Need to fix the processing of "../../"-style links to go back to root and back. Example: Note 513.
        • Fix problem with broken bespoke links to Printed Notes from Archived Notes.
        • Improve flexibility of reading lists attached to printable version of Notes (different sort orders, priority items only, etc).
        • Improve reading-lists from Notes (ie. firstly PID, then all starting with topic from Philosophy Papers Full)
      8. Status
        • Check how "YTD Planned %" is calculated - seems incorrect early in the Quarter if the plan varies during the year.
      9. Technology
        • Investigate the use of RTF in memo fields, so that I can get round the 64k character limit.
        • Read the Google documentation (Link (https://www.google.com/webmasters/#?modal_active=none)) to investigate where I’m going wrong in the (failure to) use META tags to ensure my stuff sorts correctly in the search engines.
        • Use generated Javascript to allow multi-level expandable / contractable lists in Notes and Paper Abstracts.
        • 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.
    • 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
        • 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.
        • Books - Referencing of Notes: The "+NnnnN+" method works from the Book Summary, "++nnn++" from Book Abstract, but neither vice-versa.
        • 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.
        • 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 table13" 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)
        • Create Second-Level Jump (+ maybe split pages) for Philosophy / Identity Papers / Books Full - similar to Blackberry pages
        • Determine more efficient method of updating "Books to Papers", "Papers to Notes" and "Books to Notes" - use archiving
      6. Education
      7. General
        • Fix "American" date formats in Electronic Resources page
      8. Notes
        • Create "who's who" of respondents (will just be private notes)
        • Create Functor to facilitate addition of Audio Files to Music Page (not sure why raised - see ID=348)
      9. Papers
        • Remove all large 'Comments' that have been utilised to expand Paper Abstracts (by moving them to Notes14). Cancelled and replaced by simply appending large (> 5k) Comments to Abstracts, so the work-around looks seamless.
      10. Photos
        • As revealed by Spider: Links failing in NotesPrint_1282_0_P_R.htm. 20 items.
      11. Technology
        • Create own local webserver
        • Increase use of Frames15
        • Investigate Wiki-technology (inc. Confluence, Plone CMS & Windows Help)
      12. WebRefs
        • Add collection of "non-identity" weblinks.
        • Complete investigation and correction of broken “External” Links.
        • The Spider was generating WebRefs. Procedurally, this ought not to have been possible.
          1. The major problem turned out to be because unprocessed16 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.
          3. I've re-opened the case! But now Spider_Ctrl outputs the message 'Check Webrefs_To_Be_Added_By_Spider_Detail and run Webrefs_Add if necessary'.
          4. The August 2020 run produced a list of 163 items. I think these are all down to fixes undertaken following a full WebRefs check run. I need to check and find out why the lists appear.
          5. Maybe they come from the 'WebRef Missing' page on WebLinks_Tester, which arises as a result of running Map_WebRefs, which regenerates the WebRef_Maps table, via Map_WebRefs_Mapper, after I've fixed the links on Webrefs_Table. There are 146 such items as of end August 2020, but they had all disappeared by a re-run of early September 2020.
          6. I assume it's some sort of timeing issue, so I'm cancelling the change.
  2. Other Websites: Outstanding Items By Priority:-
    • Priority: 1
      1. Bridge
        • Regular updates to the Hutton Bridge Club (https://www.bridgewebs.com/hutton.html) Website.
          → On-Going
        • Regular updates to the Mountnessing Bridge Club (https://www.bridgewebs.com/mountnessingbc/) Website.
          → On-Going
      2. Enigma
        • Termly updates to the Enigma Ensemble (http://www.enigmaensemble.co.uk/) Website.
          → On-Going
    • Cancelled Developments
      1. Bridge
        • Create "Small Sites" database for Alaric (if chased)
        • Run Eve Goblets - if asked!



Outstanding Developments by Category
  1. Own Website: Outstanding Items By Category:-
    1. Abstracts
      • Priority: 2
        • Ensure some minimal data on Abstracts for Identity Papers Read
          → In Progress
    2. Aesthetics
      • Priority: 3
        • Undertake a trawl through all (categories of) web-page, making aesthetic improvements, and correcting content.
    3. Architecture
      • Priority: 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.
          → 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!
          → In Progress
        • Document, Repair & update my Website site-map
          → In Progress
        • Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
          → On-Going
        • Where possible, use ID rather than NAME for in-page hyperlinks
      • Priority: 2
        • Improve flexibility of password-protected areas (ie. multiple areas, with different log-ons).
      • Priority: 3
        • Add scrolling titles to Lists
      • Cancelled Developments
        • Create expandable lists in Abstracts, Notes ("Plus table18=13" cells? For categorised lists)
    4. Authors
      • Cancelled Developments
        • 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.
    5. Backups
      • 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.
        • Review architecture to improve performance; Need to document first
      • Priority: 2
        • Determine why flag on directories "not to be backed up" gets reset
        • Investigate historic error messages
      • Cancelled Developments
        • 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.
    6. Books
      • Priority: 1
        • Further improve the time to regenerate Book Summaries. Took about 22 minutes on 04/10/2020, but should be under 5 minutes!
      • Work-arounds
        • 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.
        • Books - Referencing of Notes: The "+NnnnN+" method works from the Book Summary, "++nnn++" from Book Abstract, but neither vice-versa.
        • 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.
        • 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
        • Create "Books by Subject" and "Books by Title" lists
    7. Books/Papers
      • Priority: 1
        • Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
        • Reformat the BookCitings and PaperCitings pages:-
          1. Detail PaperCitings Pages: 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 BookCitings (copy the code: or, better, combine the two subs).
          2. Summary (Author Letter) pages: Include counts (as in Authors' Citations).
          3. Ensure uses the Cross_Reference table.
          4. Document!
      • Priority: 3
        • Introduce check that if a Book is flagged as "read" so are its Papers. Manual check completed in March 2018.
        • Review the effectiveness of the categorised reading lists for both Papers and Books.
      • Cancelled Developments
        • Create list of "Identity" papers - and books - to obtain (ie. the "zzz"s)
        • Create Second-Level Jump (+ maybe split pages) for Philosophy / Identity Papers / Books Full - similar to Blackberry pages
        • Determine more efficient method of updating "Books to Papers", "Papers to Notes" and "Books to Notes" - use archiving
    8. Bridge
      • Priority: 1
        • Develop auto-reconciliation routines vs EBU results download
          → In Progress
      • Priority: 3
        • Hand-Dealing:
          1. Some hands not showing in consolidated lists
          2. Bidding sometimes missing for SD (maybe connected)
    9. Documenter
      • Priority: 1
        • Investigate the error reports from the Documenter, especially unused variables & queries.
          → On-Going
        • Provide Functional Documentation for Website Generator (using Notes)
          → In Progress
      • Priority: 3
        • Investigate & fix “Query Fragments” issue.
        • Separate Documenter from the main database & code, then add a parameter so it doesn’t necessarily document itself.
        • 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.
      • 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.
    10. Education
    11. Facebook
    12. General
      • Cancelled Developments
        • Fix "American" date formats in Electronic Resources page
    13. Infrastructure
      • Priority: 1
        • iCloud for Windows: Re-install & solve 'The upload folder for iCloud Photos is missing' problem. Try on new Laptop.
    14. Notes
      • Priority: 1
        • Add "Note Alternates" to Note pages.
        • 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.
        • 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.
        • 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.
        • Enhance Functors to work for selected non-temp Notes so that up-to-date stats can be incorporated. This is complex as I want to avoid production of an Archived Note each time a non-Temp Note is regenerated. I also want to ensure that Notes whose variable text consists entirely of Functors get archived correctly (which they might not if I removed Functor-generated text from Notes before saving them to the Notes table).
        • Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
        • Investigate Note_Links: Section references seem to be incorrect
        • Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
        • Split Aeon Page into multiple sub-pages (either by topic or by priority)
        • Suppress the publication of the Printable versions of Temp Notes
        • Upgrade Auto_Reference_Notes to reference Sub-Notes: Currently only affects one note - Somerset Maugham - so not yet urgent
      • 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”.
        • Bug: "++ NP ++" links to previously linked note or to (non-)Note 0. Example!
        • Check (in use) that the optional "don't print" feature for specific footnotes doesn't print other footnotes further down the chain. Probably OK.
        • Enable reproduction of archived “Printed Notes”.
        • Improve Printable notes processing for "Temp" Notes (ie. produce a "_T" (& include all "_T"s), but leave standard prints free of "Temps".
        • Investigate Notes Archiving - see if could re-create re-formatted if required from saved historical versions (but not fixed re directories)
        • Reading Lists: Fix duplications:-
          1. Items "cited" and "categorised" (sometimes seem to) appear twice.
          2. Books and "single papers" of that Book both appear.
      • Priority: 3
        • As revealed by Spider: NotesPrint from Secure_Jen fails for Notes_Jump links. Need to fix the processing of "../../"-style links to go back to root and back. Example: Note 513.
        • Fix problem with broken bespoke links to Printed Notes from Archived Notes.
        • Improve flexibility of reading lists attached to printable version of Notes (different sort orders, priority items only, etc).
        • Improve reading-lists from Notes (ie. firstly PID, then all starting with topic from Philosophy Papers Full)
      • Cancelled Developments
        • Create "who's who" of respondents (will just be private notes)
        • Create Functor to facilitate addition of Audio Files to Music Page (not sure why raised - see ID=348)
    15. Papers
      • Priority: 1
        • The monthly regeneration process for Paper Abstracts was still taking just over 5 hours. I thought it could not be fixed until the cross-referencing project is fully complete and documented. However, it spontaneously improved to 1.6 hours in the August 2020 run. Monitor! Last run: 1.63 hours on 04/10/2020.
      • Priority: 2
        • When "+PnnnP+" reference used in an Object, allow "#Reference" style to be more specific where in the Paper Abstract the reference is.
      • Cancelled Developments
        • Remove all large 'Comments' that have been utilised to expand Paper Abstracts (by moving them to Notes26=14). Cancelled and replaced by simply appending large (> 5k) Comments to Abstracts, so the work-around looks seamless.
    16. Photos
      • Priority: 1
        • Develop software & procedure to make adding more content to the photos pages easier to undertake.
        • Timeline software: Add photos for Holidays & Family History
      • Cancelled Developments
        • As revealed by Spider: Links failing in NotesPrint_1282_0_P_R.htm. 20 items.
    17. Process
      • Priority: 1
        • Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
    18. Spider
      • Priority: 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 pages27=7 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.
          → On-Going
    19. Status
      • Priority: 3
        • Check how "YTD Planned %" is calculated - seems incorrect early in the Quarter if the plan varies during the year.
    20. Technology
      • Priority: 1
        • Look into Sistrix Smart28=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
          → In Progress
      • Priority: 2
        • Increase use of CSS Style Sheets
      • Priority: 3
        • Investigate the use of RTF in memo fields, so that I can get round the 64k character limit.
        • Read the Google documentation (Link (https://www.google.com/webmasters/#?modal_active=none)) to investigate where I’m going wrong in the (failure to) use META tags to ensure my stuff sorts correctly in the search engines.
        • Use generated Javascript to allow multi-level expandable / contractable lists in Notes and Paper Abstracts.
        • 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.
      • Priority: 4
        • Add page-hit counters
      • Cancelled Developments
        • Create own local webserver
        • Increase use of Frames29=15
        • Investigate Wiki-technology (inc. Confluence, Plone CMS & Windows Help)
    21. WebRefs
      • Priority: 1
        • Webrefs_Update failing because IE loops with Aeon / Psyche pages. Currently doing manual checking - try to find an automated solution.
          → In Progress
        • 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.
        • Find a way of recording Missing Webrefs other than debug.print: create table, then suppress message for known problems
        • Investigate items flagged as defunct. Populate Defunct_Explanation in WebRefs_Table. Consider use of FairUse (Link - Fair Use) for documents no longer available that I'd downloaded.
          → On-Going
        • Investigate WebRefs with Issue = 'URL Translated OK': does the translation really work? How?
      • Cancelled Developments
        • Add collection of "non-identity" weblinks.
        • Complete investigation and correction of broken “External” Links.
        • The Spider was generating WebRefs. Procedurally, this ought not to have been possible.
          1. The major problem turned out to be because unprocessed30=16 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.
          3. I've re-opened the case! But now Spider_Ctrl outputs the message 'Check Webrefs_To_Be_Added_By_Spider_Detail and run Webrefs_Add if necessary'.
          4. The August 2020 run produced a list of 163 items. I think these are all down to fixes undertaken following a full WebRefs check run. I need to check and find out why the lists appear.
          5. Maybe they come from the 'WebRef Missing' page on WebLinks_Tester, which arises as a result of running Map_WebRefs, which regenerates the WebRef_Maps table, via Map_WebRefs_Mapper, after I've fixed the links on Webrefs_Table. There are 146 such items as of end August 2020, but they had all disappeared by a re-run of early September 2020.
          6. I assume it's some sort of timeing issue, so I'm cancelling the change.
  2. Other Websites: Outstanding Items By Category:-
    1. Bridge
      • Cancelled Developments
        • Create "Small Sites" database for Alaric (if chased)
      • Priority: 1
        • Regular updates to the Hutton Bridge Club (https://www.bridgewebs.com/hutton.html) Website.
          → On-Going
        • Regular updates to the Mountnessing Bridge Club (https://www.bridgewebs.com/mountnessingbc/) Website.
          → On-Going
      • Cancelled Developments
        • Run Eve Goblets - if asked!
    2. Enigma
      • Priority: 1
        • Termly updates to the Enigma Ensemble (http://www.enigmaensemble.co.uk/) Website.
          → On-Going





In-Page Footnotes

Footnote 7:
  • 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 8:
  • See Sistrix (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Optimizr - Defunct (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 13:
  • I'm not sure what was intended here.
Footnote 14:
  • Once the size-limitation on Notes has been resolved.
Footnote 15:
  • This is now archaic, and was subsequently largely abandoned, though useful at the time.
Footnote 16:
  • 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 18:
  • I'm not sure what was intended here.
Footnote 26:
  • Once the size-limitation on Notes has been resolved.
Footnote 27:
  • 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 28:
  • See Sistrix (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Optimizr - Defunct (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 29:
  • This is now archaic, and was subsequently largely abandoned, though useful at the time.
Footnote 30:
  • 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.

Note last updated: 01/11/2020 09:40:19


Footnote 4.28: (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: 01/11/2020 11:41:17


Footnote 10: (Status: Chess (2020 - September))

As this project is substantially in abeyance, this report is mostly generated automatically, with minor textual additions at the end of each academic year.


Rationale for this Project
  • For years I’d been thinking of returning to chess after a very long lay-off; effectively since my school days. Now, it seems, I’ve actually done so.
  • For further information, see my Chess Page1.
  • I have played – as and when selected – for the Billericay A & B Teams in the North Essex Chess League (http://www.necl.org.uk/) Divisions 1 & 4 and for the Billericay I Team in Southend & District Chess League (http://www.southendchessclub.co.uk/league/), Division 1. Also, in the Billericay Chess Club Championship (https://www.billericaychessclub.org.uk/club_championship.html) and any KO competitions Billericay may enter.
  • After a decent start in 18Q4, my results have been rather poor, and I lost a bit of confidence towards the end of the 2018/19 season, drawing with – and in one case losing to – a string of weak players. Blunders!
  • Last season, my results were terrible, and I had stopped playing even before the whole chess scene (at least “over the board”) went into lock-down mid-March 2020 on account of the coronavirus pandemic.
  • My grade started off as a fairly respectable 151, but has since dropped to a disgraceful 128, lower than when I first played as a 14-year-old. The ECF have recently moved to monthly ELO ratings (ECF Monthly Rating Database (https://www.ecfrating.org.uk/v2/new/list_players.php)).
  • Here are my Consolidated Results. Follow the PGN links for the actual games.

Summary of Progress during July - September 2020
  1. I spent 17.25 hours in 20Q3 on this Project, or related work (62.25 hours YTD, where for "YTD" - Year to Date - I mean the (academic) year that commenced in October 2019). That's 132.3% of the planned effort (43.4% YTD). Overall, 2.5% of my Project effort in the Quarter was directed towards this project (making 2.2% YTD) - as against 1.9% planned (4.8% YTD).
  2. Chess (Total Hours = 17.25)
    1. Chess - Reading / Writing (Total Hours = 0.75)
    2. Chess - Admin (Total Hours = 10)
    3. Chess - Training (Total Hours = 6.5)

Summary of Progress during October 2019 – September 2020 (YTD Activity2)
  1. Chess (Total Hours = 62.25)
    1. Chess - Reading / Writing (Total Hours = 2)
    2. Chess - Admin (Total Hours = 33.5)
    3. Chess - Play (Total Hours = 12.75)
      • Chess - Billericay Chess Club - NECL Match (3.25 hours)
      • Chess - Billericay Chess Club - Southend League Match (9.5 hours)
        → See "Chess - Playing" (12.75 hours)
    4. Chess - Training (Total Hours = 14)
  2. I’ve been so fed up with the game I’ve put it on ice.
  3. I seem to have two main problems:-
    1. Firstly, my opening theory is non-existent, and this has resulted in cramped positions as black, or conceding quick equality as white.
    2. Secondly, in attempting to play in a more open manner than the stodgy and careful approach of my youth, I’ve left myself open to “tactics” that have resulted in the loss of a piece on many occasions. Sometimes these have arisen where I was routinely winning, and just failed to look at what my opponent was threatening.
  4. There’s no quick fix to either of these.
    1. The first requires opening preparation. There’s no reason why I shouldn’t do this.
    2. There ought to be a “quick fix” to the second, but “just concentrate” is easier said than done. It is said that blitz play sharpens your tactics, so I started to try this out – using 10-minute games against human opponents – on Chess.com (https://www.chess.com/) – but have not continued. I need to!
    3. I’ve purchased three books on general strategy and tactics for the club player – I just need to read them!
  5. While (subject to the caveat above) I do review my games – see3 my Consolidated Results – I’ve not spent much time on study or training.
  6. Progress (if any) in the current quarter can be obtained from the relevant section of my Summary Task List4.

Plans for the Near Future:
Summary of Progress to Date (since October 2018)
  1. I have now produced statistics similar to those for Bridge7, my Consolidated Results. Follow the PGN links for the actual games.
  2. Also, see what comes “free” with The ECF Grading Database (http://www.ecfgrading.org.uk/new/menu.php) (though this has now been superseded by ECF Monthly Rating Database (https://www.ecfrating.org.uk/v2/new/list_players.php)).
  3. Enough of an indication of progress has been given above, though see also my Chess Page8.





In-Page Footnotes

Footnote 2:
  • 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.
Footnote 3:
  • Setting this page up was a useful advance in 19Q2, when I enabled the use of pgn4web Board Generator (http://pgn4web-board-generator.casaschi.net/board-generator.html).
  • I found out how to link to analysis on Chess.com (https://www.chess.com/) in 19Q4.
Footnote 5:
  • And consider migrating from Chess.com (https://www.chess.com/), though I renewed my membership at the end of August 2020, but downgraded from Diamond, costing about £80, to Gold, costing about £24.
Footnote 6:
  • This used to say "full participation", but I've let the team captain know that my 'mind games' focus is 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.

Note last updated: 04/10/2020 00:27:22


Footnote 10.1: (Theo Todman's Chess Page)

Introduction Chess Background Status Report Consolidated Results
Progress to Date My Chess Books Useful Links Chess YouTube Videos



Introduction
  • For years I’d been thinking of returning to chess after a very long lay-off; effectively since my school days. Now, it seems, I’ve actually done so.
  • For my background as a chess-player at school and early adulthood – when I showed some aptitude – see Theo Todman's Chess Background.
  • An incentive to return to the game has always been that my brother-in-law4 runs the Albany Club in the Middlesex and London Leagues and he’s keen for me to play, though doing so would involve rather a slog in travelling back and forth.
  • Also, one of my former Bridge partners might be thinking of returning to Chess now that he’s retired, having been of a similar standard to me, though having played more recently5.
  • However, I’ve now joined the Billericay Chess Club6, which I’ve found very welcoming, and also the ECF, so I can get graded7.
  • I intend to play – as and when selected – for the Billericay A Team in the North Essex Chess League (http://www.necl.org.uk/) Division 2 and for the B Team in Division 3. Also for the Billericay I Team in Southend & District Chess League (http://www.southendchessclub.co.uk/league/) and in the Billericay Chess Club Championship (https://www.billericaychessclub.org.uk/club_championship.html) (though this competition expired mid-season).
  • Follow This Link for my most recent Status Report. I produce them Quarterly.


Useful Links

Chess YouTube
  • Over time, I intend to add many series of videos in this section.
  • For now, just see the links to “Hutch: Chess with GM Tal Baron” contained in:-
    → "Chess - Chess - YouTube Videos".


Summary of Progress to Date (since October 2018)
  1. I have now provided statistics similar to those for my Bridge activities. For these follow THIS LINK. There are – in some cases – onward links to the actual games.
  2. Similar statistical information – but not the games – also comes “free” with The ECF Grading Database (http://www.ecfgrading.org.uk/new/menu.php). There are plans to update this monthly from the beginning of 2020 - see ECF Monthly Grading Proposal (https://www.englishchess.org.uk/monthly-grading-proposal/). However, currently it can be more than 6 months out of date. The advantage of the ECF data is that it provides information on the opponents.
  3. Enough for now to say that in 18Q4 I played 7 gradable games – 2 in the Southend League Division 1, 1 in the NECL Division 3, and 4 in the Billericay Club Championship, winning 4 and drawing 3 for an average rating of 151 which was confirmed by the ECF by the end of January 2019.
  4. Since then I’ve played a further 17 games, which is good, but my results have nose-dived somewhat, and my rating is trending towards 129.
  5. These results are viewable by following the links above.
  6. In the case of the ECF site, search on my name. Then click on the Ref and then - at the bottom of the page - on the pink-coloured bar10.





In-Page Footnotes

Footnote 4: Footnote 5:
  • Though not sufficiently recently to appear on the ECF database (unless he should be the Colin Scott who played for Thurrock between 1994 and 2002, rated 124 dropping to 106, which isn’t what he told me!).
Footnote 6:
  • I have to admit that the chess scene in Billericay initially seemed somewhat unexciting. I visited Billericay Chess Club on 6th April 2011. There was a club match, so I couldn’t play any of the better players, but played a keen but not very competent young man who hadn’t make the cut. It was interesting to see how rusty I was, though I won all four games. I had a chat with one of the committee-members afterwards, and left my email address. For some reason, I didn’t hear back. However, I’ve subsequently (July 2018) made contact again and am now a fully signed-up and enthusiastic member.
  • The Billericay Club has an excellent website: see Billericay Chess Club (https://www.billericaychessclub.org.uk/index.html). It seems to go into a hiatus around November eac