--- a/admin/import.php +++ b/admin/import.php @@ -11,7 +11,7 @@ // loop through all of the files while (false !== ($fname = readdir($dhandle))) { if (($fname != '.') && ($fname != '..')) { - echo "<a href=\"import.php?fname=$fname\">$fname</a>" . filesize($path . $fname) . "<br/>"; + echo "<a href=\"import.php?fname=$fname\">$fname</a> " . filesize($path . $fname) . " " . date("c",filemtime($path . $fname)) . "<br/>"; } } } @@ -52,7 +52,8 @@ if (in_array(($datamapping0709[$headers[$c]]), $contractNoticeFields)) { if (($datamapping0709[$headers[$c]]) == "parentCN" || ($datamapping0709[$headers[$c]]) == "CNID") { - $data[$c] = substr($data[$c], 2); + $data[$c] = substr($data[$c], 2); // take off the "CN" prefix + $data[$c] = str_replace("-A","00",$data[$c]); // make amendments really big numbers if ($data[$c] > 0) { $contractNoticeInsert .= ($firstCN ? "" : ",") . mysql_real_escape_string($data[$c]); } else { @@ -86,19 +87,19 @@ if ($result) $success++; elseif (strpos(mysql_error(), "Duplicate entry") === false) - echo $data[2] . " failed CN insert.<br>" . mysql_error() . " <br> $contractNoticeInsert <br><br>\n"; + echo $data[2] . " failed CN insert.<br>" . mysql_error() . " <br> $contractNoticeInsert <br> $row <br><br>\n"; $result = mysql_query($agencyInsert); if ($result) $success++; elseif (strpos(mysql_error(), "Duplicate entry") === false) - echo $data[2] . " failed agency insert.<br>" . mysql_error() . " <br> $agencyInsert <br><br>\n"; + echo $data[2] . " failed agency insert.<br>" . mysql_error() . " <br> $agencyInsert <br>$row <br><br>\n"; $result = mysql_query($supplierInsert); if ($result) $success++; elseif (strpos(mysql_error(), "Duplicate entry") === false) - echo $data[2] . " failed supplier insert.<br>" . mysql_error() . " <br> $supplierInsert <br><br>\n"; + echo $data[2] . " failed supplier insert.<br>" . mysql_error() . " <br> $supplierInsert <br>$row <br><br>\n"; flush(); //echo "<hr>\n"; @@ -111,3 +112,4 @@ fclose($handle); } ?> +