WasteBolt Gatehouse — Your Weighbridge Side Companion
WasteBolt Gatehouse is a free Windows desktop app that sits on your yard office PC. Log loads directly, watch a CSV folder, or sync your SQL Server weighbridge database — all three paths stage records into WasteBolt automatically, ready for DWT submission.
v2.0.0 · Windows 10/11 · 64-bit · No admin rights required on most systems
How Gatehouse Works
Gatehouse bridges your weighbridge PC and WasteBolt. It supports three data sources — choose the one that matches your site's workflow. All three stage records into the same queue that appears on WasteBolt's Import Review page.
How WasteBolt Gatehouse works
Step 1 — Download & Sign In
Setup takes around 10 minutes. You'll need your WasteBolt login details and — for CSV mode — a sample CSV file from your weighbridge software.
Download WasteBolt Gatehouse
Click the Download button on this page or go to Settings → Integrations inside WasteBolt. Run the .exe on your yard office Windows PC.
Windows SmartScreen may show a warning because Gatehouse is a new app. Click More info → Run anyway to continue — this is normal for unsigned software.
Sign in with your WasteBolt account
Open Gatehouse and sign in with the same email and password you use on WasteBolt. No separate API key needed. Tick "Remember me" if this is a dedicated yard PC.
Step 2 — Choose Your Data Source
Go to Settings → Data Source and pick one of three modes. You can switch at any time.
Option A — CSV Watch Folder
Best for: any weighbridge that can export CSV files
Point Gatehouse at the folder your weighbridge software exports CSVs into. Gatehouse polls the folder on a configurable interval (default: 1 minute). When a new file arrives, every row is read, mapped to WasteBolt fields, and staged automatically. Processed files are moved to a processed/ subfolder — so nothing is ever submitted twice.
- In Settings → Data Source, select CSV Watch Folder.
- Set the Watch Folder path to the folder your weighbridge exports into.
- Click 📂 Load Sample CSV to auto-populate the column mapping from your actual CSV headers.
- Review the mapping, set any "Fixed for all" values (e.g. Means of Transport), then click Save.
- Return to the Sync tab and click Start Sync. The status indicator turns green when running.
Option B — Log Job (Direct Entry)
Best for: sites without a weighbridge, or when you want desktop-first entry
Log Job is a full-screen data entry form inside Gatehouse. Fill in vehicle, producer, waste type, weights, and all DWT fields — then submit. The record is staged immediately and appears in Staged Records for processing. No CSV needed, no browser needed.
- Click Log Job in the Gatehouse sidebar.
- Select the vehicle from your pick list (auto-fills carrier details).
- Choose producer, waste type, weights, and any DWT-specific fields (HP codes, POPs, etc.).
- Click Submit — the record is staged and visible in Staged Records instantly.
Enable Job Planning in Settings to allow drivers to plan jobs in advance. Gatehouse then shows an Active Jobs list — click Complete when the vehicle arrives to log the actual weights.
Option C — SQL Server Sync
Best for: Globeweigh, Avery Weigh-Tronix, and other SQL Server weighbridge systems
Gatehouse connects directly to your weighbridge's SQL Server database, running a SELECT query on a configurable interval. It tracks the last processed transaction ID — so only new records are staged on each poll. No CSV export required.
- In Settings → Data Source, select SQL Server.
- Enter your SQL Server address, database name, ODBC driver, and credentials (or tick Windows Authentication).
- Enter your SELECT query — alias columns to the standard WasteBolt field names (e.g.
CompanyName,NetKg,VehicleReg). See the Column Reference in the Gatehouse docs. - Set the poll interval (default: every 5 minutes).
- Click Save, then Start Sync. Gatehouse connects and stages any records newer than the saved watermark ID.
SQL Server sync requires ODBC Driver 17 for SQL Server (or later) installed on the same PC — download free from Microsoft. If the driver isn't found, the SQL Sync option remains unavailable in Settings but everything else works normally.
CSV Column Mapping
Column mapping tells Gatehouse which column in your CSV corresponds to which WasteBolt field. You only need to do this once — Gatehouse saves your mapping. The fastest way is to use 📂 Load Sample CSV, which reads your CSV headers and pre-populates all dropdowns.
Column Mapping — Settings → Data Source → Column Mapping
★ Required fields. Click 📂 Load Sample CSV to auto-populate the dropdowns from your actual CSV headers.
Fixed values ("Fixed for all")
Some fields are the same for every load through your gate — Means of Transport, Container Type, Receiver Site. Set these as fixed values in the mapping table and Gatehouse applies them to every row automatically, without needing a CSV column for them.
Import Templates — Filling in DWT Fields Automatically
Your weighbridge CSV probably doesn't contain EWC codes, carrier addresses, or hazardous property codes. Import Templates fill in those gaps. Each template matches staged records by company name, vehicle, product, or ticket ID — then applies a full set of producer, carrier, consignee, and waste details from your pick lists.
What a template provides
- Producer company details (name, address, EA number)
- Carrier details (reg no., address, means of transport)
- Consignee / receiver site details
- Waste type (EWC code, description, physical form)
- Disposal / recovery code
- Hazardous and POPs classification
- Season ticket linking for repeat loads
Matching rules
- Company Name equals / contains / starts with…
- Vehicle Reg equals…
- Product / waste name equals / contains…
- EWC code equals…
- Multiple rules can be combined on one template
- Priority order controls which template wins when multiple match
- Auto Match applies templates to all unmatched records in one click
Templates created or edited in Gatehouse are stored in the same wtn_import_templates table as the website — they work identically on both.
Staged Records — Review & Process
Every record from every source lands in Staged Records. This is where you review, match templates, edit any problems, and convert to WTNs.
✦ Auto Match
Runs your Import Templates against all unmatched records. Gatehouse checks each template's matching rules in priority order and assigns the best match. Auto Match never overwrites a manual assignment — it only touches records without a template. After matching, a summary shows how many matched and how many still need attention.
Review and filter
Filter records by status: Needs Attention (default), Matched, Processed, or All. Each row shows the company name, vehicle, waste, weight, date, and its DWT readiness badge — a quick indicator of whether the record has everything Defra needs for submission.
Edit a record
Click Edit on any unprocessed row to open the full edit form. Correct company name, vehicle reg, weights, dates, EWC code, hazardous classification, carrier details — everything. Save and it's updated in the staging queue immediately.
Process / Create WTN
Once a record is matched to a template and marked valid, click Process (or Process All Valid) to convert it into a WTN or season ticket docket. The record moves from Staged Records into your Waste Movements list. Processed records also appear in the DWT Submit tab, ready to be sent to Defra.
Duplicate detection: Gatehouse checks every incoming record against the staging queue before inserting. If a Ticket ID already exists, the row is flagged as a duplicate and skipped — you'll see it in the activity log. Duplicate rows in the current view are also highlighted in red with a warning banner.
DWT Submit — Send to Defra from the Desktop
The Submit tab shows all your processed WTNs and dockets pending Digital Waste Tracking submission. Gatehouse triggers the same auto-dwt-submitter function the WasteBolt website uses — so submissions behave identically whether you press Submit Now here or on the web.
Submit Now
Triggers a one-off DWT run — picks up to 50 pending records, validates each one against Defra requirements, and submits. Results appear in the log below.
Auto-submit schedule
Set a schedule (every N hours, or daily at a set time) so Gatehouse submits automatically without anyone clicking. Schedule resets on restart.
Flag Resubmit
Sets a record back to "pending" so the next Submit Now picks it up — useful when a submission failed due to a data error you've since corrected.
Credentials check
A banner at the top checks whether your Defra API Code is configured. If not, Submit Now is disabled — add your API Code in WasteBolt Settings → Integrations.