Office Mac and EZ Populate

[jimmysflyshop]

We are using Zen Cart 1.3.8 which I believe is the current program. We have been using Zen Cart for the last few months and have just recently launched our site. We have all the latest programs for Zen Cart. During the building process I was using a PC. I have just purchased an Macbook, and installed Microsoft Office so that I would be able to use Easy Populate with Zen Cart. Everything works okay except for one issue.

My issue is that when I download and update the .csv file and try to import it back to Zen Cart it is not properly updated. The new information that I have entered and saved on the .cvs file is not imported into Zen Cart. When I save the file to be imported I save it as a .csv file. I get a message that the import was successful but I don't receive any messages about the site being updated like I do on my PC.

Am I missing something here? I know I can't be the only one using an Apple to run Easy Populate. Any help would be appreciated. Hopefully I have given you enough information to help me, if not let me know.

[rstevenson]

I'm on Mac (OS X v10.4.11) and I too use Excel and EZ Populate, but not often so my memory is a bit rusty on this. I recall that I had some sort of problem using the Excel-created file directly. Since I have a programmer's editor (the excellent BBEdit, see barebones.com) it was easy and quick to open the file in my editor, save it again and then upload it. I never trust MS products to do things simply, so I wouldn't expect the Excel file to be a plain text file. There'll be some junk in it somewhere, I'm sure.

Rob