--- a/admin/updateUNSPSC.php +++ b/admin/updateUNSPSC.php @@ -7,12 +7,15 @@ $unspscresult = $conn->prepare('select * from "UNSPSCcategories";'); $unspscresult->execute(); foreach ($unspscresult->fetchAll() as $row) { + $row['Title'] = strtolower($row['Title']); $unspsc[strtolower($row['Title'])] = $row['UNSPSC']; // some Australian spellings -/* $isiz = str_replace("iz", "is", $row['Title']); + $isiz = str_replace("iz", "is", $row['Title']); $unspsc[$isiz] = $row['UNSPSC']; $filfill = str_replace("fill", "fil", $row['Title']); $unspsc[$filfill] = $row['UNSPSC']; + $ampersand = str_replace("&", "and", $row['Title']); + $unspsc[$ampersand] = $row['UNSPSC']; $defence = str_replace("efense", "efence", $row['Title']); $unspsc[$defence] = $row['UNSPSC']; $armor = str_replace("rmored", "rmoured", $row['Title']); @@ -50,7 +53,7 @@ // some just plain wrong $noOilRigs = str_replace("Building and Construction and Maintenance Services", "Management and provision of all facilities engineering modification and maintenance services for a site or platform", $row['Title']); - $unspsc[$noOilRigs] = $row['UNSPSC'];*/ + $unspsc[$noOilRigs] = $row['UNSPSC']; } //print_r($unspsc); $query = 'SELECT "CNID",lower("category") as category,"value"