Theo Todman's Web Page

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

Status Reports - Website - Outstanding Developments

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.
        2. Check all link-types still work and fix any errors.
        3. Complete the auto-triggering of regeneration of “associated” link pages.
        4. Fix update bug in Convert_Webrefs.
        5. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
      2. Architecture (On-Going): Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
      3. Authors: Authors Narrative: enable footnotes.
      4. Backups: Review architecture to improve performance; Need to document first
      5. Books/Papers: Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
      6. Documenter: Create Functor using Form_Documentation_Links to automatically add control-links to documentation Notes.
      7. Documenter (In Progress): Provide Functional Documentation for Website Generator (using Notes)
      8. Education: Investigate Bootstrap.
      9. Education: Plan what to do with "Sitepoint (Learnable) - Sitepoint Learnable Web Development Courses" and the eBooks in my possession.
      10. Education (In Progress): Read "PC Pro - Computing in the Real World".
      11. Education (In Progress): Read "Barnes (Russell), Ed. - Web Designer".
      12. Education: Re-start "Harvard University - CS50 Introduction to Computer Science" (consider accreditation).
      13. Education: Understand Bitcoin & Blockchain better
      14. Footnotes: Enable the re-use of Footnotes in the same Note3. Currently, they appear twice.
      15. General: Tidy up Site - delete un-updated pages (especially old Printed Notes).
      16. Notes: Add "Note Alternates" to Note pages.
      17. Notes: Allow the option to concatenate Notes in the Printed version (ie. linearly embed them essay-style), rather than treating the hyperlinks as footnotes – but still keep the hyperlink & cross-referencing in place.
        1. For use as "disclaimers" - eg. for "Plug Notes".
        2. For Thesis / essays: the difficulty here is the need for linking passages to make the text run smoothly.
      18. Notes (In Progress): Create automatic4 key-word referencing (ie. to Notes in the Notes-Group "Personal Identity")
      19. Notes: Create auto-regen of all Note_nnn_Links
      20. Notes: Ensure FN referencing within Notes and referencing between Abstracts and Notes works for archived Notes.
      21. Notes: Investigate Note_Links: needs versioning, and section of calling Note
      22. Notes: Investigate Note_Links: Section references seem to be incorrect
      23. Notes: Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
      24. Notes: Suppress the publication of the Printable versions of Temp Notes
      25. Papers (In Progress): Create password-protected area to hold pdfs, and links thereto.
      26. Photos: Add photos of Tom - Create Timeline software
      27. Photos: Develop software & procedure to make adding more content to the photos pages easier to undertake.
      28. Process: Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
      29. Spider: Determine why copying of data back to the slave database takes so long - approx. 3.5 hours. May need to re-architect.
      30. Status: Add extra items to Functors to facilitate Quarterly Reporting.
      31. WebRefs: Documentation & Bug-fixes: Phase 2
        1. Re-document the procedures in the light of recent changes.
        2. Resolve issues generated / revealed by the spider.
        3. Investigate - and fix where possible - broken links.
    • Priority: 2
      1. Abstracts (In Progress): Ensure some minimal data on Abstracts for Identity Papers Read
      2. Architecture: Improve flexibility of password-protected areas (ie. multiple areas, with different log-ons).
      3. Backups: Determine why flag on directories "not to be backed up" gets reset
      4. Backups: Investigate historic error messages
      5. 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”.
      6. Notes: Bug: "++ NP ++" links to previously linked note or to (non-)Note 0. Example!
      7. 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.
      8. Notes: Enable reproduction of archived “Printed Notes”.
      9. Notes: Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
      10. Notes: Improve Printable notes processing for "Temp" Notes (ie. produce a "_T" (& include all "_T"s), but leave standard prints free of "Temps".
      11. Notes: Investigate Notes Archiving - see if could re-create re-formatted if required from saved historical versions (but not fixed re directories)
      12. Notes: Reading Lists: Fix duplications:-
        1. Items "cited" and "categorised" (sometimes seem to) appear twice.
        2. Books and "single papers" of that Book both appear.
      13. Notes: Solve the problem of the size limitation for Notes (eg. by allowing their concatenation, but check in Access 2013 first).
      14. Papers: Remove all large “Comments” that have been utilised to expand Paper Abstracts (by moving them to Notes7).
      15. Papers: When "+PnnnP+" reference used in an Object, allow "#Reference" style to be more specific where in the Paper Abstract the reference is.
      16. Spider: Analyse the results of the data collection exercise and design a plan of campaign to fix broken “Internal” links and prevent recurrence.
      17. Spider: Correct the code so the problems discovered by the Spider don’t recur.
      18. Spider: Delete “orphan pages” that are never linked to, ie. Use the Spider to “prune” redundant pages automatically where possible.
      19. Spider: Fix the historical data where errors are uncovered by the Spider (no simple task to automate).
      20. Technology: Increase use of CSS Style Sheets
      21. WebRefs (In Progress): Complete investigation and correction of broken “External” Links.
    • Priority: 3
      1. Aesthetics: Undertake a trawl through all (categories of) web-page, making aesthetic improvements, and correcting content.
      2. Architecture: Add scrolling titles to Lists
      3. Authors: Enable "alternate names" for identically-named authors (to avoid middle-initial = X).
      4. Books/Papers: Introduce check that if a Book is flagged as "read" so are its Papers. Manual check completed in March 2018.
      5. Books/Papers: Review the effectiveness of the categorised reading lists for both Papers and Books.
      6. Documenter: Investigate & fix “Query Fragments” issue.
      7. Documenter: Investigate the error reports from the Documenter, especially unused variables & queries.
      8. Documenter: Separate Documenter from the main database & code, then add a parameter so it doesn’t necessarily document itself.
      9. 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.
      10. Facebook: Upgrade my Facebook page ("Facebook - Understand Facebook & Build Personal Facebook Page") using "Abram (Carolyn) - Facebook for Dummies: Fifth Edition" for inspiration / guidance.
      11. Notes: Add “Date Created” to Note_Links (for audit purposes; I’m still not convinced that links disappear when they should).
      12. Notes: Determine why very long printable notes (eg. Level 3+ for Note 170) are being truncated.
      13. Notes: Fix problem with broken bespoke links to Printed Notes from Archived Notes.
      14. Notes: Improve flexibility of reading lists attached to printable version of Notes (different sort orders, priority items only, etc).
      15. Notes: Improve reading-lists from Notes (ie. firstly PID, then all starting with topic from Philosophy Papers Full)
      16. Status: Check how "YTD Planned %" is calculated - seems incorrect early in the Quarter if the plan varies during the year.
      17. Technology: Investigate the use of RTF in memo fields, so that I can get round the 64k character limit.
      18. Technology: Look into Sistrix Smart9.
      19. Technology: Read the Google documentation (Link (https://www.google.com/webmasters/)) to investigate where I’m going wrong in the (failure to) use META tags to ensure my stuff sorts correctly in the search engines.
      20. Technology: Use generated Javascript to allow multi-level expandable / contractable lists in Notes and Paper Abstracts.
      21. 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.
    • Priority: 4
      1. Technology: Add page-hit counters
    • Priority: 5
      1. Documenter: Technical Documenter:-
        1. Investigate possibilities of retailing the documenter.
        2. Enhance to document Macros.
        3. Look at ways of documenting other (MS Access) databases & trial on Northwind.
    • Work-arounds
      1. Books (Work-around): Book Comments: if there are explicit internal links to files in Book Comments, they cannot work both in the BookSummary and BookPaperAbstracts, which are at different directory levels. So, don’t put them in the Comments – only in the Abstract.
      2. Books (Work-around): Books - Referencing of Notes: The "+NnnnN+" method works from the Book Summary, "++nnn++" from Book Abstract, but neither vice-versa.
      3. Books (Work-around): Books by Location: the jump table led to an invalid location. I bodged the data, by deleting an unused location, and didn’t properly investigate.
      4. Books (Work-around): Books to Notes: There’s an issue if a Note changes from Secure to non-Secure, but I bodged the data and didn’t try to fix it.
    • Cancelled Developments
      1. Architecture: Create expandable lists in Abstracts, Notes ("Plus table11" cells? For categorised lists)
      2. Books: Create "Books by Subject" and "Books by Title" lists
      3. Books/Papers: Create list of "Identity" papers - and books - to obtain (ie. the "zzz"s)
      4. Books/Papers: Create Second-Level Jump (+ maybe split pages) for Philosophy / Identity Papers / Books Full - similar to Blackberry pages
      5. Books/Papers: Determine more efficient method of updating "Books to Papers", "Papers to Notes" and "Books to Notes" - use archiving
      6. General: Fix "American" date formats in Electronic Resources page
      7. Notes: Create "who's who" of respondents (will just be private notes)
      8. Technology: Create own local webserver
      9. Technology: Increase use of Frames12
      10. Technology: Investigate Wiki-technology (inc. Confluence, Plone CMS & Windows Help)
      11. WebRefs: Add collection of "non-identity" weblinks
  2. Other Websites: Outstanding Items By Priority:-
    • Priority: 1
      1. Bridge: Create "Small Sites" database for Alaric
      2. Enigma (On-Going): Termly updates to the Enigma Ensemble (http://www.enigmaensemble.co.uk/) Website.
      3. Sophie (On-Going): Periodic updates to Sophie Botros: Live Site (http://www.sophiebotros.com/)
    • Cancelled Developments
      1. Bridge: Run Eve Goblets - if asked!


  1. Own Website: Outstanding Items By Category:-
    • Abstracts
      1. Priority 2 (In Progress): Ensure some minimal data on Abstracts for Identity Papers Read
    • Aesthetics
      1. Priority 3: Undertake a trawl through all (categories of) web-page, making aesthetic improvements, and correcting content.
    • Architecture
      1. Priority 1: Complete XRef-re-engineering project:-
        1. Ensure all links and link-pages use the new XRef table, and pension off the old tables.
        2. Check all link-types still work and fix any errors.
        3. Complete the auto-triggering of regeneration of “associated” link pages.
        4. Fix update bug in Convert_Webrefs.
        5. Fix Bug whereby PaperSummary pages seem to have “Works-” and “Books/Papers-” Citings that refer to the same link-pages.
      2. Priority 1 (On-Going): Review effectiveness of hyperlinking method in the light of PhD and Philosophy of Religion experience.
      3. Priority 2: Improve flexibility of password-protected areas (ie. multiple areas, with different log-ons).
      4. Priority 3: Add scrolling titles to Lists
      5. Cancelled: Create expandable lists in Abstracts, Notes ("Plus table13" cells? For categorised lists)
    • Authors
      1. Priority 1: Authors Narrative: enable footnotes.
      2. Priority 3: Enable "alternate names" for identically-named authors (to avoid middle-initial = X).
    • Backups
      1. Priority 1: Review architecture to improve performance; Need to document first
      2. Priority 2: Determine why flag on directories "not to be backed up" gets reset
      3. Priority 2: Investigate historic error messages
    • Books
      1. Work-around: Book Comments: if there are explicit internal links to files in Book Comments, they cannot work both in the BookSummary and BookPaperAbstracts, which are at different directory levels. So, don’t put them in the Comments – only in the Abstract.
      2. Work-around: Books - Referencing of Notes: The "+NnnnN+" method works from the Book Summary, "++nnn++" from Book Abstract, but neither vice-versa.
      3. Work-around: Books by Location: the jump table led to an invalid location. I bodged the data, by deleting an unused location, and didn’t properly investigate.
      4. 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.
      5. Cancelled: Create "Books by Subject" and "Books by Title" lists
    • Books/Papers
      1. Priority 1: Investigate whether multiple Subject/Topic/Subtopic usage leads anywhere (ie. are just the first (of 3) actually used). Fix anything amiss.
      2. Priority 3: Introduce check that if a Book is flagged as "read" so are its Papers. Manual check completed in March 2018.
      3. Priority 3: Review the effectiveness of the categorised reading lists for both Papers and Books.
      4. Cancelled: Create list of "Identity" papers - and books - to obtain (ie. the "zzz"s)
      5. Cancelled: Create Second-Level Jump (+ maybe split pages) for Philosophy / Identity Papers / Books Full - similar to Blackberry pages
      6. Cancelled: Determine more efficient method of updating "Books to Papers", "Papers to Notes" and "Books to Notes" - use archiving
    • Documenter
      1. Priority 1: Create Functor using Form_Documentation_Links to automatically add control-links to documentation Notes.
      2. Priority 1 (In Progress): Provide Functional Documentation for Website Generator (using Notes)
      3. Priority 3: Investigate & fix “Query Fragments” issue.
      4. Priority 3: Investigate the error reports from the Documenter, especially unused variables & queries.
      5. Priority 3: Separate Documenter from the main database & code, then add a parameter so it doesn’t necessarily document itself.
      6. 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.
      7. Priority 5: Technical Documenter:-
        1. Investigate possibilities of retailing the documenter.
        2. Enhance to document Macros.
        3. Look at ways of documenting other (MS Access) databases & trial on Northwind.
    • Education
      1. Priority 1: Investigate Bootstrap.
      2. Priority 1: Plan what to do with "Sitepoint (Learnable) - Sitepoint Learnable Web Development Courses" and the eBooks in my possession.
      3. Priority 1 (In Progress): Read "PC Pro - Computing in the Real World".
      4. Priority 1 (In Progress): Read "Barnes (Russell), Ed. - Web Designer".
      5. Priority 1: Re-start "Harvard University - CS50 Introduction to Computer Science" (consider accreditation).
      6. Priority 1: Understand Bitcoin & Blockchain better
    • Facebook
      1. Priority 3: Upgrade my Facebook page ("Facebook - Understand Facebook & Build Personal Facebook Page") using "Abram (Carolyn) - Facebook for Dummies: Fifth Edition" for inspiration / guidance.
    • Footnotes
      1. Priority 1: Enable the re-use of Footnotes in the same Note15. Currently, they appear twice.
    • General
      1. Priority 1: Tidy up Site - delete un-updated pages (especially old Printed Notes).
      2. Cancelled: Fix "American" date formats in Electronic Resources page
    • Notes
      1. Priority 1: Add "Note Alternates" to Note pages.
      2. Priority 1: Allow the option to concatenate Notes in the Printed version (ie. linearly embed them essay-style), rather than treating the hyperlinks as footnotes – but still keep the hyperlink & cross-referencing in place.
        1. For use as "disclaimers" - eg. for "Plug Notes".
        2. For Thesis / essays: the difficulty here is the need for linking passages to make the text run smoothly.
      3. Priority 1 (In Progress): Create automatic16 key-word referencing (ie. to Notes in the Notes-Group "Personal Identity")
      4. Priority 1: Create auto-regen of all Note_nnn_Links
      5. Priority 1: Ensure FN referencing within Notes and referencing between Abstracts and Notes works for archived Notes.
      6. Priority 1: Investigate Note_Links: needs versioning, and section of calling Note
      7. Priority 1: Investigate Note_Links: Section references seem to be incorrect
      8. Priority 1: Printable Notes: fix the bug whereby the “private” flag is round the wrong way.
      9. Priority 1: Suppress the publication of the Printable versions of Temp Notes
      10. 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”.
      11. Priority 2: Bug: "++ NP ++" links to previously linked note or to (non-)Note 0. Example!
      12. 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.
      13. Priority 2: Enable reproduction of archived “Printed Notes”.
      14. Priority 2: Fix bugs in multi-level footnoting in Printable Notes – the referencing is going wrong.
      15. Priority 2: Improve Printable notes processing for "Temp" Notes (ie. produce a "_T" (& include all "_T"s), but leave standard prints free of "Temps".
      16. Priority 2: Investigate Notes Archiving - see if could re-create re-formatted if required from saved historical versions (but not fixed re directories)
      17. Priority 2: Reading Lists: Fix duplications:-
        1. Items "cited" and "categorised" (sometimes seem to) appear twice.
        2. Books and "single papers" of that Book both appear.
      18. Priority 2: Solve the problem of the size limitation for Notes (eg. by allowing their concatenation, but check in Access 2013 first).
      19. Priority 3: Add “Date Created” to Note_Links (for audit purposes; I’m still not convinced that links disappear when they should).
      20. Priority 3: Determine why very long printable notes (eg. Level 3+ for Note 170) are being truncated.
      21. Priority 3: Fix problem with broken bespoke links to Printed Notes from Archived Notes.
      22. Priority 3: Improve flexibility of reading lists attached to printable version of Notes (different sort orders, priority items only, etc).
      23. Priority 3: Improve reading-lists from Notes (ie. firstly PID, then all starting with topic from Philosophy Papers Full)
      24. Cancelled: Create "who's who" of respondents (will just be private notes)
    • Papers
      1. Priority 1 (In Progress): Create password-protected area to hold pdfs, and links thereto.
      2. Priority 2: Remove all large “Comments” that have been utilised to expand Paper Abstracts (by moving them to Notes20).
      3. Priority 2: When "+PnnnP+" reference used in an Object, allow "#Reference" style to be more specific where in the Paper Abstract the reference is.
    • Photos
      1. Priority 1: Add photos of Tom - Create Timeline software
      2. Priority 1: Develop software & procedure to make adding more content to the photos pages easier to undertake.
    • Process
      1. Priority 1: Determine why Recalculation & Changed Book/Papers produce unneeded regeneration.
    • Spider
      1. Priority 1: Determine why copying of data back to the slave database takes so long - approx. 3.5 hours. May need to re-architect.
      2. Priority 2: Analyse the results of the data collection exercise and design a plan of campaign to fix broken “Internal” links and prevent recurrence.
      3. Priority 2: Correct the code so the problems discovered by the Spider don’t recur.
      4. Priority 2: Delete “orphan pages” that are never linked to, ie. Use the Spider to “prune” redundant pages automatically where possible.
      5. Priority 2: Fix the historical data where errors are uncovered by the Spider (no simple task to automate).
    • Status
      1. Priority 1: Add extra items to Functors to facilitate Quarterly Reporting.
      2. Priority 3: Check how "YTD Planned %" is calculated - seems incorrect early in the Quarter if the plan varies during the year.
    • Technology
      1. Priority 2: Increase use of CSS Style Sheets
      2. Priority 3: Investigate the use of RTF in memo fields, so that I can get round the 64k character limit.
      3. Priority 3: Look into Sistrix Smart21.
      4. Priority 3: Read the Google documentation (Link (https://www.google.com/webmasters/)) to investigate where I’m going wrong in the (failure to) use META tags to ensure my stuff sorts correctly in the search engines.
      5. Priority 3: Use generated Javascript to allow multi-level expandable / contractable lists in Notes and Paper Abstracts.
      6. Priority 3: Very long pages (eg. Concatenated Notes and Book Paper Abstracts) fail to render correctly in Firefox (mostly OK in other browsers). Investigate whether it’s possible to subdivide them.
      7. Priority 4: Add page-hit counters
      8. Cancelled: Create own local webserver
      9. Cancelled: Increase use of Frames22
      10. Cancelled: Investigate Wiki-technology (inc. Confluence, Plone CMS & Windows Help)
    • WebRefs
      1. Priority 1: Documentation & Bug-fixes: Phase 2
        1. Re-document the procedures in the light of recent changes.
        2. Resolve issues generated / revealed by the spider.
        3. Investigate - and fix where possible - broken links.
      2. Priority 2 (In Progress): Complete investigation and correction of broken “External” Links.
      3. Cancelled: Add collection of "non-identity" weblinks
  2. Other Websites: Outstanding Items By Category:-
    • Bridge
      1. Priority 1: Create "Small Sites" database for Alaric
      2. Cancelled: Run Eve Goblets - if asked!
    • Enigma
      1. Priority 1 (On-Going): Termly updates to the Enigma Ensemble (http://www.enigmaensemble.co.uk/) Website.
    • Sophie
      1. Priority 1 (On-Going): Periodic updates to Sophie Botros: Live Site (http://www.sophiebotros.com/)



In-Page Footnotes

Footnote 3:
  • This occurs in these reports, but possibly elsewhere.
Footnote 4:
  • This is complicated for a number of reasons:-
    1. There will be false positives, so there needs 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).
    3. The referencing differs depending on whether the term is in a Footnote or not.
    4. I'd need to check for already-existing links, variant grammatical forms, etc.
  • Maybe try this out using the case of "Supervenience".
Footnote 7:
  • Once the size-limitation on Notes has been resolved.
Footnote 9:
  • See Link (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Link (http://www.optimizr.com/).
  • 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 11:
  • I'm not sure what was intended here.
Footnote 12:
  • This is now archaic, and was subsequently largely abandoned, though useful at the time.
Footnote 13:
  • I'm not sure what was intended here.
Footnote 15:
  • This occurs in these reports, but possibly elsewhere.
Footnote 16:
  • This is complicated for a number of reasons:-
    1. There will be false positives, so there needs 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).
    3. The referencing differs depending on whether the term is in a Footnote or not.
    4. I'd need to check for already-existing links, variant grammatical forms, etc.
  • Maybe try this out using the case of "Supervenience".
Footnote 20:
  • Once the size-limitation on Notes has been resolved.
Footnote 21:
  • See Link (https://www.sistrix.com/smart/)
  • This used to be called Optimizr, see Link (http://www.optimizr.com/).
  • 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 22:
  • This is now archaic, and was subsequently largely abandoned, though useful at the time.


Note last updated: 19/06/2018 09:02:53



Text Colour Conventions

  1. Black: Printable Text by me; © Theo Todman, 2018
  2. Blue: Text by me; © Theo Todman, 2018


Return to Home page
Timestamp: 19/06/2018 09:02:30. Comments to theo@theotodman.com.