YouTube Transcript Indexer

Fetches all videos from The Arkansas eTraveler's channel, extracts transcripts, and matches station mentions (store numbers, city names) to specific timestamps. Run this periodically to keep the index up to date.

Index Status
Total Videos
109
Processed
109
Pending
0
Failed
0
Total Mentions
39
Stations Matched
23
Daily Auto-Indexer
The daily cron runs at 06:00 UTC. It has not run yet since the server last started.
Schedule: every day at 06:00 UTC
Run Indexer

This will fetch all unprocessed videos from the channel, extract transcripts, and match station mentions. Only new videos (not yet in the database) will be processed. This can take several minutes depending on how many new videos there are.

How It Works
  1. 1Fetches all video IDs from The Arkansas eTraveler's YouTube channel using the YouTube Data API.
  2. 2For each new video, downloads the auto-generated captions (TimedText XML) from YouTube.
  3. 3Scans the transcript for store numbers (#206, store 206, etc.) and city names.
  4. 4Records each match with the exact timestamp, so users can jump directly to the mention.
  5. 5Results appear as a 📺 badge in the station directory — click to expand the video list.