Jump to content

Lao

Members
  • Content count

    172
  • Joined

  • Last visited

Everything posted by Lao

  1. Anyone? I'm just searching for the latest working Easy Populate contrib using Excel (xls or csv) files.
  2. Hi all! I am looking for a good/working "Easy Populate" kind of contribution. I already checked this http://addons.oscommerce.com/info/500 but there are soooo many versions that I don't know which one to pick. Anyone care to show me the link to the "ultimate" Easy Populate (using Excel files)? Thank you.
  3. Thank you much. It really worked. Now I have a new little annoying thing. If I want to remove a product from my store and I just delete it from the .csv file, isn't it supposed to delete it? For example: If I have 3 laptops in my store, created by the .csv file in the proper categories. After that, if I want to remove one of the laptops and I upload the .csv file with only 2 laptops, isn't it supposed to delete the other one?
  4. Hi guys! I'm having some little problems with this conttrib and I was wondering if you can please help me. This is the error I get: File uploaded. Temporary filename: /tmp/phpTanYMl User filename: EP2008Jan20-0606.csv Size: 1429 | Inspiron 1 | Dell Inspi | Specificat | | | | | Dell Inspi | Specificat | | | | | ins1300.jp | 1680.67 | 5 | 3.5 | 0000-00-00 | 1/20/2008 | Dell | Laptop - N | | Laptop - N | | | | | | | | | | Laptop - N | | incl TVA | Active Updated Updated 1054 - Unknown column 'products_head_title_tag' in 'field list' UPDATE products_description SET products_name='Dell Inspiron 1300', products_description='Specificatiile vin aici Dedesubt, cu tot ce trebuie.', products_head_title_tag = '', products_head_desc_tag = '', products_head_keywords_tag = '', products_url='' WHERE products_id = '567' AND language_id = '4' LIMIT 1 [TEP STOP]
  5. Yeap, my mistake. :D After I replaced the file this appears in my Admin: I looked at the file from 2.74 and managed to make some changes to the 2.81 file and now it looks like this: I can't change the upper text and "INACTIVATE_EP", I don't know how. Also, I haven't tried the contrib until now, I read that it would be a good thing to read the instructions first, so I decided to do it by the book. This way I eliminate one possible problem: ME. :))
  6. Well, I installed the 2,74 version like you said, but after I added easypopulate.php from 2.81 it gave me this error: Warning: main(includes/functions/easypopulate_functions.php) [function.main]: failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/maycon.ro/subdomains/sh/httpdocs/admin/easypopulate.php on line 53 Warning: main() [function.include]: Failed opening 'includes/functions/easypopulate_functions.php' for inclusion (include_path='.:/usr/local/psa/apache/share/pear') in /usr/local/psa/home/vhosts/maycon.ro/subdomains/sh/httpdocs/admin/easypopulate.php on line 53 On line 53 there's: include (DIR_WS_FUNCTIONS . 'easypopulate_functions.php'); Any idea?
  7. Ok, but there's only an easypopulate.php file. ?!? :(
  8. Can you give me a link to a good 2.8 or 2.9 version? I see there are more than one of each version and I don't know wich one to choose. Thanks. ;)
  9. Well, I hope it helps too, as I'll uninstall Extra Images right now and see how it's going.
  10. Ok, I get it. I have the following mods: - customers_extra_fields - extra_images_with_admin1_3 - EZ_Price_Updater - Fixed Width Site With CSS - Order_IP_Recorder_1.4 addon - best_sellers_rolling_1 - dynamic_sitemap v 2.0 - Java Categories - New Products Changing - osC-Cache_v1.1a - Purchase Without Account_0.910 - Switch between Displaying Prices Inc_Ex VAT. Hope this helps.
  11. As this is a looong thread and right now i have limited time, allow me to ask you guys: what is the last good version of this contrib? Thanks in advance.
  12. Hello all! I'm searching for a contrib that can make the "Products Expected" lines that are located under "New Products of the month" to show like the "New Products of the month" module, in a rectangle layout. I want a "Products Expected" module under "New Products of the month" module. Thanks.
  13. Hi guys! I'm having a little displlaying problem with the contrib mentioned in the title. I guess I installed it right, but I get "?>" somewhere up in the products info, as the image shows: And this is a part of product_info.php code, the one that I had to add so that images are displayed verticaly: I'd like to know where that ?> is coming from in my catalog. <td class="main"> <?php if (tep_not_null($product_info['products_image'])) { ?> <table border="0" cellspacing="0" cellpadding="2" align="right"> <tr> <td align="center" class="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> <?php //BOF - Custom hack for extra images //////////////////////////////////////// $products_extra_images_query = tep_db_query("SELECT products_extra_image, products_extra_images_id FROM " . TABLE_PRODUCTS_EXTRA_IMAGES . " WHERE products_id='" . $product_info['products_id'] . "'"); while ($extra_images = tep_db_fetch_array($products_extra_images_query)) { ?> <BR> <script language="javascript"><!-- document.write('<?php echo '<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_EXTRA_IMAGES, 'peiID=' . $extra_images['products_extra_images_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $extra_images['products_extra_image'], addslashes($product_info['products_name']),SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></SCRIPT> <NOSCRIPT> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $extra_images['products_extra_image']) . '">' . tep_image(DIR_WS_IMAGES . $extra_images['products_extra_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </NOSCRIPT> <?php } //BOF - Custom hack for extra images //////////////////////////////////////// ?> </td> </tr> </table> <?php } ?> <p><?php echo stripslashes($product_info['products_description']); ?></p> <?php $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> And also, does anyone know how can I find the products that I want to add images, by the name of product instead of the model?
  14. I found the problem with the help of Dreamweaver. It was in product_info.php in the lower part of it. There was an extra ?> somewhere. ;)
  15. This is popup_extra_images.php from catalog ( file that needed to be added). Could it be from it? I don't know PHP, that's why I'm asking you all. This is the only file that is added to the catalog. <?php /* $Id: popup_extra_images.php,v 1.0 2003/06/11 Mikel Williams osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $navigation->remove_current_page(); $products_query = tep_db_query("select pd.products_name, pei.products_extra_image from " . TABLE_PRODUCTS_EXTRA_IMAGES . " pei left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pei.products_id = pd.products_id where pei.products_extra_images_id = '" . $HTTP_GET_VARS['peiID'] . "' and pd.language_id = '" . $languages_id . "'"); $products_values = tep_db_fetch_array($products_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML <?php echo HTML_PARAMS; ?> <HEAD> <TITLE><?php echo $products_values['products_name']; ?></TITLE> <BASE href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <script language="javascript"><!-- var i=0; function resize() { if (navigator.appName == 'Netscape') i=40; if (document.images[0]) window.resizeTo(document.images[0].width +30, document.images[0].height+60-i); self.focus(); } //--></SCRIPT> </HEAD> <BODY onLoad="resize();"> <?php echo tep_image(DIR_WS_IMAGES . $products_values['products_extra_image'], $products_values['products_name']); ?> </BODY> </HTML> <?php require('includes/application_bottom.php'); ?>
  16. It appeared after I installed the contrib. I'll tommorow over all files, now it's 2 a.m. and I'm kinda tired. ;)
  17. Lao

    Customers extra fields

    I installed Kit's original contrib from here: http://www.oscommerce.com/community/contri...ch,extra+fields then added zoulxp's patch and that's it. I reinstalled it 2 or 3 times by now, maybe i'll try that one more time tomorrow. I have some other modds but i don't think those are the problems. Has anyone did something else that is not mentioned in the contrib?!
  18. Lao

    Customers extra fields

    I still can't get past my problem and no one knows what's the problem. :(
  19. Lao

    Customers extra fields

    Helllooo!!! Anybodyyyy!!!
  20. Lao

    Customers extra fields

    Did you do something different in the instalation process? I can't make it to remember whatever the text is written by a cutomer. I can't see the data (in admin or invoice) that a customer inputs when he creates an account.
  21. Lao

    Customers extra fields

    Did you solved that error? Are your extra fields remembered when a customer creates a new account? Can you see the new fields in admin or in invoice?
  22. Lao

    Customers extra fields

    Vantalk, pentru problema mea ai rezolvare? Daca da, cum?
  23. Hi all! I'm trying to put some customized buttons right bellow the header. I made the buttons myself with Free-Buttons, BUT now i don't know how to insert them into "extraheader.php" file from "Nav bar with on/off tabs" contrib. Maybe you can help me. The buttons' htm code looks like this: <!-- Begin Free-Buttons.org --> <table align=left width=0 id="free-buttons.org:screxst0" cellpadding=0 cellspacing=0 border=0><tr> <td title='No'><a href="http://www.maycon.ro" onmouseover='wbe("0o");' onmouseout='wbe("0n");' onmousedown='wbe("0c");'><img src="wbimg/imgn0.gif" name=btn0 width=100 height=30 border=0 alt='Index, prima pagina, first page'></a></td> <td title='No text'><a href="http://www.maycon.ro/dynamic_sitemap.php" onmouseover='wbe("1o");' onmouseout='wbe("1n");' onmousedown='wbe("1c");'><img src="wbimg/imgn1.gif" name=btn1 width=100 height=30 border=0 alt='Harta site, sitemap'></a></td> <td title='No text'><a href="http://www.maycon.ro/advanced_search.php" onmouseover='wbe("2o");' onmouseout='wbe("2n");' onmousedown='wbe("2c");'><img src="wbimg/imgn2.gif" name=btn2 width=100 height=30 border=0 alt='Cautare, cauta, search'></a></td> <td title='No text'><a href="http://www.maycon.ro/download/OfertaMaycon.xls" onmouseover='wbe("3o");' onmouseout='wbe("3n");' onmousedown='wbe("3c");'><img src="wbimg/imgn3.gif" name=btn3 width=100 height=30 border=0 alt='Download oferta, download Excel offer'></a></td> <td title='No text'><a href="http://www.maycon.ro/shipping.php" onmouseover='wbe("4o");' onmouseout='wbe("4n");' onmousedown='wbe("4c");'><img src="wbimg/imgn4.gif" name=btn4 width=100 height=30 border=0 alt='Informatii despre livrare, shipping informations'></a></td> <td title='No text'><a href="http://www.maycon.ro/conditions.php" onmouseover='wbe("5o");' onmouseout='wbe("5n");' onmousedown='wbe("5c");'><img src="wbimg/imgn5.gif" name=btn5 width=100 height=30 border=0 alt='Conditiile de acordare a garantiei, warranty conditions'></a></td> <td title='No text'><a href="http://www.maycon.ro/contact_us.php" onmouseover='wbe("6o");' onmouseout='wbe("6n");' onmousedown='wbe("6c");'><img src="wbimg/imgn6.gif" name=btn6 width=100 height=30 border=0 alt='Date de contact, contact us'></a></td> </tr></table><noscript><a href=http://free-buttons.org>Created by Free-Buttons.org</a></noscript> <script type="text/javascript" language="JavaScript1.1"> <!-- function wbpr(im){var i=new Image();i.src='wbimg/img'+im;return i;} function wbe(id){x=id.substring(0,id.length-1);document['btn'+x].src=eval('btn'+id+'.src');if(id.indexOf('e')!=-1)document['btn'+x+'e'].src=eval('btn'+id+'e.src');} btn0n=wbpr('n0.gif');btn0o=wbpr('o0.gif');btn0c=wbpr('c0.gif') btn1n=wbpr('n1.gif');btn1o=wbpr('o1.gif');btn1c=wbpr('c1.gif') btn2n=wbpr('n2.gif');btn2o=wbpr('o2.gif');btn2c=wbpr('c2.gif') btn3n=wbpr('n3.gif');btn3o=wbpr('o3.gif');btn3c=wbpr('c3.gif') btn4n=wbpr('n4.gif');btn4o=wbpr('o4.gif');btn4c=wbpr('c4.gif') btn5n=wbpr('n5.gif');btn5o=wbpr('o5.gif');btn5c=wbpr('c5.gif') btn6n=wbpr('n6.gif');btn6o=wbpr('o6.gif');btn6c=wbpr('c6.gif') //--> </script> <!-- End Free-Buttons.org --> and the extraheader.php looks like this: <?php // /catalog/includes/languages/[language]/extraheader.php // in romanian.php require(DIR_WS_LANGUAGES . $language . '/' . 'extraheader.php'); ?> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=100%> <TR class=header align="center" VALIGN="CENTER"> <td><a href="<?php echo tep_href_link(FILENAME_DEFAULT); ?>"><?php echo ((($cPath_array[0] == 0) && (basename($PHP_SELF) == FILENAME_DEFAULT)) ? tep_image(DIR_WS_IMAGES . 'index.gif', 'Index') : tep_image(DIR_WS_IMAGES . 'index.gif', 'Index')); ?></a></td> <!-- <td><a href="<?php echo tep_href_link(FILENAME_ALL_PRODUCTS); ?>"><?php echo ((($cPath_array[0] == 0) && (basename($PHP_SELF) == FILENAME_ALL_PRODUCTS)) ? tep_image(DIR_WS_LANGUAGES . 'english/images/buttons/nav_tab/allproducts_tab_main_on.gif', 'All Products') : tep_image(DIR_WS_LANGUAGES . 'english/images/buttons/nav_tab/allproducts_tab_main_off.gif', 'All Products')); ?></a></td> --> <td><a href="http://www.maycon.ro/dynamic_sitemap.php"><?php echo ((($cPath_array[0] == 0) && (basename($PHP_SELF) == FILENAME_GOOGLE_SITEMAPS)) ? tep_image(DIR_WS_IMAGES . 'sitemap-on.gif', 'Sitemap') : tep_image(DIR_WS_IMAGES . 'sitemap.gif', 'Hart? site')); ?></a></td> <td><a href="http://www.maycon.ro/download/OfertaMaycon.xls"><?php echo ((($cPath_array[0] == 0) && (basename($PHP_SELF) == FILENAME_PRICELIST)) ? tep_image(DIR_WS_IMAGES . 'download-on.gif', 'Download oferta') : tep_image(DIR_WS_IMAGES . 'download.gif', 'Download oferta')); ?></a></td> <td><a href="http://www.maycon.ro/conditions.php"><?php echo (((basename($PHP_SELF) == FILENAME_SPECIALS)) ? tep_image(DIR_WS_LANGUAGES . 'english/images/buttons/nav_tab/specials_tab_main_on.gif', 'Special offers') : tep_image(DIR_WS_LANGUAGES . 'english/images/buttons/nav_tab/specials_tab_main_off.gif', 'Special offers')); ?></a></td> <td><a href="<?php echo tep_href_link(FILENAME_ADVANCED_SEARCH); ?>"><?php echo (((basename($PHP_SELF) == FILENAME_ADVANCED_SEARCH)) ? tep_image(DIR_WS_IMAGES . 'search-on.gif', 'Cautare') : tep_image(DIR_WS_IMAGES . 'search.gif', 'Cautare')); ?></a></td> <td><a href="<?php echo tep_href_link(FILENAME_SHIPPING); ?>"><?php echo ((($cPath_array[0] == 0) && (basename($PHP_SELF) == FILENAME_SHIPPING)) ? tep_image(DIR_WS_IMAGES . 'shipping-on.gif', 'Livrare') : tep_image(DIR_WS_IMAGES . 'shipping.gif', 'Livrare')); ?></a></td> <td><a href="<?php echo tep_href_link(FILENAME_CONTACT_US); ?>"><?php echo ((($cPath_array[0] == 0) && (basename($PHP_SELF) == FILENAME_CONTACT_US)) ? tep_image(DIR_WS_IMAGES . 'contact_us-on.gif', 'Contact') : tep_image(DIR_WS_IMAGES . 'contact_us.gif', 'Contact')); ?></a></td> </TR> </TABLE> Where can I insert the buttons codes so that extraheader.php will work fine?
×