Skip to content
Coyote Measurement

Overview

Imports bring terminal data into Coyote Measurement so you can validate loads, reconcile volumes, run reports, and settle accounts — without copying data through Excel.

Coyote supports unified import: upload multiple files in one run (bay TransLog files, pipeline daily reports, and producer LACT spreadsheets). The system detects file types automatically, groups them into an import session for a production day, and walks you through review before data goes live.

What gets imported

CategoryExample file typesWhat Coyote creates
Bay / CarrierSmith Microload TransLog (.txt), Emerson ROC CSV, ABB Totalflow, OMNI Flow, HoneywellStaging transactions (truck loads) per bay
Pipeline readingDeep Fork PDF, VTScada CSV, OnPing CSVPipeline reading for the production day
Producer LACTProducer LACT Excel (.xlsx)External tickets with LACT allocation review

Import session

An import session is one import run for a facility and production day.

  • A session can contain multiple files (for example Bay 1, Bay 2, and a pipeline PDF for the same day).
  • Multi-day uploads create a group of sessions linked together; use the day navigator on the session page to move between days.
  • Each file becomes an import batch inside the session.

Import session page — approval readiness, volumes, and blocking issues

Production day

Coyote uses the facility’s operational day (typically 7 AM to 7 AM in the facility timezone) to assign report day and group data.

When you upload files, Coyote tries to detect the production day from file content. You confirm or override it before processing.

Multi-Day Import — trim date range when files span many days

Import status flow

Each session and batch moves through statuses as files are parsed, validated, and approved:

Uploaded → Parsed → Validating → Validated / Needs Review → Approved or Rejected
StatusMeaning
UploadedFiles received; processing started
ParsedFile parsed into staging rows
Validating / ValidatedRules and mappings checked
Needs ReviewWarnings or issues require attention before approve
ApprovedData promoted to live transactions and readings
RejectedImport discarded; re-upload corrected files
FailedParse or system error; see batch detail for messages

Permissions

ActionPermission
View import sessions and batchesfacility:imports:list
Upload and edit import rowsfacility:imports:upload
Approve or reject a sessionfacility:imports:approve

Your role must also include access to the facility shown in the app header.

Where to go in the app

  1. Select your organization and facility in the top bar.
  2. Open Imports in the sidebar.
  3. Use New Import to upload files, or open an existing Import Session to review and approve.

Import Sessions list with New Import button

End-to-end flow

flowchart TD
  A[Select facility] --> B[Upload files]
  B --> C[Auto-detect type, bay, and date]
  C --> D[Confirm mappings and production day]
  D --> E[Process import session]
  E --> F[Review and validate rows]
  F --> G{Blocking issues?}
  G -->|Yes| H[Fix rows, mappings, cross-bay, LACT]
  H --> F
  G -->|No| I[Approve session]
  I --> J[Live transactions and readings]
  J --> K[Reports, ledger, and reconciliation]