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