Hello.

No matter how i create a CSV file, i get this error.

I tried creating it though Excel, and i tried creating it simply by rightclicking on desktop, create new textfile and save as test.csv.

No matter what approach i use, i keep getting this error: "The uploaded file must be in CSV format. Expected MIME type is "text/csv", "application/vnd.ms-excel" given"

Comments

sillo created an issue. See original summary.

krystalcode’s picture

krystalcode commented

The error indicates that the uploaded file is an Excel file instead of a CSV file. Can you try exporting it to CSV via the Excel program (instead of saving it as CSV which might only alter the file extension but the file would still be an Excel file?). Can you open the file with a simple text editor?

ChrisGrewe’s picture

ChrisGrewe commented

I'm having the same issue, and it appears to be a Windows-based issue. Any time you're uploading from a Windows machine, it's going to send that mime type. Trying it from my iPad (same file), I did not have this problem because iOS encodes the mime type correctly.

utcbrij’s picture

utcbrij commented

I'm on a iMac and my matrix is simple, although I did also try the sample and got the same error: "The Price Matrix cannot be empty. Please upload a CSV file with the matrix entries". My csv file looks like this:

1,percentage,0.08,6,100

Would like to get this working ASAP. Any help is greatly appreciated.

utcbrij’s picture

utcbrij commented
Status: Active » Fixed

An update to Drupal 8.6.15 fixed this issue.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.