122 lines
4.6 KiB
Markdown
122 lines
4.6 KiB
Markdown
---
|
|
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 -->
|