--- a/admin/import.php
+++ b/admin/import.php
@@ -109,13 +109,13 @@
                 if (in_array(($datamapping0712[$headers[$c]]), $contractNoticeFields)) {
                     if (($datamapping0712[$headers[$c]]) == "parentCN" || ($datamapping0712[$headers[$c]]) == "CNID") {
                         $data[$c] = substr($data[$c], 2); // take off the "CN" prefix
-                        if ($data[$c] > 0 && $data[$c] != '0') {
+                        if ($data[$c] > 0 && $data[$c] != '0' && $data[$c] != '') {
                             $contractNoticeInsert[] = $data[$c];
                         } else {
                             $contractNoticeInsert[] = null;
                         }
-                    } elseif (($datamapping0712[$headers[$c]]) == "supplierABN") {
-                        if ($data[$c] > 0 && $data[$c] != '0') {
+                    } elseif (($datamapping0712[$headers[$c]]) == "supplierABN" || ($datamapping0712[$headers[$c]]) == "SONID") {
+                        if ($data[$c] > 0 && $data[$c] != '0' && $data[$c] != '') {
                             $contractNoticeInsert[] = $data[$c];
                         } else {
                             $contractNoticeInsert[] = null;
@@ -191,10 +191,10 @@
     // 
     if ($success > 0) {
 $conn->exec("update datasets set \"lastUpdated\" = NOW() where title = 'Contract Notices'");
-/*    echo "link amend<br>";
+    echo "link amend<br>";
     include ("linkAmendments.php");
     echo "update UNSPSC<br>";
-    include ("updateUNSPSC.php");*/
+    include ("updateUNSPSC.php");
     }
 // cn