expert Posted October 9, 2007 Author Share Posted October 9, 2007 I was wondering if there is a XML export mod. that will export your products with their respective .htaccess modified SEF URLs? Hmmm... I know I need one! I am sure their has to be others that need it also... Looks like I am going to have to build one if its not developed already... Expert... Think you could give me a hand with your code so I could format the XML output to build the URL in the same pattern the Ultimate SEO url contrib uses? Could be a great project... you have most of it written... just need to format the output... if it is not already availible... Adam 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. Quote Link to comment Share on other sites More sharing options...
gregy Posted October 11, 2007 Share Posted October 11, 2007 hi great contribution .. works out of the box. Now i'm trying to validate it with some online xml checkers .. one at http://www.cogsci.ed.ac.uk/~richard/xml-check.html gives me following error Warning: Document has no DTD, validating abandoned(detected at end of prolog of document http://www...../exportfile.xml) Error: Input error: Illegal UTF-8 byte 2 <0x65> at file offset 690 in unnamed entity at line 14 char 10 of http://www..../exportfile.xml this first one is the one that worries me .. second one will be solved with full transaltion to utf charset .. i guess thanx in advance Quote Link to comment Share on other sites More sharing options...
gregy Posted October 11, 2007 Share Posted October 11, 2007 what about DTD validation? http://www.w3schools.com/xml/xml_dtd.asp Quote Link to comment Share on other sites More sharing options...
expert Posted October 13, 2007 Author Share Posted October 13, 2007 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. Quote Link to comment Share on other sites More sharing options...
auro Posted October 18, 2007 Share Posted October 18, 2007 (edited) 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'; Hi, I tried to modify the file .... No success. The output file is not in txt format. Erhan, I'm not a programmer. :blush:. Can you help me to do those modifications? The .txt file must be in the following format: 3049|Accesorii laptop|Acer|8 cell 4400mAh Lithium-Ion|Baterie Acer Lithiu-Ion 8 celule, 4400mAh. |596.07|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_acer_8 cell 4400mah lithium-ion_3049_4|http://www.oktal.ro/produse/foto/3049_acer.jpg 2227|Accesorii laptop|HP|Secondary Travel Battery (PB993A)|Dubleaza timpul de operare a laptopului dvs. fara sa reincarcati acumulatorul. Cu incarcare si descarcare controlata aveti intotdeauna acumulatorul laptopului dvs. aproape incarcat. |528.13|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_hp_secondary travel battery (pb993a)_2227_4|http://www.oktal.ro/produse/foto/2227_Secondary-Travel-Battery.jpg 2835|Accesorii laptop|HP|Carepack 3years Pick Up & Return HW Support|Prelugeste garantia laptopului dumneavoastra de la 1 an la 3 ani. Se poate achizitiona oricand in perioada de garantie a produsului. Exclusiv pentru produsele achizitionate de la firma Oktal Computers! |523.53|RON cu TVA|prin curier|36|http://www.oktal.ro/detalii_accesorii laptop_hp_carepack 3years pick up & return hw support_2835_4|http://www.oktal.ro/produse/foto/2835_HPCarePack.JPG 3054|Accesorii laptop|Toshiba|Warranty Extension( SE5003I-PDB)|Warranty Extension from 1 to 3 years, Notebooks with 1 year standard warranty |495.12|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_toshiba_warranty extension( se5003i-pdb)_3054_4|http://www.oktal.ro/produse/foto/3054_toshiba.jpg 3059|Accesorii laptop|Toshiba|Notebook Car Adapter (PX1188E-1NPO)|Notebook Car Adapter - 120W, 15V, 8A - black, Satellite/Pro 2410/5xxx/A10/A40/A50/M30/A80/M60 ; Portégé 20xx/3500/40xx/R100 ; Tecra 9100/M1/M2/S1/A3/S2/M3 ; Qosmio -F10/-G10/-G20/-F20 |600.88|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_toshiba_notebook car adapter (px1188e-1npo)_3059_4|http://www.oktal.ro/produse/foto/3059_adaptor.jpg 3060|Accesorii laptop|Toshiba|Notebook Car Adapter(PX1189E-1NPO)|Notebook Car Adapter - 120W, 19V, 6.3A - black, Satellite/Pro 19xx/A30/A60/P10/P20/M30X/L10 |600.88|RON cu TVA|prin curier|12|http://www.oktal.ro/detalii_accesorii laptop_toshiba_notebook car adapter(px1189e-1npo)_3060_4|http://www.oktal.ro/produse/foto/3060_no.jpg 2543|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7105BPMX|eTrust Antivirus v7.1 - 5 Users - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only |746.65|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7105bpmx_2543_4|http://www.oktal.ro/produse/foto/2543_et_antivirus.jpg 2544|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7110BPMX|eTrust Antivirus v7.1 - 10 Users - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only |1493.30|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7110bpmx_2544_4|http://www.oktal.ro/produse/foto/2544_et_antivirus.jpg 2545|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7125BPMX|eTrust Antivirus v7.1 - 25 Users - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only |3733.24|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7125bpmx_2545_4|http://www.oktal.ro/produse/foto/2545_et_antivirus.jpg 2548|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7110BPUX|eTrust Antivirus v7.1 - 10 Users - Upgrade from any previous version of eTrust InoculateIT - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only|895.88|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7110bpux_2548_4|http://www.oktal.ro/produse/foto/2548_et_antivirus.jpg 2549|Antivirus|Computer Associates|eTrust Antivirus v7.1 ETRAVE7125BPUX|eTrust Antivirus v7.1 - 25 Users - Upgrade from any previous version of eTrust InoculateIT - Includes Antivirus protection for the Desktop, Server, Gateway, Groupware, and PocketPC - Product only |836.47|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_computer associates_etrust antivirus v7.1 etrave7125bpux_2549_4|http://www.oktal.ro/produse/foto/2549_et_antivirus.jpg 1544|Antivirus|McAfee|McAfee Active Virus Defense SMB Edition (incl. Protection Pilot) 5 USERS Perpetual Licence Pack with 1 yr Gold Support|McAfee Active Virus Defense SMB Edition (incl. Protection Pilot) 5 USERS Perpetual Licence Pack with 1 yr Gold Support ADM80M005TAA |1491.96|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_mcafee_mcafee active virus defense smb edition (incl. protection pilot) 5 users perpetual licence pack with 1 yr gold support_1544_4|http://www.oktal.ro/produse/foto/1544_mcafee_logo.jpg 1545|Antivirus|McAfee|McAfee Active Virusscan SMB Edition (incl. Protection Pilot) 5 USERS Perpetual Licence Pack with 1 yr Gold Support|McAfee Active Virusscan SMB Edition (incl. Protection Pilot) 5 USERS Perpetual Licence Pack with 1 yr Gold Support SVM80M005TAA |755.67|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_mcafee_mcafee active virusscan smb edition (incl. protection pilot) 5 users perpetual licence pack with 1 yr gold support_1545_4|http://www.oktal.ro/produse/foto/1545_mcafee_logo.jpg 2686|Antivirus|Symantec|Norton Antivirus 2006 (NAV 2006 12.0 IN SMO 5 USR)|Norton Antivirus 2006 (NAV 2006 12.0 IN SMO 5 USR) – full product SY-10432459-IN |711.09|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_symantec_norton antivirus 2006 (nav 2006 12.0 in smo 5 usr)_2686_4|http://www.oktal.ro/produse/foto/2686_symantec_logo.jpg 2687|Antivirus|Symantec|Norton Antivirus 2006 (NAV 2006 12.0 IN SMO 5 USR UPG)|Norton Antivirus 2006 (NAV 2006 12.0 IN SMO 5 USR UPG) |547.36|RON cu TVA|prin curier|0|http://www.oktal.ro/detalii_antivirus_symantec_norton antivirus 2006 (nav 2006 12.0 in smo 5 usr upg)_2687_4|http://www.oktal.ro/produse/foto/2687_symantec_logo.jpg Thank you Edited October 18, 2007 by auro Quote Link to comment Share on other sites More sharing options...
Guest Posted October 25, 2007 Share Posted October 25, 2007 Hello. I was just wondering how far the import of the xml is? I al looking the whole day after some module or contrib, to do this, but had no luck... So basically you're my last chance. Cheers! Quote Link to comment Share on other sites More sharing options...
Davee Posted October 31, 2007 Share Posted October 31, 2007 Hi Anyone know how to set up a cron job to automate an export ? Thanks in advance Dave Quote Link to comment Share on other sites More sharing options...
auro Posted November 2, 2007 Share Posted November 2, 2007 Hi,I tried to modify the file .... No success. The output file is not in txt format. Erhan, I'm not a programmer. :blush:. Can you help me to do those modifications? Thank you Erhan, can you help me? Tnx. Quote Link to comment Share on other sites More sharing options...
expert Posted November 6, 2007 Author Share Posted November 6, 2007 Erhan, can you help me?Tnx. Sorry, text export format is not my intention. You can find several contributions which allow text format export. Quote Link to comment Share on other sites More sharing options...
henk3001 Posted November 21, 2007 Share Posted November 21, 2007 I like the import ideas to :) HEnk Quote Link to comment Share on other sites More sharing options...
pietonul Posted November 21, 2007 Share Posted November 21, 2007 Hello, This is a great contribution, thanks to the author! I need to display the price including taxes in the exportfile! How can I do that? Can anyone help please? Thanks! pietonul. Quote Link to comment Share on other sites More sharing options...
zeeshop Posted January 9, 2008 Share Posted January 9, 2008 Hello,This is a great contribution, thanks to the author! I need to display the price including taxes in the exportfile! How can I do that? Can anyone help please? Thanks! pietonul. Hi Expert. Can you please advise where you are with XML IMPORT. Is there any alternative you can advise what I am looking for. My Trading company is offering XML services, which can show Live Stock update on my Site. and Also system to check update product images every night. and so many live XML services, but my main intention is above two. Can you please advise any contribution on XML import. or how long it will take for release of your contribution. Regards Zee Quote Link to comment Share on other sites More sharing options...
hansmignon Posted January 21, 2008 Share Posted January 21, 2008 Dear, Do you have already something for the import ? Rgds, Hans Quote Link to comment Share on other sites More sharing options...
smartfeed Posted January 28, 2008 Share Posted January 28, 2008 Expert, There is an issue with the xml export in that if there is an "&" in the image file name or brand (mfr) name, it will not change it to & which is the appropriate xml display of an "&", causing the file to fail if you parse it. Just letting you know. Quote Rich SmartFeed Product Feed Manager Link to comment Share on other sites More sharing options...
janetgot Posted March 14, 2008 Share Posted March 14, 2008 Hi, this is a great module and I was able to get it going without any troubles... my only question is when I do an export, it creates the initial file, but I'd like to be able to overwrite the file with the same name. Right now I have to manually delete the file in order to create a new version of the same name. Is there a way to do this? Many thanks, Janet Quote Link to comment Share on other sites More sharing options...
neox Posted March 22, 2008 Share Posted March 22, 2008 Hi, I have problems with product price special. On some products with special price, instead of special price is just "1.00". Does anybody else also has that problem ? BTW tnx for this contribution! Quote Link to comment Share on other sites More sharing options...
Guest Posted March 23, 2008 Share Posted March 23, 2008 (edited) Dear Expert, Please explain in little more detail as I am a newbie, as to how to use your contribution, as it appears to be quite valuable. But I couldn't configure it correctly. I have copies the files & created a link explained in this section for xml_export.php. But I am getting the following error on clicking the link. PHP Fatal error: Cannot redeclare do_magic_quotes_gpc() (previously declared in E:\Program Files\Ensim\WEBppliance\SiteData\Domains\cbsindia.in\ROOT\Inetpub\wwwroot\orissaitbazaar\admin\includes\functions\compatibility.php:18) in E:\Program Files\Ensim\WEBppliance\SiteData\Domains\cbsindia.in\ROOT\Inetpub\wwwroot\orissaitbazaar\admin\includes\functions\compatibility.php on line 18 I have also edited two files first - admin\includes\boxes\catalog.php by including this line '<a href="' . tep_href_link(FILENAME_XML_EXPORT) . '" class="menuBoxContentLink">' . BOX_XML_EXPORT . '</a><br>' . // XML EXPORT second file is \admin\includes\filenames.php by including this line define('FILENAME_XML_EXPORT', 'xml_export.php'); Please help. 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. Edited March 23, 2008 by pkjoshi Quote Link to comment Share on other sites More sharing options...
lmhalcon Posted May 20, 2008 Share Posted May 20, 2008 is there a way to export by language? i want to export a file for english, for frenche...etc right now, only export the xml in spanish (my default language) thanks Luis Quote Link to comment Share on other sites More sharing options...
expert Posted June 28, 2008 Author Share Posted June 28, 2008 is there a way to export by language? i want to export a file for english, for frenche...etc right now, only export the xml in spanish (my default language) thanks Luis no, this works only for default language. I didn't plan to make it multi language. but can be done. Quote Link to comment Share on other sites More sharing options...
expert Posted June 28, 2008 Author Share Posted June 28, 2008 (edited) Dear Expert,Please explain in little more detail as I am a newbie, as to how to use your contribution, as it appears to be quite valuable. But I couldn't configure it correctly. I have copies the files & created a link explained in this section for xml_export.php. But I am getting the following error on clicking the link. PHP Fatal error: Cannot redeclare do_magic_quotes_gpc() (previously declared in E:\Program Files\Ensim\WEBppliance\SiteData\Domains\cbsindia.in\ROOT\Inetpub\wwwroot\orissaitbazaar\admin\includes\functions\compatibility.php:18) in E:\Program Files\Ensim\WEBppliance\SiteData\Domains\cbsindia.in\ROOT\Inetpub\wwwroot\orissaitbazaar\admin\includes\functions\compatibility.php on line 18 I have also edited two files first - admin\includes\boxes\catalog.php by including this line '<a href="' . tep_href_link(FILENAME_XML_EXPORT) . '" class="menuBoxContentLink">' . BOX_XML_EXPORT . '</a><br>' . // XML EXPORT second file is \admin\includes\filenames.php by including this line define('FILENAME_XML_EXPORT', 'xml_export.php'); Please help. 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. Edited June 28, 2008 by expert Quote Link to comment Share on other sites More sharing options...
stunami Posted July 24, 2008 Share Posted July 24, 2008 Howdy, Thanks for posting this excellent utility. Out of interest, I would like to change the encoding to UTF8 but am struggling to ind where you set it to windows 1254. How is the xml encoding configured? Kind Regards, Stu Quote A crash reduces your expensive computer to a simple stone. Link to comment Share on other sites More sharing options...
Guest Posted October 19, 2008 Share Posted October 19, 2008 It can be changed here: if (tep_db_num_rows($products_query)) { $xml_file.="<?xml version=\"1.0\" encoding=\"windows-1254\"?>\n"; Howdy, Thanks for posting this excellent utility. Out of interest, I would like to change the encoding to UTF8 but am struggling to ind where you set it to windows 1254. How is the xml encoding configured? Kind Regards, Stu Quote Link to comment Share on other sites More sharing options...
Guest Posted October 19, 2008 Share Posted October 19, 2008 Soon powerfull XML import engine is on the way Quote Link to comment Share on other sites More sharing options...
wi-fi Posted November 12, 2008 Share Posted November 12, 2008 Soon powerfull XML import engine is on the way how soon ? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 30, 2008 Share Posted November 30, 2008 It is ready actually, but my posts have been deleted related XML Core System Engine bu admins. Actually they don't realize that this engine will extend usage of osCommerce very efficiently. I need wordwide XML data feederd to add modules for this engine. Please provide me some XML samples from suppliers. [email protected] http://english.duzgun.com for more information Regards, Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.