--- a/admin/partialdata/import.php +++ b/admin/partialdata/import.php @@ -1,5 +1,6 @@ <?php -include_once ("../../lib/common.inc.php"); +if (php_sapi_name() == "cli") { + include_once ("../../lib/common.inc.php"); function processFile($fpath, $tablename) { global $conn; @@ -11,6 +12,7 @@ $handle = fopen($fpath, "r"); //"t" mode string translates windows line breaks to unix $datamapping0507 = array( + "Agency" => "agencyName", "CN ID" => "CNID", "Publish Date" => "publishDate", @@ -67,7 +69,6 @@ if (in_array(($datamapping0507[$headers[$c]]) , $contractNoticeFields)) { if (($datamapping0507[$headers[$c]]) == "parentCN" || ($datamapping0507[$headers[$c]]) == "CNID") { $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 (!is_numeric($data[$c]) && $data[$c] != "") die($data[$c] . " is not numeric"); if ($data[$c] > 0) { $contractNoticeInsert[] = $data[$c]; @@ -137,7 +138,7 @@ // loop through all of the files while (false !== ($fname = readdir($dhandle))) { if (($fname != '.') && ($fname != '..') && (!isset($_REQUEST["filter"]) || strpos($fname,$_REQUEST["filter"]) != false)) { - echo "<a href=\"import.php?fname=$fname\">$fname</a> " . filesize($path . $fname) . " " . date("c", filemtime($path . $fname)) . "<br/>"; + echo "<a href=\"importdatagov.php?fname=$fname\">$fname</a> " . filesize($path . $fname) . " " . date("c", filemtime($path . $fname)) . "<br/>"; processFile($path . $fname, "contractnotice"); } } @@ -150,5 +151,6 @@ $success+= processFile($path . $fname, "contractnotice"); } +} ?>