How muhammad-usman-911/stampsheet-electronapp-videotoexcel works
StampSheet is an Electron desktop app that reads timestamp overlays in CCTV/NVR videos and exports a reviewable Excel log. The primary workflow is: users select local or cloud videos, the app resolves camera names and streams remote file pieces as needed, OCR analyzes video frames, and users review results before exporting or appending an Excel register. The app also maintains device-local history and supports updates. The source excerpts show the main-process analysis dispatch and source handling; UI-to-main IPC details are not shown, so those links are marked unverified.
Main entry points: main.js Electron controller · App.tsx App workspace · sources.js Source resolver · Sources.tsx Source browser
Components 20
User interface
- App workspace
ui/src/App.tsx - Source browser
ui/src/Sources.tsx - Video review
ui/src/VideoTable.tsx - Video queue
ui/src/useVideos.ts - History view
ui/src/History.tsx
Video sources
- Source resolver
src/sources.js - Range stream bridge
src/streamBridge.js
Analysis and export
- Video OCR
src/videoMeta.js - Excel writer
src/excel.js
Cloud accounts
- MEGA account
src/megaAccount.js - Drive account
src/driveAccount.js
Device services
- Electron controller
main.js - Local history
src/history.js - Update service
src/updates.js
Other components
- User
- Local videos
- MEGA
- Google Drive
- Excel register
- GitHub Releases
Connections 22
- User → App workspace: uses
README.md - App workspace → Source browser: renders
ui/src/App.tsx - App workspace → Video review: renders
ui/src/App.tsx - App workspace → Video queue: uses
ui/src/App.tsx - App workspace → History view: renders
ui/src/App.tsx - Source browser → Electron controller: requests sources
- Video queue → Electron controller: requests analysis
- History view → Electron controller: requests history
- Local videos → Electron controller: selects videos
main.js - Electron controller → Source resolver: resolves sources
main.js - Source resolver → MEGA account: reads account data
src/sources.js - Source resolver → Drive account: lists Drive videos
src/sources.js - MEGA → MEGA account: authenticates and lists
README.md - Google Drive → Drive account: authenticates and lists
README.md - Electron controller → Range stream bridge: creates stream URLs
main.js - Electron controller → Video OCR: analyzes video
main.js - Range stream bridge → Video OCR: serves byte ranges
- Electron controller → Local history: records reads
main.js - Electron controller → Excel writer: writes export
main.js - Excel writer → Excel register: writes workbook
README.md - Electron controller → Update service: checks updates
main.js - Update service → GitHub Releases: gets releases
README.md