Include textual subcategories in openspending/csv export
[contractdashboard.git] / admin / updateUNSPSC.php
blob:a/admin/updateUNSPSC.php -> blob:b/admin/updateUNSPSC.php
--- a/admin/updateUNSPSC.php
+++ b/admin/updateUNSPSC.php
@@ -19,12 +19,20 @@
     $unspsc[$armor] = $row['UNSPSC'];

     $erre = str_replace("er", "re", $row['Title']);

     $unspsc[$erre] = $row['UNSPSC'];

+        $tire = str_replace("ire", "yre", $row['Title']);

+    $unspsc[$tire] = $row['UNSPSC'];

+       $aeroplane = str_replace("airplane","aeroplane", $row['Title']);

+    $unspsc[$aeroplane] = $row['UNSPSC'];

     $lyslyz = str_replace("lyz", "lys", $row['Title']);

     $unspsc[$lyslyz] = $row['UNSPSC'];

     // some divergence from standard

     $tobacco = str_replace("Food Beverage and Tobacco Products", "Food and Beverage Products", $row['Title']);

     $unspsc[$tobacco] = $row['UNSPSC'];

     $architect = str_replace("Building and Construction and Maintenance Services", "Architectural services", $row['Title']);

+    $unspsc[$architect] = $row['UNSPSC'];

+        $powercable = str_replace("Power cable", "Power cable installation and supply", $row['Title']);

+    $unspsc[$powercable] = $row['UNSPSC'];

+        $forensicIT = str_replace("Building and Construction and Maintenance Services", "Architectural services", $row['Title']);

     $unspsc[$architect] = $row['UNSPSC'];

     // 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']);