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); }