$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";
}
