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
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.

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.



