|
|
";
echo "File uploaded.
";
echo "Temporary filename: " . $file['tmp_name'] . "
";
echo "User filename: " . $file['name'] . "
";
echo "Size: " . $file['size'] . "
";
// get the entire file into an array
$readed = file(EP_TEMP_DIRECTORY . $file['name']);
}
if (!empty($_POST['localfile'])){
// move the file to where we can work with it
//$file = tep_get_uploaded_file('usrfl');
//$attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_id";
//$attribute_options_values = tep_db_query($attribute_options_query);
//$attribute_options_count = 1;
//while ($attribute_options = tep_db_fetch_array($attribute_options_values)){
//if (is_uploaded_file($file['tmp_name'])) {
// tep_copy_uploaded_file($file, EP_TEMP_DIRECTORY);
//}
echo " ";
echo "Filename: " . $_POST['localfile'] . "
";
// get the entire file into an array
$readed = file(EP_TEMP_DIRECTORY . $_POST['localfile']);
}
if (EP_EXCEL_SAFE_OUTPUT == true) {
// do excel safe input
unset($readed); // kill array setup with above code
$readed = array(); // start a new one for excel_safe_output
$fp = fopen(EP_TEMP_DIRECTORY . (isset($_FILES['usrfl'])?$file['name']:$_POST['localfile']),'r') or die('##Can not open file for reading. Script will terminate.
'); // open file
$header_line = fgets($fp);
if (strpos($header_line,',') !== false) { $ep_separator = ','; }
if (strpos($header_line,';') !== false) { $ep_separator = ';'; }
if (strpos($header_line,"\t") !== false) { $ep_separator = "\t"; }
if (strpos($header_line,'~') !== false) { $ep_separator = '~'; }
if (strpos($header_line,'-') !== false) { $ep_separator = '-'; }
if (strpos($header_line,'*') !== false) { $ep_separator = '*'; }
rewind($fp);
while($line = fgetcsv($fp,32768,$ep_separator)) // read new line (max 32K bytes)
{
unset($line[(sizeof($line)-1)]); // remove EOREOR at the end of the array
$readed[] = $line; // add to array we will process later
}
$theheaders_array = $readed[0]; // pull out header line
fclose($fp); // close file
} else {
// do normal EP input
// now we string the entire thing together in case there were carriage returns in the data
$newreaded = "";
foreach ($readed as $read){
$newreaded .= $read;
}
// now newreaded has the entire file together without the carriage returns.
// if for some reason excel put qoutes around our EOREOR, remove them then split into rows
$newreaded = str_replace('"EOREOR"', 'EOREOR', $newreaded);
$readed = explode( $ep_separator . 'EOREOR',$newreaded);
// Now we'll populate the filelayout based on the header row.
$theheaders_array = explode( $ep_separator, $readed[0] ); // explode the first row, it will be our filelayout
}
$lll = 0;
$filelayout = array();
foreach( $theheaders_array as $header ){
$cleanheader = str_replace( '"', '', $header);
// echo "Fileheader was $header
";
$filelayout[ $cleanheader ] = $lll++; //
}
unset($readed[0]); // we don't want to process the headers with the data
// now we've got the array broken into parts by the expicit end-of-row marker.
foreach ($readed as $tkey => $readed_row) {
process_row($readed_row, $filelayout, $filelayout_count, $default_these, $ep_separator, $languages);
}
// isn't working in PHP 5
// array_walk($readed, $filelayout, $filelayout_count, $default_these, 'process_row');
//*******************************
//*******************************
// UPLOAD AND SPLIT FILE
//*******************************
//*******************************
} elseif (isset($_FILES['usrfl']) && isset($_GET['split']) && $_GET['split']==1) {
// move the file to where we can work with it
$file = tep_get_uploaded_file('usrfl');
//echo "Trying to move file...";
if (is_uploaded_file($file['tmp_name'])) {
tep_copy_uploaded_file($file, EP_TEMP_DIRECTORY);
}
$infp = fopen(EP_TEMP_DIRECTORY . $file['name'], "r");
//toprow has the field headers
$toprow = fgets($infp,32768);
$filecount = 1;
echo "Creating file EP_Split" . $filecount . '.'.((EP_EXCEL_SAFE_OUTPUT==true)?'csv':'txt').' ... ';
$tmpfname = EP_TEMP_DIRECTORY . "EP_Split" . $filecount.'.'.((EP_EXCEL_SAFE_OUTPUT==true)?'csv':'txt');
$fp = fopen( $tmpfname, "w+");
fwrite($fp, $toprow);
$linecount = 0;
$line = fgets($infp,32768);
while ($line){
// walking the entire file one row at a time
// but a line is not necessarily a complete row, we need to split on rows that have "EOREOR" at the end
$line = str_replace('"EOREOR"', 'EOREOR', $line);
fwrite($fp, $line);
if (strpos($line, 'EOREOR')){
// we found the end of a line of data, store it
$linecount++; // increment our line counter
if ($linecount >= EP_SPLIT_MAX_RECORDS){
echo "Added $linecount records and closing file...
";
$linecount = 0; // reset our line counter
// close the existing file and open another;
fclose($fp);
// increment filecount
$filecount++;
echo "Creating file EP_Split" . $filecount . '.'.((EP_EXCEL_SAFE_OUTPUT==true)?'csv':'txt').' ... ';
$tmpfname = EP_TEMP_DIRECTORY . "EP_Split" . $filecount.'.'.((EP_EXCEL_SAFE_OUTPUT==true)?'csv':'txt');
//Open next file name
$fp = fopen( $tmpfname, "w+");
fwrite($fp, $toprow);
}
}
$line=fgets($infp,32768);
}
echo "Added $linecount records and closing file...
";
fclose($fp);
fclose($infp);
echo "You can download your split files in the Tools/Files under " . EP_TEMP_DIRECTORY;
}
//*******************************
//*******************************
// MAIN MENU
//*******************************
//*******************************
?>
Please backup your database before performing any Easy Populate operations!
Export EP or Froogle Products File
array( "id" => 'activestream', 'text' => 'Download on-the-fly' ), 1 => array( "id" => 'stream', 'text' => 'Create then Download' ), 2 => array( "id" => 'tempfile', 'text' => 'Create in Temp Dir' )));
echo ' a ' . tep_draw_pull_down_menu('dltype',array( 0 => array( "id" => 'full', 'text' => 'Complete' ), 1 => array( "id" => 'custom', 'text' => 'Custom' ), 2 => array( "id" => 'priceqty', 'text' => 'Price/Qty' ), 3 => array( "id" => 'category', 'text' => 'Categories' ), 4 => array( "id" => 'attrib', 'text' => 'Attributes' ), 5 => array( "id" => 'froogle', 'text' => 'Froogle' )),'custom','onChange="return switchForm(this);"');
echo ' ' . ((EP_EXCEL_SAFE_OUTPUT == true)?".csv":".txt") . ' file (model number is always included).';
$cells = array();
$cells[0][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_name', 'show', (!empty($_GET['epcust_name'])?true:false)) . ' | name' . ' |
');
$cells[0][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_description', 'show', (!empty($_GET['epcust_description'])?true:false)) . ' | description' . ' |
');
$cells[0][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_url', 'show', (!empty($_GET['epcust_url'])?true:false)) . ' | url' . ' |
');
$cells[0][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_image', 'show', (!empty($_GET['epcust_image'])?true:false)) . ' | image' . ' |
');
if (EP_PRODUCTS_WITH_ATTRIBUTES == true) {
$cells[0][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_attributes', 'show', (!empty($_GET['epcust_attributes'])?true:false)) . ' | attributes' . ' |
');
}
$cells[0][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_category', 'show', (!empty($_GET['epcust_category'])?true:false)) . ' | categories' . ' |
');
$cells[0][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_manufacturer', 'show', (!empty($_GET['epcust_manufacturer'])?true:false)) . ' | manufacturer' . ' |
');
$cells[1][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_price', 'show', (!empty($_GET['epcust_price'])?true:false)) . ' | price' . ' |
');
$cells[1][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_quantity', 'show', (!empty($_GET['epcust_quantity'])?true:false)) . ' | quantity' . ' |
');
$cells[1][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_weight', 'show', (!empty($_GET['epcust_weight'])?true:false)) . ' | weight' . ' |
');
$cells[1][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_tax_class', 'show', (!empty($_GET['epcust_tax_class'])?true:false)) . ' | tax class' . ' |
');
$cells[1][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_avail', 'show', (!empty($_GET['epcust_avail'])?true:false)) . ' | available' . ' |
');
$cells[1][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_date_added', 'show', (!empty($_GET['epcust_date_added'])?true:false)) . ' | date added' . ' |
');
$cells[1][] = array('text' => '| ' . tep_draw_checkbox_field('epcust_status', 'show', (!empty($_GET['epcust_status'])?true:false)) . ' | status' . ' |
');
$bigbox = new epbox('',false);
$bigbox->table_parameters = 'id="customtable" style="border: 1px solid #CCCCCC; padding: 2px; margin: 3px;"';
echo $bigbox->output($cells);
$manufacturers_array = array();
$manufacturers_array[] = array( "id" => '', 'text' => '- manufacturer -' );
$manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {
$manufacturers_array[] = array( "id" => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name'] );
}
$status_array = array(array( "id" => '', 'text' => '- status -' ),array( "id" => '1', 'text' => 'active' ),array( "id" => '0', 'text' => 'disabled' ));
echo 'filter by: ' . tep_draw_pull_down_menu('epcust_category_filter', array_merge(array( 0 => array( "id" => '', 'text' => '- category -' )), tep_get_category_tree()));
echo ' ' . tep_draw_pull_down_menu('epcust_manufacturer_filter', $manufacturers_array) . ' ';
echo ' ' . tep_draw_pull_down_menu('epcust_status_filter', $status_array) . ' ';
echo tep_draw_input_field('submit', 'Build File', ' style="padding: 0px"', false, 'submit');
?> |
Quick Links
|
Settings
|
EP vers:
Temp Dir:
Temp Dir is WritableTemp Dir is NOT Writable
Magic Quotes is:
register_globals is:
Split files on: records
Model Num Size:
Price with tax:
Calc Precision:
Replace quotes:
Field seperator:
Excel safe output:
Preserve tab/cr/lf:
Category depth:
Enable attributes:
SEF Froogle URLS:
More Pics:
Unknown Pics:
HTC:
SPPC:
Extra Fields:
Please see the manual in this contribution's package for help in changing these settings.
|
|
|