Of course, but that doesn’t solve the problem. The problem here is that two separate organizations with completely different software were communicating via CSV

Of course, but that doesn’t solve the problem. The problem here is that two separate organizations with completely different software were communicating via CSV file. There was a contractual obligation between them that required them to use specific units, but no technical collaboration. The problem was not in their software, but in the management and engineering discipline of the two groups.