Signed in as admin
Upload a multi-page Imerys BOL PDF to extract BOL numbers, POs, and dates. Available BOLs appear in the operator's Imerys form as a dropdown. Used BOLs are marked automatically when logged.
Updates the car weight (and batch / type when provided) on existing railcars. Each row is matched by Railcar # + PO across both the queue and completed railcars. Rows that don't match anything are skipped — this upload never creates new railcars. Columns: Railcar #, Batch, PO, Net Weight, Type.
Attaches loads to existing railcars by PO. If the PO is sitting in the queue, that railcar is promoted to completed and the loads are added to it. If the PO doesn't exist anywhere yet, a new completed railcar is created from the row's CAR NO. + BATCH + PO (its weight stays at 0 until you fill it in via Step 1). Columns: Date, CAR NO., Load #, BATCH NO., PO NO., Gross, Tare, Net, Truck, Trailer, DRIVER.
Inserts rows directly into the Imerys loads log. Download the template to see the expected columns: Ship Date, BOL Number, Customer PO, Gross, Tare, Net, Truck, Trailer, Driver, Invoice.
Each finalized or uploaded railcar gets appended as a new row in a Google Sheet
(columns: timestamp, car #, ship date, batch, PO, tons, lbs, operator, truck, trailer, invoice).
Configure the GOOGLE_SA_KEY_PATH, GOOGLE_SHEET_ID, and optional
GOOGLE_SHEET_RANGE env vars, then click Test.
Add one name at a time. Duplicates are ignored.
Add one trailer ID at a time. Saved values are uppercased; duplicates are ignored.
Add one truck ID at a time. Saved values are uppercased; duplicates are ignored.