21 Jan 2007, 2:41 AM
New Zenner
- Join Date:
- Dec 2006
- Posts:
- 42
- Plugin Contributions:
- 0
Easy Populate won't work with Excel text file, only Text Edit file.
I am downloading extended store data in easy populate, opening that file in Excel, making minor edits, saving file as tab delimited text file. When I upload and import, I get an error for about half of my product rows, not all.
If I go through the same process using Text Edit (Mac) instead of Excel, everything works fine.
The problem is the limitations of Text Edit. I have also tried saving the Excel file then opening it in Text Edit and doing a Save As, doesn't work.
I have also made sure there are no extra tabs anywhere, because the error message in Easy Populate says there is a column count error. But since it doesn't happen in Text Edit, it must be something Excel is doint to the file.
Any Ideas?
Thanks
