Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

choosealogin

Pioneers
  • Posts

    1,104
  • Joined

  • Last visited

Posts posted by choosealogin

  1. In MyPHPAdmin I have a table called products_attributes_download with the following headings;

    products_attributes_id products_attributes_filename products_attributes_maxdays products_attributes_maxcount

     

    I now assume this is table who's info I want to add to using EP. Any clues here then?

     

    You found the right table. Those 4 fields need to be added the easypopulate.php file. Simply adding them to the header row in excel won't do it, as I think you already found out.

     

    Since those are in a table that's not even looked at in EP as it stands, I don't have a quick fix. I could play with that but it will take a little time.

  2. I'm far from an expert on this download stuff, but this is what I would look at next:

     

    Just a couple of things...

     

    Around line 97 of easypopulate.php,

     

    // 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;

     

     

    Do you have that set to 'true'? That's good.

     

    Do you have dowloads enabled already? That's important...or the filename attributes won't show up for you, to my knowledge.

     

    If so, go put in one test product, the old fashioned way (in osC admin).

     

    Then go to admin>>catalog>>products_attributes and add the necessary attribute (filename) for that test product.

     

    If you still have the demo products, you can look at the attribute for Unreal Tournaments as an example.

     

    Then download a complete EP file.

     

    Your test product should show it's attribute in that file.

     

    You should be able to follow the example you'll have in your EP file to go on from there, adding filenames (as attributes) for your other products.

  3. Kgt pointed to pretty much the only reason for your error.

     

    One single (invisible) space will cause that. Put your mouse at the end of the file and drag it to the ?> at the end...and delete the space.

     

    also, just in case - editing in cPanel will add an empty line at the end. So if you're using that, use something else to edit w/.

  4. You'll have to first set up your database and code to do that (make model year), and then customize Easy Populate to fill in the fields.

     

    So the part about EP is really the easiest part, and it's the last part.

     

    I put something together for "year", but as I'm only dealing with one make and 3 models, it was fairly easy :P

     

    It's a pretty dry subject around here :huh:

     

    You could look at 'product extra fields' (in the contributions), but while the theory is good, I'm not sure how to use it for that purpose.

  5. To my knowledge, download filenames are stored as a product attribute, which easy populate alreay has the ability to handle.

     

    The table orders_products_download stores info related to ordered products, as a record of downloadable goods orders.

     

    Maybe I misunderstood what you're wanting to do.

  6. They use a JS function called 'doPic'.

     

    Googling for 'dopic', I found this

     

    http://javascript.internet.com/miscellaneo...ery-viewer.html

     

    You would need to tweak something like mopics and this 'dopic' into your code, and you're good to go.

     

    Sorry, I didn't explain very well. Mopics is a multiple image contribution. It's here

     

    http://www.oscommerce.com/community/contri...l/search,mopics

     

    It would take some customizing, but I don't think it would be too difficult.

  7. In that case some of your other paths aren't right, in that same file (admin/includes/configure.php)

     

    check this one

     

    define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

     

    using $DOCUMENT_ROOT should work....see if yours looks like that or not. You'll see in that file that a lot of the other paths reference DIR_FS_DOCUMENT_ROOT in their paths, like

     

    define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

     

    so if it can't find your DIR_FS_DOCUMENT_ROOT, then the other paths won't work either.

     

    if it's already defined as $DOCUMENT_ROOT and that's not working, try using absolute paths, instead of the $DOCUMENT_ROOT variable.

     

    To find that path, go to your osC admin panel >>tools >> server info and scroll down to where you see "document root"....use the full path you see there for this line

     

    define('DIR_FS_DOCUMENT_ROOT', /the/path/you/found/in/admin/tools/serverinfo/);

  8. I'm not sure, but I think this is the problem

     

    get rid of one ?> (the ?> that is before the if (isset($HTTP ...)

     

    ?>

     

    if (isset($HTTP_GET_VARS['manufacturers_id']))

    $db_query = tep_db_query("select manufacturers_htc_title_tag as htc_title, manufacturers_htc_description as htc_description from " .

     

    so your "whole code" will be

     

    case 'PRODUCT_LIST_IMAGE':
    
    $listing_sql .= "pd.products_name";
    
    break;
    
    case 'PRODUCT_LIST_WEIGHT':
    
    $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
    
    break;
    
    case 'PRODUCT_LIST_PRICE':
    
    $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
    
    break;
    
    }
    
    }
    
    
    if (isset($HTTP_GET_VARS['manufacturers_id']))
    $db_query = tep_db_query("select manufacturers_htc_title_tag as htc_title, manufacturers_htc_description as htc_description from " . TABLE_MANUFACTURERS_INFO . " where languages_id = '" . (int)$languages_id . "' and manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
    else
    $db_query = tep_db_query("select categories_htc_title_tag as htc_title, categories_htc_description as htc_description from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'");
    
    $htc = tep_db_fetch_array($db_query);
    ?>
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
    <tr>
    <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
    <tr>
    <td><h1><?php echo $htc['htc_title']; ?></h1></td>
    
    <?php
    
    // optional Product List Filter
    
    if (PRODUCT_LIST_FILTER > 0) {
    
    if (isset($HTTP_GET_VARS['manufacturers_id'])) {
    
    $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";
    
    } else {[quote]

  9. You'll need to make sure that v_date_added is also in your file, when downloaded it will have the original date added. At that point, make sure your column is formatted as YYYY-MM-DD and it will carry the correct original date with it on upload.

     

    PS, if it's not already including that column ...it's a change that needs to be made in the easypopulate.php file, i.e. you can't just add the column in excel and expect it to work. I realized I made it sound like that would be so easy, sorry.

     

    If you're not sure how to fix that, let me know.

  10. Paypal showing zero is usually caused by a conflict between your Paypal account currency, your osC Paypal module default currency setting, and your osC shop's default currency. Make sure all 3 of them are the same, all using the (same) correct abbreviation recognized by Paypal (USD, AUD, CAD, GBP, etc ...).

  11. When you see words that are all capital in the error, it usually means a path of some sort is undefined.

     

    In your case it's the EP_TEMP_DIR

     

    Now, there are 3 problems

     

    ...I can tell from that error that you are using a version of EP that included an .sql file in the contribution package. That .sql file needs to be loaded into your database.

     

    But, before you do that please go back and make sure you really want to use that version. Many of the most recent versions (that one in particular) have some things hard-coded into them to accomodate certain other contributions, that you may or may not be using.

     

    Simple, basic EP is the one near the top that says

     

    "easy populate is easy, just start here first". You can get that here

     

    http://www.oscommerce.com/community/contri...h,easy+populate

     

    Then, finally you will want to use txt (tab delimited) when saving the file in excel.

  12. Ok, I changed just one line. I think maybe the directions confused you...easy to do as EP has been rewritten in so many diff. ways, that the directions are somewhat irrelavant at this point.

     

    I removed the $ sign from DIR_FS_DOCUMENT_ROOT.

     

    Let's try it again now.

     

    This time, also fix the easypopulate.php file, with the temp dir declaration like this...if you haven't already.

     

    $tempdir = "/temp/";

    $tempdir2 = "/temp/";

     

    Also, once you have that finished. Then "Download Complete tab-delimited .txt file to edit"

     

    Then, if it's full of products, remove them. Just leave the header row that has the column names in it.

     

    Then fill in just 2 or 3 products. Don't try to do the whole huge upload until that works w/no errors.

     

    Let me know how that goes.

     

    <?php
    /*
    osCommerce, Open Source E-Commerce Solutions
    http://www.oscommerce.com
    
    Copyright ? 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://knifesupercenter.com'); // eg, http://localhost - should not be empty for productive servers
    define('HTTP_CATALOG_SERVER', 'http://knifesupercenter.com');
    define('HTTPS_CATALOG_SERVER', 'https://knifesupercenter.com');
    define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
    define('DIR_FS_DOCUMENT_ROOT', '/home/knifesup/public_html/'); // where the pages are located on the server
    define('DIR_WS_ADMIN', '/admin/'); // absolute path required
    define('DIR_FS_ADMIN', '/home/knifesup/public_html/admin/'); // absolute pate required
    define('DIR_WS_CATALOG', '/'); // absolute path required
    define('DIR_FS_CATALOG', '/home/knifesup/public_html/'); // absolute path required
    define('DIR_WS_IMAGES', 'images/');
    define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
    define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
    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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
    define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
    define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
    define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
    define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

  13. Hello,

     

    EP cannot find the file or your temp directory...that's why it shows up in all CAPS in your error

     

    DIR_FS_DOCUMENT_ROOT

     

    it needs to be able to find that.

     

    Could you post your admin/includes/configure.php, without the database entries that are at the bottom.

     

    PS, this is secondary, as the doc root setting needs to be correct first....but, if you created /temp/ directly in /public_html/ then the correct setting in the easypopulate.php file is:

     

    $tempdir = "/temp/";

    $tempdir2 = "/temp/";

  14. Cool, I'm glad it worked.

     

    If you want to be able to turn it back on later, you can just exclude the category box from caching by editing the includes/column_left.php

     

    if ((USE_CACHE == 'true') && empty($SID)) {

    echo tep_cache_categories_box();

    } else {

    include(DIR_WS_BOXES . 'categories.php');

    }

     

    just change all of that to just simply....

     

    include(DIR_WS_BOXES . 'categories.php');

     

    :)

×
×
  • Create New...