Theo Todman's Web Page - Notes Pages

Status Reports

Website - Outstanding Developments (2025 - May)

(Work In Progress: output at 07/04/2025 00:12:58)

Previous VersionsNote ReferencesNote Citations

Rationale for this Document


  1. Own Website: Outstanding Items By Priority:-
    • Priority: 1
      1. Architecture
        • Complete XRef-re-engineering project:-
          1. Ensure all links and link-pages use the new XRef table, and pension off the old tables where appropriate.
          2. Check all link-types still work and fix any errors.
          3. Complete the auto-triggering of regeneration of “associated” link pages.
          4. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
          5. Complete Documenting3 the process!
      2. Authors
        • Creep-check for duplicate authors & fix
      3. Backups
        • Determine why flag on directories "not to be backed up" gets reset
        • Document and enable regular running of the de-duplication function ('pruning') of the backup disk. Keep a full record of deleted duplicates.
        • Enable Backups to be undertaken on both my PC & Laptop and write reconciliation software.
        • Incorporate new 5Tb WD Backup Drive into backup system.
        • Investigate historic error messages
        • 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 document4 first
        • Sort out the contents of my C:Drives, OneDrive and Emails as documented in my Backup Documentation
      4. Books/Papers
        • For Books and Papers - add link pages - analogous to:-
          → BooksToNotes_
          → BookCitings_
          → PapersToNotes_
          → PaperCitings_
          linked to from:-
          → BookSummaries_
          → PaperSummary_
          and (maybe) from:-
          → BookPaperAbstracts_
          → Abstract_
          But, the links are FROM the Book / Paper, rather than TO
          For Books, ensure that all the links from all the Book's Papers are also included
        • Import pdfs downloaded from "LRB - London Review of Books" into databases.
        • Sub-Topic ID has reached 996: What happens after 999? Research and Fix
        • Update LRB_Files table for "LRB - London Review of Books"
          → In Progress
      5. Documentation
      6. Education
      7. Infrastructure
        • Fatal Database Errors: ‘Cannot open any more databases: Run-time error 3048’.
          1. When I then try to compact and repair the database - the first port of call when there's a strange problem - it complains that it is locked by the Administrator. Then the database won’t close and has to be zapped by Task Manager. Only then can I delete the lock file, but this doesn't resolve anything as the problem recurs. I think the 'too many databases' error message is misleading.
          2. This started on Tuesday 27th August 2024 with Bridge_Web_Generator.accdb on Desktop. I stopped running it thereon and it was fine for a day on my Laptop, then the problem recurred.
          3. Looking on-line, this seems to be a known Microsoft bug for which a fix is awaited. It looks like the garbage dispoal routines (after set db = nothing) aren't working. It's not just where you're sloppy and don't do this and rely on the system to do garbage collection: I did changes to 'Small Systems' processing, but it made no difference.
          4. My main 'Thesis' database is working fine - I managed a full Regeneration starting late on 31st August. It may be that the bug was fixed under Windows 11 but not Windows 10. However, I'm not taking the risk of running my Bridge database on my Desktop in case it mucks up my Thesis database. The failure of Compact / Repair of my Bridge database is particularly worrying, but my Thesis databse C/Rs fine on my Laptop (and Desktop). This is a relief, as this database becomes unusable after a few days otherwise as it reaches the 2Gb limit
          5. Currently I'm waiting and seeing. Re-importing all the elements into a new Bridge database made no difference.
        • Migrate from Chrome to Bitwarden for password management
      8. Notes
        • Allow the option to embed blocks of re-usable text in Notes (ie. linearly embed them essay-style) rather than using hyperlinking. Slightly analogous to Note_Snippets or Sub_Notes, but more flexible.
          1. For use as "disclaimers".
          2. The identical block of text in the Dashboard26 to that in the Note Thesis - Method & Form27 that describes the Thesis.
          3. For Thesis / essays: the difficulty here is the need for linking passages to make the text run smoothly.
          4. As a more controllable alternative to 'Printable Notes'.
        • Correct processing for 'References & Reading List' section in Thesis - References28. There are over 7,000 but only 7 items appear!
        • Determine why all my Status Reports from September 2021 are missing from Notes_Archive. Seek to recover them from backups.
        • Develop method for (manually) deleting otiose Archived Notes: ie. ensure links work for remaining Notes!
        • Enhance PID Note, Book & Paper Usage29 to include a section listing works cited in my Thesis but not read
        • Investigate Note_Links: Section references seem to be incorrect
        • Notes_Links: Segment & Provide Jump Table (Eg. For Thought30)
        • PID Thesis References - De-duplicate / suppress and / or change sort order / aggregation for non-anthology book chapters
        • Update Personal Page31 & Home Page
        • Upgrade Auto_Reference_Notes to reference Sub-Notes: Used to only affect one note - Somerset Maugham - but now may be urgent
        • When using the '#' reference to Notes, allow the omission of the Note ID for links within the same Note.
      9. Papers
      10. Photos
      11. Process
        • Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
      12. Spider
        • Investigate reduction in size of Web_Generator_Performance database that holds Raw_Links.
          1. Suppress MsgBox for 'Near to 2Gb' database size check (just use Debug).
          2. One-off deletion of rather useless links: EMail, TheosStyle.css, TT_ICO.png, #Top, ...
          3. Remove code that generates these links, and check them.
          4. Investigate removal of website 'root' (C:\Theo's Files\Websites\Theo's Website\) from Raw_Link and Full_Link. This would save 200Mb, but needs careful checking - especially against the Directory_Structure and related tables and code.
          5. If the above 'root' change is to go ahead - one-off updates + code changes required.
        • Use Edge rather than Internet Explorer for External Links Spider (use Bing AI)
      13. Status
      14. WebRefs
        • Create a page showing the use of WebRefs more clearly. The pages accessed via Theo Todman's Web-Links Test Webpages are of little use other than as an audit. Also, there are many broken links not picked up by the Spider. Need pages that use meaningful names.
        • 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 / Unknown Webrefs (eg. Webrefs 8395 and 8342 in Archived Notes 1292 and 1317) 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.
        • Investigate WebRefs with Issue = 'URL Translated OK': does the translation really work? How?
        • Visitor Stats - cmdVisitorStats_Click (and following) - loops and requires 'DAO.DBEngine.SetOption dbmaxlocksperfile,1000000' to be typed in the Immediate window. Re-engineer.
    • Priority: 2
      1. Abstracts
        • Ensure some minimal data on Abstracts for Identity Papers Read
          → In Progress
      2. Architecture
        • Document40, repair & update my Website site-map
          → In Progress
        • Improve flexibility of password-protected areas (ie. multiple areas, with different log-ons).
        • 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
      3. Authors
        • Import Author Narratives from Aeon (and other sources) into the Authors table
      4. Books
        • Further improve the time to regenerate Book Summaries. Took about 11 minutes on 07/04/2025, but should be under 5 minutes!
      5. Books/Papers
      6. Bridge
        • Correct NGS Recalculation: Incorporate 3-year limit
        • Develop auto-reconciliation routines vs EBU results download
          → In Progress
      7. Chess
        • Convert Chess Consolidated Results page to ELO Grading
      8. Documentation
      9. Documenter
        • Investigate the error reports from the Documenter, especially unused variables & queries.
          → On-Going
      10. Education
      11. Infrastructure
      12. Notes
        • Add "Note Alternates" to Note pages.
        • 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”.
        • As part of the Cross-Referencing project, check out the consistent treatment of Note 87552, which should be universally ignored. Recently, links to it appeared on web pages Book_Summary, BookPaperAbstracts and BooksToNotes, as a Note referencing a Book. The critical item was a row on the Note_Book_Links table.
        • 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 51353.
        • Bugs in Reference_Notes for embedded Notes in Papers & Books.
          1. "++ NP ++" links to previously linked note or Note 0 and causes Type Mismatch. Example54! Partly fixed?
          2. "++ space ++" in Footnotes Loops?
          3. "++ hash ++" gives Doc_ID missing & Type Mismatch
        • Check (in use) that the optional "don't print" feature for specific footnotes doesn't print other footnotes further down the chain. Probably OK.
        • Determine why very long printable notes (eg. Level 3+ for Note 17055) are being truncated. Probably suppress them in any case, as they take far too long to load.
        • Enable reproduction of archived Printable Notes.
        • Enhance comparative Ling database - Replace numerals by words in Vocabulary and Dialogues
          → In Progress
        • Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
        • 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)
        • Investigate the reintroduction of Printable Notes
        • Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
        • Reading Lists: Fix duplications:-
          1. Items "cited" and "categorised" (sometimes seem to) appear twice.
          2. Books and "single papers" of that Book both appear.
        • Suppress the publication of the Printable versions of Temp Notes
        • Very large printable Notes: eg. for Status: Summary56. Too large to be useful, and to transfer. Suppress for now, but investigate the whole idea and reinstate if possible.
      13. Papers
        • The monthly regeneration process for Paper Abstracts is still taking too long. Monitor! Last run: 1.42 hours on 07/04/2025.
        • When "+PnnnP+" reference used in an Object, allow "#Reference" style to be more specific where in the Paper Abstract the reference is.
      14. Photos
        • Timeline software57: Add photos for Holidays & Family History
        • Develop software & procedure to make adding more content to the photos pages easier to undertake.
      15. Process
        • Provide 'Quick' option for Recalculation (cmdRecalculate_Click) - exclude unnecessary items on request
        • The full Website Regeneration failed in Notes Regen because the first Private Note (13358) couldn't be copied from the Transfer directory as the private note hadn't been created there by then.
          1. It should have been, from looking at the code.
          2. Also, the private note itself (116359) is not regenerated until later.
          3. In the start-December 2019 run, no such problem occurred. So, I flagged it as complete, pending a recurrence.
          4. It recurred in the October 2023 run, but I didn't copy the error message. It hasn't recurred, so I've down-prioritised it.
      16. 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 pages63 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
        • As revealed by Spider: Consolidated Site-Hits Test Webpage. Mountnessing\index.htm Link. Should be .shtml.
        • Failed 'Printable Note' links not picked up by Spider: Especially in Blog
      17. Technology
        • Change URL for Page names to something meaningful: For Papers and Books. Needs to be short!
        • Convert site to HTTPS
        • Increase use of CSS Style Sheets
        • Look into Sistrix Smart64. 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: 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. Documentation
      6. 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.
      7. Facebook
      8. Notes
        • Allow the option to concatenate Notes in the Printable 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.
        • Fix problem with broken bespoke links to Printable 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)
      9. Status
        • Check how "YTD Planned %" is calculated - seems incorrect early in the Quarter if the plan varies during the year.
      10. Technology
        • Investigate the use of RTF in memo fields, so that I can get round the 64k character limit.
        • Read the Google documentation (Google - How to get your website on Google Search) 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 table69" cells? For categorised lists)
        • Enable use of Snippets for long Abstracts
      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
      6. Documenter
      7. Education
      8. General
        • Fix "American" date formats in Electronic Resources page
      9. Infrastructure
        • Move from My Photo Stream to iCloud by 26th July 2023. Not required!
      10. 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)
      11. Papers
        • Remove all large 'Comments' that have been utilised to expand Paper Abstracts (by moving them to Notes70). Cancelled and replaced by simply appending large (> 5k) Comments to Abstracts, so the work-around looks seamless.
      12. Photos
        • As revealed by Spider: Links failing in NotesPrint_1282_0_P_R.htm. 20 items.
      13. Technology
        • Create own local webserver
        • Increase use of Frames71
        • Investigate Wiki-technology (inc. Confluence, Plone CMS & Windows Help)
      14. 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 unprocessed72 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:-


