Jump to content

expert

Members
  • Content count

    57
  • Joined

  • Last visited

About expert

  • Birthday 07/28/1971

Profile Information

  1. 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.
  2. 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.
  3. 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
  4. 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?
  5. 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
  6. expert

    SUPPORT : XML Export contribution

    Sorry, text export format is not my intention. You can find several contributions which allow text format export.
  7. 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.
  8. 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.
  9. 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';
  10. 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");
  11. 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?
  12. 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...
  13. 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>
  14. 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 :)
  15. 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.
×