Quote Originally Posted by stuffwo View Post
Hello,
I read the post but I still am unable to have the products show. I done all the step in this post
1) Select File -> Save As
2) Ensure File type: is Text CSV (.csv)
3) check the Edit Filter settings box
4) click save

In the Export of text Files box,

Select your Character set. Probably UTF-8 is you are on zen 1.5 now.
Field delimiter: Comma ,
Text delimiter: Double quote "
you can leave the save cell contents as show box checked.

I have uploaded the file again into the server for you to look at. http://www.stuffwholesale.com/docume...p23-230347.csv
Could this be the Westminster new template that was installed I had no problems before installing the new template.
Quote Originally Posted by mc12345678 View Post
Nope, not template related. File to be imported still has incorrect format. Not entirely sure (off top of head) what setting is causing this. There are quotes around all of the text, commas within the text, but none between each column. May I suggest, just so you can see the differences in the files, to open a file using a plain text editor that has been generated for download alongside a fiile saved to be imported... You only need to look at the first line to see the significant difference... Don't even really need to read any of it, just look at the pattern.

As for the notification, yes, the file was import (opened) successfully, but it wasn't processed successfully. (Should see a long list of "issues"/information at the bottom of the screen after importing.)
Took a look through the settings of Open Office (OO) version
File, Save As, mark the box that says Edit Filter Settings before clicking the save button.
Then choose the settings:
Character Set: Unicode (UTF-8)
Field Delimiter: , (Is a comma)
Text Delimiter: " (Is a double quote)
Suggest marking the Quote all text cells block

Looks like perhaps the field delimiter was set as a space instead of a comma...
Thought also not sure what caused all of the commas at the end of each row...