Outstanding Developments by Category
  1. Own Website: Outstanding Items By Category:-
    1. Abstracts
      • Priority: 2
        • ID=17. Ensure some minimal data on Abstracts for Identity Papers Read
          → In Progress
    2. Aesthetics
      • Priority: 3
        • ID=173. Undertake a trawl through all (categories of) web-page, making aesthetic improvements, and correcting content.
    3. Architecture
      • Priority: 1
        • ID=193. Complete XRef-re-engineering project:-
          1. Ensure all links and link-pages use the new XRef table, and pension off the old tables where appropriate.
          2. Check all link-types still work and fix any errors.
          3. Complete the auto-triggering of regeneration of “associated” link pages.
          4. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
          5. Complete Documenting65 the process!
      • Priority: 2
        • ID=315. Where possible, use ID rather than NAME for in-page hyperlinks
        • ID=393. Document66, repair & update my Website site-map
          → In Progress
        • ID=68. Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
          → On-Going
        • ID=73. Improve flexibility of password-protected areas (ie. multiple areas, with different log-ons).
      • Priority: 3
        • ID=91. Add scrolling titles to Lists
      • Cancelled Developments
        • ID=466. Enable use of Snippets for long Abstracts
        • ID=90. Create expandable lists in Abstracts, Notes ("Plus table75" cells? For categorised lists)
    4. Authors
      • Priority: 1
        • ID=595. Creep-check for duplicate authors & fix
      • Priority: 2
        • ID=476. Import Author Narratives from Aeon (and other sources) into the Authors table
      • Cancelled Developments
        • ID=341. 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
        • ID=219. Review architecture to improve performance; Need to document67 first
        • ID=220. Determine why flag on directories "not to be backed up" gets reset
        • ID=232. Investigate historic error messages
        • ID=350. 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.
        • ID=494. Document and enable regular running of the de-duplication function ('pruning') of the backup disk. Keep a full record of deleted duplicates.
        • ID=582. Incorporate new 5Tb WD Backup Drive into backup system.
        • ID=583. Sort out the contents of my C:Drives, OneDrive and Emails as documented in my Backup Documentation
        • ID=584. Enable Backups to be undertaken on both my PC & Laptop and write reconciliation software.
      • Cancelled Developments
        • ID=355. 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: 2
        • ID=371. Further improve the time to regenerate Book Summaries. Took about 11 minutes on 07/04/2025, but should be under 5 minutes!
      • Work-arounds
        • ID=221. 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.
        • ID=222. 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.
        • ID=223. 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.
        • ID=224. Books - Referencing of Notes: The "+NnnnN+" method works from the Book Summary, "++nnn++" from Book Abstract, but neither vice-versa.
      • Cancelled Developments
        • ID=8. Create "Books by Subject" and "Books by Title" lists
    7. Books/Papers
      • Priority: 1
        • ID=508. For Books and Papers - add link pages - analogous to:-
          → BooksToNotes_
          → BookCitings_
          → PapersToNotes_
          → PaperCitings_
          linked to from:-
          → BookSummaries_
          → PaperSummary_
          and (maybe) from:-
          → BookPaperAbstracts_
          → Abstract_
          But, the links are FROM the Book / Paper, rather than TO
          For Books, ensure that all the links from all the Book's Papers are also included
        • ID=564. Sub-Topic ID has reached 996: What happens after 999? Research and Fix
        • ID=593. Import pdfs downloaded from "LRB - London Review of Books" into databases.
        • ID=599. Update LRB_Files table for "LRB - London Review of Books"
          → In Progress
      • Priority: 2
      • Priority: 3
        • ID=176. Review the effectiveness of the categorised reading lists for both Papers and Books.
        • ID=227. Introduce check that if a Book is flagged as "read" so are its Papers. Manual check completed in March 2018.
      • Cancelled Developments
    8. Bridge
      • Priority: 2
        • ID=351. Develop auto-reconciliation routines vs EBU results download
          → In Progress
        • ID=499. Correct NGS Recalculation: Incorporate 3-year limit
      • Priority: 3
        • ID=311. Hand-Dealing:
          1. Some hands not showing in consolidated lists
          2. Bidding sometimes missing for SD (maybe connected)
    9. Chess
      • Priority: 2
        • ID=451. Convert Chess Consolidated Results page to ELO Grading
    10. Documentation
    11. Documenter
      • Priority: 2
        • ID=190. Investigate the error reports from the Documenter, especially unused variables & queries.
          → On-Going
      • Priority: 3
        • ID=172. 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.
        • ID=194. Separate Documenter from the main database & code, then add a parameter so it doesn’t necessarily document itself.
        • ID=195. Investigate & fix “Query Fragments” issue.
      • Priority: 5
        • ID=196. 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.
      • Cancelled Developments
    12. Education
    13. Facebook
    14. General
      • Cancelled Developments
        • ID=29. Fix "American" date formats in Electronic Resources page
    15. Infrastructure
      • Priority: 1
        • ID=477. Migrate from Chrome to Bitwarden for password management
        • ID=576. Fatal Database Errors: ‘Cannot open any more databases: Run-time error 3048’.
          1. When I then try to compact and repair the database - the first port of call when there's a strange problem - it complains that it is locked by the Administrator. Then the database won’t close and has to be zapped by Task Manager. Only then can I delete the lock file, but this doesn't resolve anything as the problem recurs. I think the 'too many databases' error message is misleading.
          2. This started on Tuesday 27th August 2024 with Bridge_Web_Generator.accdb on Desktop. I stopped running it thereon and it was fine for a day on my Laptop, then the problem recurred.
          3. Looking on-line, this seems to be a known Microsoft bug for which a fix is awaited. It looks like the garbage dispoal routines (after set db = nothing) aren't working. It's not just where you're sloppy and don't do this and rely on the system to do garbage collection: I did changes to 'Small Systems' processing, but it made no difference.
          4. My main 'Thesis' database is working fine - I managed a full Regeneration starting late on 31st August. It may be that the bug was fixed under Windows 11 but not Windows 10. However, I'm not taking the risk of running my Bridge database on my Desktop in case it mucks up my Thesis database. The failure of Compact / Repair of my Bridge database is particularly worrying, but my Thesis databse C/Rs fine on my Laptop (and Desktop). This is a relief, as this database becomes unusable after a few days otherwise as it reaches the 2Gb limit
          5. Currently I'm waiting and seeing. Re-importing all the elements into a new Bridge database made no difference.
      • Priority: 2
      • Cancelled Developments
        • ID=506. Move from My Photo Stream to iCloud by 26th July 2023. Not required!
    16. Notes
      • Priority: 1
        • ID=414. Upgrade Auto_Reference_Notes to reference Sub-Notes: Used to only affect one note - Somerset Maugham - but now may be urgent
        • ID=458. Determine why all my Status Reports from September 2021 are missing from Notes_Archive. Seek to recover them from backups.
        • ID=468. Develop method for (manually) deleting otiose Archived Notes: ie. ensure links work for remaining Notes!
        • ID=475. Correct processing for 'References & Reading List' section in Thesis - References108. There are over 7,000 but only 7 items appear!
        • ID=498. PID Thesis References - De-duplicate / suppress and / or change sort order / aggregation for non-anthology book chapters
        • ID=500. Enhance PID Note, Book & Paper Usage109 to include a section listing works cited in my Thesis but not read
        • ID=512. Notes_Links: Segment & Provide Jump Table (Eg. For Thought110)
        • ID=543. Allow the option to embed blocks of re-usable text in Notes (ie. linearly embed them essay-style) rather than using hyperlinking. Slightly analogous to Note_Snippets or Sub_Notes, but more flexible.
          1. For use as "disclaimers".
          2. The identical block of text in the Dashboard111 to that in the Note Thesis - Method & Form112 that describes the Thesis.
          3. For Thesis / essays: the difficulty here is the need for linking passages to make the text run smoothly.
          4. As a more controllable alternative to 'Printable Notes'.
        • ID=545. When using the '#' reference to Notes, allow the omission of the Note ID for links within the same Note.
        • ID=572. Update Personal Page113 & Home Page
        • ID=87. Investigate Note_Links: Section references seem to be incorrect
      • Priority: 2
        • ID=104. Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
        • ID=170. Determine why very long printable notes (eg. Level 3+ for Note 170114) are being truncated. Probably suppress them in any case, as they take far too long to load.
        • ID=178. Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
        • ID=188. Enable reproduction of archived Printable Notes.
        • ID=201. Bugs in Reference_Notes for embedded Notes in Papers & Books.
          1. "++ NP ++" links to previously linked note or Note 0 and causes Type Mismatch. Example115! Partly fixed?
          2. "++ space ++" in Footnotes Loops?
          3. "++ hash ++" gives Doc_ID missing & Type Mismatch
        • ID=225. Reading Lists: Fix duplications:-
          1. Items "cited" and "categorised" (sometimes seem to) appear twice.
          2. Books and "single papers" of that Book both appear.
        • ID=273. Add "Note Alternates" to Note pages.
        • ID=385. As part of the Cross-Referencing project, check out the consistent treatment of Note 875116, which should be universally ignored. Recently, links to it appeared on web pages Book_Summary, BookPaperAbstracts and BooksToNotes, as a Note referencing a Book. The critical item was a row on the Note_Book_Links table.
        • ID=422. 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 513117.
        • ID=441. Very large printable Notes: eg. for Status: Summary118. Too large to be useful, and to transfer. Suppress for now, but investigate the whole idea and reinstate if possible.
        • ID=504. Enhance comparative Ling database - Replace numerals by words in Vocabulary and Dialogues
          → In Progress
        • ID=568. Investigate the reintroduction of Printable Notes
        • ID=56. 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”.
        • ID=59. Improve Printable notes processing for "Temp" Notes (ie. produce a "_T" (& include all "_T"s), but leave standard prints free of "Temps".
        • ID=64. Investigate Notes Archiving - see if could re-create re-formatted if required from saved historical versions (but not fixed re directories)
        • ID=76. Check (in use) that the optional "don't print" feature for specific footnotes doesn't print other footnotes further down the chain. Probably OK.
        • ID=89. Suppress the publication of the Printable versions of Temp Notes
      • Priority: 3
        • ID=180. Fix problem with broken bespoke links to Printable Notes from Archived Notes.
        • ID=42. Improve reading-lists from Notes (ie. firstly PID, then all starting with topic from Philosophy Papers Full)
        • ID=61. Allow the option to concatenate Notes in the Printable 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.
        • ID=74. Improve flexibility of reading lists attached to printable version of Notes (different sort orders, priority items only, etc).
      • Cancelled Developments
        • ID=349. Create Functor to facilitate addition of Audio Files to Music Page (not sure why raised - see ID=348)
        • ID=53. Create "who's who" of respondents (will just be private notes)
    17. Papers
      • Priority: 1
      • Priority: 2
        • ID=228. When "+PnnnP+" reference used in an Object, allow "#Reference" style to be more specific where in the Paper Abstract the reference is.
        • ID=372. The monthly regeneration process for Paper Abstracts is still taking too long. Monitor! Last run: 1.42 hours on 07/04/2025.
      • Cancelled Developments
        • ID=187. Remove all large 'Comments' that have been utilised to expand Paper Abstracts (by moving them to Notes128). Cancelled and replaced by simply appending large (> 5k) Comments to Abstracts, so the work-around looks seamless.
    18. Photos
      • Priority: 1
      • Priority: 2
        • ID=189. Develop software & procedure to make adding more content to the photos pages easier to undertake.
        • ID=330. Timeline software122: Add photos for Holidays & Family History
      • Cancelled Developments
        • ID=339. As revealed by Spider: Links failing in NotesPrint_1282_0_P_R.htm. 20 items.
    19. Process
      • Priority: 1
        • ID=268. Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
      • Priority: 2
        • ID=352. The full Website Regeneration failed in Notes Regen because the first Private Note (133123) couldn't be copied from the Transfer directory as the private note hadn't been created there by then.
          1. It should have been, from looking at the code.
          2. Also, the private note itself (1163124) is not regenerated until later.
          3. In the start-December 2019 run, no such problem occurred. So, I flagged it as complete, pending a recurrence.
          4. It recurred in the October 2023 run, but I didn't copy the error message. It hasn't recurred, so I've down-prioritised it.
        • ID=467. Provide 'Quick' option for Recalculation (cmdRecalculate_Click) - exclude unnecessary items on request
    20. Spider
      • Priority: 1
        • ID=442. Investigate reduction in size of Web_Generator_Performance database that holds Raw_Links.
          1. Suppress MsgBox for 'Near to 2Gb' database size check (just use Debug).
          2. One-off deletion of rather useless links: EMail, TheosStyle.css, TT_ICO.png, #Top, ...
          3. Remove code that generates these links, and check them.
          4. Investigate removal of website 'root' (C:\Theo's Files\Websites\Theo's Website\) from Raw_Link and Full_Link. This would save 200Mb, but needs careful checking - especially against the Directory_Structure and related tables and code.
          5. If the above 'root' change is to go ahead - one-off updates + code changes required.
        • ID=505. Use Edge rather than Internet Explorer for External Links Spider (use Bing AI)
      • Priority: 2
        • ID=182. 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 pages134 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
        • ID=456. Failed 'Printable Note' links not picked up by Spider: Especially in Blog
        • ID=480. As revealed by Spider: Consolidated Site-Hits Test Webpage. Mountnessing\index.htm Link. Should be .shtml.
    21. Status
    22. Technology
      • Priority: 2
        • ID=175. Look into Sistrix Smart140. 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
        • ID=24. Increase use of CSS Style Sheets
        • ID=495. Convert site to HTTPS
        • ID=497. Change URL for Page names to something meaningful: For Papers and Books. Needs to be short!
      • Priority: 3
        • ID=168. Use generated Javascript to allow multi-level expandable / contractable lists in Notes and Paper Abstracts.
        • ID=171. 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.
        • ID=177. Investigate the use of RTF in memo fields, so that I can get round the 64k character limit.
        • ID=192. Read the Google documentation (Google - How to get your website on Google Search) to investigate where I’m going wrong in the (failure to) use META tags to ensure my stuff sorts correctly in the search engines.
      • Priority: 4
        • ID=48. Add page-hit counters
      • Cancelled Developments
        • ID=23. Increase use of Frames141
        • ID=35. Create own local webserver
        • ID=37. Investigate Wiki-technology (inc. Confluence, Plone CMS & Windows Help)
    23. WebRefs
      • Priority: 1
        • ID=217. 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.
        • ID=381. 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.
        • ID=405. Investigate WebRefs with Issue = 'URL Translated OK': does the translation really work? How?
        • ID=408. Find a way of recording Missing / Unknown Webrefs (eg. Webrefs 8395 and 8342 in Archived Notes 1292 and 1317) other than debug.print: create table, then suppress message for known problems
        • ID=548. Create a page showing the use of WebRefs more clearly. The pages accessed via Theo Todman's Web-Links Test Webpages are of little use other than as an audit. Also, there are many broken links not picked up by the Spider. Need pages that use meaningful names.
        • ID=575. Visitor Stats - cmdVisitorStats_Click (and following) - loops and requires 'DAO.DBEngine.SetOption dbmaxlocksperfile,1000000' to be typed in the Immediate window. Re-engineer.
      • Cancelled Developments
        • ID=183. Complete investigation and correction of broken “External” Links.
        • ID=226. The Spider was generating WebRefs. Procedurally, this ought not to have been possible.
          1. The major problem turned out to be because unprocessed142 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.
        • ID=30. Add collection of "non-identity" weblinks.
  2. Other Websites: Outstanding Items By Category:-
    1. Bridge
    2. Enigma


In-Page Footnotes:

Footnotes 63, 134: Footnotes 64, 140: Footnotes 69, 75: Footnotes 70, 128: Footnotes 71, 141: Footnotes 72, 142:

Table of the Previous 12 Versions of this Note: (of 35)

Date Length Title
07/04/2025 00:15:50 64305 Website - Outstanding Developments (2025 - March)
01/02/2025 00:28:48 66911 Website - Outstanding Developments (2024 - December)
11/07/2024 23:08:10 59418 Website - Outstanding Developments (2024 - June)
04/10/2023 21:59:02 44964 Website - Outstanding Developments (2023 - September)
06/07/2023 00:43:12 44030 Website - Outstanding Developments (2023 - June)
30/04/2023 01:06:14 43872 Website - Outstanding Developments (2023 - March)
10/01/2023 23:35:31 43511 Website - Outstanding Developments (2022 - December)
10/10/2022 22:32:10 42884 Website - Outstanding Developments (2022 - September)
03/07/2022 01:29:17 41656 Website - Outstanding Developments (2022 - June)
11/04/2022 00:01:26 42763 Website - Outstanding Developments (2022 - March)
03/01/2022 23:58:34 42576 Website - Outstanding Developments (2021 - December)
01/10/2021 13:17:46 42773 Website - Outstanding Developments (2021 - September)


Note last updated Reference for this Topic Parent Topic
03/05/2025 12:49:04 981 (Website - Outstanding Developments (2025 - May)) Status: Web-Tools (2025 - March)

Summary of Notes Referenced by This Note

CT Introduction Jen_070928 (Introductory) L. Messel & Co. PDFs Available on Local Website PID Note, Book & Paper Usage
Private Note Siliconisation Status: Consciousness Studies (2023 - September) Status: General Culture (2025 - March) Status: Personal Identity (2025 - March)
Status: Summary (2025 - March) Status: Summary Task List (2025: April - May) Status: Summary Task List (YTD: 24Q4 - 25Q2) Status: Thesis Dashboard (2025: May) Test Note - Auto-XRef
Theo Todman's Personal Page Thesis - Method & Form Thought Website - Progress to Date (2025 - May) Website Generator Documentation - Audio
Website Generator Documentation - Author Narratives Website Generator Documentation - Backups Website Generator Documentation - Book & Paper Summaries Website Generator Documentation - Book / Paper List Page Generator Website Generator Documentation - Book-Paper Abstracts
Website Generator Documentation - Bridge Website Generator Documentation - Citations Website Generator Documentation - Code Documenter Website Generator Documentation - Concatenated Notes Website Generator Documentation - Control Page
Website Generator Documentation - Create Notes Web Pages Website Generator Documentation - Cross-Referencing Website Generator Documentation - Development Log Website Generator Documentation - Electronic Resources Website Generator Documentation - Full Website Re-Gen
Website Generator Documentation - Functional Overview Website Generator Documentation - Language / Ling Pages Website Generator Documentation - Library Management Website Generator Documentation - Links & Link-Pages Website Generator Documentation - Monthly Reporting
Website Generator Documentation - New Items Website Generator Documentation - Note References & Reading List Website Generator Documentation - Paper Abstract Fixes Website Generator Documentation - Philosophers Index Website Generator Documentation - PID Note, Book & Paper Usage
Website Generator Documentation - Precis Export Website Generator Documentation - Printable Note Export Website Generator Documentation - Prune Website Website Generator Documentation - Site Map Website Generator Documentation - Spider
Website Generator Documentation - Table Lists & Searches Website Generator Documentation - Thesis Dashboard Website Generator Documentation - Thesis Technology Website Generator Documentation - Time Recording Website Generator Documentation - Timelines (Photos & Blog)
Website Generator Documentation - Visitor Stats        

To access information, click on one of the links in the table above.



Summary of Notes Citing This Note

Status: Web-Tools (2025 - March), 2 Theo Todman's Website Maintainance History Website - Progress to Date (2025 - May), 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 Website Generator Documentation - Control Page Website Generator Documentation - Functors, 2, 3, 4, 5, 6
Website Generator Documentation - Recalculation & Housekeeping Website Generator Documentation - Thesis Technology, 2, 3, 4, 5 Website: Maintenance Dashboard    

To access information, click on one of the links in the table above.



Text Colour Conventions

  1. Blue: Text by me; © Theo Todman, 2025



© Theo Todman, June 2007 - May 2025.Please address any comments on this page to theo@theotodman.com.File output:
Website Maintenance Dashboard
Return to Top of this PageReturn to Theo Todman's Philosophy PageReturn to Theo Todman's Home Page