Tidy up imports
[contractdashboard.git] / admin / importUNSPSC.php
blob:a/admin/importUNSPSC.php -> blob:b/admin/importUNSPSC.php
--- a/admin/importUNSPSC.php
+++ b/admin/importUNSPSC.php
@@ -1,1 +1,32 @@
+<?php
+  include_once("../lib/common.inc.php");
+      $success = 0;
+      $fname = "UNSPSC_ECCMA_V13.2_UNDP_V7.csv";
+      echo " ============== $fname  ============== <br>";
+      flush();
+      $row = 1;
+      $handle = fopen($path . $fname, "r");
+      $headers;
+      
+      while (($data = fgetcsv($handle, 1000)) !== false) {
+          $num = count($data);
+          
+          if ($row == 3) {
+              $headers = $data;
+          } elseif ($row > 3) {
+//print_r($data);
+$query = "insert into UNSPSCcategories values(".$data[1].",'$data[2]');";		
+//echo $query."<br>\n";		
+mysql_query($query);
+              flush();
+              
+              //echo "<hr>\n";
+          }
+          
+          $row++;
+      }
+      echo "<br> $success records successfully created";
+      flush();
+      fclose($handle);
+?>