---
type: this-week-with
url: 'https://taylordrayson.com/2026/11/20/tww-s7-e265'
title: 'Season 7, Episode 265'
date: '2026-11-20T13:00:00+00:00'
fields:
  episode: S7E265
  season: '7'
  number: '265'
  topic: 'FileMaker Pro database rebuild - Using Claude to migrate the old database - Automatic Google Maps venue lookups - Traffic-based departure time calculations - Fixing duplicate client records for repeat bookings - Fixing duplicate venue records - Taylor reviewing historic business data - Cleaning up Apple Calendar reminders - Reviewing client care plans from old emails - Tidying up Zoho Books - Merging duplicate contact records'
  duration: '17m 12s'
---

# Season 7, Episode 265

FileMaker Pro database rebuild - Using Claude to migrate the old database - Automatic Google Maps venue lookups - Traffic-based departure time calculations - Fixing duplicate client records for…

Back this week after missing last week due to family illness, filming from a new angle using Taylor's standing desk

Gordon has started rebuilding his FileMaker Pro booking database, which he's used since 1996

The old database needed replacing because FileMaker wasn't compatible with the next macOS update

Using Claude to read the FileMaker XML exports and build a replacement database from scratch

Adding features the old system didn't have, like automatic Google Maps venue lookups

Calculating what time to leave for a venue using historical traffic data for that specific day of the year

Fixing duplicate client records that happened when a repeat family booked for a different child

The new system tracks multiple children per family properly, making repeat-booking stats accurate

Solving duplicate venue entries, like two "All Saints Church Hall" venues in different areas

New venues can now be pulled automatically from Google's Places API when typing an address

Still need to sort out the print and letterhead side of the new system

Running the old and new databases side by side during the transition

Taylor has been reviewing historic business data spread across old project tools, emails and calendars

Deciding whether it's worth migrating old incomplete project data or starting fresh going forward

Adding recurring reminders for tasks that repeat biweekly, yearly, or on other schedules

Cleaning up Apple Calendar reminders that have built up over time

Digging through old client emails to confirm what care plans and terms were originally agreed

Only bringing active clients into the new system, not past ones who've left

Tidying up bookkeeping records in Zoho Books

Merging duplicate contact records when details change, like a client's maiden name after marriage

Using AI to scan old emails and pull out project history that was never properly logged

 

Visit the website: <a href="https://www.thisweekwith.co.uk">https://www.thisweekwith.co.uk</a>

Drayson Design Website – <a href="https://www.draysondesign.com">https://www.draysondesign.com</a>
The Creative Tinker Website – <a href="https://www.thecreativetinker.com">https://www.thecreativetinker.com</a>

Facebook: <a href="https://www.thisweekwith.co.uk/facebook">https://www.thisweekwith.co.uk/facebook</a>
Youtube: <a href="https://www.thisweekwith.co.uk/youtube">https://www.thisweekwith.co.uk/youtube</a>

* Full transcript will be available on the website. We may receive a referral fee from any of our links which help towards the costs involved in creating this content for you.

## See also

- Listen: [Listen](https://media.blubrry.com/thisweekwith/www.thisweekwith.co.uk/wp-content/uploads/this-week-with-taylor-gordon-podcast-265.mp3)
- Watch: [Watch on YouTube](https://youtube.com/live/LG9Skn7pX7k)
- All this week with: [This Week With](https://taylordrayson.com/this-week-with)
- That day: [20 November 2026](https://taylordrayson.com/2026/11/20)
