private function parse_xls()
{
if ($this->data_dump_url = Functions::save_remote_file_to_local($this->data_dump_url, array('download_wait_time' => 1000000, 'timeout' => 600, 'download_attempts' => 5, 'file_extension' => 'xls'))) {
require_library('XLSParser');
$parser = new XLSParser();
debug("\n reading: " . $this->data_dump_url . "\n");
$temp = $parser->convert_sheet_to_array($this->data_dump_url);
$records = $parser->prepare_data($temp, "single", "SCIENTIFIC NAME", "SCIENTIFIC NAME", "CATEGORY", "ENGLISH NAME", "RANGE", "ORDER", "FAMILY", "EXTINCT", "EXTINCT_YEAR");
$records = self::fill_in_missing_names($records);
$records = self::fill_in_parent_id($records);
debug("\n" . count($records));
return $records;
}
}
private function parse_xls()
{
if ($this->data_dump_url = Functions::save_remote_file_to_local($this->data_dump_url, array('cache' => 1, 'download_wait_time' => 1000000, 'timeout' => 600, 'download_attempts' => 5, 'file_extension' => 'xlsx'))) {
require_library('XLSParser');
$parser = new XLSParser();
debug("\n reading: " . $this->data_dump_url . "\n");
$temp = $parser->convert_sheet_to_array($this->data_dump_url, 0);
$records = $parser->prepare_data($temp, "single", "Scientific name", "Scientific name", "Category", "English name", "Range", "Order", "Family", "Extinct", "Extinction Year");
$records = self::add_uppercase_fields($records);
$records = self::fill_in_missing_names($records);
$records = self::fill_in_parent_id($records);
debug("\n" . count($records));
return $records;
}
}
function prepare_taxa_list()
{
require_library('XLSParser');
$parser = new XLSParser();
$taxa = $parser->prepare_data($parser->convert_sheet_to_array(DOC_ROOT . self::TEMP_FILE_PATH . self::TAXA_LIST_FILE), "single", "NAME", "NAME", "USFWS SPECIES PROFILE URL", "DISPLAYED TEXT", "SOURCE LIST");
$parser = new XLSParser();
$synonymy = $parser->prepare_data($parser->convert_sheet_to_array(DOC_ROOT . self::TEMP_FILE_PATH . self::NAME_SYNONYMY), "single", "USFWS", "USFWS", "EOL NAME");
$parser = new XLSParser();
$names_to_be_added = $parser->prepare_data($parser->convert_sheet_to_array(DOC_ROOT . self::TEMP_FILE_PATH . self::NAMES_TO_BE_ADDED), "single", "FWS NAMES TO ADD TO EOL", "FWS NAMES TO ADD TO EOL");
echo "\n taxa: " . count($taxa);
echo "\n synonymy: " . count($synonymy);
echo "\n names_to_be_added: " . count($names_to_be_added);
return array($taxa, $synonymy, $names_to_be_added);
}
