--- 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
";
+ echo "link amend
";
include ("linkAmendments.php");
echo "update UNSPSC
";
- include ("updateUNSPSC.php");*/
+ include ("updateUNSPSC.php");
}
// cn