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,21 +19,35 @@
     $unspsc[$armor] = $row['UNSPSC'];

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

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

+    $center = str_replace("center", "centre", $row['Title']);

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

+      $accessory = str_replace("accesor", "accessor", $row['Title']);

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

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

+    $unspsc[$lyslyz] = $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'];

+    

+        $pe = str_replace("pe", "pae", $row['Title']);

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

+            $ane = str_replace("ane", "anae", $row['Title']);

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

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

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

     // some divergence from standard

+      $forensicit = str_replace("Information technology consultation services", "Forensic IT Services", $row['Title']);

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

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

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

     $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'];

+        $unemployment = str_replace("Unemployment services", "Employment services", $row['Title']);

+    $unspsc[$unemployment] = $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']);

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