--- 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>&nbsp;" . filesize($path . $fname) . "&nbsp;" . 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);
   }
 ?>
+