katheryn-website/backlog/tasks/task-8 - Deploy-Directus-as...

4.6 KiB

id title status assignee created_date updated_date labels dependencies priority
TASK-8 Deploy Directus as Airtable/Lightroom replacement Done
2026-01-18 16:07 2026-02-13 22:04
high

Description

Set up Directus on Netcup RS 8000 to replace Airtable for product/content management and import Lightroom catalog with full metadata. This will serve as the backend for Katheryn's art website.

Acceptance Criteria

  • #1 Directus deployed on Netcup with Traefik routing
  • #2 PostgreSQL database configured for art catalog schema
  • #3 Lightroom catalog exported with full metadata
  • #4 Photos imported with EXIF/IPTC/XMP metadata preserved
  • #5 Collections/albums structure migrated
  • #6 Airtable data imported into Directus
  • #7 Katheryn can access admin UI at cms.katheryntrenshaw.com

Implementation Notes

Staging Deployment Complete

Waiting for katheryntrenshaw.com domain to be transferred to Cloudflare for production deployment.

Airtable Import Complete

Imported 299 items from Airtable CSVs:

  • 9 artworks (Fine Art)
  • 145 products
  • 145 IYOS participants

Collections created: artworks, products, contacts, iyos_participants

Additional Airtable Import Complete (2026-01-28)

Imported 1,506 additional items:

  • 20 pricing bands (fine art + products)
  • 75 locations (galleries, auction houses, studios)
  • 1,411 contacts (customers, press, organizations)

New collections created in Directus:

  • locations - galleries and venues
  • pricing_bands - standard pricing tiers
  • contacts - already existed, populated with data

Total data now in Directus CMS:

  • 9 artworks
  • 145 products
  • 145 IYOS participants
  • 75 locations
  • 1,411 contacts
  • 20 pricing bands

Remaining: Lightroom catalog export from Katheryn's computer

2026-02-03 Session Progress

Completed:

  • Migrated 938 artworks from Airtable to Directus (274 skipped as duplicates, 5 errors)
  • 1038 total artworks now in Directus
  • Uploaded 287 thumbnails to Directus and linked to artworks (70 unmatched)
  • 289 artworks now have images, 749 still without
  • Generated duplicate artworks PDF report (72 names with duplicates, 403 total duplicate records)
  • Imported 72 blog posts from Squarespace XML export
  • Enhanced About page with full Squarespace content
  • Recreated homepage from Squarespace HTML:
    • Full-screen hero with Katheryn portrait + testimonial overlay
    • YouTube video background for In Your Own Skin section
    • Book section with Amazon embed
    • Events, Wisdom Words, Instagram sections
  • Added Cynthia Trenshaw Poetry link to navigation (-> cynthia-staging.jeffemmett.com)
  • Removed duplicate newsletter signup from footer
  • Deployed to katheryn-staging.jeffemmett.com

Remaining:

  • 749 artworks still need images
  • Image processing: centering, color correction (see task-10)
  • Categorization of all artworks (see task-10)
  • Newsletter setup with Listmonk + Resend (see task-9)

2026-02-04 Session Progress

Completed:

  • Added event thumbnail images to homepage events section
  • Changed homepage, events, and store pages to dynamic rendering (force-dynamic) for reliable Directus data fetching
  • Created "Work With Me" pages matching original Squarespace site:
    • /passionate-presence-centre - Living Awake 12-part series, services, testimonials
    • /consulting - Hero image, approach section, testimonials, Rumi quote
    • /1to1 - Session types (individual/couples), what to expect, areas of focus
  • Added 4 images for Work With Me pages (passionate-presence.jpg, consulting.jpg, sessions-individual.jpg, sessions-couples.jpg)
  • Updated navigation dropdown to link to new pages
  • Added YouTube video embed to Breaking The Silence page (https://youtu.be/hpzvEQs9vEk)
  • All changes deployed to katheryn-staging.jeffemmett.com

Pages now complete:

  • Homepage (with events thumbnails)
  • Work With Me: Passionate Presence Centre
  • Work With Me: Consulting
  • Work With Me: 1-to-1 Sessions
  • Breaking The Silence (with video)
  • Events (dynamic from Directus)
  • Store (dynamic from Directus)
  • Gallery (from Directus)

Directus CMS fully deployed and operational at katheryn-cms.jeffemmett.com. Running in Docker on Netcup with PostgreSQL + Redis. Frontend connects via internal Docker network. API proxy route handles asset delivery. Auto-deploy webhook configured.