[osCmax V2.0.25] Data feed has HTML

[stadham]

I need some help with my data feed from my drop shipper it has HTML in the product description. It updates correctly using easy populate but does not show the correct formating in the catalog. All the HTML code shows up in the catalog. Below is a sample of the product description taken from my data feed.
If I go into each product and cut the the description out and click the source button on and them paste it back in then click the source button back again the description is right. But I have over 9,000 products it would take me forever to do that. Is there a way to tell oscMax to read the HTML from my data feed automatically??

Please help

Randy


This is a sample of the product description I get from my drop shipper.

<p>The new Whisper air pump was redesigned from the ground up for silence and performance.  It has many patented features that minimize noise yet allows for a  powerful flow of air.</p><ul></ul>

[met00]

Version of osCmax?
Version of easypop?

I can tell you what is happening, but I don't now where it' undergoing the transformation.

All your text is getting cleaned up with a URL encode. The answer is that the descriptions should go through a URL decode and a mysql cleanup before being inserted into the database.

sample code:

$description4db = mysql_real_escape_string(urldecode($originaldescription));

The line above will take a line and ensure it's in the database safely.

Now what bothers me is that your text almost looks like something that microsoft saved (I tend to see microsoft products "clean up" the HTML to displayable HTML rather than raw HTML). So, the question really is, at what point does the text change from <p> to

<p>

I would look first at the feed file to see if it's there. Then, if you edit and save that file, look at the saved file.

[stadham]

Thanks for your quick responce

Version of osCmax? Version 2.0.25.1
Version of easypop? V 2.76g

I can tell you what is happening, but I don't now where it' undergoing the transformation.

All your text is getting cleaned up with a URL encode. The answer is that the descriptions should go through a URL decode and a mysql cleanup before being inserted into the database.

sample code:

$description4db = mysql_real_escape_string(urldecode($originaldescription));

The line above will take a line and ensure it's in the database safely.

Now what bothers me is that your text almost looks like something that microsoft saved (I tend to see microsoft products "clean up" the HTML to displayable HTML rather than raw HTML). So, the question really is, at what point does the text change from <p> to

<p>

I would look first at the feed file to see if it's there. Then, if you edit and save that file, look at the saved file.

"I have looked at the data feed code which is sent to me in text and I look at it in WordPad and it looks the same. I have tried using Excel to change to a .cvs file and things seem to be the same (although things happen in the back ground I am not awhere of and I have also used OpenOffice to convert to .cvs and with both files the product looks the same and the same thing happens in the catalog the text does not get converts to nice pretty formated HTML."

I have also tried to change a line of code in EP calles escape character conversion
this line of code

define ('EP_REPLACE_QUOTES', false);

I changed this to true with nothing changing