Oct 24, 2009
SingleFeed Export Module for Magento – How to strip HTML tags and special characters
Tested on:
SingleFeed Export Module v1.1.0
Magento v1.3.2.4
So I found this great module for Magento the other day, made by SingleFeed. It will export a product data feed every night. Then, we can import this feed into things like Google Base.
I ran into a problem though. You can’t import a data feed into Google Base that contains HTML tags and special characters. Most of the clients I work with prefer to have a WYSIWYG editor for things like the CMS pages, product descriptions, etc., which will add HTML formatting in the database. The SingleFeed Export Module does not automatically strip HTML on the fly (however I believe if you sign-up for an account at their website, they have a wizard that can do it for you.)
I poked around at the code for a bit and discovered that stripping the HTML tags and special chars would be quite easy using two functions: strip_tags, htmlspecialchars_decode.
Open app/code/community/SingleFeed/Export/Model/Mysql4/Profile.php and goto line 360:
360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 | // format product data as needed foreach ($products as $id=>&$p) { foreach ($p as $attr=>&$value) { // replace raw numeric values with source option labels if ($options = $this->attr($attr, 'options')) { if (is_array($value)) { foreach ($value as &$v) { $v = isset($options[$v]) ? $options[$v] : ''; } } else { $value = isset($options[$value]) ? $options[$value] : ''; } } // combine multiselect values if (is_array($value)) { $value = join(', ', $value); } // process special cases of loaded attributes switch ($attr) { // product url case 'url_path': $p["singlefeed.url"] = $baseUrl.$value; break; |
I love well-written code, especially with good comments. All we’re going to do is add in our new formatting (in this case, just for the product description.)
360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 | // format product data as needed foreach ($products as $id=>&$p) { foreach ($p as $attr=>&$value) { // replace raw numeric values with source option labels if ($options = $this->attr($attr, 'options')) { if (is_array($value)) { foreach ($value as &$v) { $v = isset($options[$v]) ? $options[$v] : ''; } } else { $value = isset($options[$value]) ? $options[$value] : ''; } } // combine multiselect values if (is_array($value)) { $value = join(', ', $value); } // process special cases of loaded attributes switch ($attr) { // product url case 'url_path': $p["singlefeed.url"] = $baseUrl.$value; break; // product descriptions case 'description': $p["description"] = htmlspecialchars_decode(strip_tags($value)); break; |
That was almost a little too easy…
Jeffrey, we’re glad you found our extension and have used it creatively for your needs. I might suggest you try out our solution, as we’re able to do much more than a basic feed to multiple shopping engines. Contact us for more information.
Hey Ryan,
I took a look at you’re website, I like the solution you provide. I’m definitely interested in utilizing you’re services. I’ll mention it to some of my clients to see if they are interested.
Jeff
HI Ryan and Sibble,
I realize this is an old post but I am in desperate need to get something working that will allow me to add my feeds correctly to different shopping portals. I am an tiny bit frustrated by the price of SingleFeed. But I am also VERY frustrated that there isn’t a module that will take your database and match categories correctly.
What to do?
Rhonda Morin
I eventually got the module to work and managed to fix all errors.
I put together short step-by-step guide on how to set up the Magento Google Base feed, including account configuration, adding the condition attribute & mapping attributes and publishing them here http://blog.pod1.com/e-commerce/magento-google-base-feed/
Worked like a charm!! Just a tip for those of you that may have had an issue with Singlefeed not pulling the description- I changed mine to short_description and also updated the snippet of code provided by Jeff to reflect short_description.
Thank you so much!!!