The dispatch CSV uses “Time” twice. The first is the arrival time and the second is the clearance time. A mapping that lists only the name “Time” cannot distinguish them.

Record the export version and the complete header order. Then write the position and a nearby header for each duplicate.

Export: dispatch r6
Header order: Time, Item, Time, Result
- Column 1: Time, before Item → arrived_at
- Column 3: Time, after Item and before Result → cleared_at

An example mapping distinguishes column 1 Time before Item from column 3 Time before Result.

Example source map. Use positions and neighboring headers to disambiguate the same label.

Check a row with different values

Use a test row with 08:12 in the first Time column and 08:44 in the second. Confirm those values arrive in the right fields. If a new export adds a column, recheck the header order and fixture before reusing the saved mapping.

A test row routes 08:12 to arrived_at and 08:44 to cleared_at.

Example fixture. Different sample times make a reversed mapping visible.

Keep the mapping with the sample file so a reviewer can compare the actual header row with the note.