Magento

I’ve created a .csv file based on the type of information generated when exporting a tax rate—but I get an error of ”Invalid file format upload attempt” every time.

I’ve added quotes, I’ve removed quotes, I’ve tried an .xml file; I’ve tried every conceivable way to import—every time I get the same error. What am I doing wrong; how do I import tax rates successfully?

Thanks for the help in advance.

seems there’s a lot of people with same problem ...

Anything new with this topic? Using 1.1.1 and still not working.

maijar - 06 August 2008 10:14 PM

Anything new with this topic? Using 1.1.1 and still not working.

I haven’t tried 1.1.x yet, but it is probably the same issue as with 1.0. The problem is most likely the line breaks being used in your file. I use a Mac, so it saves it with Macintosh line endings. I don’t know if it works with DOS line breaks, but I switched my CSV file to use Unix line breaks and it worked right away after that. I don’t think you can do that within Excel, so you’ll have to use a text editor that can do the conversion for you.

On my Mac, I used BBEdit (you can use TextWrangler for free: http://www.barebones.com/products/textwrangler/ ). Just open up the .csv file, File > Save As..., and in the file dialog that pops up, click the Options… button to change line breaks to Unix.

I don’t know of a good option on Windows, but there might not be a problem if it handles DOS line breaks correctly. I haven’t tried, so maybe someone else can provide confirmation one way or the other.