shift-roster-builder can turn an hourly sales export into staffing levels (--from-sales). Probing it with differently shaped made-up exports found two more ways a perfectly ordinary file read as nothing:
- Excel writes
sep=,as the first line of some CSVs. The reader took it for the header, found no sales column and returned zero rows. - Headers like
Net Sales (USD)orSales [GBP]did not match the column nameNet Sales, with the same result.
Both now read: the sep= line is skipped and a bracketed unit is dropped from the header before matching. Tests use made-up rows; a real till export is still the thing the project is waiting for.