HarnessTube Broadcast Run Manual

Overview

This manual describes the operational workflow used to prepare and run HarnessTube race graphics during a broadcast.

Step 1 – Import Race Cards

1. Open the USTA race card in your browser.
2. Press CTRL + U to open page source.
3. Press CTRL + A then CTRL + C to copy the HTML.
4. Open the USTA Import Tool from the Control Center.
5. Paste the HTML into the importer.
6. Click Import Races.
7. Review the race preview.
8. Click Send Race Card to Google Sheet.

Step 2 – Verify Program

After the printed program becomes available, verify the imported race card.

Correct any discrepancies directly in the Google Sheet.

Step 3 – Publish Track Tab

Each track tab must be published to generate a CSV feed for the broadcast dashboard.

Google Sheets → File → Share → Publish to Web Select Track Tab Format: CSV

Step 4 – Map Track in PHP

Open the file:

import_sheet.php

Copy an existing track entry and update the track name and GID.

Step 5 – Broadcast Operation

During the broadcast the operator uses the Overlay Dashboard.

Emergency Fallback

If a track mapping fails, rename the Google Sheet tab to TEST and load the TEST location in the dashboard.