Feature · CSV Import
Weighbridge CSV import: map once, then drop and go.
Your weighbridge already records every load. Export the tickets, map the columns to WasteBolt once, and every file after that maps itself. Drop it in, check it, and your loads are ready to become WTNs.
- Any CSV layout, any column order
- Mapping saved after the first upload
- Duplicate tickets caught
How CSV import works.
The setup happens once. After that, a day’s tickets take a minute.
Export your tickets
Export the day’s tickets as a CSV or TXT file from your weighbridge or site software, the same report you probably run already.
Map the columns once
Tell WasteBolt which column holds the ticket, date, customer and weight. Anything that never changes, like your own site as the receiver, can be a fixed value.
Drop the file
From then on, drag the file in and the saved mapping applies itself. Check the preview, fix anything flagged and import.
WTNs, ready or nearly
With Auto-Create on, rows that pass every check become WTNs straight away. The rest wait in Flagged For Review, where Matching Templates fill in the gaps.
Set up once. Drop and go after that.
The first upload takes a few minutes. Every one after that is a file, a check and a click.
The first upload
- Type the column header for each field you want to import
- Set fixed values for anything that’s the same on every load
- Choose kilograms or tonnes, and save the mapping
- Optionally, add Matching Templates for your regular customers
Every upload after that
- Export the file from your weighbridge or site software
- Drop it into WasteBolt: the columns map themselves
- Skim the preview: duplicates and gaps are already flagged
- Import: ready rows become WTNs, the rest go to review
Checked before anything is imported.
Before a single row is imported, WasteBolt checks the file. Tickets you’ve imported before are flagged, repeats within the file are skipped, and rows missing a ticket number or weight are marked for you to fix.
With Auto-Create WTNs on, rows that pass every check become WTNs as soon as you import. For the rest, Matching Templates fill in the producer, carrier, EWC code and recovery or disposal code by rules you set, such as the customer name or product code. Submit them all in one go, or let the daily run do it.
Why sites stick with it.
No rekeying, no copy and paste, and no second system to keep in step with the weighbridge.
Any CSV layout
No fixed template or column order. WasteBolt reads the columns your software already exports and detects the delimiter for you.
Fixed values
Set a value once for every row, such as the receiving site or a carrier you always use, so details your weighbridge doesn’t export are never missing.
Mapped once, used every time
Your mapping is saved to the account and applied to every upload automatically. Update it if your export ever changes.
No ticket imported twice
Tickets already in WasteBolt are flagged and left unticked, and a ticket repeated in the same file is skipped automatically.
Gaps caught before import
Rows missing a ticket number or a weight are flagged in the preview. Fix them on the spot or leave them out.
Templates for the rest
Matching Templates add the right producer, carrier, EWC code and recovery code per customer or product, for records that need more than the file holds.
Where CSV import does the heavy lifting.
Sites that already weigh and ticket every load in another system. See how it fits yours.
Quarries
Inert waste in for restoration reported to Defra, aggregate sales kept out of it, and contaminated loads documented on the way back out.
See the use caseInert Recycling
Rubble, soils and planings in on WTNs and DWT, recycled aggregate and topsoil out as product once they meet the end-of-waste rules, rejects out as waste.
See the use caseTransfer Stations
Skips, tippers and trade vans through the gate, clean loads turned into WTNs and DWT submissions automatically, and every sorted fraction documented on the way out.
See the use caseLandfill Sites
Contract hauliers and treatment residues over the weighbridge, clean loads to Defra automatically, and leachate tankers documented on the way out.
See the use caseMRFs
Council rounds and commercial recycling in, graded bales out to every reprocessor, with tonnage by code on both sides for your returns.
See the use caseAnaerobic Digestion
Repeat slurry and food waste loads logged in one input, with or without a weighbridge, and every waste stream in and out of the plant in one place.
See the use caseWeighbridge CSV import FAQ.
What file formats can I import?
CSV and TXT files. There’s no required template or column order: you tell WasteBolt which column is which, once, and it detects the delimiter automatically. Each row needs a ticket number, a date, a producer and a weight.
Do I have to map the columns every time?
No. You set up the mapping once, under CSV Mapping, and it’s applied automatically to every upload. Importing then becomes drag, drop, check and go. If your weighbridge software changes its export, update the mapping.
Which weighbridge software does it work with?
Any system that can export its tickets to CSV or a delimited text file, which covers most weighbridge and site management software. If your software can produce a report you can open in Excel, it can almost certainly produce a file WasteBolt can import.
Will it import the same ticket twice?
Not by accident. WasteBolt checks every ticket number against your existing WTNs and the records waiting in Flagged For Review. Ones that are already there are flagged as “Already exists” and left unticked, and a ticket that appears twice in the same file is skipped.
Do imported loads become WTNs automatically?
They can. With Auto-Create WTNs switched on, any imported row that passes every check becomes a WTN straight away. Rows that need more detail wait in Flagged For Review, where Auto-Match assigns Matching Templates and Submit All Assigned creates their WTNs in one go. A daily auto-processing run can do that part for you too.
Do I need to install anything?
No. The import runs in your browser: export the file from your weighbridge or site software, then drag it into WasteBolt. There’s nothing to install on the weighbridge PC.
Does it submit to Defra’s Digital Waste Tracking service?
Once imported loads become WTNs, DWT Auto Submit sends the ready ones to Defra’s Digital Waste Tracking service in its daily run, or you can submit them in one click. The import itself doesn’t send anything to Defra.