Vonage Call Sync

Pull Company Summary Report call rows into local SQLite.

Recommended: Chrome extension (same profile)

See EXTENSION.md — runs in your normal logged-in Chrome.

# Terminal 1 — local receiver
.\.venv\Scripts\Activate.ps1
pip install -r requirements.txt
python -m vonage_sync.server

# Then load unpacked extension from .\extension in chrome://extensions
# Click "Sync calls now"

Alternative: Playwright sync

python -m vonage_sync sync

See below / older notes for Playwright CDP mode (more fragile).

Setup

cd C:\Users\MSPSA\Documents\STS\VonageProgram
python -m venv .venv
.\.venv\Scripts\Activate.ps1
pip install -r requirements.txt
playwright install chromium
copy .env.example .env

.env is already pointed at your Chrome profile:

• CHROME_USER_DATA_DIR=...\Google\Chrome\User Data
• CHROME_PROFILE_DIRECTORY=Default (skytransportsolutions.com)

How to sync (one command)

python -m vonage_sync sync

Or just:

python -m vonage_sync

Or double-click sync.bat.

That single command will:

1. Quit/relaunch your real Chrome profile with debugging if needed
2. Open Company Summary Report
3. Click All Calls (search icon)
4. Click Export to Excel
5. Import rows into data/vonage.db

Note: If normal Chrome is already open, sync will close it and reopen with debugging so it can attach to your logged-in profile. Save any work in other Chrome tabs first.

Import a manual Excel export

python -m vonage_sync sync --import-file path\to\export.xlsx

Stats

python -m vonage_sync stats

Browser modes (.env)

BROWSER_MODE	Meaning
cdp (default)	Attach to Chrome started with open-chrome
chrome_profile	Launch Chrome with your User Data (Chrome must be closed)
storage	Legacy isolated Playwright + cookie file

Schedule (later)

For unattended sync, either:

• Leave the debug Chrome running and schedule python -m vonage_sync sync, or
• Use BROWSER_MODE=chrome_profile and ensure no other Chrome is using that profile when the task runs.

Database

• calls — report rows (deduped)
• sync_runs — sync audit log

Next phases

• FastAPI login + analytics dashboard (reads DB only)
• Missed-call classification / assignment

Troubleshooting

Issue	Fix
CDP not reachable	Quit Chrome fully, run open-chrome, then sync
Blank/temp Chrome opened	Another Chrome was still using the profile — quit all, retry
Still sees login page	Log into Vonage once in the debug Chrome window
Export button not found	UI selectors need a tweak — run sync and share the error
Wrong profile	Set CHROME_PROFILE_DIRECTORY (e.g. Profile 1) in .env