Jump to content

expert

Members
  • Content count

    57
  • Joined

  • Last visited

Everything posted by expert

  1. This is support threat of XML Export contrib. Please post any query here if you need any assistance or help or comment, Basicaly this contrib helps you creating XML feed for products in your db. You can export whole db or you can select any categories to export. You can easily modify XML structure. You can donwload it from http://www.oscommerce.com/community/contributions,5354 Now I'm focusing on XML Import feature. Importing XML is a little bit tedious for me but its time to create alternative for Easy Populate since Vendors start feeding in XML. Better to implement some XML maps to import from various vendor feeds. If there is any contributer to give me a hand it would be really apreciated.
  2. Hi, This is support forum for "Special Price Input/Edit in Product Edit/Add Screen". Screenshot is included in contribution (see in this post) In new verison there are some important bug fixes and improvements. Please upgrade... http://www.oscommerce.com/community/contri...ce+product+edit
  3. expert

    SUPPORT : XML Export contribution

    I don't have any idea about this problem. Did you place all the files correctly? This error generally occurs when you add accidentaly any of main file into language folder. Because names are the same.
  4. expert

    SUPPORT : XML Export contribution

    no, this works only for default language. I didn't plan to make it multi language. but can be done.
  5. I've found the solution fwr_cat_functions.php line: 208 change: 'name' => htmlentities($row['categories_name'])); to 'name' => htmlspecialchars($row['categories_name'])); htmlentities converts all extended characters, such as Ğ -> &artd; htmlspecialcharacters does the same but is more specific to do that. Note that, I don't know if this is applicable to everybody but worked for me
  6. Does that use code page conversion? From any code page to UTF-8? DHTML Categories menu pulls out the category names from database and prints as it is without any problem. Did anybody install this category menu apart from English store?
  7. This is really good solution for me. But I have a problem with Turkish characters in menu. Turkish chars are not shown correctly http://www.hepsistem.com/index.php To see correct characters, I put my current DHTML Categories menu under it. Please help
  8. expert

    SUPPORT : XML Export contribution

    Sorry, text export format is not my intention. You can find several contributions which allow text format export.
  9. expert

    SUPPORT : XML Export contribution

    DTD validation shouln't be a problem. I've check my export XML and it says Ok. Anybody else encounters same DTD validation problem? Btw, much improved version of XML Export is coming soon. Following iprovements are almost done; - Running in standard admin interface - Static texts are now in seperate langulage file - Full product URL is now added into XML (SEO URL can be implemented but SEO class is not in admin, so some extra work is needed to run SEO in Admin (I don't want to move export script file in catalog side due to some possible unauthorized access from anybody - In addition to that please see my note below about your data security) - Code is now more in osC code syntax - Warning and success messages are now displayed in current osC $messagestack style at top. XML Data Security warning: Please note that your generated XML can be accessed anybody from /dataexport/ folder. In order to avoid to stole your XML data please change /dataexport/ folder name in script and also don't use default exportfile.xml filename. And I strongly advice you to use .htaccess in that folder to avoid public folder listing.
  10. expert

    SUPPORT : XML Export contribution

    Actually adding full product path using SEO URL mode would be usefull. You can add it if you can, or stay tuned I will look at that.
  11. expert

    SUPPORT : XML Export contribution

    Sure. You have products data. You can use it in another format as well as XML tags that we used here. Sample: $csv_file = $product['model'] . '|' . $product['name'] . '|' . $product['description'] . '\n';
  12. expert

    SUPPORT : XML Export contribution

    Sure. Adding prd.products_status = '1' will do that. Change your "where clause part of the query " as following; WHERE ( prd.products_id = prdsc.products_id AND prdsc.language_id = '" . $row_language_id['languages_id'] . "' ) AND prd.products_id = prdtocat.products_id AND prdtocat.categories_id = " . TABLE_CATEGORIES . ".categories_id AND ( catdesccurrent.categories_id = " . TABLE_CATEGORIES . ".categories_id AND catdesccurrent.language_id = '" . $row_language_id['languages_id'] . "' ) AND prdtocat.categories_id in (".implode($categories_ids, ', ').") AND prd.products_status = '1' LIMIT 10000");
  13. expert

    SUPPORT : XML Export contribution

    I don't know about www.ucuzu.com XML structure but you can modify the XML tags to their requirement. Btw, can you post their XML structure?
  14. expert

    SUPPORT : XML Export contribution

    Hi Mike, Actually I was on a trip for a while and couldn't spend some time for import. Parsing the XML is not a problem. It is the easiest way but creating/implementing category structure is a bit tedious. I will work on it...
  15. expert

    SUPPORT : XML Export contribution

    Yes, partially yes. Both image file bane and full image path will be in XMl but full product path is not. It is possible but why do you need full product path in XML? Here is a sample generated XML <?xml version="1.0" encoding="windows-1254" ?> - <Products> - <Product> <Main_Category_id>207</Main_Category_id> <Main_Category_Name>Bahçe ve Hırdavat</Main_Category_Name> <Sub_Category_1_id>244</Sub_Category_1_id> <Sub_Category_1_Name>Bahçe</Sub_Category_1_Name> <Sub_Category_2_id>254</Sub_Category_2_id> <Sub_Category_2_Name>Benzinli Çim Biçme</Sub_Category_2_Name> <Sub_Category_3_id>288</Sub_Category_3_id> <Sub_Category_3_Name>MTD</Sub_Category_3_Name> <Product_id>1304</Product_id> <Product_Model>GLX105RH15</Product_Model> <Product_Name>AAAA MTD GLX105RH15 Çim Biçme Traktörü</Product_Name> <Product_Description><P>Product Specification bla bla bla</P></Product_Description> <Product_Price>150.00</Product_Price> <Product_Price_Special>105.00</Product_Price_Special> <Product_Currency>USD</Product_Currency> <Product_Vat_Rate>18</Product_Vat_Rate> <Product_Image>200_105HT_n.jpg</Product_Image> <Product_Image_Url>http://www.samplesite.com/images/200_105HT_n.jpg</Product_Image_Url> <Product_Quantity>3</Product_Quantity> <Product_Weight>0.00</Product_Weight> <Product_Status>1</Product_Status> <Product_Manufacturer>MTD</Product_Manufacturer> <Product_Last_Modified>2007-09-13 00:28:32</Product_Last_Modified> <Product_Date_Available /> </Product> </Products>
  16. expert

    SUPPORT : XML Export contribution

    @suhy, Actually I was focusing on functionality, so some cosmetic changes can be done on this contrib as you suggested in order to make it easy use. @TheExterminator Unfortunately I didn't work for full admin look and feel stuff. Please see suhy suggestions, so you can got it working it as an admin function over the left navigation. Wen I complete import part of that I will focus on cosmetics, so in additon to functionality you may have nice looking screens :)
  17. expert

    XML Export Help

    Sorry you must put xml_export.php file in your /admin folder. I will revise install instruction in contrib area.
  18. expert

    [Contribution] Task Manager (Admin)

    I've installed successfully, but I'm getting full blank screen when I click on any item in Task Manager toolbox I really want to get it working... I didn't understand whats wrong ...
  19. expert

    [contribution] Star Product

    for mysql 5.x compability you must modify /catalog/includes/modeules/star_product.php sql command as follows; $star_products_query = tep_db_query("select substring(pd.products_description, 1, 700) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_STAR_PRODUCT . " sp where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '" . $languages_id . "'");
  20. expert

    [contribution] Star Product

    you can change text lenght by aditing sql command. if you have already run sql, you can modify lenght from star_product table
  21. Welcome Tom, Installed your contrib successfully in my local server (Windoz with Apache) but, something is wrong with GIF images. All the JPGs are shown correctly, but GIFs are not. (See screenshot below), just appear as blank box. Click for Screenshot Changing all GIFs to JPGs is not solution at the moment, since I got more than 2000 images (mixed) Any idea? Thanks
  22. expert

    [Support] Category Fields

    that is a little bit hard and tricky. If you add any extra field to any specific category, then all products under that category will have extra field(s). However what if you move any product to under of another category which doesn't have such extra field. Beyond of that question, what if you remove whole sub category to under of another main category which doesn't have such extra fields? If future of this add-on could not able to manage such things your database may become untity.
  23. expert

    [contribution] Star Product

    simply run following Query (in phpmyadmin or any sql interface) ALTER TABLE `star_product` ADD PRIMARY KEY ( `product_id` ) I'm not sure it is correct way but it stops asking for 'no index identified'. Original contributor has forgotton that I guess. BTW did you see my admin side improvement? Look contib area.
  24. expert

    [contribution] Star Product

    I'm uploading a fix for html tag problem. With this small fix all html tags are removed from product_info part.Better to remove all, because some unclosed tags may occur html syntax problem. http://www.oscommerce.com/community/contributions,2255
  25. expert

    [contribution] Star Product

    if you encounter alignment problem with tables most probably some portion of product information text couses this if it has HTML formatting. I mean lets assume product info has <table> tag at beginning, contribution cuts its whole info before </table> tag is closed. Therefore you will have extra <table> tag on general code that it causes main page alignment problem. I'm working on this to strip some html tags. BTW, there is a missing close </table> tag in star_product.php in modules. So correct one as follows:
×