The Import Hub lets you upload a CSV export from your weighbridge system and convert the records into WasteBolt waste movements. The process has three steps: upload your file, map your columns to WasteBolt fields, then review and stage the records before they become WTNs.
Overview: How the Import Process Works
- Upload — drop your CSV file
- Map — match columns to fields
- Review — stage and approve
Records are staged after Step 3 — they are not immediately turned into WTNs. A human review step (the Import Review queue) sits between staging and final WTN creation. This lets you catch errors, edit records, and approve only the records you want before they appear in your waste records.
Step 1: Upload Your CSV
Go to Import Hub
Navigate to Import Hub from the main menu, then click Import New Data.
Select a saved template (optional)
If you have saved column mapping templates from previous imports, they appear at the top of the upload screen. Selecting one before uploading means WasteBolt will automatically apply your saved column mappings when the file loads — no manual mapping needed for recurring imports.
Upload your CSV
Drag and drop your CSV file onto the upload area, or click to browse. WasteBolt accepts .csv and .txt files. Most weighbridge systems can export to CSV — check your system’s export or reports section.
Tip: There is no required template or fixed column order. WasteBolt reads whatever columns your weighbridge software exports and lets you map them to the right fields.
Step 2: Map Your Columns
After uploading, WasteBolt shows you each column from your CSV with sample values from the first few rows. For each column, choose which WasteBolt field it maps to using the dropdown. Two fields are required; the rest are optional.
Tip: Auto-map with Bolt. Click Auto-map with Bolt and Bolt AI will analyse your column headers and suggest the best mappings automatically. You can review and adjust any suggestions before continuing. Uses 1 Bolt credit.
Available fields to map to
| WasteBolt Field | Required | Notes |
|---|---|---|
| Company / Producer | Yes | Waste producer or customer name |
| Net Weight | Yes | Weight of waste only (kg or tonnes) |
| Haulier / Carrier | No | Transport company or driver |
| Consignee / Receiver | No | Waste receiving site |
| Product / Waste Name | No | Description of the waste type |
| Product Code | No | Internal product or EWC code |
| Gross Weight | No | Total weight including vehicle |
| Tare Weight | No | Vehicle weight (empty) |
| Date In | No | Arrival date/time — DD/MM/YYYY accepted |
| Date Out | No | Departure date/time |
| Ticket / Docket ID | No | Weighbridge ticket number |
| Vehicle Registration | No | Vehicle number plate |
| Comments / Notes | No | Any additional notes |
Weight unit
Tell WasteBolt whether the weights in your CSV are in kilograms or tonnes. WasteBolt stores all weights in kg internally and converts automatically.
Saving a mapping template
Once you have mapped your columns, click Save as New to save this mapping as a template. Next time you import from the same system, select the template on the upload screen and the mapping will be applied automatically.
You can mark a template as Default to have it pre-selected every time you open the import page. Templates can be updated, renamed, or deleted at any time.
Step 3: Review and Stage
Click “Preview Data”
Once all required fields are mapped, click Preview Data. WasteBolt applies your column mappings to every row and shows you a summary: total rows, valid rows, and any invalid rows (rows missing a company name or net weight).
Review and edit records
Expand any row to see all its mapped fields. If a row has an issue, you can edit it directly — fix the company name, correct the weight, or update any other field. Edited rows are re-validated automatically.
Select rows to import
Tick the rows you want to stage, or click Select All Valid to select everything without errors. The summary bar shows the total weight of your selection.
Click “Import N Rows”
Confirm the import. Your selected records are moved to the staging queue with status Staged. You are taken to the Import Review page automatically.
After Staging: Import Review
Staged records sit in the Import Review queue until you approve them. From there you can:
- Review each record and approve individually or in bulk
- Edit any field before it becomes a WTN
- Approve records to convert them into WasteBolt waste movements
- Delete records you do not want to import
Access the review queue at any time from Import Hub → Review Staged Imports. A badge on the card shows how many records are waiting.
Weighbridge Buddy: Auto-Processing (Beta)
Weighbridge Buddy Auto-Processing is available to account admins. It automatically matches staged records against your import templates and creates WTNs on a daily schedule — no manual review required for matching records. This is also referred to as Flagged For Review Auto Processing under Work Flows → Gate — see the Gate Settings section of the Using WasteBolt Gate guide for how it interacts with Auto Submit and Matching Templates.
To enable auto-processing, go to Import Hub and scroll to the Weighbridge Buddy section. Configure two settings:
| Setting | What it controls |
|---|---|
| Run Time | Choose the hour (UTC) for the daily auto-run. Runs once per day at that time. |
| Confidence Threshold | Controls which matches are auto-approved: Any match, Exact rules only, or Proven templates (3+ successful uses). |
You can also click Run Now to trigger a manual run at any time. The results show how many records were found, matched, skipped, and how many WTNs were created.
Warning: Weighbridge Buddy is in Beta. Records that do not meet the confidence threshold are left in the staging queue for manual review rather than auto-approved. Start with Any match while getting familiar with the feature, then tighten to Proven templates once your templates are well-established.
Frequently Asked Questions
What format does my CSV need to be in?
Any CSV or TXT format is accepted — there is no required template or column order. WasteBolt reads whatever columns are in your file and lets you map them. Delimiters are auto-detected. The only required data is a company/producer name and a net weight per row.
My weighbridge exports in tonnes — will WasteBolt handle that?
Yes. On the column mapping screen, toggle the weight unit to Tonnes. WasteBolt will multiply by 1,000 and store all weights in kilograms internally.
What happens to invalid rows?
Rows that are missing a company name or a valid net weight are flagged as invalid in the review step. Invalid rows cannot be selected for staging. You can edit them to fix the issues, or skip them and only stage the valid rows.
Can I import the same file twice by accident?
WasteBolt does not automatically detect duplicate imports. Be careful to track which files you have already imported. Each import is stored as a named batch so you can see recent imports in the Import Hub.
Does WasteBolt match imported records to my pick lists?
Not automatically during import — column mapping creates raw data records. Matching to your pick lists (for EWC codes, carrier details, consignee details) happens when you approve records in the review step and WasteBolt creates the WTNs.
How many rows can I import at once?
There is no hard limit on the number of rows per CSV file. Records are inserted in batches of 100 in the background, so large files may take a moment to process.
Can sub-users see imports?
Imports are visible to all users on the same account (admin and sub-users). Sub-users can run imports. Only the account admin can configure Weighbridge Buddy auto-processing.
What’s Next
- WasteBolt Gatehouse — desktop app for CSV watch, log job, and SQL sync. Automatically watch a folder, log loads manually, or sync directly from SQL Server — all from one app.
- Using WasteBolt Gate — Flagged For Review Auto Processing and other Gate Settings that relate to auto-processing.
- Setting Up Your Customer and Waste Types pick lists — pre-fill carriers, EWC codes and sites to complete WTNs after import.
- Set Up DWT in WasteBolt — once imported, submit records to the EA via Digital Waste Tracking.