$params['text_files_path'] = 'http://localhost/eol_php_code/public/tmp/xls/big/WFF Regions version 2/'; $params['extensions'] = array('taxa', 'occurrences', 'measurements'); $resource_id = "WFF Regions version 2"; // */ /* [WWF Habitats](https://www.dropbox.com/s/dlybjsx410h90rh/WWF Habitats.xlsx?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/SarahM/WWF_Habitats.tar.gz) [Avian body sizes in relation to fecundity%2C mating system, display behavior, and resource sharing Export](https://www.dropbox.com/s/bnrbmrttgithwa1/Avian body sizes in relation to fecundity%2C mating system%2C display behavior%2C and resource sharing Export.xls?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/SarahM/Avian_body_sizes_in_relation_to_fecundity%2C_mating_system%2C_display_behavior%2C_and_resource_sharing_Export.tar.gz) [WWF.xlsx](https://www.dropbox.com/s/k49tww9xgb2xd8k/WWF.xlsx?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/SarahM/WWF.tar.gz) [WWF 2.xlsx](https://www.dropbox.com/s/u17km6pnylf6cx3/WWF 2.xlsx?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/SarahM/WWF_2.tar.gz) */ // [xxx](spreadsheet) is VALID - [DWC-A](dwca) // */ /* https://www.dropbox.com/s/0rfmqrj97v6e37y/Dragonflies Measurements 2.xlsx?dl=0 $params['text_files_path'] = 'http://localhost/eol_php_code/public/tmp/xls/big/Dragonflies Measurements 2/'; $params['extensions'] = array('taxa', 'occurrences', 'measurements', 'references'); $resource_id = "Dragonflies Measurements 2"; 8 April 2016 [Dragonflies Measurements 2.xlsx](https://www.dropbox.com/s/0rfmqrj97v6e37y/Dragonflies Measurements 2.xlsx?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/SarahM/Dragonflies_Measurements_2.tar.gz) */ $resource_id = str_replace(" ", "_", $resource_id); $func = new EOLSpreadsheetToArchiveAPI($resource_id); $func->convert_spreadsheet_text_to_dwca($params); Functions::finalize_dwca_resource($resource_id); $elapsed_time_sec = time_elapsed() - $timestart; echo "\n\n"; echo "elapsed time = " . $elapsed_time_sec / 60 . " minutes \n"; echo "elapsed time = " . $elapsed_time_sec / 60 / 60 . " hours \n"; echo "\nDone processing.\n";
[DCBirds_eol_import_spreadsheet.xls](https://www.dropbox.com/s/lh79w1egk4orxn3/DCBirds_eol_import_spreadsheet.xls?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/JenH/DCBirds_eol_import_spreadsheet.tar.gz) [climates.xls](https://www.dropbox.com/s/xknmozz5mlnl88u/climates.xls?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/SarahM/climates.tar.gz) */ /* 8-April-2016 // $spreadsheets[] = 'https://www.dropbox.com/s/xknmozz5mlnl88u/climates.xls?dl=0'; // $spreadsheets[] = 'http://localhost/eol_php_code/public/tmp/xls/big/spreadsheets/climates.xls'; // [climates.xls](https://www.dropbox.com/s/xknmozz5mlnl88u/climates.xls?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/SarahM/climates.tar.gz) // $spreadsheets[] = 'https://www.dropbox.com/s/k39t8hcvacyww9v/Coral Skeletons.xlsx?dl=0'; // [Coral Skeletons.xlsx](https://www.dropbox.com/s/k39t8hcvacyww9v/Coral Skeletons.xlsx?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/SarahM/Coral_Skeletons.tar.gz) */ /* // $spreadsheets[] = 'https://www.dropbox.com/s/tt1tqajojkyzsy5/bioluminescent.xls?dl=0'; $spreadsheets[] = 'https://www.dropbox.com/s/mui6yyhssln7jr3/bioluminescent.xlsx?dl=0'; [bioluminescent.xlsx](https://www.dropbox.com/s/mui6yyhssln7jr3/bioluminescent.xlsx?dl=0) is VALID - [DWC-A](https://dl.dropboxusercontent.com/u/7597512/spreadsheets/resources/JenH/bioluminescent.tar.gz) */ print_r($spreadsheets); foreach ($spreadsheets as $spreadsheet) { $resource_id = str_replace(" ", "_", urldecode(pathinfo($spreadsheet, PATHINFO_FILENAME))); echo "\n[{$resource_id}]"; $func = new EOLSpreadsheetToArchiveAPI($resource_id); $func->convert_to_dwca($spreadsheet); /* $func->convert_to_text_to_dwca($spreadsheet);working but not being used... since XLSParser still loads entire worksheet into memory */ Functions::finalize_dwca_resource($resource_id, $big_file); $elapsed_time_sec = time_elapsed() - $timestart; echo "\n\n"; echo "elapsed time = " . $elapsed_time_sec / 60 . " minutes \n"; echo "elapsed time = " . $elapsed_time_sec / 60 / 60 . " hours \n"; echo "\nDone processing.\n"; }