Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

About everyth5

  • Birthday 01/05/1957

Profile Information

  • Real Name
  • Gender
  • Location
    Chiang Mai, Thailand
  • Website
  1. Just starting a new osCommerce site and hoping to have it completed in a couple of months. Last one took me 6 months and that included learning PHP. Not bad.

  2. I have been trying frantically to get EP working on my local site and subdirectory site but it just seems to refresh the page. This is the code for my easypopulate.php file, in the localhost the tree is http://localhost/catalog and in the subdirectory site it is www.everything-asian.com/aa-osctestsite............ // **** Temp directory **** // if you changed your directory structure from stock and do not have /catalog/temp/, then you'll need to change this accordingly. // // Please set DOCUMENT_ROOT to $DOCUMENT_ROOT in your /catalog/admin/includes/configure.php $tempdir = "/catalog/temp/"; $tempdir2 = "/catalog/temp/"; //**** File Splitting Configuration **** // we attempt to set the timeout limit longer for this script to avoid having to split the files // NOTE: If your server is running in safe mode, this setting cannot override the timeout set in php.ini // uncomment this if you are not on a safe mode server and you are getting timeouts // set_time_limit(330); // if you are splitting files, this will set the maximum number of records to put in each file. // if you set your php.ini to a long time, you can make this number bigger global $maxrecs; $maxrecs = 300; // default, seems to work for most people. Reduce if you hit timeouts //$maxrecs = 4; // for testing //**** Image Defaulting **** global $default_images, $default_image_manufacturer, $default_image_product, $default_image_category; // set them to your own default "We don't have any picture" gif //$default_image_manufacturer = 'no_image_manufacturer.gif'; //$default_image_product = 'no_image_product.gif'; //$default_image_category = 'no_image_category.gif'; // or let them get set to nothing $default_image_manufacturer = ''; $default_image_product = ''; $default_image_category = ''; //**** Status Field Setting **** // Set the v_status field to "Inactive" if you want the status=0 in the system // Set the v_status field to "Delete" if you want to remove the item from the system <- THIS IS NOT WORKING YET! // If zero_qty_inactive is true, then items with zero qty will automatically be inactive in the store. global $active, $inactive, $zero_qty_inactive, $deleteit; $active = 'Active'; $inactive = 'Inactive'; //$deleteit = 'Delete'; // not functional yet $zero_qty_inactive = true; //**** Size of products_model in products table **** // set this to the size of your model number field in the db. We check to make sure all models are no longer than this value. // this prevents the database from getting fubared. Just making this number bigger won't help your database! They must match! global $modelsize; $modelsize = 25; //**** Price includes tax? **** // Set the v_price_with_tax to // 0 if you want the price without the tax included // 1 if you want the price to be defined for import & export including tax. global $price_with_tax; $price_with_tax =true; // **** Quote -> Escape character conversion **** // If you have extensive html in your descriptions and it's getting mangled on upload, turn this off // set to 1 = replace quotes with escape characters // set to 0 = no quote replacement global $replace_quotes; $replace_quotes = false; // **** Field Separator **** // change this if you can't use the default of tabs // Tab is the default, comma and semicolon are commonly supported by various progs // Remember, if your descriptions contain this character, you will confuse EP! global $separator; $separator = "\t"; // tab is default //$separator = ","; // comma //$separator = ";"; // semi-colon //$separator = "~"; // tilde //$separator = "-"; // dash //$separator = "*"; // splat // **** Max Category Levels **** // change this if you need more or fewer categories global $max_categories; $max_categories = 3; // 7 is default // VJ product attributes begin // **** Product Attributes **** // change this to false, if do not want to download product attributes global $products_with_attributes; $products_with_attributes = true; // change this to true, if you use QTYpro and want to set attributes stock with EP. global $products_attributes_stock; $products_attributes_stock = false; // change this if you want to download selected product options // this might be handy, if you have a lot of product options, and your output file exceeds 256 columns (which is the max. limit MS Excel is able to handle) global $attribute_options_select; //$attribute_options_select = array('Size', 'Model'); // uncomment and fill with product options name you wish to download // comment this line, if you wish to download all product options // VJ product attributes end // **************************************** // Froogle configuration variables // -- YOU MUST CONFIGURE THIS! IT WON'T WORK OUT OF THE BOX! // **************************************** // **** Froogle product info page path **** // We can't use the tep functions to create the link, because the links will point to the admin, since that's where we're at. // So put the entire path to your product_info.php page here global $froogle_product_info_path; $froogle_product_info_path = "http://www.yourdomain.com/catalog/product_info.php"; // **** Froogle product image path **** // Set this to the path to your images directory global $froogle_image_path; $froogle_image_path = "http://www.yourdomain.com/catalog/images/"; // **** Froogle - search engine friendly setting // if your store has SEARCH ENGINE FRIENDLY URLS set, then turn this to true // I did it this way because I'm having trouble with the code seeing the constants // that are defined in other places. global $froogle_SEF_urls; $froogle_SEF_urls = false; // **************************************** // End Froogle configuration variables // **************************************** //******************************* //******************************* // E N D // C O N F I G U R A T I O N // V A R I A B L E S //******************************* //******************************* //******************************* //******************************* // S T A R T // INITIALIZATION //******************************* //******************************* require('includes/application_top.php'); require('includes/database_tables.php'); //******************************* // If you are running a pre-Nov1-2002 snapshot of OSC, then we need this include line to avoid // errors like: // undefined function tep_get_uploaded_file if (!function_exists(tep_get_uploaded_file)){ include ('easypopulate_functions.php'); } //******************************* // VJ product attributes begin global $attribute_options_array; $attribute_options_array = array(); if ($products_with_attributes == true) { if (is_array($attribute_options_select) && (count($attribute_options_select) > 0)) { foreach ($attribute_options_select as $value) { $attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " where products_options_name = '" . $value . "'"; $attribute_options_values = tep_db_query($attribute_options_query); if ($attribute_options = tep_db_fetch_array($attribute_options_values)){ $attribute_options_array[] = array('products_options_id' => $attribute_options['products_options_id']); } } } else { $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); while ($attribute_options = tep_db_fetch_array($attribute_options_values)){ $attribute_options_array[] = array('products_options_id' => $attribute_options['products_options_id']); } } } // VJ product attributes end global $filelayout, $filelayout_count, $filelayout_sql, $langcode, $fileheaders; // these are the fields that will be defaulted to the current values in the database if they are not found in the incoming file global $default_these; $default_these = array( 'v_products_image', #'v_products_mimage', #'v_products_bimage', #'v_products_subimage1', #'v_products_bsubimage1', #'v_products_subimage2', #'v_products_bsubimage2', #'v_products_subimage3', #'v_products_bsubimage3', 'v_categories_id', 'v_products_price', 'v_products_quantity', 'v_products_weight', 'v_date_avail', 'v_instock', 'v_tax_class_title', 'v_manufacturers_name', 'v_manufacturers_id', 'v_products_dim_type', 'v_products_length', 'v_products_width', 'v_products_height', 'v_products_upc' ); //elari check default language_id from configuration table DEFAULT_LANGUAGE $epdlanguage_query = tep_db_query("select languages_id, name from " . TABLE_LANGUAGES . " where code = '" . DEFAULT_LANGUAGE . "'"); if (tep_db_num_rows($epdlanguage_query)) { $epdlanguage = tep_db_fetch_array($epdlanguage_query); $epdlanguage_id = $epdlanguage['languages_id']; $epdlanguage_name = $epdlanguage['name']; } else { Echo 'Strange but there is no default language to work... That may not happen, just in case... '; } $langcode = ep_get_languages(); if ( $dltype != '' ){ // if dltype is set, then create the filelayout. Otherwise it gets read from the uploaded file ep_create_filelayout($dltype); // get the right filelayout for this download } //******************************* //******************************* // E N D // INITIALIZATION //******************************* //******************************* and this is the code in the easypopulate_functions.php file <?php function tep_get_uploaded_file($filename) { if (isset($_FILES[$filename])) { $uploaded_file = array('name' => $_FILES[$filename]['name'], 'type' => $_FILES[$filename]['type'], 'size' => $_FILES[$filename]['size'], 'tmp_name' => $_FILES[$filename]['tmp_name']); } elseif (isset($GLOBALS['HTTP_POST_FILES'][$filename])) { global $HTTP_POST_FILES; $uploaded_file = array('name' => $HTTP_POST_FILES[$filename]['name'], 'type' => $HTTP_POST_FILES[$filename]['type'], 'size' => $HTTP_POST_FILES[$filename]['size'], 'tmp_name' => $HTTP_POST_FILES[$filename]['tmp_name']); } else { $uploaded_file = array('name' => $GLOBALS[$filename . '_name'], 'type' => $GLOBALS[$filename . '_type'], 'size' => $GLOBALS[$filename . '_size'], 'tmp_name' => $GLOBALS[$filename]); } return $uploaded_file; } // the $filename parameter is an array with the following elements: // name, type, size, tmp_name function tep_copy_uploaded_file($filename, $target) { if (substr($target, -1) != '/') $target .= '/'; $target .= $filename['name']; move_uploaded_file($filename['tmp_name'], $target); } I have NO idea what else to do to make it work. Hope someone can PLEASE help me. Kelvin
  3. Why would the file be too big for my test sites (both online and locally) when it works fine on my live site???
  4. This is on both a local server and a live server. Same results.
  5. Thank you John for responding. Firstly, I apologize if I sounded negative, but I have been passed over for so long and was getting frustrated. I tried daily to figure this problem out. Anyway, here is the code from the configure.php file. <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://everything-asian.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://everything-asian.com'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'everything-asian.com'); define('HTTPS_COOKIE_DOMAIN', 'everything-asian.com'); define('HTTP_COOKIE_PATH', '/aa-osctestsite/'); define('HTTPS_COOKIE_PATH', '/aa-osctestsite/'); define('DIR_WS_HTTP_CATALOG', '/aa-osctestsite/'); define('DIR_WS_HTTPS_CATALOG', '/aa-osctestsite/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/home/everyth5/public_html/aa-osctestsite/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); And this is the temp settings in the easypopulate.php file. $tempdir = "/public_html/aa-osctestsite/temp/"; $tempdir2 = "/public_html/aa-osctestsite/temp/"; Thank you so much for your help Kelvin
  6. Well it has been almost 3 weeks now since I posted the original request for help on this issue and I have not receive one response. Either it is something that is impossible to fix so no one wants to attempt to help me or I am invisible. lol I have since added a new osCommerce test site to a subdirectory on my server and I have run into the same problem. When I try to download OR upload a txt file, the screen just seems to refresh itself. Can anyone help me with this one PLEEEEAAAASSSSSEEEE. Thank you Kelvin
  7. I am trying to get EP working on my subdirectory site online and on my local site but have run into the same problem with both. I tried to download a Froogle tab-delimited txt file and a full txt file for editing as well as uploading a txt file from my live site and nothing happens. It seems like it just refreshes the window. There are no error messages or anything. I have the Temp file in the correct place and with the correct permissions. Hope someone can help me with this. Kelvin
  8. everyth5

    Easy Populate not working right.

    I have been trying there for the past 2 weeks and have been totally ignored there! Not even a comment.
  9. everyth5

    Easy Populate not working right.

    I have finally figured out the premissions for the Temp file and got it set right. But I still cannot do anything with my Easy Populate. When I try to download or upload, I get NO errors but it doesn't do anything. Please someone help me with this. I have tried to use the Support forum for this over the past 2 weeks but have NEVER received even an acknowledgement that I am there. Thanks for your help Kelvin
  10. Please someone, anyone......... I need to fix this before I can go further with testing.
  11. Ok, so I finally figured out what was wrong with CHMODing the Temp file and have it set to 777. Now I tried again to download editable txt file and Froogle tab delimited txt file and installing my file from my live site to the test site online but cannot. It seems to not do anything! Can someone help me on this one??? Thanks Kelvin
  12. I have one header tag that is reading the wrong page. When I go to the checkout, my Delivery Instructions displays the Shipping and Returns Information Box header tag. I cannot figure out where to change it. Hope someone can send me in the right direction to fix this. Kelvin
  13. everyth5

    Showing wrong Tag

    Sorry, Wrong place on the forum
  14. Still having troubles with this one. Can anyone help me? Thanks Kelvin