Importing with Quotation Mark

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I'm working on a client's site where they're importing products and categories that don't start with the quotation marks, but might have a quotation mark in the product title to denote inches (for example: Berkley 6" Fillet Knife. When the import is completed, it's showing a double quote in the data database and on the site for the product and category title. 
Does anyone have an explanation or an alternative to stop this from happening? I'm tried having him use &quot; and it converts the & into &amp;when it imports into the database, so that won't work. 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
John-Geek Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 23-June-2011 Status: Offline Points: 0	Post Options Post Reply Quote John-Geek Report Post Thanks(0) Quote Reply Topic: Importing with Quotation Mark Posted: 17-February-2013 at 11:34pm
	I'm working on a client's site where they're importing products and categories that don't start with the quotation marks, but might have a quotation mark in the product title to denote inches (for example: Berkley 6" Fillet Knife. When the import is completed, it's showing a double quote in the data database and on the site for the product and category title. Does anyone have an explanation or an alternative to stop this from happening? I'm tried having him use " and it converts the & into &when it imports into the database, so that won't work.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 17-February-2013 at 11:51pm
	Did you import as a CSV or XLS? As a quick test, if you used CSV, try XLS please.

John-Geek Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 23-June-2011 Status: Offline Points: 0	Post Options Post Reply Quote John-Geek Report Post Thanks(0) Quote Reply Posted: 18-February-2013 at 12:19am
	Okay, I will have them try that.