Theo Todman's Web Page - Notes Pages

Website Documentation

Website Generator Documentation - Timelines (Photos & Blog)

(Work In Progress: output at 01/06/2024 05:52:42)

Previous VersionsNote ReferencesNote Citations

This document covers1 the following functions performed by clicking buttons on the front screen:-

  1. Update / Output Timeline Pages (cmdTimelines_Click)

To see the Code, click on the procedure name above.


Detailed Processing – Maintenance of Static Data

Detailed Processing – Blog15

Detailed Processing – Coxes Farm Timeline21

Detailed processing – Generic Timelines
  1. Overview:
    • These use Functor_16 to generate the table in the webpage, using the MS Access tables Photos_Raw and Photo_Narratives.
    • This function is much more sophisticated than the items immediately above, and allows the importing of photos in bulk.
    • The names of photo JPEGs are copied from the selected directory into the table Photos_Raw, classified by (currently) one of three photo-types, reflecting the four options above, ie:-
      1. Coxes Farm Repairs23: “CoxesFarmRepairs”.
      2. Coxes Farm Pre-Repairs24: “CoxesFarmPreRepairs”.
      3. Coxes Farm Gardens25: “CoxesFarmGardens”. For some reason 9 of these have Timeline = “CoxesFarmGarden” (singular). These require investigation.
      4. Henry26: “Henry”.
    • Optionally, the photos themselves are copied to the Photos/Notes directory on the local copy of my website (they must be copied over manually to the live site).
    • Large and small copies of the same photo are matched up – using the string immediately before the “.jpg” to the preceding “_” (if any) – so that the small photo appears on the grid, for rapidity of loading, the large photo only being displayed on request.
    • I found a useful free utility – Mass Image Compressor – that can compress images in bulk. It works fine, and quickly.
    • The photos are segregated by month and displayed in descending date order. The date used is the “date taken” in the JPEG header, if there is one, otherwise a manually-entered date can be used. If both exist, the manually entered date takes precedence.
    • Within the month bands, a further segregation is allowed by photo-subgroup.
    • A narrative associated with each Month (or Subgroup within Month) can be entered to the Photo_Narratives table.
    • A jump-table (by Month, not sub-group) appears at the top of the page to allow easy access to, and an overview of, the timeline. The Narrative for the month appears as a pop-up.
    • An issue was display of portrait photos, which appeared as landscape in the grid, and when rotated distorted the grid unacceptably. I sorted this eventually, and flag such items – manually rotated using the standard Microsoft Photos utility – within Photos_Raw.
    • A final issue was the date the photo was taken. This can often be deduced from the JPEG header, using a modified version of a utility I found on-line (now incorporated into GetProperty). Otherwise, the date can be encoded in the file-name, or physically typed in to the Photos_Raw table.
  2. The following subroutines and functions are called into play:-
    1. Create_Timeline: This is the controlling routine, and will be covered in detail later.
    2. Compressed_Photos_Copy: This is a routine that copies already compressed images from a selected directory and copies them to another selected directory, prefixing the file name with “Small_”. The images can then be imported using Create_Timeline. This is just to save me the bother of pasting in “Small_” so many times and making errors!
    3. GetProperty: This is a modified version of a bit of freeware found on-line (originally in VB). It returns “Property n” from the JPEG header. I only use it with n=12, which is “date photo taken”. It is not always set.
    4. Photo_Copy:
    5. Photo_Copy2:
    6. Photo_Preparation:
    7. Images_Add:
    8. Functor_16: The processing of Functor_16 should be documented in my Note on Functors27, but it seems it’s just listed. As the processing works and is rarely used these days, further documentation isn’t a priority.
  3. Create_Timeline:
This Note is awaiting further attention28.

In-Page Footnotes:

Footnote 1:

Previous Version of this Note:

Date Length Title
05/04/2019 10:36:29 5168 Website Generator Documentation - Timelines

Note last updated Reference for this Topic Parent Topic
01/06/2024 05:52:43 1284 (Website Generator Documentation - Timelines (Photos & Blog)) Website Generator Documentation - Control Page

Summary of Notes Referenced by This Note

Awaiting Attention (Documentation) Coxes Farm Coxes Farm (Gardens) Coxes Farm (Pre-Repairs) Coxes Farm (Repairs)
Henry Theo Todman's Blog Website Generator Documentation - Functors Website Generator Documentation - Printable Note Export Website Generator Documentation - Printable Notes

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

Summary of Notes Citing This Note

Status: Priority Task List (2024 - May), 2, 3, 4 Status: Summary (2024 - March), 2, 3, 4 Status: Summary Task List (YTD: 23Q4 - 24Q2), 2 Status: Web-Tools (2024 - March), 2, 3, 4, 5 Website - Outstanding Developments (2024 - May), 2, 3, 4, 5, 6, 7, 8
Website Generator Documentation - Control Page Website Generator Documentation - Functors, 2, 3, 4      

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

Text Colour Conventions

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

© Theo Todman, June 2007 - June 2024.Please address any comments on this page to output:
Website Maintenance Dashboard
Return to Top of this PageReturn to Theo Todman's Philosophy PageReturn to Theo Todman's Home Page