Master TNB/Trilliant

Browse and import tcm_records — serial, packaging, reel, and comments.

Total records —

tcm_records

Distinct serials —

Unique serial_number

Missing comments —

—

Last updated —

Newest updated_at

Excel import

Download the sample template, fill rows, then drop or browse one or more .xlsx files. Multi-value serial_number cells (comma, semicolon, pipe, or newline) expand to separate records. Parsing checks database and in-upload duplicates before you choose skip, update, or cancel. Large files (over 10,000 rows) analyze and import in server-side batches.

Download template

TCM not in Files/ADF —

View on Cross check

Files/ADF not in TCM —

View on Cross check

Extra asset rows —

Duplicate nested_serial_number

Net gap —

—

Nested serial records

Nested serial	Count	Meter serial	Asset ID	Customer	Source file	Created

—

Files in this import

File	Rows	Expanded	Missing key