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

## Description

<!-- SECTION:DESCRIPTION:BEGIN -->
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.
<!-- SECTION:DESCRIPTION:END -->

## Acceptance Criteria
<!-- AC:BEGIN -->
- [x] #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
- [x] #6 Airtable data imported into Directus
- [ ] #7 Katheryn can access admin UI at cms.katheryntrenshaw.com
<!-- AC:END -->

## Implementation Notes

<!-- SECTION:NOTES:BEGIN -->
## Staging Deployment Complete
- Directus CMS: https://katheryn-cms.jeffemmett.com
- Website staging: https://katheryn-staging.jeffemmett.com
- Admin email: katheryn@katheryntrenshaw.com
- Admin password: 9BHhUaHSQjefuAEaPqPyjerf

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.
<!-- SECTION:NOTES:END -->