Yeah, this csv file is hosed and is not in the correct format. Many columns are missing and nothing is inside of quotes. You also changed the first line from:



to




We have an article here at http://www.coffeecup.com/help/articles/ … eator-pro/ which shows the proper formatting of the file. Just make sure everything matched 100%.

Good luck!

OK when I export from Excel as a CSV file it does not put in the quote Marks can anyone tell me what I am doing wrong? Thanks!

Dave

I am not an Excel expert, but maybe this will help:


http://www.google.com/search?client=fir … gle+Search

or

http://creativyst.com/Doc/Articles/CSV/ … Variations

If it helps any, I was one of the first people to have issues with "pasted" info from other places like online sites and/or from other programs that aren't text editors. I found once, after I pasted a few lines of text directly copied from a website, that it somehow copied some of the formatting of the text also rather than just raw text, and of course it didn't show that text formatting in the program so I proceeded to use that product as a base product, copying that product and pasting it to make a new product etc....

Needless to say, if Scott remembers this situation at all, I ended up with some colored text and sized text that I didn't format that way and of course it spanned a good section of products I had used that copied one to create and I could not figure out how to get rid of the formatting. Nothing I changed inside the program worked for formatting and I was told by support in the end that I would have to redo those products.... So.....

As a last resort I copied the text from the products, to a plain text editor ( I believe it was Textpad or Notetab Plus at that time ) and then deleted the text from the product (not deleting the product, just the text area) and then pasted the text back in directly from the Text Editor (copied and pasted from there) and that seemed to get rid of the formatting of those lines of code and it then behaved as it should and allowed me to format it inside the program again.

Lesson Learned: Don't copy text or lines directly from the web to your product. If you find you need to copy text such as a detailed product description from your supplier, copy that to a text editor first, then copy it from there to your product details page. This strips any formatting that may be hidden inside that text from the web. It's an extra step to be sure, but it's also saved me a lot of headaches since then. I was able to go through the products I had and strip the code for them all and replace it same as that one I fixed and all things worked out in the end, thankfully lol.

Hope that helps even a little

Nice story. What does copy/paste formating have to do with field delimiters in Excel?

That's what it has to do with this thread in general

Oh, he has to copy/paste the field delimiters.

I have completely gone through every item description, cutting out the description to notepad and then copying back into the description...thus in theory doing what Jo Ann describes in eliminating web formatting. I am still getting the same error message when trying to export to csv. This was working previously.....could I be missing something else?