Uncaught SoapFault exception: [Sender] Invalid XML with Magento API

"Uncaught SoapFault exception: [Sender] Invalid XML" outputs when I try to import开发者_如何学C bulk products into Magento. I have a excel file, a product per line, I have about 178 products. Everything is ok until it goes to the 22 line. The Fatal Error outputs.

Anyone knows what's happened. Thank you very much!

---

You may have used some special characters (like "<" (left chevron) or ">" (right chevron) or "'" (single quote)), in the product existing in line #22.

You need to make sure that the special characters are converted / used by the corresponding HTML entities only in such scenarios, directly in the excel file only.

If you don't convert / delete those special characters in the excel file only, then in the API they get used up as the characters to be used for the API. This is a little bit similar to the way how SQL Injection occurs.

Hope it helps.