Connect Server
Sync BoQ data across team members' machines — share price lists, work catalogs, norms via a central server.
Use case: team of 5-10 people working on the same project, each on a portion, needing shared unit prices / work catalogs.
4 commands in this group
DVD Cons → group Connection System has:
| Command | Purpose | License |
|---|---|---|
| Connect Server | Login + sync data from server | Premium |
| Disconnect | Disconnect, work offline | Free |
| Push Format | Push current file's format/style to server as template | Premium |
| Admin | Admin panel (admin role only) | Premium |
Connect Server
DVD Cons → group Connection System → click Connect Server.
Step 1 — First-time setup
Dialog asks for server info:
- Server URL — e.g.
https://server.dvdpm.net/api(provided by team admin). - Email + Password — your account on the server.
- Workspace — pick the team workspace (e.g. "Project A", "Hanoi BCH").
Click Login → server authenticates → returns JWT token (stored in registry).
Step 2 — Sync data
After login, the dialog shows available data sets on the server:
| Name | Type | Last updated | Action |
|---|---|---|---|
| PriceList_2026 | Sheet (Excel) | 2026-05-10 | [Download] |
| WorkCatalog | Sheet (Excel) | 2026-04-22 | [Download] |
| LaborNorms | Sheet (Excel) | 2026-03-15 | [Download] |
| Format_Macro_QS | Style template | 2026-05-12 | [Apply] |
Click Download → addin downloads sheet from server, inserts into the current workbook. Click Apply → applies style template (font, color, border) to the selected sheet.
Step 3 — Upload changes
If you've updated the local price list → click Push on the corresponding row → addin uploads sheet to server as the new version.
Conflict
If the server version is newer than yours (someone pushed before you) → addin shows a conflict dialog:
- Force overwrite — overwrite (loses others' changes).
- Pull theirs first — download theirs → manual merge → push again.
- Cancel — do nothing.
Disconnect
DVD Cons → group Connection System → click Disconnect.
Disconnect from server:
- Clear local JWT token.
- Stop heartbeat (every 4 hours).
- Already-downloaded sheets remain in the workbook (sync stops, data not deleted).
After disconnect, Connect Server / Push / Pull commands all fail until reconnected.
Push Format
DVD Cons → group Connection System → click Push Format.
Push current workbook's format/style to server as a shared template:
- Font, font size, color theme.
- Number format (defaults for VND money cells, m³, m², ...).
- Border style.
- Header row style (bold + background).
Server stores it as template "Style_Date_UserName" → other members can Pull and see the new format file.
Premium + Admin role
"Push Format" requires an active license + role "Editor"/"Admin" on the workspace.
Admin
DVD Cons → group Connection System → click Admin.
Admin panel (only Admin role can open):
Tab Users
- List users in workspace.
- Add user (email + role).
- Remove user.
- Change role (Viewer / Editor / Admin).
Tab Data sets
- CRUD price lists / catalogs / norms.
- View version history.
- Rollback old version.
Tab Audit log
- Change history (who did what, when).
- Filter by user / date / action.
Tab Workspace settings
- Workspace name.
- Logo upload.
- Default style template.
Backend infrastructure
DVDAddin Connect Server backend:
- Cloudflare Workers + D1 SQLite (same infra as license server).
- JWT auth (RS256).
- Per-workspace data isolation.
- Real-time conflict detection via ETag.
Self-hosting
Large enterprises can self-host the backend (open source planned for 2027). Currently uses dvdpm.net SaaS.
Account + API key management
- Server URL (default
https://server.dvdpm.net/api). - Save credentials (tick to skip login each time).
- Auto-sync interval (5/15/30/60 minutes).
- Conflict resolution default (Manual / Take theirs / Take mine).
License gating
| Command | Free | Activated/Trial |
|---|---|---|
| Connect Server | ✗ | ✓ |
| Disconnect | ✓ | ✓ |
| Push Format | ✗ | ✓ |
| Admin | ✗ | ✓ (admin role) |
Troubleshooting
"Cannot connect to server"
- Network → firewall / proxy blocking
server.dvdpm.net. - Wrong Server URL (check Preferences).
"Invalid credentials"
- Wrong email/password.
- Account locked by admin → contact admin.
"Sync conflict — both modified"
- Someone else edited the same sheet → choose resolve strategy (Force overwrite / Pull first / Cancel).
Slow sync
- Price list > 10,000 rows → upload/download takes 30s-2 min.
- Slow network → split sheet, sync in parts.
Related
- License — license enables sync.
- Preferences → Server — configure server URL + auto-sync.
- QS Tools — Show Formulas, Trace Lookup (data analysis after sync).