--- a/admin/importUNSPSC.php
+++ b/admin/importUNSPSC.php
@@ -25,7 +25,8 @@
}
// import new from file
$success = 0;
- $fname = "UNSPSC_ECCMA_V13.2_UNDP_V7.csv";
+// $fname = "UNSPSC_ECCMA_V13.2_UNDP_V7.csv";
+ $fname = "AusTenderCustomisedUNSPSCCodeSet-August2012.csv";
echo " ============== $fname ==============
";
flush();
$row = 1;
@@ -35,17 +36,20 @@
while (($data = fgetcsv($handle, 1000)) !== false) {
$num = count($data);
- if ($row == 3) {
+/* if ($row == 3) {
$headers = $data;
} elseif ($row > 3) {
//print_r($data);
-$query = 'insert into "UNSPSCcategories" values(".$data[1].","$data[2]");';
-//echo $query."
\n";
+$query = 'insert into "UNSPSCcategories" values(".$data[1].","$data[2]");'; */
+$query = 'delete from "UNSPSCcategories" where "UNSPSC" = '.$data[0].'; insert into "UNSPSCcategories" values('.$data[0].',\''.trim($data[1]).'\');';
+echo $query."
\n";
$conn->exec($query);
+print_r($conn->errorInfo());
+
flush();
//echo "