Media Mentions Import Plan

Created: 2026-01-22 Status: On hold - to be resumed later Source spreadsheet: https://docs.google.com/spreadsheets/d/1uOmmpNkyvTdxJuWukfCEmmy6OmMpFW3dxUy6BH2QAYo/edit?gid=889121273#gid=889121273 (tab: "Locals to port in")

Overview

Import 18 external article links as media_mention CPT entries on production California Forever site.

Key Findings

All 18 items are external links - the 4 URLs on solano.californiaforever.com all 301 redirect to The Reporter. No native content needs to be extracted from the old site.

Publications Referenced

Publication Count
Daily Republic 5
The Reporter 11
KRON4 1

URL Verification Results

The 4 solano.californiaforever.com URLs all redirect externally: - /david-cates-why-im-a-yes-on-california-forever/ → thereporter.com/2024/06/14/... - /mike-genest-the-solano-county-gap/ → thereporter.com/2024/05/24/... - /michael-fortney-lets-create-tomorrow-together/ → thereporter.com/2024/03/08/... - /annie-vogelpohl-california-forever-means-a-new-solano-county/ → thereporter.com/2024/03/07/...

Data Required Per Post

Each media_mention post needs:

Field Source Required
Post title Article headline Yes
quote_text Key quote/excerpt from article Yes
source_name "Daily Republic", "The Reporter", or "KRON4" Yes
article_url External URL Yes
date Publication date No
author Article author (if available) No
content_type "article" taxonomy term Yes
source_logo Publication logo (added manually) No

Implementation Plan

Step 1: Create Import Script

Location: content-import/import-media-mentions.php

The script will: 1. Loop through articles array (hardcoded data for all 18 articles) 2. Create media_mention post for each 3. Set ACF fields (quote_text, source_name, article_url, date) 4. Assign content_type: article taxonomy term 5. Log results

Step 2: Test Locally First

  1. Run script on local California Forever site
  2. Verify 18 posts created correctly
  3. Check posts appear in "In the Media" admin
  4. Test that links work

Step 3: Deploy to Production

  1. SSH to production via Flywheel
  2. Upload import script
  3. Run: wp eval-file content-import/import-media-mentions.php
  4. Verify posts created
  5. Delete script
  6. Add publication logos manually in wp-admin

Complete Article List (18 items)

# Title URL Source
1 Suisun Council accepts $55,000 California Forever grant dailyrepublic.com/.../article_648538a7-a61e-4e72-be84-0efbd73f75fc.html Daily Republic
2 California Forever looks to buy Suisun properties... dailyrepublic.com/.../article_83e4f527-239a-4bf9-bebd-71aa0229a975.html Daily Republic
3 The undeveloped 1,400 acres of riverfront near Collinsville... dailyrepublic.com/.../article_a12513c1-0e52-4bcd-8954-1540fe5000a0.html Daily Republic
4 Sramek speaks on shipyard dream thereporter.com/2025/04/24/... The Reporter
5 Prospective Collinsville port riding wave of interest, support dailyrepublic.com/.../article_e4cf5a71-efc1-48a9-9ae3-554f18a0da3e.html Daily Republic
6 California Forever planner speaks at UC Davis thereporter.com/2025/03/14/... The Reporter
7 Former head of Air Force air mobility joins California Forever dailyrepublic.com/.../article_a8ba287e-9e02-11ef-9fb6-233b74789947.html Daily Republic
8 California Forever unveils murals at Vista Theatre thereporter.com/2024/09/06/... The Reporter
9 Jason Russell: A call for sacrifice thereporter.com/2024/08/14/... The Reporter
10 Shivneil Prasad: A vote for hope and opportunity thereporter.com/2024/07/17/... The Reporter
11 Shanon Sloves: Money, value can go hand in hand thereporter.com/2024/06/27/... The Reporter
12 California Forever sponsor Rio Vista Clinic thereporter.com/2024/06/24/... The Reporter
13 Commentary: Time to say yes dailyrepublic.com/opinion/.../article_dbf53e5a-2fed-11ef-9521-7b42a17586c1.html Daily Republic
14 David Cates: Why I'm a yes on California Forever → thereporter.com/2024/06/14/... The Reporter
15 Mike Genest: The Solano County gap → thereporter.com/2024/05/24/... The Reporter
16 California Forever donates 500K to Solano County nonprofits kron4.com/news/bay-area/... KRON4
17 Michael Fortney: Let's create tomorrow together → thereporter.com/2024/03/08/... The Reporter
18 Annie Vogelpohl: California Forever means a new Solano County → thereporter.com/2024/03/07/... The Reporter

Note: Items 14, 15, 17, 18 use the redirect destination URLs (from solano.californiaforever.com → thereporter.com)

Decisions Made

Risks & Mitigations

Risk Mitigation
Production database corruption Test locally first, have Flywheel backup ready
Duplicate posts Script will check for existing posts by title before creating
Missing quote_text Using title as placeholder, can edit in wp-admin later

Next Steps (When Resuming)

  1. Write content-import/import-media-mentions.php with all 18 articles hardcoded
  2. Test script on local California Forever site
  3. Verify posts created correctly
  4. Deploy to production via Flywheel SSH
  5. Add publication logos manually