Hello,
I have some brand name product with & like D&G
there is a solution to have D&G in the database ? now I have DampG
Thx,
Jean-Christophe
Hello Dave,
I understand the problem with the &, I decide to change all D&G to Dolce Gabbana and now it's OK
Thx for your help
Jean-Christophe
Hi david
I have created an extra "fieldA" like a short description field, how do I go about making this field exempt from normalisation?
regards
Phil Stone
www.buy24-7.net
Hi Phil,
Additional fields shouldn't be being normalised as it stands; if there appear to be characters being removed could you give an example of before / after import...
Cheers,
David.
--
PriceTapestry.com
hi David
The Problem is not with the display (sorry meant to say that) but rather with the search, when I search the terms in this field, having already made the changes to the search.php file etc, up until now this was a hidden field for pid numbers and when someone searched for something it came up in the results, now this field is being used as a "merchant full product name display" instead and when I search the term in the field it doesn't work
eg:
{link saved}
When I search for "MC814BA" it works no problem, but when I search for "Apple iMac 27"" or "Apple iMac 27" it doest work (Best buy product name) but if I search for "APLCAMC814" (insights product name as in old pid number) it works no problem
I hope this makes sense
regards
Phil Stone
www.buy24-7.net
Hi Jean-Christophe,
It is a concious design decision within Price Tapestry to aggressively strip out any characters which are known to cause problems within a web environment - including the ampersand.
In this instance, the best thing to do would be to create a search and replace filter on the brand field for this feed, search for "&" and replace with either blank, or " and " to give "D and G".
However, if you want to try and make it work, the first thing to do would be to remove the normalisation from the brand field during import. To do this, remove (comment out) the following code from includes/admin.php
<?phpif ($admin_importFeed["field_brand"])
{
$record[$admin_importFeed["field_brand"]] = tapestry_normalise($record[$admin_importFeed["field_brand"]]);
}
?>
Then, at the top of search.php you will need to permit the & character in the query by changing:
$q = (isset($_GET["q"])?tapestry_normalise($_GET["q"],":\."):"");to:
$q = (isset($_GET["q"])?tapestry_normalise($_GET["q"],"&:\."):"");This should work, but it is quite likely that there will be other problems that arrise as a result - I would advise against it...
Cheers,
David.