Usage Import does not accept CSV files that are saved from Mac
Issue: Trying to upload Usage file that is saved on CSV format but Zuora seems not accepting it. Nothing is uploaded and notification if it was successful or failed.
Explanation: Mac Excel version is changing the date format on the CSV file. This means that if you enter a date on Usage's STARTDATE like 2/1/2012 and save as CSV, the date will be change into 2/1/12 --- the two digit year is not accepted therefore, the Usage upload will not accept it.
Our engineers are aware of the issue and DE8201 is tracking this defect.
Work around to consider: Instead of saving the Usage file to CSV, Mac Excel users can use XLS instead. Additionally, if you have OpenOffice, you can save the Usage file on CSV via OpenOffice.