You can bring loads into WasteBolt from any weighbridge or site system that exports a CSV. Set up your column mapping once, telling WasteBolt which column holds what. After that, every upload maps itself: drop the file, check the rows, and import.

Both are on the Gate menu and are for admins only:

  • Gate → CSV Mapping: set up once
  • Gate → Import from CSV: use every time

Step 1: Set Up Your Column Mapping (Once)

Open Gate → CSV Mapping. For each WasteBolt field, choose where its value comes from:

  • From CSV: type the column header exactly as it appears in your file, such as “Ticket No” or “Nett Wt”.
  • Fixed: a value used for every row, such as your own site as the consignee, a carrier you always use, or a physical form that never changes.

Required fields

Three fields must be set before you can import, and they must come from your file because they’re different on every row:

Field Typical column
Unique Reference / Ticket ID Ticket number, docket number
Date & Time Received Date in, weigh date
Producer / Company Name Customer, account name

Every other field is optional: carrier, consignee and broker details, waste name, description, EWC code, physical form, container, recovery or disposal code, hazardous details, vehicle registration, gross, tare and net weight, and comments. Leave a field blank and you can fill it in later with a Matching Template or by editing the record.

Tip: The more you set here, the less there is to do later. Fixed values are the quickest win: if every load in the file comes to your site, set the consignee as a fixed value and you’ll never type it again.

Other settings

  • Weight Unit in CSV: kilograms or tonnes. WasteBolt stores everything in kg.
  • CSV has a header row: turn this off if your file starts with data on row 1. The header row is never imported as a load.

Click Save Mapping. It’s applied automatically to every upload from now on. If your weighbridge software changes its export, come back and update it.

Step 2: Upload Your File

Open Gate → Import from CSV. If the mapping is set up, you’ll see “Column mapping configured — upload your CSV and it will be applied automatically.”

Drag your file onto the upload area, or click to browse. WasteBolt accepts .csv and .txt files from any system, with no fixed column order. It detects the delimiter for you.

No export to hand? Use Download template CSV for a blank file with the right columns.

Step 3: Review the Rows

WasteBolt applies your mapping to every row and shows a summary: Total Rows, Valid, Invalid, Duplicate refs, Selected and Selected Weight.

Invalid rows

A row is invalid if it’s missing its ticket ID or has a missing or invalid weight. Expand the row to fix it, or leave it out.

Duplicates

WasteBolt checks every ticket ID before anything is imported:

  • Already exists: the ticket is already on a WTN or waiting in Flagged For Review. These rows are left unticked. Tick one by hand only if you really mean to import it again.
  • Duplicate ref: the same ticket appears more than once in this file. Only the first is imported. The repeats can’t be selected.

Select and import

Click Select All Valid (which leaves out invalid rows, duplicates and tickets that already exist), or tick rows yourself, then import.

What Happens After You Import

Imported rows go to Flagged For Review as records waiting to become WTNs, grouped as a batch named after your file.

If Auto-Create WTNs is switched on in your Gate workflow, any row that already passes every check becomes a WTN straight away. Rows that need more detail wait in Flagged For Review. When every row was ready, you’re told how many WTNs were created.

Drop-and-go: With a complete mapping (using fixed values for anything your weighbridge doesn’t export) and Auto-Create WTNs on, a day’s tickets can go from file to finished WTNs in one upload.

Filling in the rest

For rows that need more detail, such as a different carrier or EWC code per customer, set up Matching Templates. In Flagged For Review, Auto-Match assigns a template to each record that fits, and Submit All Assigned creates their WTNs in one go. Flagged For Review Auto Processing can do this for you once a day: see Gate Auto Processing.

Frequently Asked Questions

What format does my CSV need to be in?

Any CSV or TXT file. There’s no required layout or column order: you tell WasteBolt which column is which, once. Each row needs a ticket ID, a date, a producer and a weight.

My weighbridge exports in tonnes. Will WasteBolt handle that?

Yes. Set Weight Unit in CSV to Tonnes in your mapping. WasteBolt converts to kilograms.

Can I import the same file twice by accident?

Not without noticing. Tickets already in WasteBolt are flagged Already exists and left unticked, and repeats within a file can’t be selected.

What if my file has a column WasteBolt doesn’t need?

Ignore it. Only the columns you map are read.

How many rows can I import at once?

There’s no hard limit. Rows are saved in batches of 100, so a large file may take a moment.

Can drivers import files?

No. CSV Mapping and Import from CSV are for admins only.

Do I need WasteBolt Gatehouse?

No. Importing a CSV works entirely in your browser. WasteBolt Gatehouse is an optional desktop app if you’d rather have WasteBolt pick up files from a folder, or sync from SQL Server, automatically.

What’s Next